Table zfindb.public.db_link 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
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
dblink_length int4 10  √  null
dblink_fdbcont_zdb_id text 2147483647
foreign_db_contains.fdbcont_zdb_id dblink_fdbcont_zdb_id_foreign_key_odc C

Table contained 915,842 rows at Mon Sep 03 04:09 PDT 2018

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

Close relationships  within of separation: