| 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 |
|---|---|---|---|---|---|---|---|
| dbxref_content | dbxref_content_hjindex | int4 | 10 | ||||
| def_content | def_content_hjindex | int4 | 10 | ||||
| header_content | header_content_hjindex | int4 | 10 | ||||
| relation | holdsoverchain_relation_hjindex | int4 | 10 | √ | null | ||
| idspace_content | idspace_content_hjindex | int4 | 10 | ||||
| intersectionof_content | intersectionof_content_hjindex | int4 | 10 | ||||
| obo_content | obo_content_hjindex | int4 | 10 | ||||
| relationship_content | relationship_content_hjindex | int4 | 10 | ||||
| source_content | source_content_hjindex | int4 | 10 | ||||
| subsetdef_content | subsetdef_content_hjindex | int4 | 10 | ||||
| synonym_content | synonym_content_hjindex | int4 | 10 | ||||
| synonymcategory_content | synonymcategory_content_hjindex | int4 | 10 | ||||
| synonymtypedef_content | synonymtypedef_content_hjindex | int4 | 10 | ||||
| term_content | term_content_hjindex | int4 | 10 | ||||
| typedef_content | typedef_content_hjindex | int4 | 10 | ||||
| xrefanalog_content | xrefanalog_content_hjindex | int4 | 10 | ||||
| xrefunknown_content | xrefunknown_content_hjindex | int4 | 10 | ||||
| dbxref_content | dbxref_content_hjchildid | int8 | 19 | √ | null | ||
| dbxref_content | dbxref_content_hjid | int8 | 19 | ||||
| def_content | def_content_hjchildid | int8 | 19 | √ | null | ||
| def_content | def_content_hjid | int8 | 19 | ||||
| header_content | header_content_hjchildid | int8 | 19 | √ | null | ||
| header_content | header_content_hjid | int8 | 19 | ||||
| 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 | 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 | ||
| idspace_content | idspace_content_hjchildid | int8 | 19 | √ | null | ||
| idspace_content | idspace_content_hjid | int8 | 19 | ||||
| intersectionof_content | intersectionof_content_hjchildid | int8 | 19 | √ | null | ||
| intersectionof_content | intersectionof_content_hjid | int8 | 19 | ||||
| obo_content | obo_content_hjchildid | int8 | 19 | √ | null | ||
| obo_content | obo_content_hjid | int8 | 19 | ||||
| relationship_content | relationship_content_hjchildid | int8 | 19 | √ | null | ||
| relationship_content | relationship_content_hjid | int8 | 19 | ||||
| source_content | source_content_hjchildid | int8 | 19 | √ | null | ||
| source_content | source_content_hjid | int8 | 19 | ||||
| subsetdef_content | subsetdef_content_hjchildid | int8 | 19 | √ | null | ||
| subsetdef_content | subsetdef_content_hjid | int8 | 19 | ||||
| synonym_content | synonym_content_hjchildid | int8 | 19 | √ | null | ||
| synonym_content | synonym_content_hjid | int8 | 19 | ||||
| synonymcategory_content | synonymcategory_content_hjchildid | int8 | 19 | √ | null | ||
| synonymcategory_content | synonymcategory_content_hjid | int8 | 19 | ||||
| synonymtypedef_content | synonymtypedef_content_hjchildid | int8 | 19 | √ | null | ||
| synonymtypedef_content | synonymtypedef_content_hjid | int8 | 19 | ||||
| term_content | term_content_hjchildid | int8 | 19 | √ | null | ||
| term_content | term_content_hjid | int8 | 19 | ||||
| typedef_content | typedef_content_hjchildid | int8 | 19 | √ | null | ||
| typedef_content | typedef_content_hjid | int8 | 19 | ||||
| xrefanalog_content | xrefanalog_content_hjchildid | int8 | 19 | √ | null | ||
| xrefanalog_content | xrefanalog_content_hjid | int8 | 19 | ||||
| xrefunknown_content | xrefunknown_content_hjchildid | int8 | 19 | √ | null | ||
| xrefunknown_content | xrefunknown_content_hjid | int8 | 19 | ||||
| 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_hjclass | varchar | 2147483647 | √ | null | ||
| def_content | def_content_hjclass | varchar | 2147483647 | √ | null | ||
| header_content | header_content_hjclass | varchar | 2147483647 | √ | null | ||
| 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 | ||||
| idspace_content | idspace_content_hjclass | varchar | 2147483647 | √ | null | ||
| intersectionof_content | intersectionof_content_hjclass | varchar | 2147483647 | √ | null | ||
| obo_content | obo_content_hjclass | varchar | 2147483647 | √ | null | ||
| relationship_content | relationship_content_hjclass | varchar | 2147483647 | √ | null | ||
| synonym | scope | varchar | 2147483647 | √ | null | ||
| source_content | source_content_hjclass | varchar | 2147483647 | √ | null | ||
| subsetdef_content | subsetdef_content_hjclass | varchar | 2147483647 | √ | null | ||
| synonym_content | synonym_content_hjclass | varchar | 2147483647 | √ | null | ||
| synonymcategory_content | synonymcategory_content_hjclass | varchar | 2147483647 | √ | null | ||
| synonymtypedef_content | synonymtypedef_content_hjclass | varchar | 2147483647 | √ | null | ||
| term_content | term_content_hjclass | varchar | 2147483647 | √ | null | ||
| typedef_content | typedef_content_hjclass | varchar | 2147483647 | √ | null | ||
| xrefanalog_content | xrefanalog_content_hjclass | varchar | 2147483647 | √ | null | ||
| xrefunknown_content | xrefunknown_content_hjclass | varchar | 2147483647 | √ | null |