| 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 |