SchemaSpy Analysis of godb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Nov 21 10:46 PST 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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