| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| TermWID | BIGINT | NUMBER | No | Reference to a term. |
| OtherWID | BIGINT | NUMBER | No | The WID of the object associated with this term. |
| Relationship | VARCHAR | VARCHAR2(50) | Yes | Enumeration. Enumerated Values:
keyword - The term is a keyword that characterizes the object. superclass - The term names a class, and the object is an instance or a subclass of that class. |
| Column | References |
|---|---|
| OtherWID | Chemical : WID |
| OtherWID | Reaction : WID |
| OtherWID | Protein : WID |
| OtherWID | Feature : WID |
| OtherWID | Function : WID |
| OtherWID | EnzymaticReaction : WID |
| OtherWID | GeneticCode : WID |
| OtherWID | Division : WID |
| OtherWID | Taxon : WID |
| OtherWID | BioSource : WID |
| OtherWID | BioSubtype : WID |
| OtherWID | NucleicAcid : WID |
| OtherWID | Subsequence : WID |
| OtherWID | Gene : WID |
| OtherWID | Pathway : WID |
| OtherWID | Term : WID |
| OtherWID | Computation : WID |
| OtherWID | Citation : WID |
| OtherWID | Contact : WID |
| OtherWID | Archive : WID |
| OtherWID | Experiment : WID |
| OtherWID | ExperimentData : WID |
| OtherWID | Support : WID |
| Name | Columns |
|---|---|
| TO_RelatedTerm | TermWID,OtherWID |
| OT_RelatedTerm | OtherWID,TermWID |