| 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 |
| Identifier | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Identifiable.identifier An identifier is an unambiguous string that is unique within the scope (i.e. a document, a set of related documents, or a repository) of its use. |
| Name | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Identifiable.name The potentially ambiguous common identifier. |
| ExperimentalFactor | BIGINT | NUMBER | Yes | Represents 1..n association between ExperimentalFactor and FactorValue The pairing of BioAssay FactorValues with the ExperimentDesign ExperimentFactor. |
| ExperimentalFactor2 | BIGINT | NUMBER | Yes | Represents n..1 association between FactorValue and ExperimentalFactor The pairing of BioAssay FactorValues with the ExperimentDesign ExperimentFactor. |
| FactorValue_Measurement | BIGINT | NUMBER | Yes | Represents 1..1 association between FactorValue and Measurement The measured value for this factor. |
| FactorValue_Value | BIGINT | NUMBER | Yes | Represents 1..1 association between FactorValue and OntologyEntry Allows a more complex value to be specified for a FactorValue than a simple Measurement. |
| Table | Column |
|---|---|
| BioAssayWIDFactorValueWID | FactorValueWID |
| Name | Columns |
|---|---|
| FactorValue1 | DataSetWID |
| FactorValue2 | Identifier |
| FactorValue3 | Name |
| FactorValue4 | ExperimentalFactor |
| FactorValue5 | ExperimentalFactor2 |
| FactorValue6 | FactorValue_Measurement |
| FactorValue7 | FactorValue_Value |