Table Index

ZoneDefect


Represents MAGE Class ZoneDefect
Stores the defect information for a zone.

Columns

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
ArrayManufactureDeviation BIGINT NUMBER Yes Represents 1..n association between ArrayManufactureDeviation and ZoneDefect
Descriptions of how a Zone has been printed differently than specified in the ArrayDesign.
ZoneDefect_DefectType BIGINT NUMBER Yes Represents 1..1 association between ZoneDefect and OntologyEntry
Indicates the type of defect (e.g. a missing zone or a moved zone).
ZoneDefect_PositionDelta BIGINT NUMBER Yes Represents 1..1 association between ZoneDefect and PositionDelta
How the zone deviates in position from the ArrayDesign.
Zone BIGINT NUMBER Yes Represents n..1 association between ZoneDefect and Zone
Reference to the Zone that was misprinted.

Referenced By

None.

Other Constraints

None.

Indexes

Name Columns
ZoneDefect1 DataSetWID
ZoneDefect2 ArrayManufactureDeviation
ZoneDefect3 ZoneDefect_DefectType
ZoneDefect4 ZoneDefect_PositionDelta
ZoneDefect5 Zone