| 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. |
| ArrayDesign_FeatureGroups | BIGINT | NUMBER | Yes | Represents 1..n association between ArrayDesign and FeatureGroup The grouping of like Features together. Typically for a physical array design, this will be a single grouping of features whose type might be PCR Product or Oligo. If more than one technology type occurs on the array, such as the mixing of Cloned BioMaterial and Oligos, then there would be multiple FeatureGroups to segregate the technology types. |
| DesignElementGroup_Species | BIGINT | NUMBER | Yes | Represents 1..1 association between DesignElementGroup and OntologyEntry The organism from which the biosequences of this group are from. |
| FeatureWidth | FLOAT | NUMBER | Yes | MAGE attribute FeatureGroup.featureWidth The width of the feature. |
| FeatureLength | FLOAT | NUMBER | Yes | MAGE attribute FeatureGroup.featureLength The length of the feature. |
| FeatureHeight | FLOAT | NUMBER | Yes | MAGE attribute FeatureGroup.featureHeight The height of the feature. |
| FeatureGroup_TechnologyType | BIGINT | NUMBER | Yes | Represents 1..1 association between FeatureGroup and OntologyEntry The technology type of this design. By specifying a technology type, higher level analysis can use appropriate algorithms to compare the results from multiple arrays. The technology type may be spotted cDNA or in situ photolithography. |
| FeatureGroup_FeatureShape | BIGINT | NUMBER | Yes | Represents 1..1 association between FeatureGroup and OntologyEntry The expected shape of the feature on the array: circular, oval, square, etc. |
| FeatureGroup_DistanceUnit | BIGINT | NUMBER | Yes | Represents 1..1 association between FeatureGroup and DistanceUnit The unit for the feature measures. |
| Table | Column |
|---|---|
| DesignElement | FeatureGroup_Features |
| DesignElement | FeatureGroup |
| ArrayDesignWIDReporterGroupWID | ReporterGroupWID |
| ArrayDesignWIDCompositeGrpWID | CompositeGroupWID |
| ComposGrpWIDComposSequenceWID | CompositeGroupWID |
| ReporterGroupWIDReporterWID | ReporterGroupWID |
| Name | Columns |
|---|---|
| DesignElementGroup1 | DataSetWID |
| DesignElementGroup2 | MAGEClass |
| DesignElementGroup3 | Identifier |
| DesignElementGroup4 | Name |
| DesignElementGroup5 | ArrayDesign_FeatureGroups |
| DesignElementGroup6 | DesignElementGroup_Species |
| DesignElementGroup7 | FeatureWidth |
| DesignElementGroup8 | FeatureLength |
| DesignElementGroup9 | FeatureHeight |
| DesignElementGroup10 | FeatureGroup_TechnologyType |
| DesignElementGroup11 | FeatureGroup_FeatureShape |
| DesignElementGroup12 | FeatureGroup_DistanceUnit |