Magento 2 - 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