Posts tagged: Database

Magento Table Structure

When you first look at Magento database, it can be overwhelming because of its complexity. The Magento database is heavily dependent on EAV (Entity Attribute Value) model. While the EAV model makes it easier to expand the database, i.e. adding your own entities or attributes specific for your store, SQL codes can be very difficult to write. Before you customize Magento database, make sure you read through EAV model and you understand Magento table structure thoroughly. EAV Core Tables All EAV tables are prefixed with "eav_". eav_entity_type: table of all entitiesIt contains information about entity codes, entity models, entity tables and more. Example ...