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 12. Shipment_temperatures

Item

Data type

Description

shipment_reference

  • n/a

string

Primary key. Foreign key.

logger_id

  • n/a

string

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.