Table zfindb.public.protein 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
up_uniprot_id text 2147483647
marker_to_protein.mtp_uniprot_id marker_to_protein_uniprot_id C
protein_to_interpro.pti_uniprot_id protein_to_interpro_uniprot_id C
protein_to_pdb.ptp_uniprot_id protein_to_pdb_uniprot_id C
zdb_active_data.zactvd_zdb_id protein_zdb_active_data_fk_odc C
up_fdbcont_zdb_id text 2147483647
foreign_db_contains.fdbcont_zdb_id protein_fdbcont_zdb_id_fk R
up_length int4 10  √  null

Table contained 56,814 rows at Tue Sep 15 16:40 PDT 2020

Indexes:
Column(s) Type Sort Constraint Name
up_uniprot_id Primary key Asc protein_pkey

Close relationships  within of separation: