Table zfindb.public.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 text 2147483647
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 text 2147483647
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,840 rows at Tue Sep 15 16:40 PDT 2020

Column(s) Type Sort Constraint Name
bqry_zdb_id Primary key Asc blast_query_primary_key
bqry_runcan_zdb_id + bqry_accbk_pk_id Must be unique Asc/Asc blast_query_alternate_key_index
bqry_accbk_pk_id Performance Asc bqry_accbk_pk_id_foreign_key_index
bqry_runcan_zdb_id Performance Asc bqry_runcan_zdb_id_foreign_key_odc_index

Close relationships  within of separation: