Table zfindb.informix.stage 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
stg_zdb_id varchar 50
anatomy_display.anatdisp_stg_zdb_id anatdisp_stg_zdb_id_foreign_key C
image_stage.imgstg_end_stg_zdb_id imgstg_end_stg_zdb_id_foregin_key R
image_stage.imgstg_start_stg_zdb_id imgstg_start_stg_zdb_id_foregin_key R
phenotype_experiment.phenox_end_stg_zdb_id phenox_end_stg_foreign_key_odc C
phenotype_experiment.phenox_start_stg_zdb_id phenox_start_stg_foreign_key_odc C
probe_library.probelib_stg_zdb_id probelib_stg_zdb_id_foreign_key R
term_stage.ts_end_stg_zdb_id ts_end_stg_zdb_id_foreign_key R
term_stage.ts_start_stg_zdb_id ts_start_stage_zdb_id_foreign_key R
zdb_active_data.zactvd_zdb_id stage_active_data_foreign_key C
stg_name varchar 80  √  null
stg_hours_start decimal 7,2
stg_hours_end decimal 7,2
stg_other_features varchar 50  √  null
stg_name_ext varchar 50  √  null
stg_name_long varchar 130  √  null
stg_abbrev varchar 40  √  null
stg_obo_id varchar 20

Table contained 45 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name Anomalies
stg_zdb_id Must be unique Asc stage_primary_key_index  
stg_name Must be unique Asc stg_name_index This unique column is also nullable
stg_obo_id Must be unique Asc stg_obo_id_index  

Close relationships  within of separation: