uniprotdb.public contains 416 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
uniprottype	copyright	varchar	0	√		null
uniprottype	hjid	int8	8				entrytype.uniprottype_entry_hjid fk5adfa2ac4b853b11
uniprottype	hjtype	varchar	0
uniprottype	hjversion	int8	8