Magento2-quote

Magento2 quote erd

Tables (9)

quote

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • converted_at — timestamp — Converted At
  • is_active — smallint(5) — Is Active
  • is_virtual — smallint(5) — Is Virtual
  • is_multi_shipping — smallint(5) — Is Multi Shipping
  • items_count — int(10) — Items Count
  • items_qty — decimal(12,4) — Items Qty
  • orig_order_id — int(10) — Orig Order Id
  • store_to_base_rate — decimal(12,4) — Store To Base Rate
  • store_to_quote_rate — decimal(12,4) — Store To Quote Rate
  • base_currency_code — varchar(255) — Base Currency Code
  • store_currency_code — varchar(255) — Store Currency Code
  • quote_currency_code — varchar(255) — Quote Currency Code
  • grand_total — decimal(12,4) — Grand Total
  • base_grand_total — decimal(12,4) — Base Grand Total
  • checkout_method — varchar(255) — Checkout Method
  • customer_id — int(10) — Customer Id
  • customer_tax_class_id — int(10) — Customer Tax Class Id
  • customer_group_id — int(10) — Customer Group Id
  • customer_email — varchar(255) — Customer Email
  • customer_prefix — varchar(40) — Customer Prefix
  • customer_firstname — varchar(255) — Customer Firstname
  • customer_middlename — varchar(40) — Customer Middlename
  • customer_lastname — varchar(255) — Customer Lastname
  • customer_suffix — varchar(40) — Customer Suffix
  • customer_dob — datetime — Customer Dob
  • customer_note — varchar(255) — Customer Note
  • customer_note_notify — smallint(5) — Customer Note Notify
  • customer_is_guest — smallint(5) — Customer Is Guest
  • remote_ip — varchar(32) — Remote Ip
  • applied_rule_ids — varchar(255) — Applied Rule Ids
  • reserved_order_id — varchar(64) — Reserved Order Id
  • password_hash — varchar(255) — Password Hash
  • coupon_code — varchar(255) — Coupon Code
  • global_currency_code — varchar(255) — Global Currency Code
  • base_to_global_rate — decimal(12,4) — Base To Global Rate
  • base_to_quote_rate — decimal(12,4) — Base To Quote Rate
  • customer_taxvat — varchar(255) — Customer Taxvat
  • customer_gender — varchar(255) — Customer Gender
  • subtotal — decimal(12,4) — Subtotal
  • base_subtotal — decimal(12,4) — Base Subtotal
  • subtotal_with_discount — decimal(12,4) — Subtotal With Discount
  • base_subtotal_with_discount — decimal(12,4) — Base Subtotal With Discount
  • is_changed — int(10) — Is Changed
  • trigger_recollect — smallint(6) — NOT NULL — Trigger Recollect
  • ext_shipping_info — text — Ext Shipping Info
  • is_persistent — smallint(5) — Is Quote Persistent
  • gift_message_id — int(11) — Gift Message Id

quote_address

  • address_id — int(10) — Primary key — NOT NULL — Address Id
  • quote_id — int(10) — Foreign key → quote.entity_id — NOT NULL — Quote Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • customer_id — int(10) — Customer Id
  • save_in_address_book — smallint(6) — Save In Address Book
  • customer_address_id — int(10) — Customer Address Id
  • address_type — varchar(10) — Address Type
  • email — varchar(255) — Email
  • prefix — varchar(40) — Prefix
  • firstname — varchar(20) — Firstname
  • middlename — varchar(20) — Middlename
  • lastname — varchar(20) — Lastname
  • suffix — varchar(40) — Suffix
  • company — varchar(255) — Company
  • street — varchar(255) — Street
  • city — varchar(40) — City
  • region — varchar(40) — Region
  • region_id — int(10) — Region Id
  • postcode — varchar(20) — Postcode
  • country_id — varchar(30) — Country Id
  • telephone — varchar(20) — Phone Number
  • fax — varchar(20) — Fax
  • same_as_billing — smallint(5) — NOT NULL — Same As Billing
  • collect_shipping_rates — smallint(5) — NOT NULL — Collect Shipping Rates
  • shipping_method — varchar(40) — Shipping Method
  • shipping_description — varchar(255) — Shipping Description
  • weight — decimal(12,4) — NOT NULL — Weight
  • subtotal — decimal(12,4) — NOT NULL — Subtotal
  • base_subtotal — decimal(12,4) — NOT NULL — Base Subtotal
  • subtotal_with_discount — decimal(12,4) — NOT NULL — Subtotal With Discount
  • base_subtotal_with_discount — decimal(12,4) — NOT NULL — Base Subtotal With Discount
  • tax_amount — decimal(12,4) — NOT NULL — Tax Amount
  • base_tax_amount — decimal(12,4) — NOT NULL — Base Tax Amount
  • shipping_amount — decimal(12,4) — NOT NULL — Shipping Amount
  • base_shipping_amount — decimal(12,4) — NOT NULL — Base Shipping Amount
  • shipping_tax_amount — decimal(12,4) — Shipping Tax Amount
  • base_shipping_tax_amount — decimal(12,4) — Base Shipping Tax Amount
  • discount_amount — decimal(12,4) — NOT NULL — Discount Amount
  • base_discount_amount — decimal(12,4) — NOT NULL — Base Discount Amount
  • grand_total — decimal(12,4) — NOT NULL — Grand Total
  • base_grand_total — decimal(12,4) — NOT NULL — Base Grand Total
  • customer_notes — text — Customer Notes
  • applied_taxes — text — Applied Taxes
  • discount_description — varchar(255) — Discount Description
  • shipping_discount_amount — decimal(12,4) — Shipping Discount Amount
  • base_shipping_discount_amount — decimal(12,4) — Base Shipping Discount Amount
  • subtotal_incl_tax — decimal(12,4) — Subtotal Incl Tax
  • base_subtotal_total_incl_tax — decimal(12,4) — Base Subtotal Total Incl Tax
  • discount_tax_compensation_amount — decimal(12,4) — Discount Tax Compensation Amount
  • base_discount_tax_compensation_amount — decimal(12,4) — Base Discount Tax Compensation Amount
  • shipping_discount_tax_compensation_amount — decimal(12,4) — Shipping Discount Tax Compensation Amount
  • base_shipping_discount_tax_compensation_amnt — decimal(12,4) — Base Shipping Discount Tax Compensation Amount
  • shipping_incl_tax — decimal(12,4) — Shipping Incl Tax
  • base_shipping_incl_tax — decimal(12,4) — Base Shipping Incl Tax
  • free_shipping — smallint(6)
  • vat_id — text — Vat Id
  • vat_is_valid — smallint(6) — Vat Is Valid
  • vat_request_id — text — Vat Request Id
  • vat_request_date — text — Vat Request Date
  • … +2

