Table zfindb.public.blast_database 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
blastdb_zdb_id text 2147483647
blastdb_order.bdborder_child_blastdb_zdb_id bdborder_child_foreign_key R
blastdb_order.bdborder_parent_blastdb_zdb_id bdborder_parent_foreign_key R
blastdb_regen_content.brc_blastdb_zdb_id blastdb_regen_content_blastdb_zdb_id_foreign_key R
blastdb_run.blastdbr_blastdb_zdb_id blastdbr_blastdb_zdb_id_foreign_key R
foreign_db_contains.fdbcont_primary_blastdb_zdb_id fdbcont_primary_blastdb_zdb_id_foreign_key R
int_fdbcont_analysis_tool.ifat_blastdb_zdb_id ifat_blastdb_foreign_key_odc C
blastdb_name text 2147483647
blastdb_abbrev text 2147483647
blastdb_description text 2147483647  √  null
blastdb_public bool 1 false
blastdb_type text 2147483647
blast_database_type.bdbt_type blast_database_type_foreign_key R
blastdb_path text 2147483647  √  null
blastdb_tool_display_name text 2147483647
blastdb_tool_display_order int4 10  √  null
blastdb_is_being_processed bool 1 false
blastdb_origination_id int8 19  √  null
blast_database_origination_type.bdot_pk_id bdot_origination_id_foreign_key R
blastdb_num_seqs int4 10  √  null
blastdb_num_accessions int4 10  √  null
blastdb_last_regenerated timestamp 29,6  √  null
blastdb_old_num_seqs text 2147483647  √  null

Table contained 55 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
blastdb_zdb_id Primary key Asc blast_database_primary_key
blastdb_origination_id Performance Asc bdot_origination_id_foreign_key_index
blastdb_name Must be unique Asc blast_database_alternate_key_index
blastdb_type Performance Asc blast_database_type_foreign_key_index

Close relationships  within of separation: