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. |
ExperimentDesign | BIGINT | NUMBER | Yes | Represents 1..n association between ExperimentDesign and ExperimentalFactor The description of the factors (TimeCourse, Dosage, etc.) that group the BioAssays. |
ExperimentalFactor_Category | BIGINT | NUMBER | Yes | Represents 1..1 association between ExperimentalFactor and OntologyEntry The category of an ExperimentalFactor could be biological (time, [glucose]) or a methodological factor (differing cDNA preparation protocols). |
Table | Column |
---|---|
FactorValue | ExperimentalFactor |
FactorValue | ExperimentalFactor2 |
Name | Columns |
---|---|
ExperimentalFactor1 | DataSetWID |
ExperimentalFactor2 | Identifier |
ExperimentalFactor3 | Name |
ExperimentalFactor4 | ExperimentDesign |
ExperimentalFactor5 | ExperimentalFactor_Category |