SchemaSpy Analysis of gmbuilder.public - Columns Back to documentation
XMLPipeDB
Generated by SchemaSpy on Mon Apr 20 11:21 PDT 2009
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

gmbuilder.public contains 717 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
acc content varchar 0  √  null
acc hjid int8 8
acc hjtype varchar 0
acc hjversion int8 8
altid content varchar 0  √  null
altid hjid int8 8
altid hjtype varchar 0
altid hjversion int8 8
autogeneratedby content varchar 0  √  null
autogeneratedby hjid int8 8
autogeneratedby hjtype varchar 0
autogeneratedby hjversion int8 8
bpccommentgroupabsorptiontype hjid int8 8
commenttype.absorption fke0cb521925e10d55
bpccommentgroupabsorptiontype hjtype varchar 0
bpccommentgroupabsorptiontype hjversion int8 8
bpccommentgroupabsorptiontype max varchar 0  √  null
bpccommentgroupabsorptiontype text varchar 0  √  null
bpccommentgroupkineticstype hjid int8 8
bpccommentgroupkineticstype_km.bpccommentgroupkineticstype_km_hjid fk7f295df8108a5f95
bpccommentgroupkineticstype_vmax.bpccommentgroupkineticstype_vmax_hjid fk5a4f44644a8788c9
commenttype.kinetics fke0cb5219d8cf5aeb
bpccommentgroupkineticstype hjtype varchar 0
bpccommentgroupkineticstype hjversion int8 8
bpccommentgroupkineticstype text varchar 0  √  null
bpccommentgroupkineticstype_km bpccommentgroupkineticstype_km_hjid int8 8
bpccommentgroupkineticstype.hjid fk7f295df8108a5f95
bpccommentgroupkineticstype_km bpccommentgroupkineticstype_km_hjindex int4 4
bpccommentgroupkineticstype_km hjvalue varchar 0  √  null
bpccommentgroupkineticstype_vmax bpccommentgroupkineticstype_vmax_hjid int8 8
bpccommentgroupkineticstype.hjid fk5a4f44644a8788c9
bpccommentgroupkineticstype_vmax bpccommentgroupkineticstype_vmax_hjindex int4 4
bpccommentgroupkineticstype_vmax hjvalue varchar 0  √  null
citationtype authorlist int8 8  √  null
namelisttype.hjid fk7c9796e1f57415a4
citationtype citingcitation int8 8  √  null
citationtype.hjid fk7c9796e136491e54
citationtype city varchar 0  √  null
citationtype country varchar 0  √  null
citationtype date_hjclass varchar 0  √  null
citationtype date_hjid int8 8  √  null
citationtype db varchar 0  √  null
citationtype editorlist int8 8  √  null
namelisttype.hjid fk7c9796e1f22c5486
citationtype first varchar 0  √  null
citationtype hjid int8 8
citationtype.citingcitation fk7c9796e136491e54
dbreferencetype.citationtype_dbreference_hjid fke43b3d279338ff06
referencetype.citation fk8f0bd505dc62f600
citationtype hjtype varchar 0
citationtype hjversion int8 8
citationtype institute varchar 0  √  null
citationtype last varchar 0  √  null
citationtype locator varchar 0  √  null
citationtype name varchar 0  √  null
citationtype number varchar 0  √  null
citationtype publisher varchar 0  √  null
citationtype title varchar 0  √  null
citationtype type varchar 0  √  null
citationtype volume varchar 0  √  null
comment content varchar 0  √  null
comment hjid int8 8
comment hjtype varchar 0
comment hjversion int8 8
commenttype absorption int8 8  √  null
bpccommentgroupabsorptiontype.hjid fke0cb521925e10d55
commenttype conflict int8 8  √  null
commenttype_conflicttype.hjid fke0cb5219cfa3bf01
commenttype error varchar 0  √  null
commenttype evidence varchar 0  √  null
commenttype experiments numeric 65535,65531  √  null
commenttype hjid int8 8
commenttype_linktype.commenttype_link_hjid fk856ab5da6ecf92fd
eventtype.commenttype_event_hjid fk7951b8d4603ad4e9
interactanttype.commenttype_interactant_hjid fkdcfa0aabdb8bd172
isoformtype.commenttype_isoform_hjid fk981cf9838394509a
locationtype.commenttype_location_hjid fk65214af9d640322
subcellularlocationtype.commenttype_subcellularlocation_hjid fkdab41539501d42c4
commenttype hjtype varchar 0
commenttype hjversion int8 8
commenttype kinetics int8 8  √  null
bpccommentgroupkineticstype.hjid fke0cb5219d8cf5aeb
commenttype mass float4 4  √  null
commenttype method varchar 0  √  null
commenttype molecule varchar 0  √  null
commenttype name varchar 0  √  null
commenttype organismsdiffer bool 1  √  null
commenttype phdependence varchar 0  √  null
commenttype redoxpotential varchar 0  √  null
commenttype temperaturedependence varchar 0  √  null
commenttype text int8 8  √  null
evidencedstringtype.hjid fke0cb5219c81d818d
commenttype type varchar 0  √  null
commenttype_conflicttype hjid int8 8
commenttype.conflict fke0cb5219cfa3bf01
commenttype_conflicttype hjtype varchar 0
commenttype_conflicttype hjversion int8 8
commenttype_conflicttype ref varchar 0  √  null
commenttype_conflicttype sequence int8 8  √  null
commenttype_conflicttype_sequencetype.hjid fk6f5452b2bcd5b9d1
commenttype_conflicttype type varchar 0  √  null
commenttype_conflicttype_sequencetype hjid int8 8
commenttype_conflicttype.sequence fk6f5452b2bcd5b9d1
commenttype_conflicttype_sequencetype hjtype varchar 0
commenttype_conflicttype_sequencetype hjversion int8 8
commenttype_conflicttype_sequencetype id varchar 0  √  null
commenttype_conflicttype_sequencetype resource varchar 0  √  null
commenttype_conflicttype_sequencetype version numeric 65535,65531  √  null
commenttype_linktype commenttype_link_hjid int8 8  √  null
commenttype.hjid fk856ab5da6ecf92fd
commenttype_linktype commenttype_link_hjindex int4 4  √  null
commenttype_linktype hjid int8 8
commenttype_linktype hjtype varchar 0
commenttype_linktype hjversion int8 8
commenttype_linktype uri varchar 0  √  null
consider content varchar 0  √  null
consider hjid int8 8
consider hjtype varchar 0
consider hjversion int8 8
consortiumtype hjid int8 8
consortiumtype hjtype varchar 0
consortiumtype hjversion int8 8
consortiumtype name varchar 0  √  null
copyright hjid int8 8
copyright hjtype varchar 0
copyright hjversion int8 8
copyright value varchar 0  √  null
createdby content varchar 0  √  null
createdby hjid int8 8
createdby hjtype varchar 0
createdby hjversion int8 8
creationdate content varchar 0  √  null
creationdate hjid int8 8
creationdate hjtype varchar 0
creationdate hjversion int8 8
date content varchar 0  √  null
date hjid int8 8
date hjtype varchar 0
date hjversion int8 8
dbname content varchar 0  √  null
dbname hjid int8 8
dbname hjtype varchar 0
dbname hjversion int8 8
dbreferencetype citationtype_dbreference_hjid int8 8  √  null
citationtype.hjid fke43b3d279338ff06
dbreferencetype citationtype_dbreference_hjindex int4 4  √  null
dbreferencetype entrytype_dbreference_hjid int8 8  √  null
entrytype.hjid fke43b3d27e13d04b6
dbreferencetype entrytype_dbreference_hjindex int4 4  √  null
dbreferencetype evidence varchar 0  √  null
dbreferencetype hjid int8 8
propertytype.dbreferencetype_property_hjid fkd64442cf68b562be
dbreferencetype hjtype varchar 0
dbreferencetype hjversion int8 8
dbreferencetype id varchar 0  √  null
dbreferencetype key varchar 0  √  null
dbreferencetype organismtype_dbreference_hjid int8 8  √  null
organismtype.hjid fke43b3d2762738266
dbreferencetype organismtype_dbreference_hjindex int4 4  √  null
dbreferencetype type varchar 0  √  null
dbxref hjid int8 8
dbxref_content.dbxref_content_hjid fkd2ec78d3f25e5d81
dbxref hjtype varchar 0
dbxref hjversion int8 8
dbxref_content dbxref_content_hjchildid int8 8  √  null
dbxref_content dbxref_content_hjclass varchar 0  √  null
dbxref_content dbxref_content_hjid int8 8
dbxref.hjid fkd2ec78d3f25e5d81
dbxref_content dbxref_content_hjindex int4 4
def hjid int8 8
def_content.def_content_hjid fk297cc9ffab33cea3
def hjtype varchar 0
def hjversion int8 8
def_content def_content_hjchildid int8 8  √  null
def_content def_content_hjclass varchar 0  √  null
def_content def_content_hjid int8 8
def.hjid fk297cc9ffab33cea3
def_content def_content_hjindex int4 4
defaultnamespace content varchar 0  √  null
defaultnamespace hjid int8 8
defaultnamespace hjtype varchar 0
defaultnamespace hjversion int8 8
defstr content varchar 0  √  null
defstr hjid int8 8
defstr hjtype varchar 0
defstr hjversion int8 8
disjointfrom content varchar 0  √  null
disjointfrom hjid int8 8
disjointfrom hjtype varchar 0
disjointfrom hjversion int8 8
domain content varchar 0  √  null
domain hjid int8 8
domain hjtype varchar 0
domain hjversion int8 8
entrytype created timestamp 8,6  √  null
entrytype dataset varchar 0  √  null
entrytype hjid int8 8
dbreferencetype.entrytype_dbreference_hjid fke43b3d27e13d04b6
entrytype_accession.entrytype_accession_hjid fkf3878e31135b043f
entrytype_comment.entrytype_comment_hjid fk208663aca2ddba4
entrytype_genetype.entrytype_gene_hjid fk80090042cb570028
entrytype_name.entrytype_name_hjid fk3476d05e4cb1a72
evidencetype.entrytype_evidence_hjid fk3691f25187be97a6
featuretype.entrytype_feature_hjid fk4cf1bb3022d4956d
genelocationtype.entrytype_genelocation_hjid fk3055bc647f1c3193
keywordtype.entrytype_keyword_hjid fk1603aca37c00d25a
organismtype.entrytype_organism_hjid fk44b91f4c3e7d0a0b
organismtype.entrytype_organismhost_hjid fk44b91f4c46dcd7e3
referencetype.entrytype_reference_hjid fk8f0bd50574685d78
entrytype hjtype varchar 0
entrytype hjversion int8 8
entrytype modified timestamp 8,6  √  null
entrytype protein int8 8  √  null
proteintype.hjid fk5adfa2ac3fcd2588
entrytype proteinexistence int8 8  √  null
proteinexistencetype.hjid fk5adfa2ac25cd0850
entrytype sequence int8 8  √  null
sequencetype.hjid fk5adfa2ac4029d2b4
entrytype uniprottype_entry_hjid int8 8  √  null
uniprottype.hjid fk5adfa2ac4b853b11
entrytype uniprottype_entry_hjindex int4 4  √  null
entrytype version numeric 65535,65531  √  null
entrytype_accession entrytype_accession_hjid int8 8
entrytype.hjid fkf3878e31135b043f
entrytype_accession entrytype_accession_hjindex int4 4
entrytype_accession hjvalue varchar 0  √  null
entrytype_comment entrytype_comment_hjchildid int8 8  √  null
entrytype_comment entrytype_comment_hjclass varchar 0  √  null
entrytype_comment entrytype_comment_hjid int8 8
entrytype.hjid fk208663aca2ddba4
entrytype_comment entrytype_comment_hjindex int4 4
entrytype_genetype entrytype_gene_hjid int8 8  √  null
entrytype.hjid fk80090042cb570028
entrytype_genetype entrytype_gene_hjindex int4 4  √  null
entrytype_genetype hjid int8 8
genenametype.entrytype_genetype_name_hjid fkc89d6eba37ea5013
entrytype_genetype hjtype varchar 0
entrytype_genetype hjversion int8 8
entrytype_name entrytype_name_hjid int8 8
entrytype.hjid fk3476d05e4cb1a72
entrytype_name entrytype_name_hjindex int4 4
entrytype_name hjvalue varchar 0  √  null
eventtype commenttype_event_hjid int8 8  √  null
commenttype.hjid fk7951b8d4603ad4e9
eventtype commenttype_event_hjindex int4 4  √  null
eventtype hjid int8 8
eventtype hjtype varchar 0
eventtype hjversion int8 8
eventtype type varchar 0  √  null
evidencedstringtype evidence varchar 0  √  null
evidencedstringtype hjid int8 8
commenttype.text fke0cb5219c81d818d
proteinnamegroupalternativenametype.fullname fk872c08e11748f9fa
proteinnamegrouprecommendednametype.fullname fk7709318f1748f9fa
proteinnamegroupsubmittednametype.fullname fkf248bbef1748f9fa
proteintype.allergenname fk4419093d4e30b06d
proteintype.biotechname fk4419093de2f9b389
proteintype_componenttype.allergenname fk2b00f6354e30b06d
proteintype_componenttype.biotechname fk2b00f635e2f9b389
proteintype_domaintype.allergenname fke3f7c6804e30b06d
proteintype_domaintype.biotechname fke3f7c680e2f9b389
evidencedstringtype hjtype varchar 0
evidencedstringtype hjversion int8 8
evidencedstringtype proteinnamegroupalternativenametype_shortname_hjid int8 8  √  null
proteinnamegroupalternativenametype.hjid fk45d53f987de00adc
evidencedstringtype proteinnamegroupalternativenametype_shortname_hjindex int4 4  √  null
evidencedstringtype proteinnamegrouprecommendednametype_shortname_hjid int8 8  √  null
proteinnamegrouprecommendednametype.hjid fk45d53f98440fd91c
evidencedstringtype proteinnamegrouprecommendednametype_shortname_hjindex int4 4  √  null
evidencedstringtype proteintype_cdantigenname_hjid int8 8  √  null
proteintype.hjid fk45d53f98ecf3308b
evidencedstringtype proteintype_cdantigenname_hjindex int4 4  √  null
evidencedstringtype proteintype_componenttype_cdantigenname_hjid int8 8  √  null
proteintype_componenttype.hjid fk45d53f98c23c0be6
evidencedstringtype proteintype_componenttype_cdantigenname_hjindex int4 4  √  null
evidencedstringtype proteintype_componenttype_innname_hjid int8 8  √  null
proteintype_componenttype.hjid fk45d53f9899b8b42a
evidencedstringtype proteintype_componenttype_innname_hjindex int4 4  √  null
evidencedstringtype proteintype_domaintype_cdantigenname_hjid int8 8  √  null
proteintype_domaintype.hjid fk45d53f98e79b22e0
evidencedstringtype proteintype_domaintype_cdantigenname_hjindex int4 4  √  null
evidencedstringtype proteintype_domaintype_innname_hjid int8 8  √  null
proteintype_domaintype.hjid fk45d53f9833363ee4
evidencedstringtype proteintype_domaintype_innname_hjindex int4 4  √  null
evidencedstringtype proteintype_innname_hjid int8 8  √  null
proteintype.hjid fk45d53f9857f232cf
evidencedstringtype proteintype_innname_hjindex int4 4  √  null
evidencedstringtype status varchar 0  √  null
evidencedstringtype subcellularlocationtype_location_hjid int8 8  √  null
subcellularlocationtype.hjid fk45d53f989043d942
evidencedstringtype subcellularlocationtype_location_hjindex int4 4  √  null
evidencedstringtype subcellularlocationtype_orientation_hjid int8 8  √  null
subcellularlocationtype.hjid fk45d53f98e6dad713
evidencedstringtype subcellularlocationtype_orientation_hjindex int4 4  √  null
evidencedstringtype subcellularlocationtype_topology_hjid int8 8  √  null
subcellularlocationtype.hjid fk45d53f9828b45ac8
evidencedstringtype subcellularlocationtype_topology_hjindex int4 4  √  null
evidencedstringtype value varchar 0  √  null
evidencetype attribute varchar 0  √  null
evidencetype category varchar 0  √  null
evidencetype date timestamp 8,6  √  null
evidencetype entrytype_evidence_hjid int8 8  √  null
entrytype.hjid fk3691f25187be97a6
evidencetype entrytype_evidence_hjindex int4 4  √  null
evidencetype hjid int8 8
evidencetype hjtype varchar 0
evidencetype hjversion int8 8
evidencetype key varchar 0  √  null
evidencetype type varchar 0  √  null
featuretype description varchar 0  √  null
featuretype entrytype_feature_hjid int8 8  √  null
entrytype.hjid fk4cf1bb3022d4956d
featuretype entrytype_feature_hjindex int4 4  √  null
featuretype evidence varchar 0  √  null
featuretype hjid int8 8
featuretype_variation.featuretype_variation_hjid fka6f63ba4953dd530
featuretype hjtype varchar 0
featuretype hjversion int8 8
featuretype id varchar 0  √  null
featuretype location int8 8  √  null
locationtype.hjid fk4cf1bb302d6b089c
featuretype original varchar 0  √  null
featuretype ref varchar 0  √  null
featuretype status varchar 0  √  null
featuretype type varchar 0  √  null
featuretype_variation featuretype_variation_hjid int8 8
featuretype.hjid fka6f63ba4953dd530
featuretype_variation featuretype_variation_hjindex int4 4
featuretype_variation hjvalue varchar 0  √  null
formatversion content varchar 0  √  null
formatversion hjid int8 8
formatversion hjtype varchar 0
formatversion hjversion int8 8
genelocationtype entrytype_genelocation_hjid int8 8  √  null
entrytype.hjid fk3055bc647f1c3193
genelocationtype entrytype_genelocation_hjindex int4 4  √  null
genelocationtype evidence varchar 0  √  null
genelocationtype hjid int8 8
genelocationtype hjtype varchar 0
genelocationtype hjversion int8 8
genelocationtype name int8 8  √  null
statustype.hjid fk3055bc64b7cee32f
genelocationtype type varchar 0  √  null
genenametype entrytype_genetype_name_hjid int8 8  √  null
entrytype_genetype.hjid fkc89d6eba37ea5013
genenametype entrytype_genetype_name_hjindex int4 4  √  null
genenametype evidence varchar 0  √  null
genenametype hjid int8 8
genenametype hjtype varchar 0
genenametype hjversion int8 8
genenametype type varchar 0  √  null
genenametype value varchar 0  √  null
global content varchar 0  √  null
global hjid int8 8
global hjtype varchar 0
global hjversion int8 8
header hjid int8 8
header_content.header_content_hjid fk43aa44c77ed8ea01
header hjtype varchar 0
header hjversion int8 8
header_content header_content_hjchildid int8 8  √  null
header_content header_content_hjclass varchar 0  √  null
header_content header_content_hjid int8 8
header.hjid fk43aa44c77ed8ea01
header_content header_content_hjindex int4 4
id content varchar 0  √  null
id hjid int8 8
id hjtype varchar 0
id hjversion int8 8
idspace hjid int8 8
idspace_content.idspace_content_hjid fke7560cc5798d57e3
idspace hjtype varchar 0
idspace hjversion int8 8
idspace_content idspace_content_hjchildid int8 8  √  null
idspace_content idspace_content_hjclass varchar 0  √  null
idspace_content idspace_content_hjid int8 8
idspace.hjid fke7560cc5798d57e3
idspace_content idspace_content_hjindex int4 4
interactanttype commenttype_interactant_hjid int8 8  √  null
commenttype.hjid fkdcfa0aabdb8bd172
interactanttype commenttype_interactant_hjindex int4 4  √  null
interactanttype hjid int8 8
interactanttype hjtype varchar 0
interactanttype hjversion int8 8
interactanttype id varchar 0  √  null
interactanttype intactid varchar 0  √  null
interactanttype label varchar 0  √  null
intersectionof hjid int8 8
intersectionof_content.intersectionof_content_hjid fk7e0b957a6ef53e01
intersectionof hjtype varchar 0
intersectionof hjversion int8 8
intersectionof_content intersectionof_content_hjchildid int8 8  √  null
intersectionof_content intersectionof_content_hjclass varchar 0  √  null
intersectionof_content intersectionof_content_hjid int8 8
intersectionof.hjid fk7e0b957a6ef53e01
intersectionof_content intersectionof_content_hjindex int4 4
inverseof content varchar 0  √  null
inverseof hjid int8 8
inverseof hjtype varchar 0
inverseof hjversion int8 8
isa content varchar 0  √  null
isa hjid int8 8
isa hjtype varchar 0
isa hjversion int8 8
isanonymous content varchar 0  √  null
isanonymous hjid int8 8
isanonymous hjtype varchar 0
isanonymous hjversion int8 8
isantisymmetric content varchar 0  √  null
isantisymmetric hjid int8 8
isantisymmetric hjtype varchar 0
isantisymmetric hjversion int8 8
isobsolete content varchar 0  √  null
isobsolete hjid int8 8
isobsolete hjtype varchar 0
isobsolete hjversion int8 8
isoformtype commenttype_isoform_hjid int8 8  √  null
commenttype.hjid fk981cf9838394509a
isoformtype commenttype_isoform_hjindex int4 4  √  null
isoformtype hjid int8 8
isoformtype_id.isoformtype_id_hjid fk93d161776be415d0
isoformtype_nametype.isoformtype_name_hjid fkaef4dfc12ddc4d60
isoformtype hjtype varchar 0
isoformtype hjversion int8 8
isoformtype note int8 8  √  null
isoformtype_notetype.hjid fk981cf9833419c097
isoformtype sequence int8 8  √  null
isoformtype_sequencetype.hjid fk981cf98352dffc35
isoformtype_id hjvalue varchar 0  √  null
isoformtype_id isoformtype_id_hjid int8 8
isoformtype.hjid fk93d161776be415d0
isoformtype_id isoformtype_id_hjindex int4 4
isoformtype_nametype evidence varchar 0  √  null
isoformtype_nametype hjid int8 8
isoformtype_nametype hjtype varchar 0
isoformtype_nametype hjversion int8 8
isoformtype_nametype isoformtype_name_hjid int8 8  √  null
isoformtype.hjid fkaef4dfc12ddc4d60
isoformtype_nametype isoformtype_name_hjindex int4 4  √  null
isoformtype_nametype value varchar 0  √  null
isoformtype_notetype evidence varchar 0  √  null
isoformtype_notetype hjid int8 8
isoformtype.note fk981cf9833419c097
isoformtype_notetype hjtype varchar 0
isoformtype_notetype hjversion int8 8
isoformtype_notetype value varchar 0  √  null
isoformtype_sequencetype hjid int8 8
isoformtype.sequence fk981cf98352dffc35
isoformtype_sequencetype hjtype varchar 0
isoformtype_sequencetype hjversion int8 8
isoformtype_sequencetype ref varchar 0  √  null
isoformtype_sequencetype type varchar 0  √  null
isreflexive content varchar 0  √  null
isreflexive hjid int8 8
isreflexive hjtype varchar 0
isreflexive hjversion int8 8
isroot content varchar 0  √  null
isroot hjid int8 8
isroot hjtype varchar 0
isroot hjversion int8 8
issymmetric content varchar 0  √  null
issymmetric hjid int8 8
issymmetric hjtype varchar 0
issymmetric hjversion int8 8
istransitive content varchar 0  √  null
istransitive hjid int8 8
istransitive hjtype varchar 0
istransitive hjversion int8 8
keywordtype entrytype_keyword_hjid int8 8  √  null
entrytype.hjid fk1603aca37c00d25a
keywordtype entrytype_keyword_hjindex int4 4  √  null
keywordtype evidence varchar 0  √  null
keywordtype hjid int8 8
keywordtype hjtype varchar 0
keywordtype hjversion int8 8
keywordtype id varchar 0  √  null
keywordtype value varchar 0  √  null
lexicalcategory content varchar 0  √  null
lexicalcategory hjid int8 8
lexicalcategory hjtype varchar 0
lexicalcategory hjversion int8 8
local content varchar 0  √  null
local hjid int8 8
local hjtype varchar 0
local hjversion int8 8
locationtype begin int8 8  √  null
positiontype.hjid fk65214afc7310104
locationtype commenttype_location_hjid int8 8  √  null
commenttype.hjid fk65214af9d640322
locationtype commenttype_location_hjindex int4 4  √  null
locationtype endposition int8 8  √  null
positiontype.hjid fk65214afc19e1136
locationtype hjid int8 8
featuretype.location fk4cf1bb302d6b089c
locationtype hjtype varchar 0
locationtype hjversion int8 8
locationtype position int8 8  √  null
positiontype.hjid fk65214afee2f2184
locationtype sequence varchar 0  √  null
name content varchar 0  √  null
name hjid int8 8
name hjtype varchar 0
name hjversion int8 8
namelisttype hjid int8 8
citationtype.authorlist fk7c9796e1f57415a4
citationtype.editorlist fk7c9796e1f22c5486
namelisttype_personorconsortium.namelisttype_personorconsortium_hjid fk452761f5969e4ea2
namelisttype hjtype varchar 0
namelisttype hjversion int8 8
namelisttype_personorconsortium namelisttype_personorconsortium_hjchildid int8 8  √  null
namelisttype_personorconsortium namelisttype_personorconsortium_hjclass varchar 0  √  null
namelisttype_personorconsortium namelisttype_personorconsortium_hjid int8 8
namelisttype.hjid fk452761f5969e4ea2
namelisttype_personorconsortium namelisttype_personorconsortium_hjindex int4 4
namespace content varchar 0  √  null
namespace hjid int8 8
namespace hjtype varchar 0
namespace hjversion int8 8
obo hjid int8 8
obo_content.obo_content_hjid fke8dc0bf63fb25803
obo hjtype varchar 0
obo hjversion int8 8
obo_content obo_content_hjchildid int8 8  √  null
obo_content obo_content_hjclass varchar 0  √  null
obo_content obo_content_hjid int8 8
obo.hjid fke8dc0bf63fb25803
obo_content obo_content_hjindex int4 4
organismnametype hjid int8 8
organismnametype hjtype varchar 0
organismnametype hjversion int8 8
organismnametype organismtype_name_hjid int8 8  √  null
organismtype.hjid fk8f6d77774ebd64e2
organismnametype organismtype_name_hjindex int4 4  √  null
organismnametype type varchar 0  √  null
organismnametype value varchar 0  √  null
organismtype entrytype_organism_hjid int8 8  √  null
entrytype.hjid fk44b91f4c3e7d0a0b
organismtype entrytype_organism_hjindex int4 4  √  null
organismtype entrytype_organismhost_hjid int8 8  √  null
entrytype.hjid fk44b91f4c46dcd7e3
organismtype entrytype_organismhost_hjindex int4 4  √  null
organismtype hjid int8 8
dbreferencetype.organismtype_dbreference_hjid fke43b3d2762738266
organismnametype.organismtype_name_hjid fk8f6d77774ebd64e2
organismtype hjtype varchar 0
organismtype hjversion int8 8
organismtype key varchar 0  √  null
organismtype lineage int8 8  √  null
organismtype_lineagetype.hjid fk44b91f4c167da5b0
organismtype_lineagetype hjid int8 8
organismtype.lineage fk44b91f4c167da5b0
organismtype_lineagetype_taxon.organismtype_lineagetype_taxon_hjid fk261f89fdf8d2e7e4
organismtype_lineagetype hjtype varchar 0
organismtype_lineagetype hjversion int8 8
organismtype_lineagetype_taxon hjvalue varchar 0  √  null
organismtype_lineagetype_taxon organismtype_lineagetype_taxon_hjid int8 8
organismtype_lineagetype.hjid fk261f89fdf8d2e7e4
organismtype_lineagetype_taxon organismtype_lineagetype_taxon_hjindex int4 4
persontype hjid int8 8
persontype hjtype varchar 0
persontype hjversion int8 8
persontype name varchar 0  √  null
positiontype hjid int8 8
locationtype.begin fk65214afc7310104
locationtype.endposition fk65214afc19e1136
locationtype.position fk65214afee2f2184
positiontype hjtype varchar 0
positiontype hjversion int8 8
positiontype position numeric 65535,65531  √  null
positiontype status varchar 0  √  null
propertytype dbreferencetype_property_hjid int8 8  √  null
dbreferencetype.hjid fkd64442cf68b562be
propertytype dbreferencetype_property_hjindex int4 4  √  null
propertytype hjid int8 8
propertytype hjtype varchar 0
propertytype hjversion int8 8
propertytype type varchar 0  √  null
propertytype value varchar 0  √  null
proteinexistencetype hjid int8 8
entrytype.proteinexistence fk5adfa2ac25cd0850
proteinexistencetype hjtype varchar 0
proteinexistencetype hjversion int8 8
proteinexistencetype type varchar 0  √  null
proteinnamegroupalternativenametype fullname int8 8  √  null
evidencedstringtype.hjid fk872c08e11748f9fa
proteinnamegroupalternativenametype hjid int8 8
evidencedstringtype.proteinnamegroupalternativenametype_shortname_hjid fk45d53f987de00adc
proteinnamegroupalternativenametype hjtype varchar 0
proteinnamegroupalternativenametype hjversion int8 8
proteinnamegroupalternativenametype proteintype_alternativename_hjid int8 8  √  null
proteintype.hjid fk872c08e15abf3d8b
proteinnamegroupalternativenametype proteintype_alternativename_hjindex int4 4  √  null
proteinnamegroupalternativenametype proteintype_componenttype_alternativename_hjid int8 8  √  null
proteintype_componenttype.hjid fk872c08e1d2ff36e6
proteinnamegroupalternativenametype proteintype_componenttype_alternativename_hjindex int4 4  √  null
proteinnamegroupalternativenametype proteintype_domaintype_alternativename_hjid int8 8  √  null
proteintype_domaintype.hjid fk872c08e154d01ca0
proteinnamegroupalternativenametype proteintype_domaintype_alternativename_hjindex int4 4  √  null
proteinnamegroupalternativenametype ref varchar 0  √  null
proteinnamegrouprecommendednametype fullname int8 8  √  null
evidencedstringtype.hjid fk7709318f1748f9fa
proteinnamegrouprecommendednametype hjid int8 8
evidencedstringtype.proteinnamegrouprecommendednametype_shortname_hjid fk45d53f98440fd91c
proteintype.recommendedname fk4419093d8ba451bd
proteintype_componenttype.recommendedname fk2b00f6358ba451bd
proteintype_domaintype.recommendedname fke3f7c6808ba451bd
proteinnamegrouprecommendednametype hjtype varchar 0
proteinnamegrouprecommendednametype hjversion int8 8
proteinnamegrouprecommendednametype ref varchar 0  √  null
proteinnamegroupsubmittednametype fullname int8 8  √  null
evidencedstringtype.hjid fkf248bbef1748f9fa
proteinnamegroupsubmittednametype hjid int8 8
proteinnamegroupsubmittednametype hjtype varchar 0
proteinnamegroupsubmittednametype hjversion int8 8
proteinnamegroupsubmittednametype proteintype_componenttype_submittedname_hjid int8 8  √  null
proteintype_componenttype.hjid fkf248bbef5298f7d8
proteinnamegroupsubmittednametype proteintype_componenttype_submittedname_hjindex int4 4  √  null
proteinnamegroupsubmittednametype proteintype_domaintype_submittedname_hjid int8 8  √  null
proteintype_domaintype.hjid fkf248bbef77f80ed2
proteinnamegroupsubmittednametype proteintype_domaintype_submittedname_hjindex int4 4  √  null
proteinnamegroupsubmittednametype proteintype_submittedname_hjid int8 8  √  null
proteintype.hjid fkf248bbef7d501c7d
proteinnamegroupsubmittednametype proteintype_submittedname_hjindex int4 4  √  null
proteinnamegroupsubmittednametype ref varchar 0  √  null
proteintype allergenname int8 8  √  null
evidencedstringtype.hjid fk4419093d4e30b06d
proteintype biotechname int8 8  √  null
evidencedstringtype.hjid fk4419093de2f9b389
proteintype hjid int8 8
entrytype.protein fk5adfa2ac3fcd2588
evidencedstringtype.proteintype_cdantigenname_hjid fk45d53f98ecf3308b
evidencedstringtype.proteintype_innname_hjid fk45d53f9857f232cf
proteinnamegroupalternativenametype.proteintype_alternativename_hjid fk872c08e15abf3d8b
proteinnamegroupsubmittednametype.proteintype_submittedname_hjid fkf248bbef7d501c7d
proteintype_componenttype.proteintype_component_hjid fk2b00f635b41920e6
proteintype_domaintype.proteintype_domain_hjid fke3f7c6802d1c63b
proteintype hjtype varchar 0
proteintype hjversion int8 8
proteintype recommendedname int8 8  √  null
proteinnamegrouprecommendednametype.hjid fk4419093d8ba451bd
proteintype_componenttype allergenname int8 8  √  null
evidencedstringtype.hjid fk2b00f6354e30b06d
proteintype_componenttype biotechname int8 8  √  null
evidencedstringtype.hjid fk2b00f635e2f9b389
proteintype_componenttype hjid int8 8
evidencedstringtype.proteintype_componenttype_cdantigenname_hjid fk45d53f98c23c0be6
evidencedstringtype.proteintype_componenttype_innname_hjid fk45d53f9899b8b42a
proteinnamegroupalternativenametype.proteintype_componenttype_alternativename_hjid fk872c08e1d2ff36e6
proteinnamegroupsubmittednametype.proteintype_componenttype_submittedname_hjid fkf248bbef5298f7d8
proteintype_componenttype hjtype varchar 0
proteintype_componenttype hjversion int8 8
proteintype_componenttype proteintype_component_hjid int8 8  √  null
proteintype.hjid fk2b00f635b41920e6
proteintype_componenttype proteintype_component_hjindex int4 4  √  null
proteintype_componenttype recommendedname int8 8  √  null
proteinnamegrouprecommendednametype.hjid fk2b00f6358ba451bd
proteintype_domaintype allergenname int8 8  √  null
evidencedstringtype.hjid fke3f7c6804e30b06d
proteintype_domaintype biotechname int8 8  √  null
evidencedstringtype.hjid fke3f7c680e2f9b389
proteintype_domaintype hjid int8 8
evidencedstringtype.proteintype_domaintype_cdantigenname_hjid fk45d53f98e79b22e0
evidencedstringtype.proteintype_domaintype_innname_hjid fk45d53f9833363ee4
proteinnamegroupalternativenametype.proteintype_domaintype_alternativename_hjid fk872c08e154d01ca0
proteinnamegroupsubmittednametype.proteintype_domaintype_submittedname_hjid fkf248bbef77f80ed2
proteintype_domaintype hjtype varchar 0
proteintype_domaintype hjversion int8 8
proteintype_domaintype proteintype_domain_hjid int8 8  √  null
proteintype.hjid fke3f7c6802d1c63b
proteintype_domaintype proteintype_domain_hjindex int4 4  √  null
proteintype_domaintype recommendedname int8 8  √  null
proteinnamegrouprecommendednametype.hjid fke3f7c6808ba451bd
range content varchar 0  √  null
range hjid int8 8
range hjtype varchar 0
range hjversion int8 8
referencetype citation int8 8  √  null
citationtype.hjid fk8f0bd505dc62f600
referencetype entrytype_reference_hjid int8 8  √  null
entrytype.hjid fk8f0bd50574685d78
referencetype entrytype_reference_hjindex int4 4  √  null
referencetype evidence varchar 0  √  null
referencetype hjid int8 8
referencetype_scope.referencetype_scope_hjid fk1973ee7aa4a5f7ef
referencetype hjtype varchar 0
referencetype hjversion int8 8
referencetype key varchar 0  √  null
referencetype source int8 8  √  null
sourcedatatype.hjid fk8f0bd50510f9e9b2
referencetype_scope hjvalue varchar 0  √  null
referencetype_scope referencetype_scope_hjid int8 8
referencetype.hjid fk1973ee7aa4a5f7ef
referencetype_scope referencetype_scope_hjindex int4 4
relationship hjid int8 8
relationship_content.relationship_content_hjid fk7acb6572c102b4a1
relationship hjtype varchar 0
relationship hjversion int8 8
relationship_content relationship_content_hjchildid int8 8  √  null
relationship_content relationship_content_hjclass varchar 0  √  null
relationship_content relationship_content_hjid int8 8
relationship.hjid fk7acb6572c102b4a1
relationship_content relationship_content_hjindex int4 4
remark content varchar 0  √  null
remark hjid int8 8
remark hjtype varchar 0
remark hjversion int8 8
replacedby content varchar 0  √  null
replacedby hjid int8 8
replacedby hjtype varchar 0
replacedby hjversion int8 8
savedby content varchar 0  √  null
savedby hjid int8 8
savedby hjtype varchar 0
savedby hjversion int8 8
scope content varchar 0  √  null
scope hjid int8 8
scope hjtype varchar 0
scope hjversion int8 8
sequencetype checksum varchar 0  √  null
sequencetype fragment varchar 0  √  null
sequencetype hjid int8 8
entrytype.sequence fk5adfa2ac4029d2b4
sequencetype hjtype varchar 0
sequencetype hjversion int8 8
sequencetype length numeric 65535,65531  √  null
sequencetype mass numeric 65535,65531  √  null
sequencetype modified timestamp 8,6  √  null
sequencetype precursor bool 1  √  null
sequencetype value varchar 0  √  null
sequencetype version numeric 65535,65531  √  null
source hjid int8 8
source_content.source_content_hjid fk97a65c558d7ee0c1
source hjtype varchar 0
source hjversion int8 8
source_content source_content_hjchildid int8 8  √  null
source_content source_content_hjclass varchar 0  √  null
source_content source_content_hjid int8 8
source.hjid fk97a65c558d7ee0c1
source_content source_content_hjindex int4 4
sourcedatatype hjid int8 8
referencetype.source fk8f0bd50510f9e9b2
sourcedatatype_speciesorstrainorplasmid.sourcedatatype_speciesorstrainorplasmid_hjid fkd57105c356b60b70
sourcedatatype hjtype varchar 0
sourcedatatype hjversion int8 8
sourcedatatype_plasmidtype evidence varchar 0  √  null
sourcedatatype_plasmidtype hjid int8 8
sourcedatatype_plasmidtype hjtype varchar 0
sourcedatatype_plasmidtype hjversion int8 8
sourcedatatype_plasmidtype value varchar 0  √  null
sourcedatatype_speciesorstrainorplasmid sourcedatatype_speciesorstrainorplasmid_hjchildid int8 8  √  null
sourcedatatype_speciesorstrainorplasmid sourcedatatype_speciesorstrainorplasmid_hjclass varchar 0  √  null
sourcedatatype_speciesorstrainorplasmid sourcedatatype_speciesorstrainorplasmid_hjid int8 8
sourcedatatype.hjid fkd57105c356b60b70
sourcedatatype_speciesorstrainorplasmid sourcedatatype_speciesorstrainorplasmid_hjindex int4 4
sourcedatatype_speciestype hjid int8 8
sourcedatatype_speciestype hjtype varchar 0
sourcedatatype_speciestype hjversion int8 8
sourcedatatype_speciestype ref varchar 0  √  null
sourcedatatype_speciestype value varchar 0  √  null
sourcedatatype_straintype evidence varchar 0  √  null
sourcedatatype_straintype hjid int8 8
sourcedatatype_straintype hjtype varchar 0
sourcedatatype_straintype hjversion int8 8
sourcedatatype_straintype value varchar 0  √  null
sourcedatatype_tissuetype evidence varchar 0  √  null
sourcedatatype_tissuetype hjid int8 8
sourcedatatype_tissuetype hjtype varchar 0
sourcedatatype_tissuetype hjversion int8 8
sourcedatatype_tissuetype value varchar 0  √  null
sourcedatatype_transposontype evidence varchar 0  √  null
sourcedatatype_transposontype hjid int8 8
sourcedatatype_transposontype hjtype varchar 0
sourcedatatype_transposontype hjversion int8 8
sourcedatatype_transposontype value varchar 0  √  null
sourcefullpath content varchar 0  √  null
sourcefullpath hjid int8 8
sourcefullpath hjtype varchar 0
sourcefullpath hjversion int8 8
sourceid content varchar 0  √  null
sourceid hjid int8 8
sourceid hjtype varchar 0
sourceid hjversion int8 8
sourcemd5 content varchar 0  √  null
sourcemd5 hjid int8 8
sourcemd5 hjtype varchar 0
sourcemd5 hjversion int8 8
sourcemtime content varchar 0  √  null
sourcemtime hjid int8 8
sourcemtime hjtype varchar 0
sourcemtime hjversion int8 8
sourceparsetime content varchar 0  √  null
sourceparsetime hjid int8 8
sourceparsetime hjtype varchar 0
sourceparsetime hjversion int8 8
sourcepath content varchar 0  √  null
sourcepath hjid int8 8
sourcepath hjtype varchar 0
sourcepath hjversion int8 8
sourcetype content varchar 0  √  null
sourcetype hjid int8 8
sourcetype hjtype varchar 0
sourcetype hjversion int8 8
statustype hjid int8 8
genelocationtype.name fk3055bc64b7cee32f
statustype hjtype varchar 0
statustype hjversion int8 8
statustype status varchar 0  √  null
statustype value varchar 0  √  null
subcellularlocationtype commenttype_subcellularlocation_hjid int8 8  √  null
commenttype.hjid fkdab41539501d42c4
subcellularlocationtype commenttype_subcellularlocation_hjindex int4 4  √  null
subcellularlocationtype hjid int8 8
evidencedstringtype.subcellularlocationtype_location_hjid fk45d53f989043d942
evidencedstringtype.subcellularlocationtype_orientation_hjid fk45d53f98e6dad713
evidencedstringtype.subcellularlocationtype_topology_hjid fk45d53f9828b45ac8
subcellularlocationtype hjtype varchar 0
subcellularlocationtype hjversion int8 8
subset content varchar 0  √  null
subset hjid int8 8
subset hjtype varchar 0
subset hjversion int8 8
subsetdef hjid int8 8
subsetdef_content.subsetdef_content_hjid fk77a1429debb8faa3
subsetdef hjtype varchar 0
subsetdef hjversion int8 8
subsetdef_content subsetdef_content_hjchildid int8 8  √  null
subsetdef_content subsetdef_content_hjclass varchar 0  √  null
subsetdef_content subsetdef_content_hjid int8 8
subsetdef.hjid fk77a1429debb8faa3
subsetdef_content subsetdef_content_hjindex int4 4
synonym hjid int8 8
synonym_content.synonym_content_hjid fk70e93bf5ae1585e3
synonym hjtype varchar 0
synonym hjversion int8 8
synonym scope varchar 0  √  null
synonym_content synonym_content_hjchildid int8 8  √  null
synonym_content synonym_content_hjclass varchar 0  √  null
synonym_content synonym_content_hjid int8 8
synonym.hjid fk70e93bf5ae1585e3
synonym_content synonym_content_hjindex int4 4
synonymcategory hjid int8 8
synonymcategory_content.synonymcategory_content_hjid fk515d54132a4b85c3
synonymcategory hjtype varchar 0
synonymcategory hjversion int8 8
synonymcategory_content synonymcategory_content_hjchildid int8 8  √  null
synonymcategory_content synonymcategory_content_hjclass varchar 0  √  null
synonymcategory_content synonymcategory_content_hjid int8 8
synonymcategory.hjid fk515d54132a4b85c3
synonymcategory_content synonymcategory_content_hjindex int4 4
synonymtext content varchar 0  √  null
synonymtext hjid int8 8
synonymtext hjtype varchar 0
synonymtext hjversion int8 8
synonymtypedef hjid int8 8
synonymtypedef_content.synonymtypedef_content_hjid fk89e3456a586f5be1
synonymtypedef hjtype varchar 0
synonymtypedef hjversion int8 8
synonymtypedef_content synonymtypedef_content_hjchildid int8 8  √  null
synonymtypedef_content synonymtypedef_content_hjclass varchar 0  √  null
synonymtypedef_content synonymtypedef_content_hjid int8 8
synonymtypedef.hjid fk89e3456a586f5be1
synonymtypedef_content synonymtypedef_content_hjindex int4 4
term hjid int8 8
term_content.term_content_hjid fk56dbdfa6a29f821
term hjtype varchar 0
term hjversion int8 8
term_content term_content_hjchildid int8 8  √  null
term_content term_content_hjclass varchar 0  √  null
term_content term_content_hjid int8 8
term.hjid fk56dbdfa6a29f821
term_content term_content_hjindex int4 4
to_ content varchar 0  √  null
to_ hjid int8 8
to_ hjtype varchar 0
to_ hjversion int8 8
transitiveover content varchar 0  √  null
transitiveover hjid int8 8
transitiveover hjtype varchar 0
transitiveover hjversion int8 8
type content varchar 0  √  null
type hjid int8 8
type hjtype varchar 0
type hjversion int8 8
typedef hjid int8 8
typedef_content.typedef_content_hjid fk664f62852b4eafe3
typedef hjtype varchar 0
typedef hjversion int8 8
typedef_content typedef_content_hjchildid int8 8  √  null
typedef_content typedef_content_hjclass varchar 0  √  null
typedef_content typedef_content_hjid int8 8
typedef.hjid fk664f62852b4eafe3
typedef_content typedef_content_hjindex int4 4
unionof content varchar 0  √  null
unionof hjid int8 8
unionof hjtype varchar 0
unionof hjversion int8 8
uniprottype copyright varchar 0  √  null
uniprottype hjid int8 8
entrytype.uniprottype_entry_hjid fk5adfa2ac4b853b11
uniprottype hjtype varchar 0
uniprottype hjversion int8 8
xrefanalog hjid int8 8
xrefanalog_content.xrefanalog_content_hjid fk960bae257294c361
xrefanalog hjtype varchar 0
xrefanalog hjversion int8 8
xrefanalog_content xrefanalog_content_hjchildid int8 8  √  null
xrefanalog_content xrefanalog_content_hjclass varchar 0  √  null
xrefanalog_content xrefanalog_content_hjid int8 8
xrefanalog.hjid fk960bae257294c361
xrefanalog_content xrefanalog_content_hjindex int4 4
xrefunknown hjid int8 8
xrefunknown_content.xrefunknown_content_hjid fkcc1f36a9f7c3adc3
xrefunknown hjtype varchar 0
xrefunknown hjversion int8 8
xrefunknown_content xrefunknown_content_hjchildid int8 8  √  null
xrefunknown_content xrefunknown_content_hjclass varchar 0  √  null
xrefunknown_content xrefunknown_content_hjid int8 8
xrefunknown.hjid fkcc1f36a9f7c3adc3
xrefunknown_content xrefunknown_content_hjindex int4 4