Skip to main content

Controlant Support Center

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

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

Primary key. Foreign key.

logger_id

string

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.