SchemaSpy Analysis of gmbuilder.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Nov 21 10:45 PST 2016 |
| ||||||
|
gmbuilder.public contains 841 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
acc | content | varchar | 2147483647 | √ | null | ||
acc | hjid | int8 | 19 | ||||
acc | hjtype | varchar | 2147483647 | ||||
acc | hjversion | int8 | 19 | ||||
altid | content | varchar | 2147483647 | √ | null | ||
altid | hjid | int8 | 19 | ||||
altid | hjtype | varchar | 2147483647 | ||||
altid | hjversion | int8 | 19 | ||||
autogeneratedby | content | varchar | 2147483647 | √ | null | ||
autogeneratedby | hjid | int8 | 19 | ||||
autogeneratedby | hjtype | varchar | 2147483647 | ||||
autogeneratedby | hjversion | int8 | 19 | ||||
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 | ||
comment | content | varchar | 2147483647 | √ | null | ||
comment | hjid | int8 | 19 | ||||
comment | hjtype | varchar | 2147483647 | ||||
comment | hjversion | int8 | 19 | ||||
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 | ||
consider | content | varchar | 2147483647 | √ | null | ||
consider | hjid | int8 | 19 | ||||
consider | hjtype | varchar | 2147483647 | ||||
consider | hjversion | int8 | 19 | ||||
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 | ||
createdby | content | varchar | 2147483647 | √ | null | ||
createdby | hjid | int8 | 19 | ||||
createdby | hjtype | varchar | 2147483647 | ||||
createdby | hjversion | int8 | 19 | ||||
creationdate | content | varchar | 2147483647 | √ | null | ||
creationdate | hjid | int8 | 19 | ||||
creationdate | hjtype | varchar | 2147483647 | ||||
creationdate | hjversion | int8 | 19 | ||||
dataversion | content | varchar | 2147483647 | √ | null | ||
dataversion | hjid | int8 | 19 | ||||
dataversion | hjtype | varchar | 2147483647 | ||||
dataversion | hjversion | int8 | 19 | ||||
date | content | varchar | 2147483647 | √ | null | ||
date | hjid | int8 | 19 | ||||
date | hjtype | varchar | 2147483647 | ||||
date | hjversion | int8 | 19 | ||||
dbname | content | varchar | 2147483647 | √ | null | ||
dbname | hjid | int8 | 19 | ||||
dbname | hjtype | varchar | 2147483647 | ||||
dbname | hjversion | int8 | 19 | ||||
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 | ||
dbxref | hjid | int8 | 19 | ||||
dbxref | hjtype | varchar | 2147483647 | ||||
dbxref | hjversion | int8 | 19 | ||||
dbxref_content | dbxref_content_hjchildid | int8 | 19 | √ | null | ||
dbxref_content | dbxref_content_hjclass | varchar | 2147483647 | √ | null | ||
dbxref_content | dbxref_content_hjid | int8 | 19 | ||||
dbxref_content | dbxref_content_hjindex | int4 | 10 | ||||
def | hjid | int8 | 19 | ||||
def | hjtype | varchar | 2147483647 | ||||
def | hjversion | int8 | 19 | ||||
def_content | def_content_hjchildid | int8 | 19 | √ | null | ||
def_content | def_content_hjclass | varchar | 2147483647 | √ | null | ||
def_content | def_content_hjid | int8 | 19 | ||||
def_content | def_content_hjindex | int4 | 10 | ||||
defaultnamespace | content | varchar | 2147483647 | √ | null | ||
defaultnamespace | hjid | int8 | 19 | ||||
defaultnamespace | hjtype | varchar | 2147483647 | ||||
defaultnamespace | hjversion | int8 | 19 | ||||
defstr | content | varchar | 2147483647 | √ | null | ||
defstr | hjid | int8 | 19 | ||||
defstr | hjtype | varchar | 2147483647 | ||||
defstr | hjversion | int8 | 19 | ||||
disjointfrom | content | varchar | 2147483647 | √ | null | ||
disjointfrom | hjid | int8 | 19 | ||||
disjointfrom | hjtype | varchar | 2147483647 | ||||
disjointfrom | hjversion | int8 | 19 | ||||
domain | content | varchar | 2147483647 | √ | null | ||
domain | hjid | int8 | 19 | ||||
domain | hjtype | varchar | 2147483647 | ||||
domain | hjversion | int8 | 19 | ||||
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 | ||
expandassertionto | content | varchar | 2147483647 | √ | null | ||
expandassertionto | hjid | int8 | 19 | ||||
expandassertionto | hjtype | varchar | 2147483647 | ||||
expandassertionto | hjversion | int8 | 19 | ||||
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 | ||
formatversion | content | varchar | 2147483647 | √ | null | ||
formatversion | hjid | int8 | 19 | ||||
formatversion | hjtype | varchar | 2147483647 | ||||
formatversion | hjversion | int8 | 19 | ||||
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 | ||||
global | content | varchar | 2147483647 | √ | null | ||
global | hjid | int8 | 19 | ||||
global | hjtype | varchar | 2147483647 | ||||
global | hjversion | int8 | 19 | ||||
goa | annotation_extension | varchar | 2147483647 | √ | null | ||
goa | aspect | varchar | 2147483647 | ||||
goa | assigned_by | varchar | 2147483647 | ||||
goa | date | date | 13 | ||||
goa | db | varchar | 2147483647 | ||||
goa | db_object_id | varchar | 2147483647 | ||||
goa | db_object_name | varchar | 2147483647 | √ | null | ||
goa | db_object_symbol | varchar | 2147483647 | ||||
goa | db_object_synonym | varchar | 2147483647 | √ | null | ||
goa | db_object_type | varchar | 2147483647 | ||||
goa | db_reference | varchar | 2147483647 | ||||
goa | evidence_code | varchar | 2147483647 | ||||
goa | gene_product_form_id | varchar | 2147483647 | √ | null | ||
goa | go_id | varchar | 2147483647 | ||||
goa | primdbkey | int8 | 19 | ||||
goa | qualifier | varchar | 2147483647 | √ | null | ||
goa | taxon | varchar | 2147483647 | ||||
goa | with_or_from | varchar | 2147483647 | √ | null | ||
header | hjid | int8 | 19 | ||||
header | hjtype | varchar | 2147483647 | ||||
header | hjversion | int8 | 19 | ||||
header_content | header_content_hjchildid | int8 | 19 | √ | null | ||
header_content | header_content_hjclass | varchar | 2147483647 | √ | null | ||
header_content | header_content_hjid | int8 | 19 | ||||
header_content | header_content_hjindex | int4 | 10 | ||||
holdsoverchain | hjid | int8 | 19 | ||||
holdsoverchain | hjtype | varchar | 2147483647 | ||||
holdsoverchain | hjversion | int8 | 19 | ||||
id | content | varchar | 2147483647 | √ | null | ||
id | hjid | int8 | 19 | ||||
id | hjtype | varchar | 2147483647 | ||||
id | hjversion | int8 | 19 | ||||
idspace | hjid | int8 | 19 | ||||
idspace | hjtype | varchar | 2147483647 | ||||
idspace | hjversion | int8 | 19 | ||||
idspace_content | idspace_content_hjchildid | int8 | 19 | √ | null | ||
idspace_content | idspace_content_hjclass | varchar | 2147483647 | √ | null | ||
idspace_content | idspace_content_hjid | int8 | 19 | ||||
idspace_content | idspace_content_hjindex | int4 | 10 | ||||
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 | ||
intersectionof | hjid | int8 | 19 | ||||
intersectionof | hjtype | varchar | 2147483647 | ||||
intersectionof | hjversion | int8 | 19 | ||||
intersectionof_content | intersectionof_content_hjchildid | int8 | 19 | √ | null | ||
intersectionof_content | intersectionof_content_hjclass | varchar | 2147483647 | √ | null | ||
intersectionof_content | intersectionof_content_hjid | int8 | 19 | ||||
intersectionof_content | intersectionof_content_hjindex | int4 | 10 | ||||
inverseof | content | varchar | 2147483647 | √ | null | ||
inverseof | hjid | int8 | 19 | ||||
inverseof | hjtype | varchar | 2147483647 | ||||
inverseof | hjversion | int8 | 19 | ||||
isa | content | varchar | 2147483647 | √ | null | ||
isa | hjid | int8 | 19 | ||||
isa | hjtype | varchar | 2147483647 | ||||
isa | hjversion | int8 | 19 | ||||
isanonymous | content | varchar | 2147483647 | √ | null | ||
isanonymous | hjid | int8 | 19 | ||||
isanonymous | hjtype | varchar | 2147483647 | ||||
isanonymous | hjversion | int8 | 19 | ||||
isantisymmetric | content | varchar | 2147483647 | √ | null | ||
isantisymmetric | hjid | int8 | 19 | ||||
isantisymmetric | hjtype | varchar | 2147483647 | ||||
isantisymmetric | hjversion | int8 | 19 | ||||
isclasslevel | content | varchar | 2147483647 | √ | null | ||
isclasslevel | hjid | int8 | 19 | ||||
isclasslevel | hjtype | varchar | 2147483647 | ||||
isclasslevel | hjversion | int8 | 19 | ||||
ismetadatatag | content | varchar | 2147483647 | √ | null | ||
ismetadatatag | hjid | int8 | 19 | ||||
ismetadatatag | hjtype | varchar | 2147483647 | ||||
ismetadatatag | hjversion | int8 | 19 | ||||
isobsolete | content | varchar | 2147483647 | √ | null | ||
isobsolete | hjid | int8 | 19 | ||||
isobsolete | hjtype | varchar | 2147483647 | ||||
isobsolete | hjversion | int8 | 19 | ||||
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 | ||
isreflexive | content | varchar | 2147483647 | √ | null | ||
isreflexive | hjid | int8 | 19 | ||||
isreflexive | hjtype | varchar | 2147483647 | ||||
isreflexive | hjversion | int8 | 19 | ||||
isroot | content | varchar | 2147483647 | √ | null | ||
isroot | hjid | int8 | 19 | ||||
isroot | hjtype | varchar | 2147483647 | ||||
isroot | hjversion | int8 | 19 | ||||
issymmetric | content | varchar | 2147483647 | √ | null | ||
issymmetric | hjid | int8 | 19 | ||||
issymmetric | hjtype | varchar | 2147483647 | ||||
issymmetric | hjversion | int8 | 19 | ||||
istransitive | content | varchar | 2147483647 | √ | null | ||
istransitive | hjid | int8 | 19 | ||||
istransitive | hjtype | varchar | 2147483647 | ||||
istransitive | hjversion | int8 | 19 | ||||
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 | ||||
lexicalcategory | content | varchar | 2147483647 | √ | null | ||
lexicalcategory | hjid | int8 | 19 | ||||
lexicalcategory | hjtype | varchar | 2147483647 | ||||
lexicalcategory | hjversion | int8 | 19 | ||||
local | content | varchar | 2147483647 | √ | null | ||
local | hjid | int8 | 19 | ||||
local | hjtype | varchar | 2147483647 | ||||
local | hjversion | int8 | 19 | ||||
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 | ||
name | content | varchar | 2147483647 | √ | null | ||
name | hjid | int8 | 19 | ||||
name | hjtype | varchar | 2147483647 | ||||
name | hjversion | int8 | 19 | ||||
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 | ||||
namespace | content | varchar | 2147483647 | √ | null | ||
namespace | hjid | int8 | 19 | ||||
namespace | hjtype | varchar | 2147483647 | ||||
namespace | hjversion | int8 | 19 | ||||
obo | hjid | int8 | 19 | ||||
obo | hjtype | varchar | 2147483647 | ||||
obo | hjversion | int8 | 19 | ||||
obo_content | obo_content_hjchildid | int8 | 19 | √ | null | ||
obo_content | obo_content_hjclass | varchar | 2147483647 | √ | null | ||
obo_content | obo_content_hjid | int8 | 19 | ||||
obo_content | obo_content_hjindex | int4 | 10 | ||||
ontology | content | varchar | 2147483647 | √ | null | ||
ontology | hjid | int8 | 19 | ||||
ontology | hjtype | varchar | 2147483647 | ||||
ontology | hjversion | int8 | 19 | ||||
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 | ||
propertyvalue | content | varchar | 2147483647 | √ | null | ||
propertyvalue | hjid | int8 | 19 | ||||
propertyvalue | hjtype | varchar | 2147483647 | ||||
propertyvalue | hjversion | int8 | 19 | ||||
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 | ||
range | content | varchar | 2147483647 | √ | null | ||
range | hjid | int8 | 19 | ||||
range | hjtype | varchar | 2147483647 | ||||
range | hjversion | int8 | 19 | ||||
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 | ||||
relation | content | varchar | 2147483647 | √ | null | ||
relation | hjid | int8 | 19 | ||||
relation | hjtype | varchar | 2147483647 | ||||
relation | hjversion | int8 | 19 | ||||
relation | holdsoverchain_relation_hjid | int8 | 19 | √ | null | ||
relation | holdsoverchain_relation_hjindex | int4 | 10 | √ | null | ||
relationship | hjid | int8 | 19 | ||||
relationship | hjtype | varchar | 2147483647 | ||||
relationship | hjversion | int8 | 19 | ||||
relationship_content | relationship_content_hjchildid | int8 | 19 | √ | null | ||
relationship_content | relationship_content_hjclass | varchar | 2147483647 | √ | null | ||
relationship_content | relationship_content_hjid | int8 | 19 | ||||
relationship_content | relationship_content_hjindex | int4 | 10 | ||||
remark | content | varchar | 2147483647 | √ | null | ||
remark | hjid | int8 | 19 | ||||
remark | hjtype | varchar | 2147483647 | ||||
remark | hjversion | int8 | 19 | ||||
replacedby | content | varchar | 2147483647 | √ | null | ||
replacedby | hjid | int8 | 19 | ||||
replacedby | hjtype | varchar | 2147483647 | ||||
replacedby | hjversion | int8 | 19 | ||||
savedby | content | varchar | 2147483647 | √ | null | ||
savedby | hjid | int8 | 19 | ||||
savedby | hjtype | varchar | 2147483647 | ||||
savedby | hjversion | int8 | 19 | ||||
scope | content | varchar | 2147483647 | √ | null | ||
scope | hjid | int8 | 19 | ||||
scope | hjtype | varchar | 2147483647 | ||||
scope | hjversion | int8 | 19 | ||||
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 | ||
source | hjid | int8 | 19 | ||||
source | hjtype | varchar | 2147483647 | ||||
source | hjversion | int8 | 19 | ||||
source_content | source_content_hjchildid | int8 | 19 | √ | null | ||
source_content | source_content_hjclass | varchar | 2147483647 | √ | null | ||
source_content | source_content_hjid | int8 | 19 | ||||
source_content | source_content_hjindex | int4 | 10 | ||||
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 | ||||
sourcefullpath | content | varchar | 2147483647 | √ | null | ||
sourcefullpath | hjid | int8 | 19 | ||||
sourcefullpath | hjtype | varchar | 2147483647 | ||||
sourcefullpath | hjversion | int8 | 19 | ||||
sourceid | content | varchar | 2147483647 | √ | null | ||
sourceid | hjid | int8 | 19 | ||||
sourceid | hjtype | varchar | 2147483647 | ||||
sourceid | hjversion | int8 | 19 | ||||
sourcemd5 | content | varchar | 2147483647 | √ | null | ||
sourcemd5 | hjid | int8 | 19 | ||||
sourcemd5 | hjtype | varchar | 2147483647 | ||||
sourcemd5 | hjversion | int8 | 19 | ||||
sourcemtime | content | varchar | 2147483647 | √ | null | ||
sourcemtime | hjid | int8 | 19 | ||||
sourcemtime | hjtype | varchar | 2147483647 | ||||
sourcemtime | hjversion | int8 | 19 | ||||
sourceparsetime | content | varchar | 2147483647 | √ | null | ||
sourceparsetime | hjid | int8 | 19 | ||||
sourceparsetime | hjtype | varchar | 2147483647 | ||||
sourceparsetime | hjversion | int8 | 19 | ||||
sourcepath | content | varchar | 2147483647 | √ | null | ||
sourcepath | hjid | int8 | 19 | ||||
sourcepath | hjtype | varchar | 2147483647 | ||||
sourcepath | hjversion | int8 | 19 | ||||
sourcetype | content | varchar | 2147483647 | √ | null | ||
sourcetype | hjid | int8 | 19 | ||||
sourcetype | hjtype | varchar | 2147483647 | ||||
sourcetype | hjversion | int8 | 19 | ||||
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 | ||||
subset | content | varchar | 2147483647 | √ | null | ||
subset | hjid | int8 | 19 | ||||
subset | hjtype | varchar | 2147483647 | ||||
subset | hjversion | int8 | 19 | ||||
subsetdef | hjid | int8 | 19 | ||||
subsetdef | hjtype | varchar | 2147483647 | ||||
subsetdef | hjversion | int8 | 19 | ||||
subsetdef_content | subsetdef_content_hjchildid | int8 | 19 | √ | null | ||
subsetdef_content | subsetdef_content_hjclass | varchar | 2147483647 | √ | null | ||
subsetdef_content | subsetdef_content_hjid | int8 | 19 | ||||
subsetdef_content | subsetdef_content_hjindex | int4 | 10 | ||||
synonym | hjid | int8 | 19 | ||||
synonym | hjtype | varchar | 2147483647 | ||||
synonym | hjversion | int8 | 19 | ||||
synonym | scope | varchar | 2147483647 | √ | null | ||
synonym_content | synonym_content_hjchildid | int8 | 19 | √ | null | ||
synonym_content | synonym_content_hjclass | varchar | 2147483647 | √ | null | ||
synonym_content | synonym_content_hjid | int8 | 19 | ||||
synonym_content | synonym_content_hjindex | int4 | 10 | ||||
synonymcategory | hjid | int8 | 19 | ||||
synonymcategory | hjtype | varchar | 2147483647 | ||||
synonymcategory | hjversion | int8 | 19 | ||||
synonymcategory_content | synonymcategory_content_hjchildid | int8 | 19 | √ | null | ||
synonymcategory_content | synonymcategory_content_hjclass | varchar | 2147483647 | √ | null | ||
synonymcategory_content | synonymcategory_content_hjid | int8 | 19 | ||||
synonymcategory_content | synonymcategory_content_hjindex | int4 | 10 | ||||
synonymtext | content | varchar | 2147483647 | √ | null | ||
synonymtext | hjid | int8 | 19 | ||||
synonymtext | hjtype | varchar | 2147483647 | ||||
synonymtext | hjversion | int8 | 19 | ||||
synonymtypedef | hjid | int8 | 19 | ||||
synonymtypedef | hjtype | varchar | 2147483647 | ||||
synonymtypedef | hjversion | int8 | 19 | ||||
synonymtypedef_content | synonymtypedef_content_hjchildid | int8 | 19 | √ | null | ||
synonymtypedef_content | synonymtypedef_content_hjclass | varchar | 2147483647 | √ | null | ||
synonymtypedef_content | synonymtypedef_content_hjid | int8 | 19 | ||||
synonymtypedef_content | synonymtypedef_content_hjindex | int4 | 10 | ||||
term | hjid | int8 | 19 | ||||
term | hjtype | varchar | 2147483647 | ||||
term | hjversion | int8 | 19 | ||||
term_content | term_content_hjchildid | int8 | 19 | √ | null | ||
term_content | term_content_hjclass | varchar | 2147483647 | √ | null | ||
term_content | term_content_hjid | int8 | 19 | ||||
term_content | term_content_hjindex | int4 | 10 | ||||
to_ | content | varchar | 2147483647 | √ | null | ||
to_ | hjid | int8 | 19 | ||||
to_ | hjtype | varchar | 2147483647 | ||||
to_ | hjversion | int8 | 19 | ||||
transitiveover | content | varchar | 2147483647 | √ | null | ||
transitiveover | hjid | int8 | 19 | ||||
transitiveover | hjtype | varchar | 2147483647 | ||||
transitiveover | hjversion | int8 | 19 | ||||
type | content | varchar | 2147483647 | √ | null | ||
type | hjid | int8 | 19 | ||||
type | hjtype | varchar | 2147483647 | ||||
type | hjversion | int8 | 19 | ||||
typedef | hjid | int8 | 19 | ||||
typedef | hjtype | varchar | 2147483647 | ||||
typedef | hjversion | int8 | 19 | ||||
typedef_content | typedef_content_hjchildid | int8 | 19 | √ | null | ||
typedef_content | typedef_content_hjclass | varchar | 2147483647 | √ | null | ||
typedef_content | typedef_content_hjid | int8 | 19 | ||||
typedef_content | typedef_content_hjindex | int4 | 10 | ||||
unionof | content | varchar | 2147483647 | √ | null | ||
unionof | hjid | int8 | 19 | ||||
unionof | hjtype | varchar | 2147483647 | ||||
unionof | 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 | ||||
xrefanalog | hjid | int8 | 19 | ||||
xrefanalog | hjtype | varchar | 2147483647 | ||||
xrefanalog | hjversion | int8 | 19 | ||||
xrefanalog_content | xrefanalog_content_hjchildid | int8 | 19 | √ | null | ||
xrefanalog_content | xrefanalog_content_hjclass | varchar | 2147483647 | √ | null | ||
xrefanalog_content | xrefanalog_content_hjid | int8 | 19 | ||||
xrefanalog_content | xrefanalog_content_hjindex | int4 | 10 | ||||
xrefunknown | hjid | int8 | 19 | ||||
xrefunknown | hjtype | varchar | 2147483647 | ||||
xrefunknown | hjversion | int8 | 19 | ||||
xrefunknown_content | xrefunknown_content_hjchildid | int8 | 19 | √ | null | ||
xrefunknown_content | xrefunknown_content_hjclass | varchar | 2147483647 | √ | null | ||
xrefunknown_content | xrefunknown_content_hjid | int8 | 19 | ||||
xrefunknown_content | xrefunknown_content_hjindex | int4 | 10 |