Table zfindb.informix.accession_bank Generated by
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
accbk_acc_num varchar 30
accbk_length int 10  √  null
accbk_pk_id serial8 19  √ 
blast_hit.bhit_target_accbk_pk_id bhit_target_accbk_pk_id_foreign_keyn_odc C
blast_query.bqry_accbk_pk_id bqry_accbk_pk_id_foreign_key_odc C
accbk_fdbcont_zdb_id varchar 50
foreign_db_contains.fdbcont_zdb_id accbk_fdbcont_zdb_id_foreign_key_odc C
accbk_defline lvarchar 2048  √  null
accbk_abbreviation varchar 30  √  null
accbk_name varchar 255  √  null

Table contained 1,884,697 rows at Tue Nov 10 13:18 PST 2015

Column(s) Type Sort Constraint Name
accbk_defline + accbk_acc_num + accbk_fdbcont_zdb_id Must be unique Asc/Asc/Asc accbk_alternate_key_index
accbk_defline + accbk_fdbcont_zdb_id Performance Asc/Asc accbk_fdbcont_foreign_key_index
accbk_defline + accbk_pk_id Must be unique Asc/Asc accbk_primary_key_index

Close relationships  within of separation: