Table uniprotdb.public.proteinnamegroupalternativenametype 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
evidencedstringtype.proteinnamegroupalternativenametype_ecnumber_hjid fk45d53f9898922c00 R
evidencedstringtype.proteinnamegroupalternativenametype_shortname_hjid fk45d53f987de00adc R
hjtype varchar 2147483647
hjversion int8 19
fullname int8 19  √  null
evidencedstringtype.hjid fk872c08e11748f9fa R
proteintype_componenttype_alternativename_hjid int8 19  √  null
proteintype_componenttype.hjid fk872c08e1d2ff36e6 R
proteintype_componenttype_alternativename_hjindex int4 10  √  null
proteintype_domaintype_alternativename_hjid int8 19  √  null
proteintype_domaintype.hjid fk872c08e154d01ca0 R
proteintype_domaintype_alternativename_hjindex int4 10  √  null
proteintype_alternativename_hjid int8 19  √  null
proteintype.hjid fk872c08e15abf3d8b R
proteintype_alternativename_hjindex int4 10  √  null

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

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

Close relationships  within of separation: