| Both sides previous revision Previous revision Next revision | Previous revision |
| tables_fields:other_tables:coldchain [2023/01/31 03:30] – Adam Dewey | tables_fields:other_tables:coldchain [2023/02/01 02:55] (current) – Adam Dewey |
|---|
| |
| ====== Sensor ====== | ====== Sensor ====== |
| | |
| | <WRAP center round alert 100%> |
| | Central data</WRAP> |
| |
| ^ Field name ^ Description ^ Type ^ Indexed ^ | ^ Field name ^ Description ^ Type ^ Indexed ^ |
| | macAddress | The mac address of the sensor | Text | | | | macAddress | The mac address of the sensor | Text | | |
| | batteryLevel | The most recent battery % reading of the sensor | Real | | | | batteryLevel | The most recent battery % reading of the sensor | Real | | |
| | temperature | | Real | | | | temperature | The most recent temperature reading of the sensor | Real | | |
| | lastConnectionDate | | Date | | | | lastConnectionDate | | Date | | |
| | lasstConnectionTime | | Time | | | | lastConnectionTime | | Time | | |
| | **storeID** | The ID of the store to which this sensor belongs | Alpha | * | | | **storeID** | The ID of the store to which this sensor belongs | Alpha | * | |
| | logInterval | The interval between taking temperature readings (in seconds) | Long | | | | logInterval | The interval between taking temperature readings (in seconds) | Long | | |
| | numberOfLogs | | Long | | | | numberOfLogs | | Long | | |
| | is_active | Whether the sensor is marked as active or not | Boolean | | | | is_active | Whether the sensor is marked as active or not | Boolean | | |
| | log_delay_time | | Time | | | | log_delay_time | The date that the user selected to start recording temperature logs | Time | | |
| | log_delay_date | | Date | | | | log_delay_date | The time that the user selected to start recording temperature logs | Date | | |
| | programmed_date | | Date | | | | programmed_date | | Date | | |
| | programmed_time | | Time | | | | programmed_time | | Time | | |
| | acknowledged | Whether the breach has been marked as 'acknowledged' by the user | Boolean | | | | acknowledged | Whether the breach has been marked as 'acknowledged' by the user | Boolean | | |
| | sensor_ID | The ID of the sensor that reported this breach | Alpha | | | | sensor_ID | The ID of the sensor that reported this breach | Alpha | | |
| | threshold_maximum_temperature | The upper bound temperature for the range of temperatures the breach is defined for. For example, if a breach is defined for all temperatures over 8 degrees, the maximum will be infinity. | Real| | | | threshold_maximum_temperature | The upper bound temperature for the breach configuration | Real| | |
| | threshold_minimum_temperature | The lower bound temperature for the range of temperatures the breach is defined for. For example, if a breach is defined for all temperatures over 8 degrees, the minimum will be 8. | Real | | | | threshold_minimum_temperature | The lower bound temperature for the breach configuration | Real | | |
| | threshold_duration | The duration a temperature must have been within the thresholds for it to be considered a breach. (milliseconds) | Int | | | | threshold_duration | The duration threshold for the breach configuration | Int | | |
| | type | The type of breach - Hot, Cold, Consecutive or Cumulative | Alpha | | | | type | The type of breach - Hot / Cold, Consecutive or Cumulative | Alpha | | |
| |
| |
| |
| ^ Field name ^ Description ^ Type ^ Indexed ^ | ^ Field name ^ Description ^ Type ^ Indexed ^ |
| | **ID** | | Alpha | * | | | **ID** | The unique identifying number assigned to this breach configuration | Alpha | * | |
| | maximum_temperature | | Real | | | | maximum_temperature | The upper bound temperature for the range of temperatures the breach is defined for. For example, if a breach is defined for all temperatures over 8 degrees, the maximum will be infinity. | Real | | |
| | minimum_temperature | | Real | | | | minimum_temperature | The lower bound temperature for the range of temperatures the breach is defined for. For example, if a breach is defined for all temperatures over 8 degrees, the minimum will be 8. | Real | | |
| | duration | | Long | | | | duration | The duration a temperature must have been within the thresholds for it to be considered a breach. (milliseconds) | Long | | |
| | colour | | Alpha | | | | colour | Contains hexidecimal codes for colours. Use case: Displaying a line on a graph in a certain colour - red for a 'hot breach', blue for a 'cold breach' | Alpha | | |
| | description | | Alpha | | | | description | Description of the breach configuration, e.g. 'Hot breach' | Alpha | | |
| | is_active | | Boolean | | | | is_active | Whether the breach is currently ongoing or not | Boolean | | |
| | location_type_ID | | Alpha | | | | location_type_ID | | Alpha | | |
| | store_ID | | Alpha | | | | store_ID | | Alpha | | |
| | type | | Alpha | | | | type | The type of breach - Hot / Cold, Consecutive or Cumulative | Alpha | | |
| | | location_ID | | Alpha | | |
| |
| |
| |
| ^ Field name ^ Description ^ Type ^ Indexed ^ | ^ Field name ^ Description ^ Type ^ Indexed ^ |
| | **ID** | | Alpha | * | | | **ID** | The unique identifying number assigned to this temperature log | Alpha | * | |
| | temperature | | Real | | | | temperature | The temperature of the log (in Celsius) | Real | | |
| | date | | Date | | | | date | The date of the log | Date | | |
| | time | | Time | | | | time | The time of the log | Time | | |
| | location_ID | | Alpha | | | | location_ID | The location of the sensor at the time of the log | Alpha | | |
| | temperature_breach_ID | | Alpha | | | | temperature_breach_ID | Indicates that this temperature log is contributing to a temperature_breach, which can span many temperature logs | Alpha | | |
| | store_ID | | Alpha | | | | store_ID | The store of the sensor at the time of the log | Alpha | | |
| | sensor_ID | | Alpha | | | | sensor_ID | The unique identifying number of the sensor that took the log | Alpha | | |
| | log_interval | | Long | | | | log_interval | The interval between taking temperature readings of the sensor at the time of the log (in seconds) | Long | | |
| ---- struct data ---- | ---- struct data ---- |
| pagestatus.status : | pagestatus.status : |
| ---- | ---- |
| |