Shipment
The table below describes the Shipment table in the Minimal database schema.
This table contains the following virtual tables:
This table contains the following foldable column:
- Entity_Id
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
Entity_Id Primary Key Foreign Key linked to column Entity_Id in Orders table |
SQL_INTEGER(unsigned) | False | False |
|
Billing_Address_Id |
SQL_INTEGER(signed) | True | True |
|
Created_At |
SQL_TIMESTAMP | True | True |
|
Customer_Id |
SQL_INTEGER(signed) | True | True |
|
Email_Sent |
SQL_INTEGER(unsigned) | True | True |
|
Increment_Id |
SQL_VARCHAR(255) | True | True |
|
Order_Id |
SQL_INTEGER(unsigned) | True | True |
|
Package |
SQL_LONGVARCHAR(2147483647) | False | True |
|
Shipment_Status |
SQL_INTEGER(signed) | True | True |
|
Shipping_Address_Id |
SQL_INTEGER(signed) | True | True |
|
Shipping_Label |
SQL_VARCHAR(255) | True | True |
|
Store_Id |
SQL_INTEGER(unsigned) | True | True |
|
Total_Qty |
SQL_NUMERIC(12,4) | True | True |
|
Total_Weight |
SQL_NUMERIC(12,4) | True | True |
|
Updated_At |
SQL_TIMESTAMP | True | True |