Magento Entity-Attribute-Value
With a complex system architecture, Magento developers realized that a traditional development approach could be counterproductive for a scalable idea to implement an e-commerce solution.
Developers, therefore, decided to adopt the Entity-Attribute-Value (EAV) architecture approach.
This database structure embraces the Magento 2.0 complexity processes and variables and allows an unlimited numbers of attributes to any item, such as categories, products, costumers, addresses, and more.
The three main points of EAV can be described as follows:
Entity: Data items are represented as entities. In the database, each entity has a record.
Attribute: Many attributes could belong to a specific entity; for example, the customer entity has name, birth date, phone, and so on. In Magento, all the attributes are listed in a single table.
Value: This is the value of each attribute. For example, customer is an entity that has an attribute called name with the value Fernando Miguel...
