SchemaSpy - Table zfindb.public.foreign_db

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

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

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

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