| 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. |
| Row_ | SMALLINT | NUMBER | Yes | MAGE attribute Zone.row row position in the ZoneGroup |
| Column_ | SMALLINT | NUMBER | Yes | MAGE attribute Zone.column column position in the ZoneGroup. |
| UpperLeftX | FLOAT | NUMBER | Yes | MAGE attribute Zone.upperLeftX Boundary vertical upper left position relative to (0,0). |
| UpperLeftY | FLOAT | NUMBER | Yes | MAGE attribute Zone.upperLeftY Boundary horizontal upper left position relative to (0,0). |
| LowerRightX | FLOAT | NUMBER | Yes | MAGE attribute Zone.lowerRightX Boundary vertical lower right position relative to (0,0). |
| LowerRightY | FLOAT | NUMBER | Yes | MAGE attribute Zone.lowerRightY Boundary horizontal lower right position relative to (0,0). |
| Zone_DistanceUnit | BIGINT | NUMBER | Yes | Represents 1..1 association between Zone and DistanceUnit Unit for the Zone attributes. |
| ZoneGroup_ZoneLocations | BIGINT | NUMBER | Yes | Represents 1..n association between ZoneGroup and Zone Describes the location of different zones within the array design. |
| Table | Column |
|---|---|
| ZoneDefect | Zone |
| DesignElement | Zone |
| Name | Columns |
|---|---|
| Zone1 | DataSetWID |
| Zone2 | Identifier |
| Zone3 | Name |
| Zone4 | Row_ |
| Zone5 | Column_ |
| Zone6 | UpperLeftX |
| Zone7 | UpperLeftY |
| Zone8 | LowerRightX |
| Zone9 | LowerRightY |
| Zone10 | Zone_DistanceUnit |
| Zone11 | ZoneGroup_ZoneLocations |