MageSmith

🛍️ Magento_Quote · engine innodb

quote_item

Sales Flat Quote Item

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

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

Click a node to jump to that table.

Related tables (6)

parent_item_id → quote_itemquote_id → quotestore_id → storequote_address_item → quote_item_idquote_item → parent_item_idquote_item_option → item_id

Columns (53)

NameTypeNullDefaultComment
gift_message_id int yesGift Message ID
free_shipping smallint unsignedno0Free Shipping
item_id PKint unsignednoItem ID
quote_id int unsignedno0Quote ID
created_at timestamp noCURRENT_TIMESTAMPCreated At
updated_at timestamp noCURRENT_TIMESTAMPUpdated At
product_id int unsignedyesProduct ID
store_id smallint unsignedyesStore ID
parent_item_id int unsignedyesParent Item ID
is_virtual smallint unsignedyesIs Virtual
sku varchar(255) yesSku
name varchar(255) yesName
description text yesDescription
applied_rule_ids text yesApplied Rule Ids
additional_data text yesAdditional Data
is_qty_decimal smallint unsignedyesIs Qty Decimal
no_discount smallint unsignedyes0No Discount
weight decimal yes0Weight
qty decimal no0Qty
price decimal no0Price
base_price decimal no0Base Price
custom_price decimal yesCustom Price
discount_percent decimal yes0Discount Percent
discount_amount decimal yes0Discount Amount
base_discount_amount decimal yes0Base Discount Amount
tax_percent decimal yes0Tax Percent
tax_amount decimal yes0Tax Amount
base_tax_amount decimal yes0Base Tax Amount
row_total decimal no0Row Total
base_row_total decimal no0Base Row Total
row_total_with_discount decimal yes0Row Total With Discount
row_weight decimal yes0Row Weight
product_type varchar(255) yesProduct Type
base_tax_before_discount decimal yesBase Tax Before Discount
tax_before_discount decimal yesTax Before Discount
original_custom_price decimal yesOriginal Custom Price
redirect_url varchar(255) yesRedirect Url
base_cost decimal yesBase Cost
price_incl_tax decimal yesPrice Incl Tax
base_price_incl_tax decimal yesBase Price Incl Tax
row_total_incl_tax decimal yesRow Total Incl Tax
base_row_total_incl_tax decimal yesBase Row Total Incl Tax
discount_tax_compensation_amount decimal yesDiscount Tax Compensation Amount
base_discount_tax_compensation_amount decimal yesBase Discount Tax Compensation Amount
weee_tax_applied text yesWeee Tax Applied
weee_tax_applied_amount decimal yesWeee Tax Applied Amount
weee_tax_applied_row_amount decimal yesWeee Tax Applied Row Amount
weee_tax_disposition decimal yesWeee Tax Disposition
weee_tax_row_disposition decimal yesWeee Tax Row Disposition
base_weee_tax_applied_amount decimal yesBase Weee Tax Applied Amount
base_weee_tax_applied_row_amnt decimal yesBase Weee Tax Applied Row Amnt
base_weee_tax_disposition decimal yesBase Weee Tax Disposition
base_weee_tax_row_disposition decimal yesBase Weee Tax Row Disposition

Keys & indexes

Primary key: item_id

Indexes

  • QUOTE_ITEM_PARENT_ITEM_ID (parent_item_id) btree
  • QUOTE_ITEM_PRODUCT_ID (product_id) btree
  • QUOTE_ITEM_QUOTE_ID (quote_id) btree
  • QUOTE_ITEM_STORE_ID (store_id) btree

References (3)

  • parent_item_id → quote_item .item_id (on delete CASCADE)
  • quote_id → quote .entity_id (on delete CASCADE)
  • store_id → store .store_id (on delete SET NULL)

Referenced by (3)