SchemaSpy Analysis of godb.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Nov 21 10:46 PST 2016 |
| ||||||
|
godb.public contains 334 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 | ||||
comment | content | varchar | 2147483647 | √ | null | ||
comment | hjid | int8 | 19 | ||||
comment | hjtype | varchar | 2147483647 | ||||
comment | hjversion | int8 | 19 | ||||
consider | content | varchar | 2147483647 | √ | null | ||
consider | hjid | int8 | 19 | ||||
consider | hjtype | varchar | 2147483647 | ||||
consider | hjversion | int8 | 19 | ||||
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 | ||||
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 | ||||
expandassertionto | content | varchar | 2147483647 | √ | null | ||
expandassertionto | hjid | int8 | 19 | ||||
expandassertionto | hjtype | varchar | 2147483647 | ||||
expandassertionto | hjversion | int8 | 19 | ||||
formatversion | content | varchar | 2147483647 | √ | null | ||
formatversion | hjid | int8 | 19 | ||||
formatversion | hjtype | varchar | 2147483647 | ||||
formatversion | hjversion | int8 | 19 | ||||
global | content | varchar | 2147483647 | √ | null | ||
global | hjid | int8 | 19 | ||||
global | hjtype | varchar | 2147483647 | ||||
global | hjversion | int8 | 19 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
name | content | varchar | 2147483647 | √ | null | ||
name | hjid | int8 | 19 | ||||
name | hjtype | varchar | 2147483647 | ||||
name | hjversion | int8 | 19 | ||||
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 | ||||
propertyvalue | content | varchar | 2147483647 | √ | null | ||
propertyvalue | hjid | int8 | 19 | ||||
propertyvalue | hjtype | varchar | 2147483647 | ||||
propertyvalue | hjversion | int8 | 19 | ||||
range | content | varchar | 2147483647 | √ | null | ||
range | hjid | int8 | 19 | ||||
range | hjtype | varchar | 2147483647 | ||||
range | hjversion | int8 | 19 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 |