| 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. |
| Barcode | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute ArrayGroup.barcode Identifier for the ArrayGroup. |
| ArraySpacingX | FLOAT | NUMBER | Yes | MAGE attribute ArrayGroup.arraySpacingX If there exist more than one array on a slide or a chip, then the spacing between the arrays is useful so that scanning / feature extraction software can crop images representing 1 unique bioassay. |
| ArraySpacingY | FLOAT | NUMBER | Yes | MAGE attribute ArrayGroup.arraySpacingY If there exist more than one array on a slide or a chip, then the spacing between the arrays is useful so that scanning / feature extraction software can crop images representing 1 unique bioassay. |
| NumArrays | SMALLINT | NUMBER | Yes | MAGE attribute ArrayGroup.numArrays This attribute defines the number of arrays on a chip or a slide. |
| OrientationMark | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute ArrayGroup.orientationMark For a human to determine where the top left side of the array is, such as a barcode or frosted side of the glass, etc. |
| OrientationMarkPosition | VARCHAR | VARCHAR2(25) | Yes | MAGE attribute ArrayGroup.orientationMarkPosition One of top, bottom, left or right. |
| Width | FLOAT | NUMBER | Yes | MAGE attribute ArrayGroup.width The width of the platform |
| Length | FLOAT | NUMBER | Yes | MAGE attribute ArrayGroup.length The length of the platform. |
| ArrayGroup_SubstrateType | BIGINT | NUMBER | Yes | Represents 1..1 association between ArrayGroup and OntologyEntry Commonly, arrays will be spotted on 1x3 glass microscope slides but there is nothing that says this must be the case. This association is for scanners to inform them on the possible different formats of slides that can contain arrays. |
| ArrayGroup_DistanceUnit | BIGINT | NUMBER | Yes | Represents 1..1 association between ArrayGroup and DistanceUnit The unit of the measurement attributes. |
| Table | Column |
|---|---|
| Array_ | ArrayGroup |
| Fiducial | ArrayGroup_Fiducials |
| ArrayGroupWIDArrayWID | ArrayGroupWID |
| Name | Columns |
|---|---|
| ArrayGroup1 | DataSetWID |
| ArrayGroup2 | Identifier |
| ArrayGroup3 | Name |
| ArrayGroup4 | Barcode |
| ArrayGroup5 | ArraySpacingX |
| ArrayGroup6 | ArraySpacingY |
| ArrayGroup7 | NumArrays |
| ArrayGroup8 | OrientationMark |
| ArrayGroup9 | OrientationMarkPosition |
| ArrayGroup10 | Width |
| ArrayGroup11 | Length |
| ArrayGroup12 | ArrayGroup_SubstrateType |
| ArrayGroup13 | ArrayGroup_DistanceUnit |