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.
hex	Hexadecimal value. See more. Hidden as it was only used for logger_id, which now uses string
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 n/a	string	Unique identifier for shipment, as provided by customer when shipment was created. Primary key. Foreign key.
logger_id n/a	string	Unique identifier of logger, in hexadecimal format. This is the bar code value assigned to this logger from Controlant, in hexadecimal format. The bar code value is printed on one side of the logger along with the bar code. Primary key.
timestamp n/a	ts	Date and time measurement was made, in `YYYY-MM-DDTHH:MM:SSZ` format. Primary key.
channel n/a	int	Channel logger made the measurement on. Normally the channel is 0 except for dual probe loggers which also have channel 1. 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 n/a	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.