| 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 |
| MAGEClass | VARCHAR | VARCHAR2(100) | No | Discriminator column specifies type of object this row represents |
| 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. |
| DerivedBioAssay_Type | BIGINT | NUMBER | Yes | Represents 1..1 association between DerivedBioAssay and OntologyEntry The derivation type, for instance collapsed spot replicate, ratio, averaged intensity, bioassay replicates, etc. |
| FeatureExtraction | BIGINT | NUMBER | Yes | Represents 1..1 association between MeasuredBioAssay and FeatureExtraction The association between the MeasuredBioAssay and the FeatureExtraction Event. |
| BioAssayCreation | BIGINT | NUMBER | Yes | Represents 1..1 association between PhysicalBioAssay and BioAssayCreation The association between the BioAssayCreation event (typically Hybridization) and the PhysicalBioAssay and its annotation of this event. |
| Table | Column |
|---|---|
| BioEvent | BioAssayMapTarget |
| BioEvent | PhysicalBioAssayTarget |
| BioEvent | PhysicalBioAssay |
| BioEvent | Target |
| BioEvent | PhysicalBioAssaySource |
| BioEvent | MeasuredBioAssayTarget |
| BioEvent | PhysicalBioAssay2 |
| BioAssayTuple | BioAssay |
| Image | PhysicalBioAssay |
| ExperimentWIDBioAssayWID | BioAssayWID |
| ExperimentDesignWIDBioAssayWID | BioAssayWID |
| BioAssayDimensioWIDBioAssayWID | BioAssayWID |
| BioAssayMapWIDBioAssayWID | BioAssayWID |
| BioAssayWIDChannelWID | BioAssayWID |
| BioAssayWIDFactorValueWID | BioAssayWID |
| DerivBioAWIDDerivBioADataWID | DerivedBioAssayWID |
| DerivBioAssayWIDBioAssayMapWID | DerivedBioAssayWID |
| MeasBAssayWIDMeasBAssayDataWID | MeasuredBioAssayWID |
| Name | Columns |
|---|---|
| BioAssay1 | DataSetWID |
| BioAssay2 | MAGEClass |
| BioAssay3 | Identifier |
| BioAssay4 | Name |
| BioAssay5 | DerivedBioAssay_Type |
| BioAssay6 | FeatureExtraction |
| BioAssay7 | BioAssayCreation |