The Entity, Attribute and Value (EAV) database architecture is at first, extremely difficult to grasp. Combine this with the lack of documentation on EAV and you find that most people don’t truly appreciate just how good EAV is and more importantly, how well suited it is to Magento. In this article I will attempt to shed some light on EAV in the hopes of helping you understand how it works, why it works and how this knowledge can benefit you as a Magento developer. To better understand this article, I recommend opening up a development Magento database using a tool such as phpMyAdmin.
What is EAV?
EAV stands for Entity, Attribute and Value. Let’s look at each part of that and try to understand them a little better.
The entity represents Magento data items such as products, categories, customers and orders. Each entity (product, category etc) will have it’s own entity record in the database.