| SchemaSpy Analysis of godb.public - Columns | Back to documentation XMLPipeDB |
| Generated by SchemaSpy on Mon Apr 20 11:20 PDT 2009 |
| ||||||
|
| |||||||
godb.public contains 293 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| acc | content | varchar | 0 | √ | null | ||||||
| acc | hjid | int8 | 8 | ||||||||
| acc | hjtype | varchar | 0 | ||||||||
| acc | hjversion | int8 | 8 | ||||||||
| altid | content | varchar | 0 | √ | null | ||||||
| altid | hjid | int8 | 8 | ||||||||
| altid | hjtype | varchar | 0 | ||||||||
| altid | hjversion | int8 | 8 | ||||||||
| autogeneratedby | content | varchar | 0 | √ | null | ||||||
| autogeneratedby | hjid | int8 | 8 | ||||||||
| autogeneratedby | hjtype | varchar | 0 | ||||||||
| autogeneratedby | hjversion | int8 | 8 | ||||||||
| comment | content | varchar | 0 | √ | null | ||||||
| comment | hjid | int8 | 8 | ||||||||
| comment | hjtype | varchar | 0 | ||||||||
| comment | hjversion | int8 | 8 | ||||||||
| consider | content | varchar | 0 | √ | null | ||||||
| consider | hjid | int8 | 8 | ||||||||
| consider | hjtype | varchar | 0 | ||||||||
| consider | hjversion | int8 | 8 | ||||||||
| date | content | varchar | 0 | √ | null | ||||||
| date | hjid | int8 | 8 | ||||||||
| date | hjtype | varchar | 0 | ||||||||
| date | hjversion | int8 | 8 | ||||||||
| dbname | content | varchar | 0 | √ | null | ||||||
| dbname | hjid | int8 | 8 | ||||||||
| dbname | hjtype | varchar | 0 | ||||||||
| dbname | hjversion | int8 | 8 | ||||||||
| dbxref | hjid | int8 | 8 |
|
|||||||
| dbxref | hjtype | varchar | 0 | ||||||||
| dbxref | hjversion | int8 | 8 | ||||||||
| dbxref_content | dbxref_content_hjchildid | int8 | 8 | √ | null | ||||||
| dbxref_content | dbxref_content_hjclass | varchar | 0 | √ | null | ||||||
| dbxref_content | dbxref_content_hjid | int8 | 8 |
|
|||||||
| dbxref_content | dbxref_content_hjindex | int4 | 4 | ||||||||
| def | hjid | int8 | 8 |
|
|||||||
| def | hjtype | varchar | 0 | ||||||||
| def | hjversion | int8 | 8 | ||||||||
| def_content | def_content_hjchildid | int8 | 8 | √ | null | ||||||
| def_content | def_content_hjclass | varchar | 0 | √ | null | ||||||
| def_content | def_content_hjid | int8 | 8 |
|
|||||||
| def_content | def_content_hjindex | int4 | 4 | ||||||||
| defaultnamespace | content | varchar | 0 | √ | null | ||||||
| defaultnamespace | hjid | int8 | 8 | ||||||||
| defaultnamespace | hjtype | varchar | 0 | ||||||||
| defaultnamespace | hjversion | int8 | 8 | ||||||||
| defstr | content | varchar | 0 | √ | null | ||||||
| defstr | hjid | int8 | 8 | ||||||||
| defstr | hjtype | varchar | 0 | ||||||||
| defstr | hjversion | int8 | 8 | ||||||||
| disjointfrom | content | varchar | 0 | √ | null | ||||||
| disjointfrom | hjid | int8 | 8 | ||||||||
| disjointfrom | hjtype | varchar | 0 | ||||||||
| disjointfrom | hjversion | int8 | 8 | ||||||||
| domain | content | varchar | 0 | √ | null | ||||||
| domain | hjid | int8 | 8 | ||||||||
| domain | hjtype | varchar | 0 | ||||||||
| domain | hjversion | int8 | 8 | ||||||||
| formatversion | content | varchar | 0 | √ | null | ||||||
| formatversion | hjid | int8 | 8 | ||||||||
| formatversion | hjtype | varchar | 0 | ||||||||
| formatversion | hjversion | int8 | 8 | ||||||||
| global | content | varchar | 0 | √ | null | ||||||
| global | hjid | int8 | 8 | ||||||||
| global | hjtype | varchar | 0 | ||||||||
| global | hjversion | int8 | 8 | ||||||||
| header | hjid | int8 | 8 |
|
|||||||
| header | hjtype | varchar | 0 | ||||||||
| header | hjversion | int8 | 8 | ||||||||
| header_content | header_content_hjchildid | int8 | 8 | √ | null | ||||||
| header_content | header_content_hjclass | varchar | 0 | √ | null | ||||||
| header_content | header_content_hjid | int8 | 8 |
|
|||||||
| header_content | header_content_hjindex | int4 | 4 | ||||||||
| id | content | varchar | 0 | √ | null | ||||||
| id | hjid | int8 | 8 | ||||||||
| id | hjtype | varchar | 0 | ||||||||
| id | hjversion | int8 | 8 | ||||||||
| idspace | hjid | int8 | 8 |
|
|||||||
| idspace | hjtype | varchar | 0 | ||||||||
| idspace | hjversion | int8 | 8 | ||||||||
| idspace_content | idspace_content_hjchildid | int8 | 8 | √ | null | ||||||
| idspace_content | idspace_content_hjclass | varchar | 0 | √ | null | ||||||
| idspace_content | idspace_content_hjid | int8 | 8 |
|
|||||||
| idspace_content | idspace_content_hjindex | int4 | 4 | ||||||||
| intersectionof | hjid | int8 | 8 |
|
|||||||
| intersectionof | hjtype | varchar | 0 | ||||||||
| intersectionof | hjversion | int8 | 8 | ||||||||
| intersectionof_content | intersectionof_content_hjchildid | int8 | 8 | √ | null | ||||||
| intersectionof_content | intersectionof_content_hjclass | varchar | 0 | √ | null | ||||||
| intersectionof_content | intersectionof_content_hjid | int8 | 8 |
|
|||||||
| intersectionof_content | intersectionof_content_hjindex | int4 | 4 | ||||||||
| inverseof | content | varchar | 0 | √ | null | ||||||
| inverseof | hjid | int8 | 8 | ||||||||
| inverseof | hjtype | varchar | 0 | ||||||||
| inverseof | hjversion | int8 | 8 | ||||||||
| isa | content | varchar | 0 | √ | null | ||||||
| isa | hjid | int8 | 8 | ||||||||
| isa | hjtype | varchar | 0 | ||||||||
| isa | hjversion | int8 | 8 | ||||||||
| isanonymous | content | varchar | 0 | √ | null | ||||||
| isanonymous | hjid | int8 | 8 | ||||||||
| isanonymous | hjtype | varchar | 0 | ||||||||
| isanonymous | hjversion | int8 | 8 | ||||||||
| isantisymmetric | content | varchar | 0 | √ | null | ||||||
| isantisymmetric | hjid | int8 | 8 | ||||||||
| isantisymmetric | hjtype | varchar | 0 | ||||||||
| isantisymmetric | hjversion | int8 | 8 | ||||||||
| isobsolete | content | varchar | 0 | √ | null | ||||||
| isobsolete | hjid | int8 | 8 | ||||||||
| isobsolete | hjtype | varchar | 0 | ||||||||
| isobsolete | hjversion | int8 | 8 | ||||||||
| isreflexive | content | varchar | 0 | √ | null | ||||||
| isreflexive | hjid | int8 | 8 | ||||||||
| isreflexive | hjtype | varchar | 0 | ||||||||
| isreflexive | hjversion | int8 | 8 | ||||||||
| isroot | content | varchar | 0 | √ | null | ||||||
| isroot | hjid | int8 | 8 | ||||||||
| isroot | hjtype | varchar | 0 | ||||||||
| isroot | hjversion | int8 | 8 | ||||||||
| issymmetric | content | varchar | 0 | √ | null | ||||||
| issymmetric | hjid | int8 | 8 | ||||||||
| issymmetric | hjtype | varchar | 0 | ||||||||
| issymmetric | hjversion | int8 | 8 | ||||||||
| istransitive | content | varchar | 0 | √ | null | ||||||
| istransitive | hjid | int8 | 8 | ||||||||
| istransitive | hjtype | varchar | 0 | ||||||||
| istransitive | hjversion | int8 | 8 | ||||||||
| lexicalcategory | content | varchar | 0 | √ | null | ||||||
| lexicalcategory | hjid | int8 | 8 | ||||||||
| lexicalcategory | hjtype | varchar | 0 | ||||||||
| lexicalcategory | hjversion | int8 | 8 | ||||||||
| local | content | varchar | 0 | √ | null | ||||||
| local | hjid | int8 | 8 | ||||||||
| local | hjtype | varchar | 0 | ||||||||
| local | hjversion | int8 | 8 | ||||||||
| name | content | varchar | 0 | √ | null | ||||||
| name | hjid | int8 | 8 | ||||||||
| name | hjtype | varchar | 0 | ||||||||
| name | hjversion | int8 | 8 | ||||||||
| namespace | content | varchar | 0 | √ | null | ||||||
| namespace | hjid | int8 | 8 | ||||||||
| namespace | hjtype | varchar | 0 | ||||||||
| namespace | hjversion | int8 | 8 | ||||||||
| obo | hjid | int8 | 8 |
|
|||||||
| obo | hjtype | varchar | 0 | ||||||||
| obo | hjversion | int8 | 8 | ||||||||
| obo_content | obo_content_hjchildid | int8 | 8 | √ | null | ||||||
| obo_content | obo_content_hjclass | varchar | 0 | √ | null | ||||||
| obo_content | obo_content_hjid | int8 | 8 |
|
|||||||
| obo_content | obo_content_hjindex | int4 | 4 | ||||||||
| range | content | varchar | 0 | √ | null | ||||||
| range | hjid | int8 | 8 | ||||||||
| range | hjtype | varchar | 0 | ||||||||
| range | hjversion | int8 | 8 | ||||||||
| relationship | hjid | int8 | 8 |
|
|||||||
| relationship | hjtype | varchar | 0 | ||||||||
| relationship | hjversion | int8 | 8 | ||||||||
| relationship_content | relationship_content_hjchildid | int8 | 8 | √ | null | ||||||
| relationship_content | relationship_content_hjclass | varchar | 0 | √ | null | ||||||
| relationship_content | relationship_content_hjid | int8 | 8 |
|
|||||||
| relationship_content | relationship_content_hjindex | int4 | 4 | ||||||||
| remark | content | varchar | 0 | √ | null | ||||||
| remark | hjid | int8 | 8 | ||||||||
| remark | hjtype | varchar | 0 | ||||||||
| remark | hjversion | int8 | 8 | ||||||||
| replacedby | content | varchar | 0 | √ | null | ||||||
| replacedby | hjid | int8 | 8 | ||||||||
| replacedby | hjtype | varchar | 0 | ||||||||
| replacedby | hjversion | int8 | 8 | ||||||||
| savedby | content | varchar | 0 | √ | null | ||||||
| savedby | hjid | int8 | 8 | ||||||||
| savedby | hjtype | varchar | 0 | ||||||||
| savedby | hjversion | int8 | 8 | ||||||||
| scope | content | varchar | 0 | √ | null | ||||||
| scope | hjid | int8 | 8 | ||||||||
| scope | hjtype | varchar | 0 | ||||||||
| scope | hjversion | int8 | 8 | ||||||||
| source | hjid | int8 | 8 |
|
|||||||
| source | hjtype | varchar | 0 | ||||||||
| source | hjversion | int8 | 8 | ||||||||
| source_content | source_content_hjchildid | int8 | 8 | √ | null | ||||||
| source_content | source_content_hjclass | varchar | 0 | √ | null | ||||||
| source_content | source_content_hjid | int8 | 8 |
|
|||||||
| source_content | source_content_hjindex | int4 | 4 | ||||||||
| sourcefullpath | content | varchar | 0 | √ | null | ||||||
| sourcefullpath | hjid | int8 | 8 | ||||||||
| sourcefullpath | hjtype | varchar | 0 | ||||||||
| sourcefullpath | hjversion | int8 | 8 | ||||||||
| sourceid | content | varchar | 0 | √ | null | ||||||
| sourceid | hjid | int8 | 8 | ||||||||
| sourceid | hjtype | varchar | 0 | ||||||||
| sourceid | hjversion | int8 | 8 | ||||||||
| sourcemd5 | content | varchar | 0 | √ | null | ||||||
| sourcemd5 | hjid | int8 | 8 | ||||||||
| sourcemd5 | hjtype | varchar | 0 | ||||||||
| sourcemd5 | hjversion | int8 | 8 | ||||||||
| sourcemtime | content | varchar | 0 | √ | null | ||||||
| sourcemtime | hjid | int8 | 8 | ||||||||
| sourcemtime | hjtype | varchar | 0 | ||||||||
| sourcemtime | hjversion | int8 | 8 | ||||||||
| sourceparsetime | content | varchar | 0 | √ | null | ||||||
| sourceparsetime | hjid | int8 | 8 | ||||||||
| sourceparsetime | hjtype | varchar | 0 | ||||||||
| sourceparsetime | hjversion | int8 | 8 | ||||||||
| sourcepath | content | varchar | 0 | √ | null | ||||||
| sourcepath | hjid | int8 | 8 | ||||||||
| sourcepath | hjtype | varchar | 0 | ||||||||
| sourcepath | hjversion | int8 | 8 | ||||||||
| sourcetype | content | varchar | 0 | √ | null | ||||||
| sourcetype | hjid | int8 | 8 | ||||||||
| sourcetype | hjtype | varchar | 0 | ||||||||
| sourcetype | hjversion | int8 | 8 | ||||||||
| subset | content | varchar | 0 | √ | null | ||||||
| subset | hjid | int8 | 8 | ||||||||
| subset | hjtype | varchar | 0 | ||||||||
| subset | hjversion | int8 | 8 | ||||||||
| subsetdef | hjid | int8 | 8 |
|
|||||||
| subsetdef | hjtype | varchar | 0 | ||||||||
| subsetdef | hjversion | int8 | 8 | ||||||||
| subsetdef_content | subsetdef_content_hjchildid | int8 | 8 | √ | null | ||||||
| subsetdef_content | subsetdef_content_hjclass | varchar | 0 | √ | null | ||||||
| subsetdef_content | subsetdef_content_hjid | int8 | 8 |
|
|||||||
| subsetdef_content | subsetdef_content_hjindex | int4 | 4 | ||||||||
| synonym | hjid | int8 | 8 |
|
|||||||
| synonym | hjtype | varchar | 0 | ||||||||
| synonym | hjversion | int8 | 8 | ||||||||
| synonym | scope | varchar | 0 | √ | null | ||||||
| synonym_content | synonym_content_hjchildid | int8 | 8 | √ | null | ||||||
| synonym_content | synonym_content_hjclass | varchar | 0 | √ | null | ||||||
| synonym_content | synonym_content_hjid | int8 | 8 |
|
|||||||
| synonym_content | synonym_content_hjindex | int4 | 4 | ||||||||
| synonymcategory | hjid | int8 | 8 |
|
|||||||
| synonymcategory | hjtype | varchar | 0 | ||||||||
| synonymcategory | hjversion | int8 | 8 | ||||||||
| synonymcategory_content | synonymcategory_content_hjchildid | int8 | 8 | √ | null | ||||||
| synonymcategory_content | synonymcategory_content_hjclass | varchar | 0 | √ | null | ||||||
| synonymcategory_content | synonymcategory_content_hjid | int8 | 8 |
|
|||||||
| synonymcategory_content | synonymcategory_content_hjindex | int4 | 4 | ||||||||
| synonymtext | content | varchar | 0 | √ | null | ||||||
| synonymtext | hjid | int8 | 8 | ||||||||
| synonymtext | hjtype | varchar | 0 | ||||||||
| synonymtext | hjversion | int8 | 8 | ||||||||
| synonymtypedef | hjid | int8 | 8 |
|
|||||||
| synonymtypedef | hjtype | varchar | 0 | ||||||||
| synonymtypedef | hjversion | int8 | 8 | ||||||||
| synonymtypedef_content | synonymtypedef_content_hjchildid | int8 | 8 | √ | null | ||||||
| synonymtypedef_content | synonymtypedef_content_hjclass | varchar | 0 | √ | null | ||||||
| synonymtypedef_content | synonymtypedef_content_hjid | int8 | 8 |
|
|||||||
| synonymtypedef_content | synonymtypedef_content_hjindex | int4 | 4 | ||||||||
| term | hjid | int8 | 8 |
|
|||||||
| term | hjtype | varchar | 0 | ||||||||
| term | hjversion | int8 | 8 | ||||||||
| term_content | term_content_hjchildid | int8 | 8 | √ | null | ||||||
| term_content | term_content_hjclass | varchar | 0 | √ | null | ||||||
| term_content | term_content_hjid | int8 | 8 |
|
|||||||
| term_content | term_content_hjindex | int4 | 4 | ||||||||
| to_ | content | varchar | 0 | √ | null | ||||||
| to_ | hjid | int8 | 8 | ||||||||
| to_ | hjtype | varchar | 0 | ||||||||
| to_ | hjversion | int8 | 8 | ||||||||
| transitiveover | content | varchar | 0 | √ | null | ||||||
| transitiveover | hjid | int8 | 8 | ||||||||
| transitiveover | hjtype | varchar | 0 | ||||||||
| transitiveover | hjversion | int8 | 8 | ||||||||
| type | content | varchar | 0 | √ | null | ||||||
| type | hjid | int8 | 8 | ||||||||
| type | hjtype | varchar | 0 | ||||||||
| type | hjversion | int8 | 8 | ||||||||
| typedef | hjid | int8 | 8 |
|
|||||||
| typedef | hjtype | varchar | 0 | ||||||||
| typedef | hjversion | int8 | 8 | ||||||||
| typedef_content | typedef_content_hjchildid | int8 | 8 | √ | null | ||||||
| typedef_content | typedef_content_hjclass | varchar | 0 | √ | null | ||||||
| typedef_content | typedef_content_hjid | int8 | 8 |
|
|||||||
| typedef_content | typedef_content_hjindex | int4 | 4 | ||||||||
| unionof | content | varchar | 0 | √ | null | ||||||
| unionof | hjid | int8 | 8 | ||||||||
| unionof | hjtype | varchar | 0 | ||||||||
| unionof | hjversion | int8 | 8 | ||||||||
| xrefanalog | hjid | int8 | 8 |
|
|||||||
| xrefanalog | hjtype | varchar | 0 | ||||||||
| xrefanalog | hjversion | int8 | 8 | ||||||||
| xrefanalog_content | xrefanalog_content_hjchildid | int8 | 8 | √ | null | ||||||
| xrefanalog_content | xrefanalog_content_hjclass | varchar | 0 | √ | null | ||||||
| xrefanalog_content | xrefanalog_content_hjid | int8 | 8 |
|
|||||||
| xrefanalog_content | xrefanalog_content_hjindex | int4 | 4 | ||||||||
| xrefunknown | hjid | int8 | 8 |
|
|||||||
| xrefunknown | hjtype | varchar | 0 | ||||||||
| xrefunknown | hjversion | int8 | 8 | ||||||||
| xrefunknown_content | xrefunknown_content_hjchildid | int8 | 8 | √ | null | ||||||
| xrefunknown_content | xrefunknown_content_hjclass | varchar | 0 | √ | null | ||||||
| xrefunknown_content | xrefunknown_content_hjid | int8 | 8 |
|
|||||||
| xrefunknown_content | xrefunknown_content_hjindex | int4 | 4 |