🛒 Magento_Sales · engine innodb

sales_shipment

Sales Flat Shipment

Neighbourhood (1-hop foreign-key graph — showing 5 of 5)

flowchart LR
  c["sales_shipment"]:::center
  n0["sales_order"]
  click n0 "/schema/table/sales_order"
  n0 -- order_id --> c
  n1["store"]
  click n1 "/schema/table/store"
  n1 -- store_id --> c
  n2["sales_shipment_comment"]
  click n2 "/schema/table/sales_shipment_comment"
  c -- parent_id --> n2
  n3["sales_shipment_item"]
  click n3 "/schema/table/sales_shipment_item"
  c -- parent_id --> n3
  n4["sales_shipment_track"]
  click n4 "/schema/table/sales_shipment_track"
  c -- parent_id --> n4
  click c "/schema/table/sales_shipment"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (5)

order_id → sales_order store_id → store sales_shipment_comment → parent_id sales_shipment_item → parent_id sales_shipment_track → parent_id

Columns (18)

Name	Type	Null	Default	Comment
entity_id PK	int unsigned	no		Entity ID
store_id	smallint unsigned	yes		Store ID
total_weight	decimal	yes		Total Weight
total_qty	decimal	yes		Total Qty
email_sent	smallint	yes		Email Sent
send_email	smallint unsigned	yes		Send Email
order_id	int unsigned	no		Order ID
customer_id	int	yes		Customer ID
shipping_address_id	int	yes		Shipping Address ID
billing_address_id	int	yes		Billing Address ID
shipment_status	int	yes		Shipment Status
increment_id	varchar(50)	yes		Increment ID
created_at	timestamp	no	CURRENT_TIMESTAMP	Created At
updated_at	timestamp	no	CURRENT_TIMESTAMP	Updated At
packages	text	yes		Packed Products in Packages
shipping_label	mediumblob	yes		Shipping Label Content
customer_note	text	yes		Customer Note
customer_note_notify	smallint unsigned	yes		Customer Note Notify

Keys & indexes

Primary key: entity_id

Unique

SALES_SHIPMENT_INCREMENT_ID_STORE_ID (increment_id, store_id)

Indexes

SALES_SHIPMENT_STORE_ID (store_id) btree
SALES_SHIPMENT_TOTAL_QTY (total_qty) btree
SALES_SHIPMENT_ORDER_ID (order_id) btree
SALES_SHIPMENT_CREATED_AT (created_at) btree
SALES_SHIPMENT_UPDATED_AT (updated_at) btree
SALES_SHIPMENT_SEND_EMAIL (send_email) btree
SALES_SHIPMENT_EMAIL_SENT (email_sent) btree

References (2)

order_id → sales_order .entity_id (on delete CASCADE)
store_id → store .store_id (on delete SET NULL)

Referenced by (3)

sales_shipment_comment .parent_id → .entity_id (on delete CASCADE)
sales_shipment_item .parent_id → .entity_id (on delete CASCADE)
sales_shipment_track .parent_id → .entity_id (on delete CASCADE)