🛒 Magento_Sales · engine innodb
sales_shipment_grid
Sales Flat Shipment Grid
Columns (20)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_id | int unsigned | no | Entity ID | |
| increment_id | varchar(50) | yes | Increment ID | |
| store_id | smallint unsigned | yes | Store ID | |
| order_increment_id | varchar(32) | no | Order Increment ID | |
| order_id | int unsigned | no | Order ID | |
| order_created_at | timestamp | no | CURRENT_TIMESTAMP | Order Increment ID |
| customer_name | varchar(128) | no | Customer Name | |
| total_qty | decimal | yes | Total Qty | |
| shipment_status | int | yes | Shipment Status | |
| order_status | varchar(32) | yes | Order | |
| billing_address | varchar(255) | yes | Billing Address | |
| shipping_address | varchar(255) | yes | Shipping Address | |
| billing_name | varchar(128) | yes | Billing Name | |
| shipping_name | varchar(128) | yes | Shipping Name | |
| customer_email | varchar(128) | yes | Customer Email | |
| customer_group_id | int | yes | ||
| payment_method | varchar(32) | yes | Payment Method | |
| shipping_information | varchar(255) | yes | Shipping Method Name | |
| created_at | timestamp | yes | Created At | |
| updated_at | timestamp | yes | Updated At |
Keys & indexes
Primary key: entity_id
Unique
- SALES_SHIPMENT_GRID_INCREMENT_ID_STORE_ID (increment_id, store_id)
Indexes
- SALES_SHIPMENT_GRID_STORE_ID (store_id) btree
- SALES_SHIPMENT_GRID_TOTAL_QTY (total_qty) btree
- SALES_SHIPMENT_GRID_ORDER_INCREMENT_ID (order_increment_id) btree
- SALES_SHIPMENT_GRID_SHIPMENT_STATUS (shipment_status) btree
- SALES_SHIPMENT_GRID_ORDER_STATUS (order_status) btree
- SALES_SHIPMENT_GRID_CREATED_AT (created_at) btree
- SALES_SHIPMENT_GRID_UPDATED_AT (updated_at) btree
- SALES_SHIPMENT_GRID_ORDER_CREATED_AT (order_created_at) btree
- SALES_SHIPMENT_GRID_SHIPPING_NAME (shipping_name) btree
- SALES_SHIPMENT_GRID_BILLING_NAME (billing_name) btree
- SALES_SHIPMENT_GRID_ORDER_ID (order_id) btree
- FTI_086B40C8955F167B8EA76653437879B4 (increment_id, order_increment_id, shipping_name, customer_name, customer_email, billing_address, shipping_address) fulltext