Skip to main content

Shipment_boundaries table

In this section:

The Shipment_boundaries table contains information about the upper and lower temperature boundaries of a shipment and the severity if that boundary is exceeded.

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 16. Shipment_boundaries

Item

Data type

Description

shipment_reference

  • n/a

string

Primary key. Foreign key.

boundary_type

  • n/a

string

Primary key.

threshold_value_lower

double

Primary key.

threshold_value_upper

double

Primary key.

accumulative_time_limit

  • n/a

int

Primary key.

severity

  • n/a

string

Primary key.