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

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

Item

Data type

Description

shipment_reference

string

Primary key. Foreign key.

boundary_type

string

Primary key.

threshold_value_lower

double

Primary key.

threshold_value_upper

double

Primary key.

accumulative_time_limit

int

Primary key.

severity

string

Primary key.