EAV Tables

Updated . Posted . Visible to the public.

A list of EAV tables and their purpose.

|----------------------------+-------------------------------------------------------------------------------------|
| Table | Contains |
|----------------------------+-------------------------------------------------------------------------------------|
| eav_attribute | Attributes and their global config values |
| catalog_eav_attribute | Catalog-specific config values for attributes |
| eav_attribute_set | Attribute sets, which are the top level containers for attributes against an entity |
| eav_attribute_group | Attribute groups, which belong to sets |
| eav_entity_attribute | Attribute to group membership (also seems to contain set, which is duplication) |
| eav_attribute_label | Per-store attribute labels |
| eav_attribute_option | Multi-select and dropdown options |
| eav_attribute_option_value | Multi-select and dropdown option labels |
|----------------------------+-------------------------------------------------------------------------------------|

Mike Whitby
Last edit
Posted by Mike Whitby to Magento (2012-07-12 15:19)