MageSmith

🛍️ Magento_Quote · engine innodb

quote_address_item

Sales Flat Quote Address Item

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

flowchart LR
  c["quote_address_item"]:::center
  n0["quote_address"]
  click n0 "/schema/table/quote_address"
  n0 -- quote_address_id --> c
  n1["quote_item"]
  click n1 "/schema/table/quote_item"
  n1 -- quote_item_id --> c
  click c "/schema/table/quote_address_item"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

quote_address_id → quote_addressparent_item_id → quote_address_itemquote_item_id → quote_itemquote_address_item → parent_item_id

Columns (41)

NameTypeNullDefaultComment
gift_message_id int yesGift Message ID
free_shipping int unsignedyesFree Shipping
address_item_id PKint unsignednoAddress Item ID
parent_item_id int unsignedyesParent Item ID
quote_address_id int unsignedno0Quote Address ID
quote_item_id int unsignedno0Quote Item ID
created_at timestamp noCURRENT_TIMESTAMPCreated At
updated_at timestamp noCURRENT_TIMESTAMPUpdated At
applied_rule_ids text yesApplied Rule Ids
additional_data text yesAdditional Data
weight decimal yes0Weight
qty decimal no0Qty
discount_amount decimal yes0Discount Amount
tax_amount decimal yes0Tax Amount
row_total decimal no0Row Total
base_row_total decimal no0Base Row Total
row_total_with_discount decimal yes0Row Total With Discount
base_discount_amount decimal yes0Base Discount Amount
base_tax_amount decimal yes0Base Tax Amount
row_weight decimal yes0Row Weight
product_id int unsignedyesProduct ID
super_product_id int unsignedyesSuper Product ID
parent_product_id int unsignedyesParent Product ID
store_id smallint unsignedyesStore ID
sku varchar(255) yesSku
image varchar(255) yesImage
name varchar(255) yesName
description text yesDescription
is_qty_decimal int unsignedyesIs Qty Decimal
price decimal yesPrice
discount_percent decimal yesDiscount Percent
no_discount int unsignedyesNo Discount
tax_percent decimal yesTax Percent
base_price decimal yesBase Price
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

Keys & indexes

Primary key: address_item_id

Indexes

  • QUOTE_ADDRESS_ITEM_QUOTE_ADDRESS_ID (quote_address_id) btree
  • QUOTE_ADDRESS_ITEM_PARENT_ITEM_ID (parent_item_id) btree
  • QUOTE_ADDRESS_ITEM_QUOTE_ITEM_ID (quote_item_id) btree
  • QUOTE_ADDRESS_ITEM_STORE_ID (store_id) btree

References (3)

Referenced by (1)