Magento EAV structure & role of eav_attribute’s backend_type field
Introduction: Magento database is based on EAV(Entity Attribute Value) architecture. And it uses this architecture, especially for categories, products, customers & customer addresses. Before Magento version 1.4.x it used EAV structure for orders as well but thereafter order’s EAV structure has been converted to a flat structure. From the definition of EAV: Entity(E): Entity actually …