Table Index

Unit


Represents MAGE Class Unit
The unit is a strict enumeration of types.
Includes MAGE Class ConcentrationUnit
Includes MAGE Class DistanceUnit
Includes MAGE Class MassUnit
Includes MAGE Class QuantityUnit
Includes MAGE Class TemperatureUnit
Includes MAGE Class TimeUnit
Includes MAGE Class VolumeUnit

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
MAGEClass VARCHAR VARCHAR2(100) No Discriminator column specifies type of object this row represents
UnitName VARCHAR VARCHAR2(255) Yes MAGE attribute Unit.unitName
The name of the unit.
UnitNameCV VARCHAR VARCHAR2(25) Yes MAGE attribute ConcentrationUnit.unitNameCV
UnitNameCV2 VARCHAR VARCHAR2(25) Yes MAGE attribute DistanceUnit.unitNameCV
UnitNameCV3 VARCHAR VARCHAR2(25) Yes MAGE attribute MassUnit.unitNameCV
UnitNameCV4 VARCHAR VARCHAR2(25) Yes MAGE attribute QuantityUnit.unitNameCV
UnitNameCV5 VARCHAR VARCHAR2(25) Yes MAGE attribute TemperatureUnit.unitNameCV
UnitNameCV6 VARCHAR VARCHAR2(25) Yes MAGE attribute TimeUnit.unitNameCV
UnitNameCV7 VARCHAR VARCHAR2(25) Yes MAGE attribute VolumeUnit.unitNameCV

Referenced By

Table Column
DesignElementGroup FeatureGroup_DistanceUnit
Zone Zone_DistanceUnit
ZoneGroup ZoneGroup_DistanceUnit
ZoneLayout ZoneLayout_DistanceUnit
ArrayGroup ArrayGroup_DistanceUnit
Fiducial Fiducial_DistanceUnit
PositionDelta PositionDelta_DistanceUnit
Position_ Position_DistanceUnit
Measurement Measurement_Unit

Other Constraints

None.

Indexes

Name Columns
Unit1 DataSetWID
Unit2 MAGEClass
Unit3 UnitName
Unit4 UnitNameCV
Unit5 UnitNameCV2
Unit6 UnitNameCV3
Unit7 UnitNameCV4
Unit8 UnitNameCV5
Unit9 UnitNameCV6
Unit10 UnitNameCV7