🗃️ Magento_Eav · engine innodb
eav_entity_attribute
Eav Entity Attributes
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["eav_entity_attribute"]:::center n0["eav_attribute"] click n0 "/schema/table/eav_attribute" n0 -- attribute_id --> c n1["eav_attribute_group"] click n1 "/schema/table/eav_attribute_group" n1 -- attribute_group_id --> c click c "/schema/table/eav_entity_attribute" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (2)
Columns (6)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_attribute_id PK | int unsigned | no | Entity Attribute ID | |
| entity_type_id | smallint unsigned | no | 0 | Entity Type ID |
| attribute_set_id | smallint unsigned | no | 0 | Attribute Set ID |
| attribute_group_id | smallint unsigned | no | 0 | Attribute Group ID |
| attribute_id | smallint unsigned | no | 0 | Attribute ID |
| sort_order | smallint | no | 0 | Sort Order |
Keys & indexes
Primary key: entity_attribute_id
Unique
- EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID (attribute_set_id, attribute_id)
- EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID (attribute_group_id, attribute_id)
Indexes
- EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER (attribute_set_id, sort_order) btree
- EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID (attribute_id) btree
References (2)
- attribute_id → eav_attribute .attribute_id (on delete CASCADE)
- attribute_group_id → eav_attribute_group .attribute_group_id (on delete CASCADE)