ODMX [ODMX_DBWrench_Schema.xml]
A table which gives the position of equipment relative to its parent equipment or sampling feature
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| EquipmentPositionID | Integer |
| ||||
| EquipmentID | Integer |
|
|||||
| PositionStartDateUTC | BigInt | ||||||
| PositionEndDateUTC | BigInt |
| |||||
| EquipmentZOffset_m | Float |
| The Z Offset of the Equipment. Positive is higher up | ||||
| EquipmentNSOffset_m | Float |
| The NS Offset of the Equipment. Positive is towards the N | ||||
| EquipmentEWOffset_m | Float |
| EW offset. Positive is towards the East | ||||
| EquipmentHeightNote | VarChar() |
| A free form field to annotate details about the equipment Position |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_EquipmentPosition_Equipment | ODMXEquipment.Equipment | ODMXEquipment.EquipmentPosition | EquipmentID | EquipmentID |
(none)
| Diagram Name |
| ODMXEquipment |