quote

Magento2 quote erd

Tables (7)

quote

  • quote_id — int(10) — Primary key — NOT NULL — quote_id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id

quote_address

  • address_id — int(10) — Primary key — NOT NULL — Address Id
  • quote_id — int(10) — Foreign key → quote.quote_id — NOT NULL — Quote Id

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

quote_item

  • item_id — int(10) — Primary key — NOT NULL — Item Id
  • quote_id — int(10) — Foreign key → quote.quote_id — NOT NULL — Quote Id
  • product_id — int(10) — Product Id
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • sku — varchar(255) — Sku

quote_payment

  • payment_id — int(10) — Primary key — NOT NULL — Payment Id
  • quote_id — int(10) — Foreign key → quote.quote_id — NOT NULL — Quote 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

store

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