Table gmbuilder.public.evidencedstringtype 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
bpccommentgroupabsorptiontype.max fk1d8423bec7e8e1c4 R
evidencedstringtype_evidence.evidencedstringtype_evidence_hjid fkb84fff3e19bd1e5e R
proteinnamegroupalternativenametype.fullname fk872c08e11748f9fa R
proteinnamegrouprecommendednametype.fullname fk7709318f1748f9fa R
proteinnamegroupsubmittednametype.fullname fkf248bbef1748f9fa R
proteintype.allergenname fk4419093d4e30b06d R
proteintype.biotechname fk4419093de2f9b389 R
proteintype_componenttype.allergenname fk2b00f6354e30b06d R
proteintype_componenttype.biotechname fk2b00f635e2f9b389 R
proteintype_domaintype.allergenname fke3f7c6804e30b06d R
proteintype_domaintype.biotechname fke3f7c680e2f9b389 R
hjtype varchar 2147483647
hjversion int8 19
status varchar 2147483647  √  null
value varchar 2147483647  √  null
bpccommentgroupabsorptiontype_text_hjid int8 19  √  null
bpccommentgroupabsorptiontype.hjid fk45d53f9836f8ec94 R
bpccommentgroupabsorptiontype_text_hjindex int4 10  √  null
bpccommentgroupkineticstype_km_hjid int8 19  √  null
bpccommentgroupkineticstype.hjid fk45d53f98108a5f95 R
bpccommentgroupkineticstype_km_hjindex int4 10  √  null
bpccommentgroupkineticstype_vmax_hjid int8 19  √  null
bpccommentgroupkineticstype.hjid fk45d53f984a8788c9 R
bpccommentgroupkineticstype_vmax_hjindex int4 10  √  null
bpccommentgroupkineticstype_text_hjid int8 19  √  null
bpccommentgroupkineticstype.hjid fk45d53f989cd1342a R
bpccommentgroupkineticstype_text_hjindex int4 10  √  null
bpccommentgroupphdependencetype_text_hjid int8 19  √  null
bpccommentgroupphdependencetype.hjid fk45d53f98bfb584f4 R
bpccommentgroupphdependencetype_text_hjindex int4 10  √  null
bpccommentgroupredoxpotentialtype_text_hjid int8 19  √  null
bpccommentgroupredoxpotentialtype.hjid fk45d53f986a2c70de R
bpccommentgroupredoxpotentialtype_text_hjindex int4 10  √  null
bpccommentgrouptemperaturedependencetype_text_hjid int8 19  √  null
bpccommentgrouptemperaturedependencetype.hjid fk45d53f9817115ac8 R
bpccommentgrouptemperaturedependencetype_text_hjindex int4 10  √  null
commenttype_text_hjid int8 19  √  null
commenttype.hjid fk45d53f9891c845aa R
commenttype_text_hjindex int4 10  √  null
isoformtype_text_hjid int8 19  √  null
isoformtype.hjid fk45d53f98a678d7fe R
isoformtype_text_hjindex int4 10  √  null
proteinnamegroupalternativenametype_ecnumber_hjid int8 19  √  null
proteinnamegroupalternativenametype.hjid fk45d53f9898922c00 R
proteinnamegroupalternativenametype_ecnumber_hjindex int4 10  √  null
proteinnamegroupalternativenametype_shortname_hjid int8 19  √  null
proteinnamegroupalternativenametype.hjid fk45d53f987de00adc R
proteinnamegroupalternativenametype_shortname_hjindex int4 10  √  null
proteinnamegrouprecommendednametype_ecnumber_hjid int8 19  √  null
proteinnamegrouprecommendednametype.hjid fk45d53f984d48b4dc R
proteinnamegrouprecommendednametype_ecnumber_hjindex int4 10  √  null
proteinnamegrouprecommendednametype_shortname_hjid int8 19  √  null
proteinnamegrouprecommendednametype.hjid fk45d53f98440fd91c R
proteinnamegrouprecommendednametype_shortname_hjindex int4 10  √  null
proteinnamegroupsubmittednametype_ecnumber_hjid int8 19  √  null
proteinnamegroupsubmittednametype.hjid fk45d53f98dcf8b39c R
proteinnamegroupsubmittednametype_ecnumber_hjindex int4 10  √  null
proteintype_componenttype_cdantigenname_hjid int8 19  √  null
proteintype_componenttype.hjid fk45d53f98c23c0be6 R
proteintype_componenttype_cdantigenname_hjindex int4 10  √  null
proteintype_componenttype_innname_hjid int8 19  √  null
proteintype_componenttype.hjid fk45d53f9899b8b42a R
proteintype_componenttype_innname_hjindex int4 10  √  null
proteintype_domaintype_cdantigenname_hjid int8 19  √  null
proteintype_domaintype.hjid fk45d53f98e79b22e0 R
proteintype_domaintype_cdantigenname_hjindex int4 10  √  null
proteintype_domaintype_innname_hjid int8 19  √  null
proteintype_domaintype.hjid fk45d53f9833363ee4 R
proteintype_domaintype_innname_hjindex int4 10  √  null
proteintype_cdantigenname_hjid int8 19  √  null
proteintype.hjid fk45d53f98ecf3308b R
proteintype_cdantigenname_hjindex int4 10  √  null
proteintype_innname_hjid int8 19  √  null
proteintype.hjid fk45d53f9857f232cf R
proteintype_innname_hjindex int4 10  √  null
subcellularlocationtype_topology_hjid int8 19  √  null
subcellularlocationtype.hjid fk45d53f9828b45ac8 R
subcellularlocationtype_topology_hjindex int4 10  √  null
subcellularlocationtype_orientation_hjid int8 19  √  null
subcellularlocationtype.hjid fk45d53f98e6dad713 R
subcellularlocationtype_orientation_hjindex int4 10  √  null
subcellularlocationtype_location_hjid int8 19  √  null
subcellularlocationtype.hjid fk45d53f989043d942 R
subcellularlocationtype_location_hjindex int4 10  √  null

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

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

Close relationships  within of separation: