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

Table	Column	Type	Size	Nulls	Auto	Default	Comments
bpccommentgroupabsorptiontype	hjid	int8	19
bpccommentgroupabsorptiontype	hjtype	varchar	2147483647
bpccommentgroupabsorptiontype	hjversion	int8	19
bpccommentgroupabsorptiontype	max	int8	19	√		null
bpccommentgroupkineticstype	hjid	int8	19
bpccommentgroupkineticstype	hjtype	varchar	2147483647
bpccommentgroupkineticstype	hjversion	int8	19
bpccommentgroupphdependencetype	hjid	int8	19
bpccommentgroupphdependencetype	hjtype	varchar	2147483647
bpccommentgroupphdependencetype	hjversion	int8	19
bpccommentgroupredoxpotentialtype	hjid	int8	19
bpccommentgroupredoxpotentialtype	hjtype	varchar	2147483647
bpccommentgroupredoxpotentialtype	hjversion	int8	19
bpccommentgrouptemperaturedependencetype	hjid	int8	19
bpccommentgrouptemperaturedependencetype	hjtype	varchar	2147483647
bpccommentgrouptemperaturedependencetype	hjversion	int8	19
citationtype	authorlist	int8	19	√		null
citationtype	city	varchar	2147483647	√		null
citationtype	country	varchar	2147483647	√		null
citationtype	date_hjclass	varchar	2147483647	√		null
citationtype	date_hjid	int8	19	√		null
citationtype	db	varchar	2147483647	√		null
citationtype	editorlist	int8	19	√		null
citationtype	first	varchar	2147483647	√		null
citationtype	hjid	int8	19
citationtype	hjtype	varchar	2147483647
citationtype	hjversion	int8	19
citationtype	institute	varchar	2147483647	√		null
citationtype	last	varchar	2147483647	√		null
citationtype	locator	varchar	2147483647	√		null
citationtype	name	varchar	2147483647	√		null
citationtype	number	varchar	2147483647	√		null
citationtype	publisher	varchar	2147483647	√		null
citationtype	title	varchar	2147483647	√		null
citationtype	type	varchar	2147483647	√		null
citationtype	volume	varchar	2147483647	√		null
cofactortype	commenttype_cofactor_hjid	int8	19	√		null
cofactortype	commenttype_cofactor_hjindex	int4	10	√		null
cofactortype	dbreference	int8	19	√		null
cofactortype	hjid	int8	19
cofactortype	hjtype	varchar	2147483647
cofactortype	hjversion	int8	19
cofactortype	name	varchar	2147483647	√		null
cofactortype_evidence	cofactortype_evidence_hjid	int8	19
cofactortype_evidence	cofactortype_evidence_hjindex	int4	10
cofactortype_evidence	hjvalue	int4	10	√		null
commenttype	absorption	int8	19	√		null
commenttype	conflict	int8	19	√		null
commenttype	disease	int8	19	√		null
commenttype	error	varchar	2147483647	√		null
commenttype	experiments	int4	10	√		null
commenttype	hjid	int8	19
commenttype	hjtype	varchar	2147483647
commenttype	hjversion	int8	19
commenttype	kinetics	int8	19	√		null
commenttype	locationtype	varchar	2147483647	√		null
commenttype	mass	float4	8,8	√		null
commenttype	method	varchar	2147483647	√		null
commenttype	molecule	int8	19	√		null
commenttype	name	varchar	2147483647	√		null
commenttype	organismsdiffer	bool	1	√		null
commenttype	phdependence	int8	19	√		null
commenttype	redoxpotential	int8	19	√		null
commenttype	temperaturedependence	int8	19	√		null
commenttype	type	varchar	2147483647	√		null
commenttype_conflicttype	hjid	int8	19
commenttype_conflicttype	hjtype	varchar	2147483647
commenttype_conflicttype	hjversion	int8	19
commenttype_conflicttype	ref	varchar	2147483647	√		null
commenttype_conflicttype	sequence	int8	19	√		null
commenttype_conflicttype	type	varchar	2147483647	√		null
commenttype_conflicttype_sequencetype	hjid	int8	19
commenttype_conflicttype_sequencetype	hjtype	varchar	2147483647
commenttype_conflicttype_sequencetype	hjversion	int8	19
commenttype_conflicttype_sequencetype	id	varchar	2147483647	√		null
commenttype_conflicttype_sequencetype	resource	varchar	2147483647	√		null
commenttype_conflicttype_sequencetype	version	int4	10	√		null
commenttype_diseasetype	acronym	varchar	2147483647	√		null
commenttype_diseasetype	dbreference	int8	19	√		null
commenttype_diseasetype	description	varchar	2147483647	√		null
commenttype_diseasetype	hjid	int8	19
commenttype_diseasetype	hjtype	varchar	2147483647
commenttype_diseasetype	hjversion	int8	19
commenttype_diseasetype	id	varchar	2147483647	√		null
commenttype_diseasetype	name	varchar	2147483647	√		null
commenttype_evidence	commenttype_evidence_hjid	int8	19
commenttype_evidence	commenttype_evidence_hjindex	int4	10
commenttype_evidence	hjvalue	int4	10	√		null
commenttype_linktype	commenttype_link_hjid	int8	19	√		null
commenttype_linktype	commenttype_link_hjindex	int4	10	√		null
commenttype_linktype	hjid	int8	19
commenttype_linktype	hjtype	varchar	2147483647
commenttype_linktype	hjversion	int8	19
commenttype_linktype	uri	varchar	2147483647	√		null
consortiumtype	hjid	int8	19
consortiumtype	hjtype	varchar	2147483647
consortiumtype	hjversion	int8	19
consortiumtype	name	varchar	2147483647	√		null
copyright	hjid	int8	19
copyright	hjtype	varchar	2147483647
copyright	hjversion	int8	19
copyright	value	varchar	2147483647	√		null
dbreferencetype	citationtype_dbreference_hjid	int8	19	√		null
dbreferencetype	citationtype_dbreference_hjindex	int4	10	√		null
dbreferencetype	entrytype_dbreference_hjid	int8	19	√		null
dbreferencetype	entrytype_dbreference_hjindex	int4	10	√		null
dbreferencetype	hjid	int8	19
dbreferencetype	hjtype	varchar	2147483647
dbreferencetype	hjversion	int8	19
dbreferencetype	id	varchar	2147483647	√		null
dbreferencetype	molecule	int8	19	√		null
dbreferencetype	organismtype_dbreference_hjid	int8	19	√		null
dbreferencetype	organismtype_dbreference_hjindex	int4	10	√		null
dbreferencetype	type	varchar	2147483647	√		null
dbreferencetype_evidence	dbreferencetype_evidence_hjid	int8	19
dbreferencetype_evidence	dbreferencetype_evidence_hjindex	int4	10
dbreferencetype_evidence	hjvalue	int4	10	√		null
entrytype	created	timestamp	29,6	√		null
entrytype	dataset	varchar	2147483647	√		null
entrytype	hjid	int8	19
entrytype	hjtype	varchar	2147483647
entrytype	hjversion	int8	19
entrytype	modified	timestamp	29,6	√		null
entrytype	organism	int8	19	√		null
entrytype	protein	int8	19	√		null
entrytype	proteinexistence	int8	19	√		null
entrytype	sequence	int8	19	√		null
entrytype	uniprottype_entry_hjid	int8	19	√		null
entrytype	uniprottype_entry_hjindex	int4	10	√		null
entrytype	version	int4	10	√		null
entrytype_accession	entrytype_accession_hjid	int8	19
entrytype_accession	entrytype_accession_hjindex	int4	10
entrytype_accession	hjvalue	varchar	2147483647	√		null
entrytype_comment	entrytype_comment_hjchildid	int8	19	√		null
entrytype_comment	entrytype_comment_hjclass	varchar	2147483647	√		null
entrytype_comment	entrytype_comment_hjid	int8	19
entrytype_comment	entrytype_comment_hjindex	int4	10
entrytype_name	entrytype_name_hjid	int8	19
entrytype_name	entrytype_name_hjindex	int4	10
entrytype_name	hjvalue	varchar	2147483647	√		null
eventtype	commenttype_event_hjid	int8	19	√		null
eventtype	commenttype_event_hjindex	int4	10	√		null
eventtype	hjid	int8	19
eventtype	hjtype	varchar	2147483647
eventtype	hjversion	int8	19
eventtype	type	varchar	2147483647	√		null
evidencedstringtype	bpccommentgroupabsorptiontype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupabsorptiontype_text_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupkineticstype_km_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupkineticstype_km_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupkineticstype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupkineticstype_text_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupkineticstype_vmax_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupkineticstype_vmax_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupphdependencetype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupphdependencetype_text_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgroupredoxpotentialtype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgroupredoxpotentialtype_text_hjindex	int4	10	√		null
evidencedstringtype	bpccommentgrouptemperaturedependencetype_text_hjid	int8	19	√		null
evidencedstringtype	bpccommentgrouptemperaturedependencetype_text_hjindex	int4	10	√		null
evidencedstringtype	commenttype_text_hjid	int8	19	√		null
evidencedstringtype	commenttype_text_hjindex	int4	10	√		null
evidencedstringtype	hjid	int8	19
evidencedstringtype	hjtype	varchar	2147483647
evidencedstringtype	hjversion	int8	19
evidencedstringtype	isoformtype_text_hjid	int8	19	√		null
evidencedstringtype	isoformtype_text_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegroupalternativenametype_ecnumber_hjid	int8	19	√		null
evidencedstringtype	proteinnamegroupalternativenametype_ecnumber_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegroupalternativenametype_shortname_hjid	int8	19	√		null
evidencedstringtype	proteinnamegroupalternativenametype_shortname_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegrouprecommendednametype_ecnumber_hjid	int8	19	√		null
evidencedstringtype	proteinnamegrouprecommendednametype_ecnumber_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegrouprecommendednametype_shortname_hjid	int8	19	√		null
evidencedstringtype	proteinnamegrouprecommendednametype_shortname_hjindex	int4	10	√		null
evidencedstringtype	proteinnamegroupsubmittednametype_ecnumber_hjid	int8	19	√		null
evidencedstringtype	proteinnamegroupsubmittednametype_ecnumber_hjindex	int4	10	√		null
evidencedstringtype	proteintype_cdantigenname_hjid	int8	19	√		null
evidencedstringtype	proteintype_cdantigenname_hjindex	int4	10	√		null
evidencedstringtype	proteintype_componenttype_cdantigenname_hjid	int8	19	√		null
evidencedstringtype	proteintype_componenttype_cdantigenname_hjindex	int4	10	√		null
evidencedstringtype	proteintype_componenttype_innname_hjid	int8	19	√		null
evidencedstringtype	proteintype_componenttype_innname_hjindex	int4	10	√		null
evidencedstringtype	proteintype_domaintype_cdantigenname_hjid	int8	19	√		null
evidencedstringtype	proteintype_domaintype_cdantigenname_hjindex	int4	10	√		null
evidencedstringtype	proteintype_domaintype_innname_hjid	int8	19	√		null
evidencedstringtype	proteintype_domaintype_innname_hjindex	int4	10	√		null
evidencedstringtype	proteintype_innname_hjid	int8	19	√		null
evidencedstringtype	proteintype_innname_hjindex	int4	10	√		null
evidencedstringtype	status	varchar	2147483647	√		null
evidencedstringtype	subcellularlocationtype_location_hjid	int8	19	√		null
evidencedstringtype	subcellularlocationtype_location_hjindex	int4	10	√		null
evidencedstringtype	subcellularlocationtype_orientation_hjid	int8	19	√		null
evidencedstringtype	subcellularlocationtype_orientation_hjindex	int4	10	√		null
evidencedstringtype	subcellularlocationtype_topology_hjid	int8	19	√		null
evidencedstringtype	subcellularlocationtype_topology_hjindex	int4	10	√		null
evidencedstringtype	value	varchar	2147483647	√		null
evidencedstringtype_evidence	evidencedstringtype_evidence_hjid	int8	19
evidencedstringtype_evidence	evidencedstringtype_evidence_hjindex	int4	10
evidencedstringtype_evidence	hjvalue	int4	10	√		null
evidencetype	entrytype_evidence_hjid	int8	19	√		null
evidencetype	entrytype_evidence_hjindex	int4	10	√		null
evidencetype	hjid	int8	19
evidencetype	hjtype	varchar	2147483647
evidencetype	hjversion	int8	19
evidencetype	importedfrom	int8	19	√		null
evidencetype	key	numeric	131089	√		null
evidencetype	source	int8	19	√		null
evidencetype	type	varchar	2147483647	√		null
featuretype	description	varchar	2147483647	√		null
featuretype	entrytype_feature_hjid	int8	19	√		null
featuretype	entrytype_feature_hjindex	int4	10	√		null
featuretype	hjid	int8	19
featuretype	hjtype	varchar	2147483647
featuretype	hjversion	int8	19
featuretype	id	varchar	2147483647	√		null
featuretype	location	int8	19	√		null
featuretype	original	varchar	2147483647	√		null
featuretype	ref	varchar	2147483647	√		null
featuretype	status	varchar	2147483647	√		null
featuretype	type	varchar	2147483647	√		null
featuretype_evidence	featuretype_evidence_hjid	int8	19
featuretype_evidence	featuretype_evidence_hjindex	int4	10
featuretype_evidence	hjvalue	int4	10	√		null
featuretype_variation	featuretype_variation_hjid	int8	19
featuretype_variation	featuretype_variation_hjindex	int4	10
featuretype_variation	hjvalue	varchar	2147483647	√		null
genelocationtype	entrytype_genelocation_hjid	int8	19	√		null
genelocationtype	entrytype_genelocation_hjindex	int4	10	√		null
genelocationtype	hjid	int8	19
genelocationtype	hjtype	varchar	2147483647
genelocationtype	hjversion	int8	19
genelocationtype	type	varchar	2147483647	√		null
genelocationtype_evidence	genelocationtype_evidence_hjid	int8	19
genelocationtype_evidence	genelocationtype_evidence_hjindex	int4	10
genelocationtype_evidence	hjvalue	int4	10	√		null
genenametype	genetype_name_hjid	int8	19	√		null
genenametype	genetype_name_hjindex	int4	10	√		null
genenametype	hjid	int8	19
genenametype	hjtype	varchar	2147483647
genenametype	hjversion	int8	19
genenametype	type	varchar	2147483647	√		null
genenametype	value	varchar	2147483647	√		null
genenametype_evidence	genenametype_evidence_hjid	int8	19
genenametype_evidence	genenametype_evidence_hjindex	int4	10
genenametype_evidence	hjvalue	int4	10	√		null
genetype	entrytype_gene_hjid	int8	19	√		null
genetype	entrytype_gene_hjindex	int4	10	√		null
genetype	hjid	int8	19
genetype	hjtype	varchar	2147483647
genetype	hjversion	int8	19
importedfromtype	dbreference	int8	19	√		null
importedfromtype	hjid	int8	19
importedfromtype	hjtype	varchar	2147483647
importedfromtype	hjversion	int8	19
interactanttype	commenttype_interactant_hjid	int8	19	√		null
interactanttype	commenttype_interactant_hjindex	int4	10	√		null
interactanttype	hjid	int8	19
interactanttype	hjtype	varchar	2147483647
interactanttype	hjversion	int8	19
interactanttype	id	varchar	2147483647	√		null
interactanttype	intactid	varchar	2147483647	√		null
interactanttype	label	varchar	2147483647	√		null
isoformtype	commenttype_isoform_hjid	int8	19	√		null
isoformtype	commenttype_isoform_hjindex	int4	10	√		null
isoformtype	hjid	int8	19
isoformtype	hjtype	varchar	2147483647
isoformtype	hjversion	int8	19
isoformtype	sequence	int8	19	√		null
isoformtype_id	hjvalue	varchar	2147483647	√		null
isoformtype_id	isoformtype_id_hjid	int8	19
isoformtype_id	isoformtype_id_hjindex	int4	10
isoformtype_nametype	hjid	int8	19
isoformtype_nametype	hjtype	varchar	2147483647
isoformtype_nametype	hjversion	int8	19
isoformtype_nametype	isoformtype_name_hjid	int8	19	√		null
isoformtype_nametype	isoformtype_name_hjindex	int4	10	√		null
isoformtype_nametype	value	varchar	2147483647	√		null
isoformtype_nametype_evidence	hjvalue	int4	10	√		null
isoformtype_nametype_evidence	isoformtype_nametype_evidence_hjid	int8	19
isoformtype_nametype_evidence	isoformtype_nametype_evidence_hjindex	int4	10
isoformtype_sequencetype	hjid	int8	19
isoformtype_sequencetype	hjtype	varchar	2147483647
isoformtype_sequencetype	hjversion	int8	19
isoformtype_sequencetype	ref	varchar	2147483647	√		null
isoformtype_sequencetype	type	varchar	2147483647	√		null
keywordtype	entrytype_keyword_hjid	int8	19	√		null
keywordtype	entrytype_keyword_hjindex	int4	10	√		null
keywordtype	hjid	int8	19
keywordtype	hjtype	varchar	2147483647
keywordtype	hjversion	int8	19
keywordtype	id	varchar	2147483647	√		null
keywordtype	value	varchar	2147483647	√		null
keywordtype_evidence	hjvalue	int4	10	√		null
keywordtype_evidence	keywordtype_evidence_hjid	int8	19
keywordtype_evidence	keywordtype_evidence_hjindex	int4	10
locationtype	begin	int8	19	√		null
locationtype	commenttype_location_hjid	int8	19	√		null
locationtype	commenttype_location_hjindex	int4	10	√		null
locationtype	endposition	int8	19	√		null
locationtype	hjid	int8	19
locationtype	hjtype	varchar	2147483647
locationtype	hjversion	int8	19
locationtype	position	int8	19	√		null
locationtype	sequence	varchar	2147483647	√		null
moleculetype	hjid	int8	19
moleculetype	hjtype	varchar	2147483647
moleculetype	hjversion	int8	19
moleculetype	id	varchar	2147483647	√		null
moleculetype	value	varchar	2147483647	√		null
namelisttype	hjid	int8	19
namelisttype	hjtype	varchar	2147483647
namelisttype	hjversion	int8	19
namelisttype_consortiumorperson	namelisttype_consortiumorperson_hjchildid	int8	19	√		null
namelisttype_consortiumorperson	namelisttype_consortiumorperson_hjclass	varchar	2147483647	√		null
namelisttype_consortiumorperson	namelisttype_consortiumorperson_hjid	int8	19
namelisttype_consortiumorperson	namelisttype_consortiumorperson_hjindex	int4	10
organismnametype	hjid	int8	19
organismnametype	hjtype	varchar	2147483647
organismnametype	hjversion	int8	19
organismnametype	organismtype_name_hjid	int8	19	√		null
organismnametype	organismtype_name_hjindex	int4	10	√		null
organismnametype	type	varchar	2147483647	√		null
organismnametype	value	varchar	2147483647	√		null
organismtype	entrytype_organismhost_hjid	int8	19	√		null
organismtype	entrytype_organismhost_hjindex	int4	10	√		null
organismtype	hjid	int8	19
organismtype	hjtype	varchar	2147483647
organismtype	hjversion	int8	19
organismtype	lineage	int8	19	√		null
organismtype_evidence	hjvalue	int4	10	√		null
organismtype_evidence	organismtype_evidence_hjid	int8	19
organismtype_evidence	organismtype_evidence_hjindex	int4	10
organismtype_lineagetype	hjid	int8	19
organismtype_lineagetype	hjtype	varchar	2147483647
organismtype_lineagetype	hjversion	int8	19
organismtype_lineagetype_taxon	hjvalue	varchar	2147483647	√		null
organismtype_lineagetype_taxon	organismtype_lineagetype_taxon_hjid	int8	19
organismtype_lineagetype_taxon	organismtype_lineagetype_taxon_hjindex	int4	10
persontype	hjid	int8	19
persontype	hjtype	varchar	2147483647
persontype	hjversion	int8	19
persontype	name	varchar	2147483647	√		null
positiontype	hjid	int8	19
positiontype	hjtype	varchar	2147483647
positiontype	hjversion	int8	19
positiontype	position	numeric	131089	√		null
positiontype	status	varchar	2147483647	√		null
positiontype_evidence	hjvalue	int4	10	√		null
positiontype_evidence	positiontype_evidence_hjid	int8	19
positiontype_evidence	positiontype_evidence_hjindex	int4	10
propertytype	dbreferencetype_property_hjid	int8	19	√		null
propertytype	dbreferencetype_property_hjindex	int4	10	√		null
propertytype	hjid	int8	19
propertytype	hjtype	varchar	2147483647
propertytype	hjversion	int8	19
propertytype	type	varchar	2147483647	√		null
propertytype	value	varchar	2147483647	√		null
proteinexistencetype	hjid	int8	19
proteinexistencetype	hjtype	varchar	2147483647
proteinexistencetype	hjversion	int8	19
proteinexistencetype	type	varchar	2147483647	√		null
proteinnamegroupalternativenametype	fullname	int8	19	√		null
proteinnamegroupalternativenametype	hjid	int8	19
proteinnamegroupalternativenametype	hjtype	varchar	2147483647
proteinnamegroupalternativenametype	hjversion	int8	19
proteinnamegroupalternativenametype	proteintype_alternativename_hjid	int8	19	√		null
proteinnamegroupalternativenametype	proteintype_alternativename_hjindex	int4	10	√		null
proteinnamegroupalternativenametype	proteintype_componenttype_alternativename_hjid	int8	19	√		null
proteinnamegroupalternativenametype	proteintype_componenttype_alternativename_hjindex	int4	10	√		null
proteinnamegroupalternativenametype	proteintype_domaintype_alternativename_hjid	int8	19	√		null
proteinnamegroupalternativenametype	proteintype_domaintype_alternativename_hjindex	int4	10	√		null
proteinnamegrouprecommendednametype	fullname	int8	19	√		null
proteinnamegrouprecommendednametype	hjid	int8	19
proteinnamegrouprecommendednametype	hjtype	varchar	2147483647
proteinnamegrouprecommendednametype	hjversion	int8	19
proteinnamegroupsubmittednametype	fullname	int8	19	√		null
proteinnamegroupsubmittednametype	hjid	int8	19
proteinnamegroupsubmittednametype	hjtype	varchar	2147483647
proteinnamegroupsubmittednametype	hjversion	int8	19
proteinnamegroupsubmittednametype	proteintype_componenttype_submittedname_hjid	int8	19	√		null
proteinnamegroupsubmittednametype	proteintype_componenttype_submittedname_hjindex	int4	10	√		null
proteinnamegroupsubmittednametype	proteintype_domaintype_submittedname_hjid	int8	19	√		null
proteinnamegroupsubmittednametype	proteintype_domaintype_submittedname_hjindex	int4	10	√		null
proteinnamegroupsubmittednametype	proteintype_submittedname_hjid	int8	19	√		null
proteinnamegroupsubmittednametype	proteintype_submittedname_hjindex	int4	10	√		null
proteintype	allergenname	int8	19	√		null
proteintype	biotechname	int8	19	√		null
proteintype	hjid	int8	19
proteintype	hjtype	varchar	2147483647
proteintype	hjversion	int8	19
proteintype	recommendedname	int8	19	√		null
proteintype_componenttype	allergenname	int8	19	√		null
proteintype_componenttype	biotechname	int8	19	√		null
proteintype_componenttype	hjid	int8	19
proteintype_componenttype	hjtype	varchar	2147483647
proteintype_componenttype	hjversion	int8	19
proteintype_componenttype	proteintype_component_hjid	int8	19	√		null
proteintype_componenttype	proteintype_component_hjindex	int4	10	√		null
proteintype_componenttype	recommendedname	int8	19	√		null
proteintype_domaintype	allergenname	int8	19	√		null
proteintype_domaintype	biotechname	int8	19	√		null
proteintype_domaintype	hjid	int8	19
proteintype_domaintype	hjtype	varchar	2147483647
proteintype_domaintype	hjversion	int8	19
proteintype_domaintype	proteintype_domain_hjid	int8	19	√		null
proteintype_domaintype	proteintype_domain_hjindex	int4	10	√		null
proteintype_domaintype	recommendedname	int8	19	√		null
referencetype	citation	int8	19	√		null
referencetype	entrytype_reference_hjid	int8	19	√		null
referencetype	entrytype_reference_hjindex	int4	10	√		null
referencetype	hjid	int8	19
referencetype	hjtype	varchar	2147483647
referencetype	hjversion	int8	19
referencetype	key	varchar	2147483647	√		null
referencetype	source	int8	19	√		null
referencetype_evidence	hjvalue	int4	10	√		null
referencetype_evidence	referencetype_evidence_hjid	int8	19
referencetype_evidence	referencetype_evidence_hjindex	int4	10
referencetype_scope	hjvalue	varchar	2147483647	√		null
referencetype_scope	referencetype_scope_hjid	int8	19
referencetype_scope	referencetype_scope_hjindex	int4	10
sequencetype	checksum	varchar	2147483647	√		null
sequencetype	fragment	varchar	2147483647	√		null
sequencetype	hjid	int8	19
sequencetype	hjtype	varchar	2147483647
sequencetype	hjversion	int8	19
sequencetype	length	int4	10	√		null
sequencetype	mass	int4	10	√		null
sequencetype	modified	timestamp	29,6	√		null
sequencetype	precursor	bool	1	√		null
sequencetype	value	varchar	2147483647	√		null
sequencetype	version	int4	10	√		null
sourcedatatype	hjid	int8	19
sourcedatatype	hjtype	varchar	2147483647
sourcedatatype	hjversion	int8	19
sourcedatatype_plasmidtype	hjid	int8	19
sourcedatatype_plasmidtype	hjtype	varchar	2147483647
sourcedatatype_plasmidtype	hjversion	int8	19
sourcedatatype_plasmidtype	value	varchar	2147483647	√		null
sourcedatatype_plasmidtype_evidence	hjvalue	int4	10	√		null
sourcedatatype_plasmidtype_evidence	sourcedatatype_plasmidtype_evidence_hjid	int8	19
sourcedatatype_plasmidtype_evidence	sourcedatatype_plasmidtype_evidence_hjindex	int4	10
sourcedatatype_strainorplasmidortransposon	sourcedatatype_strainorplasmidortransposon_hjchildid	int8	19	√		null
sourcedatatype_strainorplasmidortransposon	sourcedatatype_strainorplasmidortransposon_hjclass	varchar	2147483647	√		null
sourcedatatype_strainorplasmidortransposon	sourcedatatype_strainorplasmidortransposon_hjid	int8	19
sourcedatatype_strainorplasmidortransposon	sourcedatatype_strainorplasmidortransposon_hjindex	int4	10
sourcedatatype_straintype	hjid	int8	19
sourcedatatype_straintype	hjtype	varchar	2147483647
sourcedatatype_straintype	hjversion	int8	19
sourcedatatype_straintype	value	varchar	2147483647	√		null
sourcedatatype_straintype_evidence	hjvalue	int4	10	√		null
sourcedatatype_straintype_evidence	sourcedatatype_straintype_evidence_hjid	int8	19
sourcedatatype_straintype_evidence	sourcedatatype_straintype_evidence_hjindex	int4	10
sourcedatatype_tissuetype	hjid	int8	19
sourcedatatype_tissuetype	hjtype	varchar	2147483647
sourcedatatype_tissuetype	hjversion	int8	19
sourcedatatype_tissuetype	value	varchar	2147483647	√		null
sourcedatatype_tissuetype_evidence	hjvalue	int4	10	√		null
sourcedatatype_tissuetype_evidence	sourcedatatype_tissuetype_evidence_hjid	int8	19
sourcedatatype_tissuetype_evidence	sourcedatatype_tissuetype_evidence_hjindex	int4	10
sourcedatatype_transposontype	hjid	int8	19
sourcedatatype_transposontype	hjtype	varchar	2147483647
sourcedatatype_transposontype	hjversion	int8	19
sourcedatatype_transposontype	value	varchar	2147483647	√		null
sourcedatatype_transposontype_evidence	hjvalue	int4	10	√		null
sourcedatatype_transposontype_evidence	sourcedatatype_transposontype_evidence_hjid	int8	19
sourcedatatype_transposontype_evidence	sourcedatatype_transposontype_evidence_hjindex	int4	10
statustype	genelocationtype_name_hjid	int8	19	√		null
statustype	genelocationtype_name_hjindex	int4	10	√		null
statustype	hjid	int8	19
statustype	hjtype	varchar	2147483647
statustype	hjversion	int8	19
statustype	status	varchar	2147483647	√		null
statustype	value	varchar	2147483647	√		null
subcellularlocationtype	commenttype_subcellularlocation_hjid	int8	19	√		null
subcellularlocationtype	commenttype_subcellularlocation_hjindex	int4	10	√		null
subcellularlocationtype	hjid	int8	19
subcellularlocationtype	hjtype	varchar	2147483647
subcellularlocationtype	hjversion	int8	19
uniprotsourcetype	dbreference	int8	19	√		null
uniprotsourcetype	hjid	int8	19
uniprotsourcetype	hjtype	varchar	2147483647
uniprotsourcetype	hjversion	int8	19
uniprotsourcetype	ref	numeric	131089	√		null
uniprottype	copyright	varchar	2147483647	√		null
uniprottype	hjid	int8	19
uniprottype	hjtype	varchar	2147483647
uniprottype	hjversion	int8	19