Column | MySQL Type | Oracle Type | Nullable | Description |
---|---|---|---|---|
OtherWID | BIGINT | NUMBER | No | Warehouse object we are linking FROM |
CrossWID | BIGINT | NUMBER | Yes | Nonnull when the object we are linking TO resides in the warehouse |
XID | VARCHAR | VARCHAR2(50) | Yes | Unique id used in referenced database of object we are linking TO. |
Type | VARCHAR | VARCHAR2(20) | Yes | Enumeration: Describes the types of identifiers stored in
XID, namely 'GUID' or 'Accession': GUIDs: ID's of type GUID
(Globally Unique ID) are associated with database objects with one
or more invariant aspects, such as a specific DNA sequence. If the
invariant aspect of the database object is to change, a new GUID is
assigned, and the old GUID is retired. Example: NCBI GI numbers.
Accession: Database objects associated with IDs of type 'Accession'
(for Accession Numbers) can change, but the Accession Number remains
the same. Accession Numbers are often associated with a Version
number to reflect such changes. Example: Swiss-Prot's Primary
Accession Number See Enumeration table for further
details. Enumerated Values:
Accession - Type of XID is an accession number (not guaranteed to be unique across datasets) GUID - Type of XID is a global unique identifier (guaranteed to be unique across datasets for a given database provider) |
Version | VARCHAR | VARCHAR2(10) | Yes | Further qualifies the values of identifiers stored in XID by
storing the version number of the identifier for datasets that
support multiple instances of the same object. For example,
NCBI Accession Numbers are associated with a version number,
which are REQUIRED for complete identification (w/o such,
different records can have the same accession number, albeit
with different version numbers) |
Relationship | VARCHAR | VARCHAR2(50) | Yes | A short description of the relationship between the objects identified by OtherWID and CrossWID
|
DatabaseName | VARCHAR | VARCHAR2(255) | Yes | The object we are linking TO resides in an external database of this name |
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 |
CrossWID | Chemical : WID |
CrossWID | Reaction : WID |
CrossWID | Protein : WID |
CrossWID | Feature : WID |
CrossWID | Function : WID |
CrossWID | EnzymaticReaction : WID |
CrossWID | GeneticCode : WID |
CrossWID | Division : WID |
CrossWID | Taxon : WID |
CrossWID | BioSource : WID |
CrossWID | BioSubtype : WID |
CrossWID | NucleicAcid : WID |
CrossWID | Subsequence : WID |
CrossWID | Gene : WID |
CrossWID | Pathway : WID |
CrossWID | Term : WID |
CrossWID | Computation : WID |
CrossWID | Citation : WID |
CrossWID | Contact : WID |
CrossWID | Archive : WID |
CrossWID | Experiment : WID |
CrossWID | ExperimentData : WID |
CrossWID | Support : WID |
Name | Columns |
---|---|
CROSS_OTHERWID | OTHERWID |
CROSS_XID | XID |