| 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 |
| Compound_ComponentCompounds | BIGINT | NUMBER | Yes | Represents 1..n association between Compound and CompoundMeasurement The Compounds and their amounts used to create this Compound. |
| Compound | BIGINT | NUMBER | Yes | Represents n..1 association between CompoundMeasurement and Compound A Compound to be used to create another Compound. |
| Measurement | BIGINT | NUMBER | Yes | Represents 1..1 association between CompoundMeasurement and Measurement The amount of the Compound. |
| Treatment_CompoundMeasurements | BIGINT | NUMBER | Yes | Represents 1..n association between Treatment and CompoundMeasurement The compounds and their amounts used in the treatment. |
| Name | Columns |
|---|---|
| CompoundMeasurement1 | DataSetWID |
| CompoundMeasurement2 | Compound_ComponentCompounds |
| CompoundMeasurement3 | Compound |
| CompoundMeasurement4 | Measurement |
| CompoundMeasurement5 | Treatment_CompoundMeasurements |