Table zfindb.public.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 text 2147483647
organism.organism_common_name foreign_db_contains_organism_foreign_key R
fdbcont_zdb_id text 2147483647
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
protein.up_fdbcont_zdb_id protein_fdbcont_zdb_id_fk R
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 text 2147483647  √  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 87 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
fdbcont_zdb_id Primary key Asc foreign_db_contains_primary_key
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

Close relationships  within of separation: