Shipment_Tracks
The table below describes the Shipment_Tracks table in the Minimal database schema.
This is a virtual table, and is linked to the Shipment table in the Minimal database schema (see Shipment).
None of the columns in this table are updatable.
This table contains the following foldable column:
- Entity_Id
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Nullable |
|---|---|---|
|
Entity_Id Primary Key Foreign Key linked to column Entity_Id in Shipment table |
SQL_INTEGER(unsigned) | False |
|
Tracks_Index Primary Key |
SQL_INTEGER(unsigned) | True |
|
Tracks_Carrier_Code |
SQL_VARCHAR(255) | True |
|
Tracks_Created_At |
SQL_TIMESTAMP | True |
|
Tracks_Description |
SQL_VARCHAR(3000) | True |
|
Tracks_Entity_Id |
SQL_INTEGER(unsigned) | True |
|
Tracks_Order_Id |
SQL_INTEGER(unsigned) | True |
|
Tracks_Parent_Id |
SQL_INTEGER(unsigned) | True |
|
Tracks_Qty |
SQL_NUMERIC(12,4) | True |
|
Tracks_Title |
SQL_VARCHAR(255) | True |
|
Tracks_Track_Number |
SQL_VARCHAR(255) | True |
|
Tracks_Updated_At |
SQL_TIMESTAMP | True |
|
Tracks_Weight |
SQL_NUMERIC(12,4) | True |