Table zfindb.informix.blast_query 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
bqry_zdb_id varchar 50
blast_hit.bhit_bqry_zdb_id bhit_bqry_zdb_id_foreign_keyn_odc C
blast_report.brpt_bqry_zdb_id blast_report_bqry_foreign_key_odc C
bqry_runcan_zdb_id varchar 50
run_candidate.runcan_zdb_id bqry_runcan_zdb_id_foreign_key_odc C
bqry_accbk_pk_id int8 19
accession_bank.accbk_pk_id bqry_accbk_pk_id_foreign_key_odc C

Table contained 14,094 rows at Tue Nov 10 13:18 PST 2015

Column(s) Type Sort Constraint Name
bqry_runcan_zdb_id Performance Asc 212_1297
bqry_runcan_zdb_id + bqry_accbk_pk_id Must be unique Asc/Asc blast_query_alternate_key_index
bqry_zdb_id Must be unique Asc blast_query_primary_key_index
bqry_accbk_pk_id Performance Asc bqry_accbk_pk_id_foreign_key_index

Close relationships  within of separation: