Skip to main content

Controlant Support Center

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

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

Item

Data type

Description

shipment_reference

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.