This is an old revision of the document!
| Field name | Description | Type | Indexed |
| ID | The unique identifying number assigned to this sensor | Alpha | * |
| locationID | The ID of the location to which this sensor belongs | Alpha | * |
| name | The name of the sensor | Text | |
| macAddress | The mac address of the sensor | Text | |
| batteryLevel | The most recent battery % reading of the sensor | Real | |
| temperature | | Real | |
| lastConnectionDate | | Date | |
| lasstConnectionTime | | 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_date | | Date | |
| programmed_date | | Date | |
| programmed_time | | Time | |
| asset_ID | | Alpha | |
| Field name | Description | Type | Indexed |
| ID | | Alpha | * |
| sensorID | | Alpha | * |
| locationID | | Alpha | * |
| aggregation | | Alpha | |
| date | | Date | |
| time | | Time | |
| customData | | Object | * |
| isInBreach | | Boolean | |
| storeID | | Alpha | * |
| temperature | | Real | |
| Field name | Description | Type | Indexed |
| ID | | Alpha | * |
| itemLineID | | Alpha | * |
| sensorLogID | | Alpha | * |
| Field name | Description | Type | Indexed |
| ID | The unique identifying number assigned to this breach | Alpha | * |
| start_date | The date that the breach began (the temperature entered the range of temperatures defining the breach) | Date | |
| start_time | The time that the breach began (entered the range of temperatures defining the breach) | Time | |
| end_date | The date that the breach completed (exited the temperature range) | Date | |
| end_time | The time the breach completed (exited the temperature range). | Time | |
| location_ID | The location of the sensor at the time that the breach was reported | Alpha | |
| store_ID | The store of the sensor at the time that the breach was reported | Alpha | |
| temperature_breach_config_ID | The ID of the breach configuration that defines the duration and temperature for this breach | Alpha | |
| 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 | |
| threshold_maximum_temperature | | Real | |
| threshold_minimum_temperature | | Real | |
| threshold_duration | | Int | |
| type | The type of breach - Hot, Cold, Consecutive or Cumulative | Alpha | |
| Field name | Description | Type | Indexed |
| ID | | Alpha | * |
| maximum_temperature | | Real | |
| minimum_temperature | | Real | |
| duration | | Long | |
| colour | | Alpha | |
| description | | Alpha | |
| is_active | | Boolean | |
| location_type_ID | | Alpha | |
| store_ID | | Alpha | |
| type | | Alpha | |
| Field name | Description | Type | Indexed |
| ID | | Alpha | * |
| temperature | | Real | |
| date | | Date | |
| time | | Time | |
| location_ID | | Alpha | |
| temperature_breach_ID | | Alpha | |
| store_ID | | Alpha | |
| sensor_ID | | Alpha | |
| log_interval | | Long | |