MageSmith

🛍️ Magento_Quote · engine innodb

quote_address

Sales Flat Quote Address

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

flowchart LR
  c["quote_address"]:::center
  n0["quote"]
  click n0 "/schema/table/quote"
  n0 -- quote_id --> c
  n1["quote_address_item"]
  click n1 "/schema/table/quote_address_item"
  c -- quote_address_id --> n1
  n2["inventory_pickup_location_quote_address"]
  click n2 "/schema/table/inventory_pickup_location_quote_address"
  c -- address_id --> n2
  n3["quote_shipping_rate"]
  click n3 "/schema/table/quote_shipping_rate"
  c -- address_id --> n3
  click c "/schema/table/quote_address"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

quote_id → quoteinventory_pickup_location_quote_address → address_idquote_address_item → quote_address_idquote_shipping_rate → address_id

Columns (64)

NameTypeNullDefaultComment
gift_message_id int yesGift Message ID
free_shipping smallint unsignedno0Free Shipping
address_id PKint unsignednoAddress ID
quote_id int unsignedno0Quote ID
created_at timestamp noCURRENT_TIMESTAMPCreated At
updated_at timestamp noCURRENT_TIMESTAMPUpdated At
customer_id int unsignedyesCustomer ID
save_in_address_book smallint yes0Save In Address Book
customer_address_id int unsignedyesCustomer Address ID
address_type varchar(10) yesAddress Type
email varchar(255) yesEmail
prefix varchar(40) yesPrefix
firstname varchar(255) yes
middlename varchar(40) yes
lastname varchar(255) yes
suffix varchar(40) yesSuffix
company varchar(255) yesCompany
street varchar(255) yesStreet
city varchar(255) yes
region varchar(255) yes
region_id int unsignedyesRegion ID
postcode varchar(20) yesPostcode
country_id varchar(30) yesCountry ID
telephone varchar(255) yes
fax varchar(255) yes
same_as_billing smallint unsignedno0Same As Billing
collect_shipping_rates smallint unsignedno0Collect Shipping Rates
shipping_method varchar(120) yes
shipping_description varchar(255) yesShipping Description
weight decimal no0Weight
subtotal decimal no0Subtotal
base_subtotal decimal no0Base Subtotal
subtotal_with_discount decimal no0Subtotal With Discount
base_subtotal_with_discount decimal no0Base Subtotal With Discount
tax_amount decimal no0Tax Amount
base_tax_amount decimal no0Base Tax Amount
shipping_amount decimal no0Shipping Amount
base_shipping_amount decimal no0Base Shipping Amount
shipping_tax_amount decimal yesShipping Tax Amount
base_shipping_tax_amount decimal yesBase Shipping Tax Amount
discount_amount decimal no0Discount Amount
base_discount_amount decimal no0Base Discount Amount
grand_total decimal no0Grand Total
base_grand_total decimal no0Base Grand Total
customer_notes text yesCustomer Notes
applied_taxes text yesApplied Taxes
discount_description varchar(255) yesDiscount Description
shipping_discount_amount decimal yesShipping Discount Amount
base_shipping_discount_amount decimal yesBase Shipping Discount Amount
subtotal_incl_tax decimal yesSubtotal Incl Tax
base_subtotal_total_incl_tax decimal yesBase Subtotal Total Incl Tax
discount_tax_compensation_amount decimal yesDiscount Tax Compensation Amount
base_discount_tax_compensation_amount decimal yesBase Discount Tax Compensation Amount
shipping_discount_tax_compensation_amount decimal yesShipping Discount Tax Compensation Amount
base_shipping_discount_tax_compensation_amnt decimal yesBase Shipping Discount Tax Compensation Amount
shipping_incl_tax decimal yesShipping Incl Tax
base_shipping_incl_tax decimal yesBase Shipping Incl Tax
vat_id text yesVat ID
vat_is_valid smallint yesVat Is Valid
vat_request_id text yesVat Request ID
vat_request_date text yesVat Request Date
vat_request_success smallint yesVat Request Success
validated_country_code text yesValidated Country Code
validated_vat_number text yesValidated Vat Number

Keys & indexes

Primary key: address_id

Indexes

  • QUOTE_ADDRESS_QUOTE_ID (quote_id) btree

References (1)

  • quote_id → quote .entity_id (on delete CASCADE)

Referenced by (3)