🗃️ Magento_Eav · engine innodb
eav_attribute_set
Eav Attribute Set
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["eav_attribute_set"]:::center n0["eav_entity_type"] click n0 "/schema/table/eav_entity_type" n0 -- entity_type_id --> c n1["eav_attribute_group"] click n1 "/schema/table/eav_attribute_group" c -- attribute_set_id --> n1 click c "/schema/table/eav_attribute_set" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (2)
Columns (4)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| attribute_set_id PK | smallint unsigned | no | Attribute Set ID | |
| entity_type_id | smallint unsigned | no | 0 | Entity Type ID |
| attribute_set_name | varchar(255) | yes | Attribute Set Name | |
| sort_order | smallint | no | 0 | Sort Order |
Keys & indexes
Primary key: attribute_set_id
Unique
- EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME (entity_type_id, attribute_set_name)
Indexes
- EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_SORT_ORDER (entity_type_id, sort_order) btree
References (1)
- entity_type_id → eav_entity_type .entity_type_id (on delete CASCADE)
Referenced by (1)
- eav_attribute_group .attribute_set_id → .attribute_set_id (on delete CASCADE)