Table zfindb.informix.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 varchar 50
zdb_active_data.zactvd_zdb_id dblink_linked_recid_zactvd_zdb_id_foreign_key C
dblink_acc_num varchar 50
dblink_info varchar 80  √  null
dblink_zdb_id varchar 50
expression_experiment.xpatex_dblink_zdb_id fx_expression_experiment_dblink_foreign_key R
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 varchar 50
dblink_length int 10  √  null
dblink_fdbcont_zdb_id varchar 50
foreign_db_contains.fdbcont_zdb_id dblink_fdbcont_zdb_id_foreign_key_odc C

Table contained 824,702 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
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
dblink_zdb_id Must be unique Asc dblink_primary_key_index

Close relationships  within of separation: