ODMX [ODMX_DBWrench_Schema.xml]
This table provides update on the system connectivity status
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| HeartbeatID | Integer |
| ||||
| HeartbeatIntervalSeconds | Integer | This tells us the expected interval in seconds between getting a heartbeat from the system | |||||
| LastHeartbeatUTC | BigInt | UTC time of last heartbeat | |||||
| EquipmentID | Integer | The equipmentID that this heartbeat is associated with. Note that not every equipment has a heartbeat - this is only relevant for IOT instruments and dataloggers |
|
||||
| LateThresholdSecondsGracePeriod | Integer | The interval in seconds after the expected heartbeat that we use for the system being Late | |||||
| EquipmentStatusCV | VarChar() |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Heartbeat_CV_EquipmentStatus | ODMXCV.CV_EquipmentStatus | ODMXEquipment.Heartbeat | Term | EquipmentStatusCV |
| fk_Heartbeat_Equipment | ODMXEquipment.Equipment | ODMXEquipment.Heartbeat | EquipmentID | EquipmentID |
(none)
| Diagram Name |
| ODMXEquipment |