| 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. |
| ArrayIdentifier | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Array.arrayIdentifier An identifying string, e.g. a barcode. |
| ArrayXOrigin | FLOAT | NUMBER | Yes | MAGE attribute Array.arrayXOrigin This can indicate the x position on a slide, chip, etc. of the first Feature and is usually specified relative to the fiducial. |
| ArrayYOrigin | FLOAT | NUMBER | Yes | MAGE attribute Array.arrayYOrigin This can indicate the y position on a slide, chip, etc. of the first Feature and is usually specified relative to the fiducial. |
| OriginRelativeTo | VARCHAR | VARCHAR2(255) | Yes | MAGE attribute Array.originRelativeTo What the array origin is relative to, e.g. upper left corner, fiducial, etc. |
| ArrayDesign | BIGINT | NUMBER | Yes | Represents n..1 association between Array and ArrayDesign The association of a physical array with its array design. |
| Information | BIGINT | NUMBER | Yes | Represents n..1 association between Array and ArrayManufacture Association between the manufactured array and the information on that manufacture. |
| ArrayGroup | BIGINT | NUMBER | Yes | Represents n..1 association between Array and ArrayGroup Association between an ArrayGroup and its Arrays, typically the ArrayGroup will represent a slide and the Arrays will be the manufactured so that they may be hybridized separately on that slide. |
| Table | Column |
|---|---|
| ArrayManufactureDeviation | Array_ |
| BioEvent | Array_ |
| ArrayGroupWIDArrayWID | ArrayWID |
| ArrayManufactureWIDArrayWID | ArrayWID |
| Name | Columns |
|---|---|
| Array_1 | DataSetWID |
| Array_2 | Identifier |
| Array_3 | Name |
| Array_4 | ArrayIdentifier |
| Array_5 | ArrayXOrigin |
| Array_6 | ArrayYOrigin |
| Array_7 | OriginRelativeTo |
| Array_8 | ArrayDesign |
| Array_9 | Information |
| Array_10 | ArrayGroup |