🛍️ Magento_Quote · engine innodb

quote

Sales Flat Quote

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

flowchart LR
  c["quote"]:::center
  n0["store"]
  click n0 "/schema/table/store"
  n0 -- store_id --> c
  n1["quote_item"]
  click n1 "/schema/table/quote_item"
  c -- quote_id --> n1
  n2["quote_address"]
  click n2 "/schema/table/quote_address"
  c -- quote_id --> n2
  n3["quote_id_mask"]
  click n3 "/schema/table/quote_id_mask"
  c -- quote_id --> n3
  n4["quote_payment"]
  click n4 "/schema/table/quote_payment"
  c -- quote_id --> n4
  click c "/schema/table/quote"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (5)

store_id → store quote_address → quote_id quote_id_mask → quote_id quote_item → quote_id quote_payment → quote_id

Columns (51)

Name	Type	Null	Default	Comment
gift_message_id	int	yes		Gift Message ID
is_persistent	smallint unsigned	yes	0	Is Quote Persistent
entity_id PK	int unsigned	no		Entity ID
store_id	smallint unsigned	no	0	Store ID
created_at	timestamp	no	CURRENT_TIMESTAMP	Created At
updated_at	timestamp	no	CURRENT_TIMESTAMP
converted_at	timestamp	yes		Converted At
is_active	smallint unsigned	yes	1	Is Active
is_virtual	smallint unsigned	yes	0	Is Virtual
is_multi_shipping	smallint unsigned	yes	0	Is Multi Shipping
items_count	int unsigned	yes	0	Items Count
items_qty	decimal	yes	0	Items Qty
orig_order_id	int unsigned	yes	0	Orig Order ID
store_to_base_rate	decimal	yes	0	Store To Base Rate
store_to_quote_rate	decimal	yes	0	Store To Quote Rate
base_currency_code	varchar(255)	yes		Base Currency Code
store_currency_code	varchar(255)	yes		Store Currency Code
quote_currency_code	varchar(255)	yes		Quote Currency Code
grand_total	decimal	yes	0	Grand Total
base_grand_total	decimal	yes	0	Base Grand Total
checkout_method	varchar(255)	yes		Checkout Method
customer_id	int unsigned	yes		Customer ID
customer_tax_class_id	int unsigned	yes		Customer Tax Class ID
customer_group_id	int unsigned	yes	0	Customer Group ID
customer_email	varchar(255)	yes		Customer Email
customer_prefix	varchar(40)	yes		Customer Prefix
customer_firstname	varchar(255)	yes		Customer Firstname
customer_middlename	varchar(40)	yes		Customer Middlename
customer_lastname	varchar(255)	yes		Customer Lastname
customer_suffix	varchar(40)	yes		Customer Suffix
customer_dob	datetime	yes		Customer Dob
customer_note	text	yes		Customer Note
customer_note_notify	smallint unsigned	yes	1	Customer Note Notify
customer_is_guest	smallint unsigned	yes	0	Customer Is Guest
remote_ip	varchar(45)	yes		Remote Ip
applied_rule_ids	varchar(255)	yes		Applied Rule Ids
reserved_order_id	varchar(64)	yes		Reserved Order ID
password_hash	varchar(255)	yes		Password Hash
coupon_code	varchar(255)	yes		Coupon Code
global_currency_code	varchar(255)	yes		Global Currency Code
base_to_global_rate	decimal	yes		Base To Global Rate
base_to_quote_rate	decimal	yes		Base To Quote Rate
customer_taxvat	varchar(255)	yes		Customer Taxvat
customer_gender	varchar(255)	yes		Customer Gender
subtotal	decimal	yes		Subtotal
base_subtotal	decimal	yes		Base Subtotal
subtotal_with_discount	decimal	yes		Subtotal With Discount
base_subtotal_with_discount	decimal	yes		Base Subtotal With Discount
is_changed	int unsigned	yes		Is Changed
trigger_recollect	smallint	no	0	Trigger Recollect
ext_shipping_info	text	yes		Ext Shipping Info

Keys & indexes

Primary key: entity_id

Indexes

QUOTE_CUSTOMER_ID_STORE_ID_IS_ACTIVE (customer_id, store_id, is_active) btree
QUOTE_STORE_ID_UPDATED_AT (store_id, updated_at) btree

References (1)

store_id → store .store_id (on delete CASCADE)

Referenced by (4)

quote_address .quote_id → .entity_id (on delete CASCADE)
quote_id_mask .quote_id → .entity_id (on delete CASCADE)
quote_item .quote_id → .entity_id (on delete CASCADE)
quote_payment .quote_id → .entity_id (on delete CASCADE)