Table zfindb.informix.foreign_db_contains 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
fdbcont_organism_common_name varchar 30
organism.organism_common_name foreign_db_contains_organism_foreign_key R
fdbcont_zdb_id varchar 50
accession_bank.accbk_fdbcont_zdb_id accbk_fdbcont_zdb_id_foreign_key_odc C
db_link.dblink_fdbcont_zdb_id dblink_fdbcont_zdb_id_foreign_key_odc C
feature_dna_mutation_detail.fdmd_fdbcont_zdb_id fdmd_fdbcont_zdb_id_foreign_key R
feature_protein_mutation_detail.fpmd_fdbcont_zdb_id fpmd_fdbcont_zdb_id_fk_constraint R
ncbi_ortholog_external_reference.noer_fdbcont_zdb_id noer_fdbcont_zdb_id_fk_odc C
ortholog_external_reference.oef_fdbcont_zdb_id oef_fdbcont_zdb_id_fk_odc C
pub_db_xref.pdx_fdbcont_zdb_id pdx_db_xref_fdbcont_fk R
fdbcont_fdbdt_id int8 19
foreign_db_data_type.fdbdt_pk_id fdbcont_fdbdt_id_foreign_key R
fdbcont_primary_blastdb_zdb_id varchar 50  √  null
blast_database.blastdb_zdb_id fdbcont_primary_blastdb_zdb_id_foreign_key R
fdbcont_fdb_db_id int8 19
foreign_db.fdb_db_pk_id fdbcont_fdb_db_id_foriegn_key R

Table contained 79 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
fdbcont_fdb_db_id Performance Asc fdbcont_fdb_db_id_foreign_key_index
fdbcont_fdbdt_id Performance Asc fdbcont_fdbdt_id_foreign_key_index
fdbcont_primary_blastdb_zdb_id Performance Asc fdbcont_primary_blastdb_zdb_id_foreign_key_index
fdbcont_organism_common_name Performance Asc foreign_db_contains_organism_foreign_key_index
fdbcont_zdb_id Must be unique Asc foreign_db_contains_primary_key_index

Close relationships  within of separation: