Cold chain

This is an old revision of the document!

Tables that are used to capture cold chain 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		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	Type	Indexed
ID	Alpha	*
sensorID	Alpha	*
locationID	Alpha	*
aggregation	Alpha
date	Date
time	Time
customData	Object	*
isInBreach	Boolean
storeID	Alpha	*
temperature	Real

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

Field name	Type	Indexed
ID	Alpha	*
start_date	Date
start_time	Time
end_date	Date
end_time	Time
location_ID	Alpha
store_ID	Alpha
temperature_breach_config_ID	Alpha
acknowledged	Boolean
sensor_ID	Alpha
threshold_maximum_temperature	Real
threshold_minimum_temperature	Real
threshold_duration	Int
type	Alpha

Field name	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	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

Sensor