Cold chain

Back to the list of other tables

Tables that are used to capture cold chain data

Sensor

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

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	Real
threshold_minimum_temperature	Real
threshold_duration	Int
type	The type of breach - Hot, Cold, Consecutive or Cumulative	Alpha

temperature_breach_config

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

temperature_log

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