🗃️ Magento_Eav · engine innodb
eav_attribute_option
Eav Attribute Option
Neighbourhood (1-hop foreign-key graph — showing 3 of 3)
flowchart LR c["eav_attribute_option"]:::center n0["eav_attribute"] click n0 "/schema/table/eav_attribute" n0 -- attribute_id --> c n1["eav_attribute_option_swatch"] click n1 "/schema/table/eav_attribute_option_swatch" c -- option_id --> n1 n2["eav_attribute_option_value"] click n2 "/schema/table/eav_attribute_option_value" c -- option_id --> n2 click c "/schema/table/eav_attribute_option" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (3)
Columns (3)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| option_id PK | int unsigned | no | Option ID | |
| attribute_id | smallint unsigned | no | 0 | Attribute ID |
| sort_order | smallint unsigned | no | 0 | Sort Order |
Keys & indexes
Primary key: option_id
Indexes
- EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID (attribute_id) btree
References (1)
- attribute_id → eav_attribute .attribute_id (on delete CASCADE)
Referenced by (2)
- eav_attribute_option_swatch .option_id → .option_id (on delete CASCADE)
- eav_attribute_option_value .option_id → .option_id (on delete CASCADE)