Table zfindb.informix.panel_count Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
panelcnt_panel_zdb_id varchar 50
panels.zdb_id panelcnt_panel_zdb_id_foreign_key C
panelcnt_mrkr_type varchar 10
marker_types.marker_type panelcnt_mrkr_type_foreign_key C
panelcnt_or_lg varchar 2  √  null
linkage_group.lg_name panelcnt_or_lg_foreign_key C
panelcnt_count int 10
panelcnt_chromosome varchar 2
chromosome.chrom_name panelcnt_chromosome_foreign_key C

Table contained 608 rows at Tue Nov 10 13:18 PST 2015

Column(s) Type Sort Constraint Name
panelcnt_panel_zdb_id + panelcnt_mrkr_type + panelcnt_chromosome Must be unique Asc/Asc/Asc panel_count_primary_key_index
panelcnt_chromosome Performance Asc panelcnt_chromosome_index
panelcnt_mrkr_type Performance Asc panelcnt_mrkr_type_index
panelcnt_or_lg Performance Asc panelcnt_or_lg_index
panelcnt_panel_zdb_id Performance Asc panelcnt_panel_zdb_id

Close relationships  within of separation: