| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| WID | BIGINT | NUMBER | No | Warehouse identifier for this entity |
| DataSetWID | BIGINT | NUMBER | No | Reference to the data set from which the entity came from |
| MAGEClass | VARCHAR | VARCHAR2(100) | No | Discriminator column specifies type of object this row represents |
| Order_ | VARCHAR | VARCHAR2(25) | Yes | MAGE attribute BioDataCube.order The order to expect the dimension. The enumeration uses the first letter of the three dimensions to represent the six possible orderings. |
| BioDataCube_DataInternal | BIGINT | NUMBER | Yes | Represents 1..1 association between BioDataCube and DataInternal Transformed class to associate white spaced delimited data to the BioAssayDataCube |
| BioDataCube_DataExternal | BIGINT | NUMBER | Yes | Represents 1..1 association between BioDataCube and DataExternal Transformed class to associate external data to the BioAssayDataCube |
| Table | Column |
|---|---|
| GeneExpressionData | BioAssayValuesWID |
| BioAssayData | BioAssayData_BioDataValues |
| BioAssayTuple | BioDataTuples_BioAssayTuples |
| Name | Columns |
|---|---|
| BioDataValues1 | DataSetWID |
| BioDataValues2 | MAGEClass |
| BioDataValues3 | Order_ |
| BioDataValues4 | BioDataCube_DataInternal |
| BioDataValues5 | BioDataCube_DataExternal |