SchemaSpy - Table zfindb.public.blast_database

Generated by
SchemaSpy

Legend:

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 54 rows at Wed Sep 15 00:41 PDT 2021

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