SchemaSpy Analysis of uniprotdb.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Nov 21 10:47 PST 2016 |
| ||||||
|
uniprotdb.public contains 489 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
commenttype | absorption | int8 | 19 | √ | null | ||
commenttype_diseasetype | acronym | varchar | 2147483647 | √ | null | ||
proteintype | allergenname | int8 | 19 | √ | null | ||
proteintype_componenttype | allergenname | int8 | 19 | √ | null | ||
proteintype_domaintype | allergenname | int8 | 19 | √ | null | ||
citationtype | authorlist | int8 | 19 | √ | null | ||
locationtype | begin | int8 | 19 | √ | null | ||
proteintype | biotechname | int8 | 19 | √ | null | ||
proteintype_componenttype | biotechname | int8 | 19 | √ | null | ||
proteintype_domaintype | biotechname | int8 | 19 | √ | 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 | ||
sequencetype | checksum | varchar | 2147483647 | √ | null | ||
referencetype | citation | int8 | 19 | √ | null | ||
dbreferencetype | citationtype_dbreference_hjid | int8 | 19 | √ | null | ||
dbreferencetype | citationtype_dbreference_hjindex | int4 | 10 | √ | null | ||
citationtype | city | varchar | 2147483647 | √ | null | ||
cofactortype_evidence | cofactortype_evidence_hjid | int8 | 19 | ||||
cofactortype_evidence | cofactortype_evidence_hjindex | int4 | 10 | ||||
cofactortype | commenttype_cofactor_hjid | int8 | 19 | √ | null | ||
cofactortype | commenttype_cofactor_hjindex | int4 | 10 | √ | null | ||
eventtype | commenttype_event_hjid | int8 | 19 | √ | null | ||
eventtype | commenttype_event_hjindex | int4 | 10 | √ | null | ||
commenttype_evidence | commenttype_evidence_hjid | int8 | 19 | ||||
commenttype_evidence | commenttype_evidence_hjindex | int4 | 10 | ||||
interactanttype | commenttype_interactant_hjid | int8 | 19 | √ | null | ||
interactanttype | commenttype_interactant_hjindex | int4 | 10 | √ | null | ||
isoformtype | commenttype_isoform_hjid | int8 | 19 | √ | null | ||
isoformtype | commenttype_isoform_hjindex | int4 | 10 | √ | null | ||
commenttype_linktype | commenttype_link_hjid | int8 | 19 | √ | null | ||
commenttype_linktype | commenttype_link_hjindex | int4 | 10 | √ | null | ||
locationtype | commenttype_location_hjid | int8 | 19 | √ | null | ||
locationtype | commenttype_location_hjindex | int4 | 10 | √ | null | ||
subcellularlocationtype | commenttype_subcellularlocation_hjid | int8 | 19 | √ | null | ||
subcellularlocationtype | commenttype_subcellularlocation_hjindex | int4 | 10 | √ | null | ||
evidencedstringtype | commenttype_text_hjid | int8 | 19 | √ | null | ||
evidencedstringtype | commenttype_text_hjindex | int4 | 10 | √ | null | ||
commenttype | conflict | int8 | 19 | √ | null | ||
uniprottype | copyright | varchar | 2147483647 | √ | null | ||
citationtype | country | varchar | 2147483647 | √ | null | ||
entrytype | created | timestamp | 29,6 | √ | null | ||
entrytype | dataset | varchar | 2147483647 | √ | null | ||
citationtype | date_hjclass | varchar | 2147483647 | √ | null | ||
citationtype | date_hjid | int8 | 19 | √ | null | ||
citationtype | db | varchar | 2147483647 | √ | null | ||
cofactortype | dbreference | int8 | 19 | √ | null | ||
commenttype_diseasetype | dbreference | int8 | 19 | √ | null | ||
importedfromtype | dbreference | int8 | 19 | √ | null | ||
uniprotsourcetype | dbreference | int8 | 19 | √ | null | ||
dbreferencetype_evidence | dbreferencetype_evidence_hjid | int8 | 19 | ||||
dbreferencetype_evidence | dbreferencetype_evidence_hjindex | int4 | 10 | ||||
propertytype | dbreferencetype_property_hjid | int8 | 19 | √ | null | ||
propertytype | dbreferencetype_property_hjindex | int4 | 10 | √ | null | ||
commenttype_diseasetype | description | varchar | 2147483647 | √ | null | ||
featuretype | description | varchar | 2147483647 | √ | null | ||
commenttype | disease | int8 | 19 | √ | null | ||
citationtype | editorlist | int8 | 19 | √ | null | ||
locationtype | endposition | int8 | 19 | √ | null | ||
entrytype_accession | entrytype_accession_hjid | int8 | 19 | ||||
entrytype_accession | entrytype_accession_hjindex | int4 | 10 | ||||
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 | ||||
dbreferencetype | entrytype_dbreference_hjid | int8 | 19 | √ | null | ||
dbreferencetype | entrytype_dbreference_hjindex | int4 | 10 | √ | null | ||
evidencetype | entrytype_evidence_hjid | int8 | 19 | √ | null | ||
evidencetype | entrytype_evidence_hjindex | int4 | 10 | √ | null | ||
featuretype | entrytype_feature_hjid | int8 | 19 | √ | null | ||
featuretype | entrytype_feature_hjindex | int4 | 10 | √ | null | ||
genetype | entrytype_gene_hjid | int8 | 19 | √ | null | ||
genetype | entrytype_gene_hjindex | int4 | 10 | √ | null | ||
genelocationtype | entrytype_genelocation_hjid | int8 | 19 | √ | null | ||
genelocationtype | entrytype_genelocation_hjindex | int4 | 10 | √ | null | ||
keywordtype | entrytype_keyword_hjid | int8 | 19 | √ | null | ||
keywordtype | entrytype_keyword_hjindex | int4 | 10 | √ | null | ||
entrytype_name | entrytype_name_hjid | int8 | 19 | ||||
entrytype_name | entrytype_name_hjindex | int4 | 10 | ||||
organismtype | entrytype_organismhost_hjid | int8 | 19 | √ | null | ||
organismtype | entrytype_organismhost_hjindex | int4 | 10 | √ | null | ||
referencetype | entrytype_reference_hjid | int8 | 19 | √ | null | ||
referencetype | entrytype_reference_hjindex | int4 | 10 | √ | null | ||
commenttype | error | varchar | 2147483647 | √ | null | ||
evidencedstringtype_evidence | evidencedstringtype_evidence_hjid | int8 | 19 | ||||
evidencedstringtype_evidence | evidencedstringtype_evidence_hjindex | int4 | 10 | ||||
commenttype | experiments | int4 | 10 | √ | null | ||
featuretype_evidence | featuretype_evidence_hjid | int8 | 19 | ||||
featuretype_evidence | featuretype_evidence_hjindex | int4 | 10 | ||||
featuretype_variation | featuretype_variation_hjid | int8 | 19 | ||||
featuretype_variation | featuretype_variation_hjindex | int4 | 10 | ||||
citationtype | first | varchar | 2147483647 | √ | null | ||
sequencetype | fragment | varchar | 2147483647 | √ | null | ||
proteinnamegroupalternativenametype | fullname | int8 | 19 | √ | null | ||
proteinnamegrouprecommendednametype | fullname | int8 | 19 | √ | null | ||
proteinnamegroupsubmittednametype | fullname | int8 | 19 | √ | null | ||
genelocationtype_evidence | genelocationtype_evidence_hjid | int8 | 19 | ||||
genelocationtype_evidence | genelocationtype_evidence_hjindex | int4 | 10 | ||||
statustype | genelocationtype_name_hjid | int8 | 19 | √ | null | ||
statustype | genelocationtype_name_hjindex | int4 | 10 | √ | null | ||
genenametype_evidence | genenametype_evidence_hjid | int8 | 19 | ||||
genenametype_evidence | genenametype_evidence_hjindex | int4 | 10 | ||||
genenametype | genetype_name_hjid | int8 | 19 | √ | null | ||
genenametype | genetype_name_hjindex | int4 | 10 | √ | null | ||
bpccommentgroupabsorptiontype | hjid | int8 | 19 | ||||
bpccommentgroupkineticstype | hjid | int8 | 19 | ||||
bpccommentgroupphdependencetype | hjid | int8 | 19 | ||||
bpccommentgroupredoxpotentialtype | hjid | int8 | 19 | ||||
bpccommentgrouptemperaturedependencetype | hjid | int8 | 19 | ||||
citationtype | hjid | int8 | 19 | ||||
cofactortype | hjid | int8 | 19 | ||||
commenttype | hjid | int8 | 19 | ||||
commenttype_conflicttype | hjid | int8 | 19 | ||||
commenttype_conflicttype_sequencetype | hjid | int8 | 19 | ||||
commenttype_diseasetype | hjid | int8 | 19 | ||||
commenttype_linktype | hjid | int8 | 19 | ||||
consortiumtype | hjid | int8 | 19 | ||||
copyright | hjid | int8 | 19 | ||||
dbreferencetype | hjid | int8 | 19 | ||||
entrytype | hjid | int8 | 19 | ||||
eventtype | hjid | int8 | 19 | ||||
evidencedstringtype | hjid | int8 | 19 | ||||
evidencetype | hjid | int8 | 19 | ||||
featuretype | hjid | int8 | 19 | ||||
genelocationtype | hjid | int8 | 19 | ||||
genenametype | hjid | int8 | 19 | ||||
genetype | hjid | int8 | 19 | ||||
importedfromtype | hjid | int8 | 19 | ||||
interactanttype | hjid | int8 | 19 | ||||
isoformtype | hjid | int8 | 19 | ||||
isoformtype_nametype | hjid | int8 | 19 | ||||
isoformtype_sequencetype | hjid | int8 | 19 | ||||
keywordtype | hjid | int8 | 19 | ||||
locationtype | hjid | int8 | 19 | ||||
moleculetype | hjid | int8 | 19 | ||||
namelisttype | hjid | int8 | 19 | ||||
organismnametype | hjid | int8 | 19 | ||||
organismtype | hjid | int8 | 19 | ||||
organismtype_lineagetype | hjid | int8 | 19 | ||||
persontype | hjid | int8 | 19 | ||||
positiontype | hjid | int8 | 19 | ||||
propertytype | hjid | int8 | 19 | ||||
proteinexistencetype | hjid | int8 | 19 | ||||
proteinnamegroupalternativenametype | hjid | int8 | 19 | ||||
proteinnamegrouprecommendednametype | hjid | int8 | 19 | ||||
proteinnamegroupsubmittednametype | hjid | int8 | 19 | ||||
proteintype | hjid | int8 | 19 | ||||
proteintype_componenttype | hjid | int8 | 19 | ||||
proteintype_domaintype | hjid | int8 | 19 | ||||
referencetype | hjid | int8 | 19 | ||||
sequencetype | hjid | int8 | 19 | ||||
sourcedatatype | hjid | int8 | 19 | ||||
sourcedatatype_plasmidtype | hjid | int8 | 19 | ||||
sourcedatatype_straintype | hjid | int8 | 19 | ||||
sourcedatatype_tissuetype | hjid | int8 | 19 | ||||
sourcedatatype_transposontype | hjid | int8 | 19 | ||||
statustype | hjid | int8 | 19 | ||||
subcellularlocationtype | hjid | int8 | 19 | ||||
uniprotsourcetype | hjid | int8 | 19 | ||||
uniprottype | hjid | int8 | 19 | ||||
bpccommentgroupabsorptiontype | hjtype | varchar | 2147483647 | ||||
bpccommentgroupkineticstype | hjtype | varchar | 2147483647 | ||||
bpccommentgroupphdependencetype | hjtype | varchar | 2147483647 | ||||
bpccommentgroupredoxpotentialtype | hjtype | varchar | 2147483647 | ||||
bpccommentgrouptemperaturedependencetype | hjtype | varchar | 2147483647 | ||||
citationtype | hjtype | varchar | 2147483647 | ||||
cofactortype | hjtype | varchar | 2147483647 | ||||
commenttype | hjtype | varchar | 2147483647 | ||||
commenttype_conflicttype | hjtype | varchar | 2147483647 | ||||
commenttype_conflicttype_sequencetype | hjtype | varchar | 2147483647 | ||||
commenttype_diseasetype | hjtype | varchar | 2147483647 | ||||
commenttype_linktype | hjtype | varchar | 2147483647 | ||||
consortiumtype | hjtype | varchar | 2147483647 | ||||
copyright | hjtype | varchar | 2147483647 | ||||
dbreferencetype | hjtype | varchar | 2147483647 | ||||
entrytype | hjtype | varchar | 2147483647 | ||||
eventtype | hjtype | varchar | 2147483647 | ||||
evidencedstringtype | hjtype | varchar | 2147483647 | ||||
evidencetype | hjtype | varchar | 2147483647 | ||||
featuretype | hjtype | varchar | 2147483647 | ||||
genelocationtype | hjtype | varchar | 2147483647 | ||||
genenametype | hjtype | varchar | 2147483647 | ||||
genetype | hjtype | varchar | 2147483647 | ||||
importedfromtype | hjtype | varchar | 2147483647 | ||||
interactanttype | hjtype | varchar | 2147483647 | ||||
isoformtype | hjtype | varchar | 2147483647 | ||||
isoformtype_nametype | hjtype | varchar | 2147483647 | ||||
isoformtype_sequencetype | hjtype | varchar | 2147483647 | ||||
keywordtype | hjtype | varchar | 2147483647 | ||||
locationtype | hjtype | varchar | 2147483647 | ||||
moleculetype | hjtype | varchar | 2147483647 | ||||
namelisttype | hjtype | varchar | 2147483647 | ||||
organismnametype | hjtype | varchar | 2147483647 | ||||
organismtype | hjtype | varchar | 2147483647 | ||||
organismtype_lineagetype | hjtype | varchar | 2147483647 | ||||
persontype | hjtype | varchar | 2147483647 | ||||
positiontype | hjtype | varchar | 2147483647 | ||||
propertytype | hjtype | varchar | 2147483647 | ||||
proteinexistencetype | hjtype | varchar | 2147483647 | ||||
proteinnamegroupalternativenametype | hjtype | varchar | 2147483647 | ||||
proteinnamegrouprecommendednametype | hjtype | varchar | 2147483647 | ||||
proteinnamegroupsubmittednametype | hjtype | varchar | 2147483647 | ||||
proteintype | hjtype | varchar | 2147483647 | ||||
proteintype_componenttype | hjtype | varchar | 2147483647 | ||||
proteintype_domaintype | hjtype | varchar | 2147483647 | ||||
referencetype | hjtype | varchar | 2147483647 | ||||
sequencetype | hjtype | varchar | 2147483647 | ||||
sourcedatatype | hjtype | varchar | 2147483647 | ||||
sourcedatatype_plasmidtype | hjtype | varchar | 2147483647 | ||||
sourcedatatype_straintype | hjtype | varchar | 2147483647 | ||||
sourcedatatype_tissuetype | hjtype | varchar | 2147483647 | ||||
sourcedatatype_transposontype | hjtype | varchar | 2147483647 | ||||
statustype | hjtype | varchar | 2147483647 | ||||
subcellularlocationtype | hjtype | varchar | 2147483647 | ||||
uniprotsourcetype | hjtype | varchar | 2147483647 | ||||
uniprottype | hjtype | varchar | 2147483647 | ||||
cofactortype_evidence | hjvalue | int4 | 10 | √ | null | ||
commenttype_evidence | hjvalue | int4 | 10 | √ | null | ||
dbreferencetype_evidence | hjvalue | int4 | 10 | √ | null | ||
entrytype_accession | hjvalue | varchar | 2147483647 | √ | null | ||
entrytype_name | hjvalue | varchar | 2147483647 | √ | null | ||
evidencedstringtype_evidence | hjvalue | int4 | 10 | √ | null | ||
featuretype_evidence | hjvalue | int4 | 10 | √ | null | ||
featuretype_variation | hjvalue | varchar | 2147483647 | √ | null | ||
genelocationtype_evidence | hjvalue | int4 | 10 | √ | null | ||
genenametype_evidence | hjvalue | int4 | 10 | √ | null | ||
isoformtype_id | hjvalue | varchar | 2147483647 | √ | null | ||
isoformtype_nametype_evidence | hjvalue | int4 | 10 | √ | null | ||
keywordtype_evidence | hjvalue | int4 | 10 | √ | null | ||
organismtype_evidence | hjvalue | int4 | 10 | √ | null | ||
organismtype_lineagetype_taxon | hjvalue | varchar | 2147483647 | √ | null | ||
positiontype_evidence | hjvalue | int4 | 10 | √ | null | ||
referencetype_evidence | hjvalue | int4 | 10 | √ | null | ||
referencetype_scope | hjvalue | varchar | 2147483647 | √ | null | ||
sourcedatatype_plasmidtype_evidence | hjvalue | int4 | 10 | √ | null | ||
sourcedatatype_straintype_evidence | hjvalue | int4 | 10 | √ | null | ||
sourcedatatype_tissuetype_evidence | hjvalue | int4 | 10 | √ | null | ||
sourcedatatype_transposontype_evidence | hjvalue | int4 | 10 | √ | null | ||
bpccommentgroupabsorptiontype | hjversion | int8 | 19 | ||||
bpccommentgroupkineticstype | hjversion | int8 | 19 | ||||
bpccommentgroupphdependencetype | hjversion | int8 | 19 | ||||
bpccommentgroupredoxpotentialtype | hjversion | int8 | 19 | ||||
bpccommentgrouptemperaturedependencetype | hjversion | int8 | 19 | ||||
citationtype | hjversion | int8 | 19 | ||||
cofactortype | hjversion | int8 | 19 | ||||
commenttype | hjversion | int8 | 19 | ||||
commenttype_conflicttype | hjversion | int8 | 19 | ||||
commenttype_conflicttype_sequencetype | hjversion | int8 | 19 | ||||
commenttype_diseasetype | hjversion | int8 | 19 | ||||
commenttype_linktype | hjversion | int8 | 19 | ||||
consortiumtype | hjversion | int8 | 19 | ||||
copyright | hjversion | int8 | 19 | ||||
dbreferencetype | hjversion | int8 | 19 | ||||
entrytype | hjversion | int8 | 19 | ||||
eventtype | hjversion | int8 | 19 | ||||
evidencedstringtype | hjversion | int8 | 19 | ||||
evidencetype | hjversion | int8 | 19 | ||||
featuretype | hjversion | int8 | 19 | ||||
genelocationtype | hjversion | int8 | 19 | ||||
genenametype | hjversion | int8 | 19 | ||||
genetype | hjversion | int8 | 19 | ||||
importedfromtype | hjversion | int8 | 19 | ||||
interactanttype | hjversion | int8 | 19 | ||||
isoformtype | hjversion | int8 | 19 | ||||
isoformtype_nametype | hjversion | int8 | 19 | ||||
isoformtype_sequencetype | hjversion | int8 | 19 | ||||
keywordtype | hjversion | int8 | 19 | ||||
locationtype | hjversion | int8 | 19 | ||||
moleculetype | hjversion | int8 | 19 | ||||
namelisttype | hjversion | int8 | 19 | ||||
organismnametype | hjversion | int8 | 19 | ||||
organismtype | hjversion | int8 | 19 | ||||
organismtype_lineagetype | hjversion | int8 | 19 | ||||
persontype | hjversion | int8 | 19 | ||||
positiontype | hjversion | int8 | 19 | ||||
propertytype | hjversion | int8 | 19 | ||||
proteinexistencetype | hjversion | int8 | 19 | ||||
proteinnamegroupalternativenametype | hjversion | int8 | 19 | ||||
proteinnamegrouprecommendednametype | hjversion | int8 | 19 | ||||
proteinnamegroupsubmittednametype | hjversion | int8 | 19 | ||||
proteintype | hjversion | int8 | 19 | ||||
proteintype_componenttype | hjversion | int8 | 19 | ||||
proteintype_domaintype | hjversion | int8 | 19 | ||||
referencetype | hjversion | int8 | 19 | ||||
sequencetype | hjversion | int8 | 19 | ||||
sourcedatatype | hjversion | int8 | 19 | ||||
sourcedatatype_plasmidtype | hjversion | int8 | 19 | ||||
sourcedatatype_straintype | hjversion | int8 | 19 | ||||
sourcedatatype_tissuetype | hjversion | int8 | 19 | ||||
sourcedatatype_transposontype | hjversion | int8 | 19 | ||||
statustype | hjversion | int8 | 19 | ||||
subcellularlocationtype | hjversion | int8 | 19 | ||||
uniprotsourcetype | hjversion | int8 | 19 | ||||
uniprottype | hjversion | int8 | 19 | ||||
commenttype_conflicttype_sequencetype | id | varchar | 2147483647 | √ | null | ||
commenttype_diseasetype | id | varchar | 2147483647 | √ | null | ||
dbreferencetype | id | varchar | 2147483647 | √ | null | ||
featuretype | id | varchar | 2147483647 | √ | null | ||
interactanttype | id | varchar | 2147483647 | √ | null | ||
keywordtype | id | varchar | 2147483647 | √ | null | ||
moleculetype | id | varchar | 2147483647 | √ | null | ||
evidencetype | importedfrom | int8 | 19 | √ | null | ||
citationtype | institute | varchar | 2147483647 | √ | null | ||
interactanttype | intactid | varchar | 2147483647 | √ | null | ||
isoformtype_id | isoformtype_id_hjid | int8 | 19 | ||||
isoformtype_id | isoformtype_id_hjindex | int4 | 10 | ||||
isoformtype_nametype | isoformtype_name_hjid | int8 | 19 | √ | null | ||
isoformtype_nametype | isoformtype_name_hjindex | int4 | 10 | √ | null | ||
isoformtype_nametype_evidence | isoformtype_nametype_evidence_hjid | int8 | 19 | ||||
isoformtype_nametype_evidence | isoformtype_nametype_evidence_hjindex | int4 | 10 | ||||
evidencedstringtype | isoformtype_text_hjid | int8 | 19 | √ | null | ||
evidencedstringtype | isoformtype_text_hjindex | int4 | 10 | √ | null | ||
evidencetype | key | numeric | 131089 | √ | null | ||
referencetype | key | varchar | 2147483647 | √ | null | ||
keywordtype_evidence | keywordtype_evidence_hjid | int8 | 19 | ||||
keywordtype_evidence | keywordtype_evidence_hjindex | int4 | 10 | ||||
commenttype | kinetics | int8 | 19 | √ | null | ||
interactanttype | label | varchar | 2147483647 | √ | null | ||
citationtype | last | varchar | 2147483647 | √ | null | ||
sequencetype | length | int4 | 10 | √ | null | ||
organismtype | lineage | int8 | 19 | √ | null | ||
featuretype | location | int8 | 19 | √ | null | ||
commenttype | locationtype | varchar | 2147483647 | √ | null | ||
citationtype | locator | varchar | 2147483647 | √ | null | ||
commenttype | mass | float4 | 8,8 | √ | null | ||
sequencetype | mass | int4 | 10 | √ | null | ||
bpccommentgroupabsorptiontype | max | int8 | 19 | √ | null | ||
commenttype | method | varchar | 2147483647 | √ | null | ||
entrytype | modified | timestamp | 29,6 | √ | null | ||
sequencetype | modified | timestamp | 29,6 | √ | null | ||
commenttype | molecule | int8 | 19 | √ | null | ||
dbreferencetype | molecule | int8 | 19 | √ | null | ||
citationtype | name | varchar | 2147483647 | √ | null | ||
cofactortype | name | varchar | 2147483647 | √ | null | ||
commenttype | name | varchar | 2147483647 | √ | null | ||
commenttype_diseasetype | name | varchar | 2147483647 | √ | null | ||
consortiumtype | name | varchar | 2147483647 | √ | null | ||
persontype | name | varchar | 2147483647 | √ | null | ||
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 | ||||
citationtype | number | varchar | 2147483647 | √ | null | ||
entrytype | organism | int8 | 19 | √ | null | ||
commenttype | organismsdiffer | bool | 1 | √ | null | ||
dbreferencetype | organismtype_dbreference_hjid | int8 | 19 | √ | null | ||
dbreferencetype | organismtype_dbreference_hjindex | int4 | 10 | √ | null | ||
organismtype_evidence | organismtype_evidence_hjid | int8 | 19 | ||||
organismtype_evidence | organismtype_evidence_hjindex | int4 | 10 | ||||
organismtype_lineagetype_taxon | organismtype_lineagetype_taxon_hjid | int8 | 19 | ||||
organismtype_lineagetype_taxon | organismtype_lineagetype_taxon_hjindex | int4 | 10 | ||||
organismnametype | organismtype_name_hjid | int8 | 19 | √ | null | ||
organismnametype | organismtype_name_hjindex | int4 | 10 | √ | null | ||
featuretype | original | varchar | 2147483647 | √ | null | ||
commenttype | phdependence | int8 | 19 | √ | null | ||
locationtype | position | int8 | 19 | √ | null | ||
positiontype | position | numeric | 131089 | √ | null | ||
positiontype_evidence | positiontype_evidence_hjid | int8 | 19 | ||||
positiontype_evidence | positiontype_evidence_hjindex | int4 | 10 | ||||
sequencetype | precursor | bool | 1 | √ | null | ||
entrytype | protein | int8 | 19 | √ | null | ||
entrytype | proteinexistence | int8 | 19 | √ | 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 | ||
proteinnamegroupalternativenametype | proteintype_alternativename_hjid | int8 | 19 | √ | null | ||
proteinnamegroupalternativenametype | proteintype_alternativename_hjindex | int4 | 10 | √ | null | ||
evidencedstringtype | proteintype_cdantigenname_hjid | int8 | 19 | √ | null | ||
evidencedstringtype | proteintype_cdantigenname_hjindex | int4 | 10 | √ | null | ||
proteintype_componenttype | proteintype_component_hjid | int8 | 19 | √ | null | ||
proteintype_componenttype | proteintype_component_hjindex | int4 | 10 | √ | null | ||
proteinnamegroupalternativenametype | proteintype_componenttype_alternativename_hjid | int8 | 19 | √ | null | ||
proteinnamegroupalternativenametype | proteintype_componenttype_alternativename_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 | ||
proteinnamegroupsubmittednametype | proteintype_componenttype_submittedname_hjid | int8 | 19 | √ | null | ||
proteinnamegroupsubmittednametype | proteintype_componenttype_submittedname_hjindex | int4 | 10 | √ | null | ||
proteintype_domaintype | proteintype_domain_hjid | int8 | 19 | √ | null | ||
proteintype_domaintype | proteintype_domain_hjindex | int4 | 10 | √ | null | ||
proteinnamegroupalternativenametype | proteintype_domaintype_alternativename_hjid | int8 | 19 | √ | null | ||
proteinnamegroupalternativenametype | proteintype_domaintype_alternativename_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 | ||
proteinnamegroupsubmittednametype | proteintype_domaintype_submittedname_hjid | int8 | 19 | √ | null | ||
proteinnamegroupsubmittednametype | proteintype_domaintype_submittedname_hjindex | int4 | 10 | √ | null | ||
evidencedstringtype | proteintype_innname_hjid | int8 | 19 | √ | null | ||
evidencedstringtype | proteintype_innname_hjindex | int4 | 10 | √ | null | ||
proteinnamegroupsubmittednametype | proteintype_submittedname_hjid | int8 | 19 | √ | null | ||
proteinnamegroupsubmittednametype | proteintype_submittedname_hjindex | int4 | 10 | √ | null | ||
citationtype | publisher | varchar | 2147483647 | √ | null | ||
proteintype | recommendedname | int8 | 19 | √ | null | ||
proteintype_componenttype | recommendedname | int8 | 19 | √ | null | ||
proteintype_domaintype | recommendedname | int8 | 19 | √ | null | ||
commenttype | redoxpotential | int8 | 19 | √ | null | ||
commenttype_conflicttype | ref | varchar | 2147483647 | √ | null | ||
featuretype | ref | varchar | 2147483647 | √ | null | ||
isoformtype_sequencetype | ref | varchar | 2147483647 | √ | null | ||
uniprotsourcetype | ref | numeric | 131089 | √ | null | ||
referencetype_evidence | referencetype_evidence_hjid | int8 | 19 | ||||
referencetype_evidence | referencetype_evidence_hjindex | int4 | 10 | ||||
referencetype_scope | referencetype_scope_hjid | int8 | 19 | ||||
referencetype_scope | referencetype_scope_hjindex | int4 | 10 | ||||
commenttype_conflicttype_sequencetype | resource | varchar | 2147483647 | √ | null | ||
commenttype_conflicttype | sequence | int8 | 19 | √ | null | ||
entrytype | sequence | int8 | 19 | √ | null | ||
isoformtype | sequence | int8 | 19 | √ | null | ||
locationtype | sequence | varchar | 2147483647 | √ | null | ||
evidencetype | source | int8 | 19 | √ | null | ||
referencetype | source | int8 | 19 | √ | 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_evidence | sourcedatatype_straintype_evidence_hjid | int8 | 19 | ||||
sourcedatatype_straintype_evidence | sourcedatatype_straintype_evidence_hjindex | int4 | 10 | ||||
sourcedatatype_tissuetype_evidence | sourcedatatype_tissuetype_evidence_hjid | int8 | 19 | ||||
sourcedatatype_tissuetype_evidence | sourcedatatype_tissuetype_evidence_hjindex | int4 | 10 | ||||
sourcedatatype_transposontype_evidence | sourcedatatype_transposontype_evidence_hjid | int8 | 19 | ||||
sourcedatatype_transposontype_evidence | sourcedatatype_transposontype_evidence_hjindex | int4 | 10 | ||||
evidencedstringtype | status | varchar | 2147483647 | √ | null | ||
featuretype | status | varchar | 2147483647 | √ | null | ||
positiontype | status | varchar | 2147483647 | √ | null | ||
statustype | 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 | ||
commenttype | temperaturedependence | int8 | 19 | √ | null | ||
citationtype | title | varchar | 2147483647 | √ | null | ||
citationtype | type | varchar | 2147483647 | √ | null | ||
commenttype | type | varchar | 2147483647 | √ | null | ||
commenttype_conflicttype | type | varchar | 2147483647 | √ | null | ||
dbreferencetype | type | varchar | 2147483647 | √ | null | ||
eventtype | type | varchar | 2147483647 | √ | null | ||
evidencetype | type | varchar | 2147483647 | √ | null | ||
featuretype | type | varchar | 2147483647 | √ | null | ||
genelocationtype | type | varchar | 2147483647 | √ | null | ||
genenametype | type | varchar | 2147483647 | √ | null | ||
isoformtype_sequencetype | type | varchar | 2147483647 | √ | null | ||
organismnametype | type | varchar | 2147483647 | √ | null | ||
propertytype | type | varchar | 2147483647 | √ | null | ||
proteinexistencetype | type | varchar | 2147483647 | √ | null | ||
entrytype | uniprottype_entry_hjid | int8 | 19 | √ | null | ||
entrytype | uniprottype_entry_hjindex | int4 | 10 | √ | null | ||
commenttype_linktype | uri | varchar | 2147483647 | √ | null | ||
copyright | value | varchar | 2147483647 | √ | null | ||
evidencedstringtype | value | varchar | 2147483647 | √ | null | ||
genenametype | value | varchar | 2147483647 | √ | null | ||
isoformtype_nametype | value | varchar | 2147483647 | √ | null | ||
keywordtype | value | varchar | 2147483647 | √ | null | ||
moleculetype | value | varchar | 2147483647 | √ | null | ||
organismnametype | value | varchar | 2147483647 | √ | null | ||
propertytype | value | varchar | 2147483647 | √ | null | ||
sequencetype | value | varchar | 2147483647 | √ | null | ||
sourcedatatype_plasmidtype | value | varchar | 2147483647 | √ | null | ||
sourcedatatype_straintype | value | varchar | 2147483647 | √ | null | ||
sourcedatatype_tissuetype | value | varchar | 2147483647 | √ | null | ||
sourcedatatype_transposontype | value | varchar | 2147483647 | √ | null | ||
statustype | value | varchar | 2147483647 | √ | null | ||
commenttype_conflicttype_sequencetype | version | int4 | 10 | √ | null | ||
entrytype | version | int4 | 10 | √ | null | ||
sequencetype | version | int4 | 10 | √ | null | ||
citationtype | volume | varchar | 2147483647 | √ | null |