Table zfindb.public.accession_bank 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
accbk_acc_num text 2147483647
accbk_length int4 10  √  null
accbk_pk_id bigserial 19  √  nextval('accession_bank_accbk_pk_id_seq'::regclass)
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 text 2147483647
foreign_db_contains.fdbcont_zdb_id accbk_fdbcont_zdb_id_foreign_key_odc C
accbk_defline text 2147483647  √  null
accbk_abbreviation text 2147483647  √  null
accbk_name text 2147483647  √  null

Table contained 1,895,016 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
accbk_pk_id Primary key Asc accession_bank_primary_key
accbk_acc_num + accbk_fdbcont_zdb_id Must be unique Asc/Asc accbk_alternate_key_index
accbk_fdbcont_zdb_id Performance Asc accbk_fdbcont_foreign_key_index

Close relationships  within of separation: