Differences

This shows you the differences between two versions of the page.

--- tables_fields:other_tables:coldchain [2023/01/31 03:41] – Adam Dewey
+++ tables_fields:other_tables:coldchain [2023/02/01 02:55] (current) – Adam Dewey
@@ Line 7: / Line 7: @@
 ====== Sensor ======
+<WRAP center round alert 100%>
+Central data</WRAP>
 ^ Field name ^ Description ^ Type ^ Indexed ^
@@ Line 14: / Line 17: @@
 | macAddress       | The mac address of the sensor | Text |  |
 | batteryLevel       | The most recent battery % reading of the sensor | Real |  |
-| temperature      | | Real |  |
+| temperature      | The most recent temperature reading of the sensor | Real |  |
 | lastConnectionDate      |  | Date |  |
-| lasstConnectionTime          |  | Time |  |
+| lastConnectionTime          |  | Time |  |
 | **storeID**          | The ID of the store to which this sensor belongs | Alpha | * |
 | logInterval           | The interval between taking temperature readings (in seconds) | Long |  |
 | numberOfLogs          |  | Long |  |
 | 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_time          |  | Time |  |
@@ Line 89: / Line 92: @@
 ^ Field name ^ Description ^ Type ^ Indexed ^
 | **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 ----
 pagestatus.status    :
 ----