Table zfindb.informix.one_to_one_accession 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
ooa_pk_id serial8 19  √ 
ooa_feature_zdb_id varchar 50
feature.feature_zdb_id ooa_feature_zdb_id_foreign_key R
ooa_dblink_zdb_id varchar 50
db_link.dblink_zdb_id ooa_dblink_zdb_id_foreign_key R
ooa_dblink_acc_num varchar 50

Table contained 15,223 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
ooa_pk_id Must be unique Asc 276_346
ooa_dblink_acc_num Must be unique Asc ooa_dblink_acc_num_index
ooa_dblink_zdb_id Must be unique Asc ooa_dblink_zdb_id_index
ooa_feature_zdb_id Must be unique Asc ooa_feature_zdb_id_index

Close relationships  within of separation: