Table zfindb.informix.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 varchar 50
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 varchar 100
blastdb_abbrev varchar 30
blastdb_description lvarchar 2500  √  null
blastdb_public boolean 1 f
blastdb_type varchar 10
blast_database_type.bdbt_type blast_database_type_foreign_key R
blastdb_path varchar 255  √  null
blastdb_tool_display_name varchar 70
blastdb_tool_display_order int 10  √  null
blastdb_is_being_processed boolean 1 f
blastdb_origination_id int8 19  √  null
blast_database_origination_type.bdot_pk_id bdot_origination_id_foreign_key R
blastdb_num_seqs int 10  √  null
blastdb_num_accessions int 10  √  null
blastdb_last_regenerated datetime year to second 19  √  null
blastdb_old_num_seqs varchar 30  √  null

Table contained 57 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
blastdb_description + blastdb_is_being_processed + blastdb_public + blastdb_origination_id Performance Asc/Asc/Asc/Asc 321_1478
blastdb_description + blastdb_is_being_processed + blastdb_public + blastdb_type Performance Asc/Asc/Asc/Asc 321_1479
blastdb_description + blastdb_is_being_processed + blastdb_public + blastdb_name Must be unique Asc/Asc/Asc/Asc blast_database_alternate_key_index
blastdb_description + blastdb_is_being_processed + blastdb_public + blastdb_zdb_id Must be unique Asc/Asc/Asc/Asc blast_database_primary_key_index

Close relationships  within of separation: