Table zfindb.public.zdb_active_source 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
zactvs_zdb_id text 2147483647
company.zdb_id cmpy_zdb_id_foreign_key C
disease_annotation.dat_source_zdb_id dat_source_zdb_id_foreign_key R
experiment.exp_source_zdb_id exp_source_zdb_id_foreign_key_odc C
figure.fig_source_zdb_id figure_source_foreign_key_odc C
int_data_source.ids_source_zdb_id ids_source_zdb_id_foreign_key C
int_data_supplier.idsup_supplier_zdb_id idsup_supplier_zdb_id_foreign_key C
journal.jrnl_zdb_id journal_zdb_active_source_foreign_key C
lab.zdb_id lab_zdb_id_foreign_key C
marker_go_term_evidence.mrkrgoev_source_zdb_id mrkrgoev_source_zdb_id_foreign_key C
person.zdb_id person_zdb_id_foreign_key C
publication.zdb_id publication_zdb_id_foreign_key C
source_alias.salias_source_zdb_id salias_source_zdb_id_foreign_key_odc C
source_alias.salias_zdb_id salias_zdb_id_foreign_key_odc C
source_feature_prefix.sfp_source_zdb_id sfp_source_zdb_id_foreign_key C
source_url.srcurl_source_zdb_id srcurl_source_zdb_id_foreign_key C
zdb_orphan_source.zorphans_zdb_id zorphans_zdb_id_foreign_key C

Table contained 64,600 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
zactvs_zdb_id Primary key Asc zdb_active_source_primary_key

Close relationships  within of separation: