Shipment_boundaries table
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 |
double | Double; 8-byte double-precision floating point numbers. |
int | Integer, whole number. |
string | String, text. |
ts | Timestamp, in |
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. |