tables_fields:other_tables:coldchain

Cold chain

Back to the list of other tables

Tables that are used to capture cold chain data

Sensor

Central data

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 The most recent temperature reading of the sensor Real
lastConnectionDate Date
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 The date that the user selected to start recording temperature logs Time
log_delay_date The time that the user selected to start recording temperature logs Date
programmed_date Date
programmed_time Time
asset_ID Alpha

SensorLog

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

sensorLogItemLineJoin

Field name Description Type Indexed
ID Alpha *
itemLineID Alpha *
sensorLogID Alpha *

temperature_breach

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 The upper bound temperature for the breach configuration Real
threshold_minimum_temperature The lower bound temperature for the breach configuration Real
threshold_duration The duration threshold for the breach configuration Int
type The type of breach - Hot / Cold, Consecutive or Cumulative Alpha

temperature_breach_config

Field name Description Type Indexed
ID The unique identifying number assigned to this breach configuration Alpha *
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 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 The duration a temperature must have been within the thresholds for it to be considered a breach. (milliseconds) Long
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 Description of the breach configuration, e.g. 'Hot breach' Alpha
is_active Whether the breach is currently ongoing or not Boolean
location_type_ID Alpha
store_ID Alpha
type The type of breach - Hot / Cold, Consecutive or Cumulative Alpha
location_ID Alpha

temperature_log

Field name Description Type Indexed
ID The unique identifying number assigned to this temperature log Alpha *
temperature The temperature of the log (in Celsius) Real
date The date of the log Date
time The time of the log Time
location_ID The location of the sensor at the time of the log Alpha
temperature_breach_ID Indicates that this temperature log is contributing to a temperature_breach, which can span many temperature logs Alpha
store_ID The store of the sensor at the time of the log Alpha
sensor_ID The unique identifying number of the sensor that took the log Alpha
log_interval The interval between taking temperature readings of the sensor at the time of the log (in seconds) Long
  • Last modified: 2023/02/01 02:55
  • by Adam Dewey