Table uniprotdb.public.proteintype 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
hjid int8 19
entrytype.protein fk5adfa2ac3fcd2588 R
evidencedstringtype.proteintype_cdantigenname_hjid fk45d53f98ecf3308b R
evidencedstringtype.proteintype_innname_hjid fk45d53f9857f232cf R
proteinnamegroupalternativenametype.proteintype_alternativename_hjid fk872c08e15abf3d8b R
proteinnamegroupsubmittednametype.proteintype_submittedname_hjid fkf248bbef7d501c7d R
proteintype_componenttype.proteintype_component_hjid fk2b00f635b41920e6 R
proteintype_domaintype.proteintype_domain_hjid fke3f7c6802d1c63b R
hjtype varchar 2147483647
hjversion int8 19
biotechname int8 19  √  null
evidencedstringtype.hjid fk4419093de2f9b389 R
recommendedname int8 19  √  null
proteinnamegrouprecommendednametype.hjid fk4419093d8ba451bd R
allergenname int8 19  √  null
evidencedstringtype.hjid fk4419093d4e30b06d R

Table contained 0 rows at Mon Nov 21 10:47 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
hjid Primary key Asc proteintype_pkey

Close relationships  within of separation: