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 7,006 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name
bqry_runcan_zdb_id Performance Asc 188_1455
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: