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