Skip to main content

Shipment_logger_excursions table

In this section:

The Shipment_logger_excursions table contains the excursion history of a logger, information about excursion events, the time they took place, and details about the excursion that was raised (boundary type, value, and allowed time period).

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 14. Shipment_logger_excursions

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 event happened, in YYYY-MM-DDTHH:MM:SSZ format.

Primary key.

boundary_type

  • n/a

string

Primary key.

severity

  • n/a

string

Primary key.

accumulative_time_limit

int

Primary key.

threshold_value_lower

double

Primary key.

threshold_value_upper

double

Primary key.