Table zfindb.public.stage 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
stg_zdb_id text 2147483647
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 text 2147483647  √  null
stg_hours_start numeric 7,2
stg_hours_end numeric 7,2
stg_other_features text 2147483647  √  null
stg_name_ext text 2147483647  √  null
stg_name_long text 2147483647  √  null
stg_abbrev text 2147483647  √  null
stg_obo_id text 2147483647

Table contained 45 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
stg_zdb_id Primary key Asc stage_primary_key  
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: