Skip to main content

Shipment_contacts table

In this section:

The Shipment_contacts table contains contact information for the shipment, phone numbers or email addresses assigned to excursion notifications.

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 17. Shipment_contacts

Item

Data type

Description

shipment_reference

  • n/a

string

Primary key. Foreign key.

contact_type

string

Type of contact information for shipment:

  • SMS

  • Email

Primary key.

contact_address

string

Address of contact for shipment, one of the following:

  • Phone number

  • Email address

Primary key.