SchemaSpy - Table zfindb.public.disease

Generated by
SchemaSpy

Legend:

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

dat_zdb_id

text

2147483647

damo_dat_fk_odc C

zdb_active_data.zactvd_zdb_id

dat_zdb_id_foreign_key_odc C

dat_term_zdb_id

text

2147483647

term.term_zdb_id

dat_term_zdb_id_foreign_key R

dat_source_zdb_id

text

2147483647

zdb_active_source.zactvs_zdb_id

dat_source_zdb_id_foreign_key R

dat_evidence_term_zdb_id

text

2147483647

√

null

term.term_zdb_id

dat_evidence_term_zdb_id_fk R

Table contained 2,621 rows at Tue Sep 15 16:40 PDT 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
dat_zdb_id	Primary key	Asc	disease_annotation_new_primary_key
dat_source_zdb_id	Performance	Asc	da_source_zdb_id_foreign_key_index
dat_term_zdb_id	Performance	Asc	da_term_zdb_id_foreign_key_index
dat_evidence_term_zdb_id	Performance	Asc	dat_evidence_term_zdb_id_index