Table zfindb.informix.phenotype_observation_generated 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
psg_id int8 19  √  null
psg_pg_id int8 19  √  null
psg_mrkr_zdb_id varchar 50  √  null
psg_mrkr_abbrev varchar 255  √  null
psg_mrkr_relation varchar 30  √  null
psg_e1a_zdb_id varchar 50  √  null
psg_e1a_name varchar 255  √  null
psg_e1_relation_name varchar 30  √  null
psg_e1b_zdb_id varchar 50  √  null
psg_e1b_name varchar 255  √  null
psg_e2a_zdb_id varchar 50  √  null
psg_e2a_name varchar 255  √  null
psg_e2_relation_name varchar 50  √  null
psg_e2b_zdb_id varchar 50  √  null
psg_e2b_name varchar 255  √  null
psg_tag varchar 40  √  null
psg_quality_zdb_id varchar 50  √  null
psg_quality_name varchar 255  √  null
psg_short_name varchar 255  √  null
psg_pre_eap_phenotype boolean 1  √  f

Table contained 124,496 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
psg_pre_eap_phenotype + psg_e1a_zdb_id Performance Asc/Asc phenotype_observation_generated_e1a_zdb_index  
psg_pre_eap_phenotype + psg_e1b_zdb_id Performance Asc/Asc phenotype_observation_generated_e1b_zdb_index  
psg_pre_eap_phenotype + psg_e2a_zdb_id Performance Asc/Asc phenotype_observation_generated_e2a_zdb_index  
psg_pre_eap_phenotype + psg_e2b_zdb_id Performance Asc/Asc phenotype_observation_generated_e2b_zdb_index  
psg_pre_eap_phenotype + psg_mrkr_zdb_id Performance Asc/Asc phenotype_observation_generated_mrkr_zdb_index  
psg_pre_eap_phenotype + psg_id Must be unique Asc/Asc phenotype_observation_generated_pk_id_index These unique columns are also nullable
psg_pre_eap_phenotype + psg_pg_id Performance Asc/Asc phenotype_observation_generated_psg_pg_id_index  
psg_pre_eap_phenotype + psg_quality_zdb_id Performance Asc/Asc phenotype_observation_generated_quality_zdb_index