Column | MySQL Type | Oracle Type | Nullable | Description |
---|---|---|---|---|
WID | BIGINT | NUMBER | No | Warehouse GUID for this BioSubtype |
Type | VARCHAR | VARCHAR2(25) | Yes | Type of subtype, e.g., "serotype" |
Value | VARCHAR | VARCHAR2(50) | No | Value of the subtype, e.g., "O157" |
DataSetWID | BIGINT | NUMBER | No | The dataset this entity came from or is associated with |
Table | Column |
---|---|
BioSourceWIDBioSubtypeWID | BioSubtypeWID |
RelatedTerm | OtherWID |
CitationWIDOtherWID | OtherWID |
CommentTable | OtherWID |
CrossReference | OtherWID |
CrossReference | CrossWID |
Description | OtherWID |
DBID | OtherWID |
SynonymTable | OtherWID |
ToolAdvice | OtherWID |
Name | Columns |
---|---|
BIOSUBTYPE_Type | Type |
BIOSUBTYPE_Value | Value |
BIOSUBTYPE_DATASETWID | DATASETWID |