| 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 |
| Type_ | VARCHAR | VARCHAR2(25) | Yes | MAGE attribute Measurement.type The type of measurement, for instance if the measurement is five feet, it can be either absolute (five feet tall) or change (five feet further along). |
| Value | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Measurement.value The value of the measurement. kindCV (and otherKind) determine with Unit the datatype of value. |
| KindCV | VARCHAR | VARCHAR2(25) | Yes | MAGE attribute Measurement.kindCV One of the enumeration values to determine the controlled vocabulary of the value. |
| OtherKind | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Measurement.otherKind Name of the controlled vocabulary if it isn't one of the Unit subclasses. |
| Measurement_Unit | BIGINT | NUMBER | Yes | Represents 1..1 association between Measurement and Unit The Unit associated with the Measurement. |
| Table | Column |
|---|---|
| FlowCytometrySample | MeasurementWID |
| FactorValue | FactorValue_Measurement |
| BioEvent | Treatment_ActionMeasurement |
| BioMaterialMeasurement | Measurement |
| CompoundMeasurement | Measurement |
| Parameter | Parameter_DefaultValue |
| Name | Columns |
|---|---|
| Measurement1 | DataSetWID |
| Measurement2 | Type_ |
| Measurement3 | Value |
| Measurement4 | KindCV |
| Measurement5 | OtherKind |
| Measurement6 | Measurement_Unit |