Table zfindb.public.interpro_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
ip_interpro_id text 2147483647
protein_to_interpro.pti_interpro_id protein_to_interpro_interpro_id C
zdb_active_data.zactvd_zdb_id interpro_protein_zdb_active_data_fk_odc C
ip_name text 2147483647
ip_type text 2147483647

Table contained 37,821 rows at Tue Sep 15 16:40 PDT 2020

Indexes:
Column(s) Type Sort Constraint Name
ip_interpro_id Primary key Asc interpro_protein_pkey
ip_interpro_id + ip_name + ip_type Must be unique Asc/Asc/Asc interpro_protein_ak

Close relationships  within of separation: