Table zfindb.informix.panel_count Generated by
SchemaSpy
Legend: SourceForge.net
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
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 Thu Jun 22 08:42 PDT 2017

Indexes:
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: