Table Index

ExperimentDesign


Represents MAGE Class ExperimentDesign
The ExperimentDesign is the description and collection of ExperimentalFactors and the hierarchy of BioAssays to which they pertain.

Columns

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.

Referenced By

Table Column
ExperimentalFactor ExperimentDesign
ExperimentDesignWIDBioAssayWID ExperimentDesignWID

Other Constraints

None.

Indexes

Name Columns
ExperimentDesign1 DataSetWID
ExperimentDesign2 Experiment_ExperimentDesigns
ExperimentDesign3 QualityControlDescription
ExperimentDesign4 NormalizationDescription
ExperimentDesign5 ReplicateDescription