| 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 |
| Experiment_ExperimentDesigns | BIGINT | NUMBER | Yes | Represents 1..n association between Experiment and ExperimentDesign The association to the description and annotation of the Experiment, along with the grouping of the top-level BioAssays. |
| QualityControlDescription | BIGINT | NUMBER | Yes | Represents 1..1 association between ExperimentDesign and Description Description of the quality control aspects of the Experiment. |
| NormalizationDescription | BIGINT | NUMBER | Yes | Represents 1..1 association between ExperimentDesign and Description Description of the normalization strategy of the Experiment. |
| ReplicateDescription | BIGINT | NUMBER | Yes | Represents 1..1 association between ExperimentDesign and Description Description of the replicate strategy of the Experiment. |
| Table | Column |
|---|---|
| ExperimentalFactor | ExperimentDesign |
| ExperimentDesignWIDBioAssayWID | ExperimentDesignWID |
| Name | Columns |
|---|---|
| ExperimentDesign1 | DataSetWID |
| ExperimentDesign2 | Experiment_ExperimentDesigns |
| ExperimentDesign3 | QualityControlDescription |
| ExperimentDesign4 | NormalizationDescription |
| ExperimentDesign5 | ReplicateDescription |