Skip to main content

Shipment_temperatures table

In this section:

The Shipment_temperatures table contains the temperature measurements history of a logger while assigned to a shipment.

Data type legend

Data type	Description
bigint	Big integer, large number.
decimal	Number with decimal point, in `11,7` format: 11 digits before decimal point, 7 digits after decimal point.
double	Double; 8-byte double-precision floating point numbers.
int	Integer, whole number.
string	String, text.
ts	Timestamp, in `YYYY-MM-DDTHH:MM:SSZ` format.

Table 4. Shipment_temperatures

Item	Data type	Description
shipment_reference	string	Unique identifier for shipment, as provided by customer when shipment was created. Primary key. Foreign key.
logger_id	string	Unique identifier of logger. This is the bar code value assigned to this logger from Controlant. The bar code value is printed on one side of the logger along with the bar code. Primary key.
timestamp	ts	Date and time measurement was made, in `YYYY-MM-DDTHH:MM:SSZ` format. Primary key.
channel	int	Channel logger made the measurement on. Only relevant for measurements made by dual probe loggers, which have channels 0 and 1. `0` - Channel 0 `1` - Channel 1 (found on dual probe loggers) Primary key.
value	double	Temperature value in 2,1 format: 2 digits before decimal point, 1 digit after decimal point. Unit of temperature is Celsius.

Would you like to provide feedback? Just click here to suggest edits.