| 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 |
| BioMaterial | BIGINT | NUMBER | Yes | Represents n..1 association between BioMaterialMeasurement and BioMaterial A source BioMaterial for a treatment. |
| Measurement | BIGINT | NUMBER | Yes | Represents 1..1 association between BioMaterialMeasurement and Measurement The amount of the BioMaterial. |
| Treatment | BIGINT | NUMBER | Yes | Represents 1..n association between Treatment and BioMaterialMeasurement The BioMaterials and the amounts used in the treatment |
| BioAssayCreation | BIGINT | NUMBER | Yes | Represents 1..n association between BioAssayCreation and BioMaterialMeasurement The BioSample and its amount used in the BioAssayCreation event. |
| Name | Columns |
|---|---|
| BioMaterialMeasurement1 | DataSetWID |
| BioMaterialMeasurement2 | BioMaterial |
| BioMaterialMeasurement3 | Measurement |
| BioMaterialMeasurement4 | Treatment |
| BioMaterialMeasurement5 | BioAssayCreation |