quote_address_item

  • address_item_id — int(10) — Primary key — NOT NULL — Address Item Id
  • quote_address_id — int(10) — Foreign key → quote_address.address_id — NOT NULL — Quote Address Id
  • quote_item_id — int(10) — Foreign key → quote_item.item_id — NOT NULL — Quote Item Id
  • parent_item_id — int(10) — Foreign key → quote_address_item.address_item_id — Parent Item Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • applied_rule_ids — text — Applied Rule Ids
  • additional_data — text — Additional Data
  • weight — decimal(12,4) — Weight
  • qty — decimal(12,4) — NOT NULL — Qty
  • discount_amount — decimal(12,4) — Discount Amount
  • tax_amount — decimal(12,4) — Tax Amount
  • row_total — decimal(12,4) — NOT NULL — Row Total
  • base_row_total — decimal(12,4) — NOT NULL — Base Row Total
  • row_total_with_discount — decimal(12,4) — Row Total With Discount
  • base_discount_amount — decimal(12,4) — Base Discount Amount
  • base_tax_amount — decimal(12,4) — Base Tax Amount
  • row_weight — decimal(12,4) — Row Weight
  • product_id — int(10) — Product Id
  • super_product_id — int(10) — Super Product Id
  • parent_product_id — int(10) — Parent Product Id
  • sku — varchar(255) — Sku
  • image — varchar(255) — Image
  • name — varchar(255) — Name
  • description — text — Description
  • is_qty_decimal — int(10) — Is Qty Decimal
  • price — decimal(12,4) — Price
  • discount_percent — decimal(12,4) — Discount Percent
  • no_discount — int(10) — No Discount
  • tax_percent — decimal(12,4) — Tax Percent
  • base_price — decimal(12,4) — Base Price
  • base_cost — decimal(12,4) — Base Cost
  • price_incl_tax — decimal(12,4) — Price Incl Tax
  • base_price_incl_tax — decimal(12,4) — Base Price Incl Tax
  • row_total_incl_tax — decimal(12,4) — Row Total Incl Tax
  • base_row_total_incl_tax — decimal(12,4) — Base Row Total Incl Tax
  • discount_tax_compensation_amount — decimal(12,4) — Discount Tax Compensation Amount
  • base_discount_tax_compensation_amount — decimal(12,4) — Base Discount Tax Compensation Amount
  • free_shipping — int(11)
  • gift_message_id — int(11) — Gift Message Id

quote_id_mask

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • quote_id — int(10) — Foreign key → quote.entity_id — NOT NULL — Quote ID
  • masked_id — varchar(32) — Masked ID

