The EAV model
EAV stands for entity, attribute, and value and is probably the most difficult concept for new Magento developers to grasp. While the EAV concept is not unique to Magento, it is rarely implemented on modern systems. Additionally, a Magento implementation is not a simple one.
What is EAV?
In order to understand what EAV is and what its role within Magento is, we need to break down parts of the EAV model:
- Entity: This represents the data items (objects) inside Magento products, customers, categories, and orders. Each entity is stored in the database with a unique ID.
- Attribute: These are our object properties. Instead of having one column ...