🛍️ Magento_Quote · engine innodb
quote_item_option
Sales Flat Quote Item Option
Neighbourhood (1-hop foreign-key graph — showing 1 of 1)
flowchart LR c["quote_item_option"]:::center n0["quote_item"] click n0 "/schema/table/quote_item" n0 -- item_id --> c click c "/schema/table/quote_item_option" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (1)
Columns (5)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| option_id PK | int unsigned | no | Option ID | |
| item_id | int unsigned | no | Item ID | |
| product_id | int unsigned | no | Product ID | |
| code | varchar(255) | no | Code | |
| value | text | yes | Value |
Keys & indexes
Primary key: option_id
Indexes
- QUOTE_ITEM_OPTION_ITEM_ID (item_id) btree
References (1)
- item_id → quote_item .item_id (on delete CASCADE)