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 |
---|---|---|---|---|---|---|
acc | content | varchar | 2147483647 | √ | null | |
altid | content | varchar | 2147483647 | √ | null | |
autogeneratedby | content | varchar | 2147483647 | √ | null | |
comment | content | varchar | 2147483647 | √ | null | |
consider | content | varchar | 2147483647 | √ | null | |
createdby | content | varchar | 2147483647 | √ | null | |
creationdate | content | varchar | 2147483647 | √ | null | |
dataversion | content | varchar | 2147483647 | √ | null | |
date | content | varchar | 2147483647 | √ | null | |
dbname | content | varchar | 2147483647 | √ | null | |
defaultnamespace | content | varchar | 2147483647 | √ | null | |
defstr | content | varchar | 2147483647 | √ | null | |
disjointfrom | content | varchar | 2147483647 | √ | null | |
domain | content | varchar | 2147483647 | √ | null | |
expandassertionto | content | varchar | 2147483647 | √ | null | |
formatversion | content | varchar | 2147483647 | √ | null | |
global | content | varchar | 2147483647 | √ | null | |
id | content | varchar | 2147483647 | √ | null | |
inverseof | content | varchar | 2147483647 | √ | null | |
isa | content | varchar | 2147483647 | √ | null | |
isanonymous | content | varchar | 2147483647 | √ | null | |
isantisymmetric | content | varchar | 2147483647 | √ | null | |
isclasslevel | content | varchar | 2147483647 | √ | null | |
ismetadatatag | content | varchar | 2147483647 | √ | null | |
isobsolete | content | varchar | 2147483647 | √ | null | |
isreflexive | content | varchar | 2147483647 | √ | null | |
isroot | content | varchar | 2147483647 | √ | null | |
issymmetric | content | varchar | 2147483647 | √ | null | |
istransitive | content | varchar | 2147483647 | √ | null | |
lexicalcategory | content | varchar | 2147483647 | √ | null | |
local | content | varchar | 2147483647 | √ | null | |
name | content | varchar | 2147483647 | √ | null | |
namespace | content | varchar | 2147483647 | √ | null | |
ontology | content | varchar | 2147483647 | √ | null | |
propertyvalue | content | varchar | 2147483647 | √ | null | |
range | content | varchar | 2147483647 | √ | null | |
relation | content | varchar | 2147483647 | √ | null | |
remark | content | varchar | 2147483647 | √ | null | |
replacedby | content | varchar | 2147483647 | √ | null | |
savedby | content | varchar | 2147483647 | √ | null | |
scope | content | varchar | 2147483647 | √ | null | |
sourcefullpath | content | varchar | 2147483647 | √ | null | |
sourceid | content | varchar | 2147483647 | √ | null | |
sourcemd5 | content | varchar | 2147483647 | √ | null | |
sourcemtime | content | varchar | 2147483647 | √ | null | |
sourceparsetime | content | varchar | 2147483647 | √ | null | |
sourcepath | content | varchar | 2147483647 | √ | null | |
sourcetype | content | varchar | 2147483647 | √ | null | |
subset | content | varchar | 2147483647 | √ | null | |
synonymtext | content | varchar | 2147483647 | √ | null | |
to_ | content | varchar | 2147483647 | √ | null | |
transitiveover | content | varchar | 2147483647 | √ | null | |
type | content | varchar | 2147483647 | √ | null | |
unionof | content | varchar | 2147483647 | √ | null | |
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_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 | |||
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 | |||
acc | hjid | int8 | 19 | |||
altid | hjid | int8 | 19 | |||
autogeneratedby | hjid | int8 | 19 | |||
comment | hjid | int8 | 19 | |||
consider | hjid | int8 | 19 | |||
createdby | hjid | int8 | 19 | |||
creationdate | hjid | int8 | 19 | |||
dataversion | hjid | int8 | 19 | |||
date | hjid | int8 | 19 | |||
dbname | hjid | int8 | 19 | |||
dbxref | hjid | int8 | 19 | |||
def | hjid | int8 | 19 | |||
defaultnamespace | hjid | int8 | 19 | |||
defstr | hjid | int8 | 19 | |||
disjointfrom | hjid | int8 | 19 | |||
domain | hjid | int8 | 19 | |||
expandassertionto | hjid | int8 | 19 | |||
formatversion | hjid | int8 | 19 | |||
global | hjid | int8 | 19 | |||
header | hjid | int8 | 19 | |||
holdsoverchain | hjid | int8 | 19 | |||
id | hjid | int8 | 19 | |||
idspace | hjid | int8 | 19 | |||
intersectionof | hjid | int8 | 19 | |||
inverseof | hjid | int8 | 19 | |||
isa | hjid | int8 | 19 | |||
isanonymous | hjid | int8 | 19 | |||
isantisymmetric | hjid | int8 | 19 | |||
isclasslevel | hjid | int8 | 19 | |||
ismetadatatag | hjid | int8 | 19 | |||
isobsolete | hjid | int8 | 19 | |||
isreflexive | hjid | int8 | 19 | |||
isroot | hjid | int8 | 19 | |||
issymmetric | hjid | int8 | 19 | |||
istransitive | hjid | int8 | 19 | |||
lexicalcategory | hjid | int8 | 19 | |||
local | hjid | int8 | 19 | |||
name | hjid | int8 | 19 | |||
namespace | hjid | int8 | 19 | |||
obo | hjid | int8 | 19 | |||
ontology | hjid | int8 | 19 | |||
propertyvalue | hjid | int8 | 19 | |||
range | hjid | int8 | 19 | |||
relation | hjid | int8 | 19 | |||
relationship | hjid | int8 | 19 | |||
remark | hjid | int8 | 19 | |||
replacedby | hjid | int8 | 19 | |||
savedby | hjid | int8 | 19 | |||
scope | hjid | int8 | 19 | |||
source | hjid | int8 | 19 | |||
sourcefullpath | hjid | int8 | 19 | |||
sourceid | hjid | int8 | 19 | |||
sourcemd5 | hjid | int8 | 19 | |||
sourcemtime | hjid | int8 | 19 | |||
sourceparsetime | hjid | int8 | 19 | |||
sourcepath | hjid | int8 | 19 | |||
sourcetype | hjid | int8 | 19 | |||
subset | hjid | int8 | 19 | |||
subsetdef | hjid | int8 | 19 | |||
synonym | hjid | int8 | 19 | |||
synonymcategory | hjid | int8 | 19 | |||
synonymtext | hjid | int8 | 19 | |||
synonymtypedef | hjid | int8 | 19 | |||
term | hjid | int8 | 19 | |||
to_ | hjid | int8 | 19 | |||
transitiveover | hjid | int8 | 19 | |||
type | hjid | int8 | 19 | |||
typedef | hjid | int8 | 19 | |||
unionof | hjid | int8 | 19 | |||
xrefanalog | hjid | int8 | 19 | |||
xrefunknown | hjid | int8 | 19 | |||
acc | hjtype | varchar | 2147483647 | |||
altid | hjtype | varchar | 2147483647 | |||
autogeneratedby | hjtype | varchar | 2147483647 | |||
comment | hjtype | varchar | 2147483647 | |||
consider | hjtype | varchar | 2147483647 | |||
createdby | hjtype | varchar | 2147483647 | |||
creationdate | hjtype | varchar | 2147483647 | |||
dataversion | hjtype | varchar | 2147483647 | |||
date | hjtype | varchar | 2147483647 | |||
dbname | hjtype | varchar | 2147483647 | |||
dbxref | hjtype | varchar | 2147483647 | |||
def | hjtype | varchar | 2147483647 | |||
defaultnamespace | hjtype | varchar | 2147483647 | |||
defstr | hjtype | varchar | 2147483647 | |||
disjointfrom | hjtype | varchar | 2147483647 | |||
domain | hjtype | varchar | 2147483647 | |||
expandassertionto | hjtype | varchar | 2147483647 | |||
formatversion | hjtype | varchar | 2147483647 | |||
global | hjtype | varchar | 2147483647 | |||
header | hjtype | varchar | 2147483647 | |||
holdsoverchain | hjtype | varchar | 2147483647 | |||
id | hjtype | varchar | 2147483647 | |||
idspace | hjtype | varchar | 2147483647 | |||
intersectionof | hjtype | varchar | 2147483647 | |||
inverseof | hjtype | varchar | 2147483647 | |||
isa | hjtype | varchar | 2147483647 | |||
isanonymous | hjtype | varchar | 2147483647 | |||
isantisymmetric | hjtype | varchar | 2147483647 | |||
isclasslevel | hjtype | varchar | 2147483647 | |||
ismetadatatag | hjtype | varchar | 2147483647 | |||
isobsolete | hjtype | varchar | 2147483647 | |||
isreflexive | hjtype | varchar | 2147483647 | |||
isroot | hjtype | varchar | 2147483647 | |||
issymmetric | hjtype | varchar | 2147483647 | |||
istransitive | hjtype | varchar | 2147483647 | |||
lexicalcategory | hjtype | varchar | 2147483647 | |||
local | hjtype | varchar | 2147483647 | |||
name | hjtype | varchar | 2147483647 | |||
namespace | hjtype | varchar | 2147483647 | |||
obo | hjtype | varchar | 2147483647 | |||
ontology | hjtype | varchar | 2147483647 | |||
propertyvalue | hjtype | varchar | 2147483647 | |||
range | hjtype | varchar | 2147483647 | |||
relation | hjtype | varchar | 2147483647 | |||
relationship | hjtype | varchar | 2147483647 | |||
remark | hjtype | varchar | 2147483647 | |||
replacedby | hjtype | varchar | 2147483647 | |||
savedby | hjtype | varchar | 2147483647 | |||
scope | hjtype | varchar | 2147483647 | |||
source | hjtype | varchar | 2147483647 | |||
sourcefullpath | hjtype | varchar | 2147483647 | |||
sourceid | hjtype | varchar | 2147483647 | |||
sourcemd5 | hjtype | varchar | 2147483647 | |||
sourcemtime | hjtype | varchar | 2147483647 | |||
sourceparsetime | hjtype | varchar | 2147483647 | |||
sourcepath | hjtype | varchar | 2147483647 | |||
sourcetype | hjtype | varchar | 2147483647 | |||
subset | hjtype | varchar | 2147483647 | |||
subsetdef | hjtype | varchar | 2147483647 | |||
synonym | hjtype | varchar | 2147483647 | |||
synonymcategory | hjtype | varchar | 2147483647 | |||
synonymtext | hjtype | varchar | 2147483647 | |||
synonymtypedef | hjtype | varchar | 2147483647 | |||
term | hjtype | varchar | 2147483647 | |||
to_ | hjtype | varchar | 2147483647 | |||
transitiveover | hjtype | varchar | 2147483647 | |||
type | hjtype | varchar | 2147483647 | |||
typedef | hjtype | varchar | 2147483647 | |||
unionof | hjtype | varchar | 2147483647 | |||
xrefanalog | hjtype | varchar | 2147483647 | |||
xrefunknown | hjtype | varchar | 2147483647 | |||
acc | hjversion | int8 | 19 | |||
altid | hjversion | int8 | 19 | |||
autogeneratedby | hjversion | int8 | 19 | |||
comment | hjversion | int8 | 19 | |||
consider | hjversion | int8 | 19 | |||
createdby | hjversion | int8 | 19 | |||
creationdate | hjversion | int8 | 19 | |||
dataversion | hjversion | int8 | 19 | |||
date | hjversion | int8 | 19 | |||
dbname | hjversion | int8 | 19 | |||
dbxref | hjversion | int8 | 19 | |||
def | hjversion | int8 | 19 | |||
defaultnamespace | hjversion | int8 | 19 | |||
defstr | hjversion | int8 | 19 | |||
disjointfrom | hjversion | int8 | 19 | |||
domain | hjversion | int8 | 19 | |||
expandassertionto | hjversion | int8 | 19 | |||
formatversion | hjversion | int8 | 19 | |||
global | hjversion | int8 | 19 | |||
header | hjversion | int8 | 19 | |||
holdsoverchain | hjversion | int8 | 19 | |||
id | hjversion | int8 | 19 | |||
idspace | hjversion | int8 | 19 | |||
intersectionof | hjversion | int8 | 19 | |||
inverseof | hjversion | int8 | 19 | |||
isa | hjversion | int8 | 19 | |||
isanonymous | hjversion | int8 | 19 | |||
isantisymmetric | hjversion | int8 | 19 | |||
isclasslevel | hjversion | int8 | 19 | |||
ismetadatatag | hjversion | int8 | 19 | |||
isobsolete | hjversion | int8 | 19 | |||
isreflexive | hjversion | int8 | 19 | |||
isroot | hjversion | int8 | 19 | |||
issymmetric | hjversion | int8 | 19 | |||
istransitive | hjversion | int8 | 19 | |||
lexicalcategory | hjversion | int8 | 19 | |||
local | hjversion | int8 | 19 | |||
name | hjversion | int8 | 19 | |||
namespace | hjversion | int8 | 19 | |||
obo | hjversion | int8 | 19 | |||
ontology | hjversion | int8 | 19 | |||
propertyvalue | hjversion | int8 | 19 | |||
range | hjversion | int8 | 19 | |||
relation | hjversion | int8 | 19 | |||
relationship | hjversion | int8 | 19 | |||
remark | hjversion | int8 | 19 | |||
replacedby | hjversion | int8 | 19 | |||
savedby | hjversion | int8 | 19 | |||
scope | hjversion | int8 | 19 | |||
source | hjversion | int8 | 19 | |||
sourcefullpath | hjversion | int8 | 19 | |||
sourceid | hjversion | int8 | 19 | |||
sourcemd5 | hjversion | int8 | 19 | |||
sourcemtime | hjversion | int8 | 19 | |||
sourceparsetime | hjversion | int8 | 19 | |||
sourcepath | hjversion | int8 | 19 | |||
sourcetype | hjversion | int8 | 19 | |||
subset | hjversion | int8 | 19 | |||
subsetdef | hjversion | int8 | 19 | |||
synonym | hjversion | int8 | 19 | |||
synonymcategory | hjversion | int8 | 19 | |||
synonymtext | hjversion | int8 | 19 | |||
synonymtypedef | hjversion | int8 | 19 | |||
term | hjversion | int8 | 19 | |||
to_ | hjversion | int8 | 19 | |||
transitiveover | hjversion | int8 | 19 | |||
type | hjversion | int8 | 19 | |||
typedef | hjversion | int8 | 19 | |||
unionof | hjversion | int8 | 19 | |||
xrefanalog | hjversion | int8 | 19 | |||
xrefunknown | hjversion | int8 | 19 | |||
relation | holdsoverchain_relation_hjid | int8 | 19 | √ | null | |
relation | holdsoverchain_relation_hjindex | int4 | 10 | √ | null | |
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_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 | |||
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 | |||
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 | |||
synonym | scope | varchar | 2147483647 | √ | null | |
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 | |||
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_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_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 | |||
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_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 | |||
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 | |||
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_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 |