SchemaSpy - Table zfindb.public.db

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

dblink_linked_recid

text

2147483647

zdb_active_data.zactvd_zdb_id

dblink_linked_recid_zactvd_zdb_id_foreign_key C

dblink_acc_num

text

2147483647

dblink_info

text

2147483647

√

null

dblink_zdb_id

text

2147483647

expression_experiment2.xpatex_dblink_zdb_id	expression_experiment2_dblink_foreign_key R
marker_go_term_evidence.mrkrgoev_protein_dblink_zdb_id	mrkrgoev_protein_dblink_id_fk_odc C
one_to_one_accession.ooa_dblink_zdb_id	ooa_dblink_zdb_id_foreign_key R

zdb_active_data.zactvd_zdb_id

dblink_zdb_id_foreign_key C

dblink_acc_num_display

text

2147483647

√

null

dblink_length

int4

√

null

dblink_fdbcont_zdb_id

text

2147483647

foreign_db_contains.fdbcont_zdb_id

dblink_fdbcont_zdb_id_foreign_key_odc C

Table contained 983,467 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
dblink_zdb_id	Primary key	Asc	dblink_primary_key
dblink_acc_num	Performance	Asc	db_link_acc_num_index
dblink_linked_recid	Performance	Asc	db_link_linked_rec_id_index
dblink_linked_recid + dblink_acc_num + dblink_fdbcont_zdb_id	Must be unique	Asc/Asc/Asc	dblink_alternate_key_index
dblink_fdbcont_zdb_id	Performance	Asc	dblink_fdbcont_zdb_id_index