quote_item

  • item_id — int(10) — Primary key — NOT NULL — Item Id
  • quote_id — int(10) — Foreign key → quote.entity_id — NOT NULL — Quote Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • product_id — int(10) — Product Id
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • parent_item_id — int(10) — Foreign key → quote_item.item_id — Parent Item Id
  • is_virtual — smallint(5) — Is Virtual
  • sku — varchar(255) — Sku
  • name — varchar(255) — Name
  • description — text — Description
  • applied_rule_ids — text — Applied Rule Ids
  • additional_data — text — Additional Data
  • is_qty_decimal — smallint(5) — Is Qty Decimal
  • no_discount — smallint(5) — No Discount
  • weight — decimal(12,4) — Weight
  • qty — decimal(12,4) — NOT NULL — Qty
  • price — decimal(12,4) — NOT NULL — Price
  • base_price — decimal(12,4) — NOT NULL — Base Price
  • custom_price — decimal(12,4) — Custom Price
  • discount_percent — decimal(12,4) — Discount Percent
  • discount_amount — decimal(12,4) — Discount Amount
  • base_discount_amount — decimal(12,4) — Base Discount Amount
  • tax_percent — decimal(12,4) — Tax Percent
  • tax_amount — decimal(12,4) — Tax Amount
  • base_tax_amount — decimal(12,4) — Base Tax Amount
  • row_total — decimal(12,4) — NOT NULL — Row Total
  • base_row_total — decimal(12,4) — NOT NULL — Base Row Total
  • row_total_with_discount — decimal(12,4) — Row Total With Discount
  • row_weight — decimal(12,4) — Row Weight
  • product_type — varchar(255) — Product Type
  • base_tax_before_discount — decimal(12,4) — Base Tax Before Discount
  • tax_before_discount — decimal(12,4) — Tax Before Discount
  • original_custom_price — decimal(12,4) — Original Custom Price
  • redirect_url — varchar(255) — Redirect Url
  • base_cost — decimal(12,4) — Base Cost
  • price_incl_tax — decimal(12,4) — Price Incl Tax
  • base_price_incl_tax — decimal(12,4) — Base Price Incl Tax
  • row_total_incl_tax — decimal(12,4) — Row Total Incl Tax
  • base_row_total_incl_tax — decimal(12,4) — Base Row Total Incl Tax
  • discount_tax_compensation_amount — decimal(12,4) — Discount Tax Compensation Amount
  • base_discount_tax_compensation_amount — decimal(12,4) — Base Discount Tax Compensation Amount
  • free_shipping — smallint(6)
  • gift_message_id — int(11) — Gift Message Id
  • weee_tax_applied — text — Weee Tax Applied
  • weee_tax_applied_amount — decimal(12,4) — Weee Tax Applied Amount
  • weee_tax_applied_row_amount — decimal(12,4) — Weee Tax Applied Row Amount
  • weee_tax_disposition — decimal(12,4) — Weee Tax Disposition
  • weee_tax_row_disposition — decimal(12,4) — Weee Tax Row Disposition
  • base_weee_tax_applied_amount — decimal(12,4) — Base Weee Tax Applied Amount
  • base_weee_tax_applied_row_amnt — decimal(12,4) — Base Weee Tax Applied Row Amnt
  • base_weee_tax_disposition — decimal(12,4) — Base Weee Tax Disposition
  • base_weee_tax_row_disposition — decimal(12,4) — Base Weee Tax Row Disposition

quote_item_option

  • option_id — int(10) — Primary key — NOT NULL — Option Id
  • item_id — int(10) — Foreign key → quote_item.item_id — NOT NULL — Item Id
  • product_id — int(10) — NOT NULL — Product Id
  • code — varchar(255) — NOT NULL — Code
  • value — text — Value

quote_payment

  • payment_id — int(10) — Primary key — NOT NULL — Payment Id
  • quote_id — int(10) — Foreign key → quote.entity_id — NOT NULL — Quote Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • method — varchar(255) — Method
  • cc_type — varchar(255) — Cc Type
  • cc_number_enc — varchar(255) — Cc Number Enc
  • cc_last_4 — varchar(255) — Cc Last 4
  • cc_cid_enc — varchar(255) — Cc Cid Enc
  • cc_owner — varchar(255) — Cc Owner
  • cc_exp_month — varchar(255) — Cc Exp Month
  • cc_exp_year — smallint(5) — Cc Exp Year
  • cc_ss_owner — varchar(255) — Cc Ss Owner
  • cc_ss_start_month — smallint(5) — Cc Ss Start Month
  • cc_ss_start_year — smallint(5) — Cc Ss Start Year
  • po_number — varchar(255) — Po Number
  • additional_data — text — Additional Data
  • cc_ss_issue — varchar(255) — Cc Ss Issue
  • additional_information — text — Additional Information
  • paypal_payer_id — varchar(255) — Paypal Payer Id
  • paypal_payer_status — varchar(255) — Paypal Payer Status
  • paypal_correlation_id — varchar(255) — Paypal Correlation Id

quote_shipping_rate

  • rate_id — int(10) — Primary key — NOT NULL — Rate Id
  • address_id — int(10) — Foreign key → quote_address.address_id — NOT NULL — Address Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • carrier — varchar(255) — Carrier
  • carrier_title — varchar(255) — Carrier Title
  • code — varchar(255) — Code
  • method — varchar(255) — Method
  • method_description — text — Method Description
  • price — decimal(12,4) — NOT NULL — Price
  • error_message — text — Error Message
  • method_title — text — Method Title

store

  • store_id — smallint(5) — Primary key — NOT NULL — Store Id