Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have some doubt in EAV. As for as I know EAV is should only be used when you are not sure about number of fields in a table which can vary in future. So eav_attribute table holds the attribute's and the values are stored in,

- eav_entity, eav_entity_int (for holding Integer values),
- eav_entity_varchar (for holding Varchar values),
- eav_entity_datetime (for holding Datetime values),
- eav_entity_decimal (for holding Decimal/float values),
- eav_entity_text (for holding text (mysql Text type) values).

I have checked those tables in default magento installed database and my magento projects (as far as i did yet) but, those tables doesn't stored any data. All are empty. Its make me mad.. Where the EAV used exactly..? Can any body explain about this with example please ..?

share|improve this question
Read this maybe it clears it: – Marius Aug 26 '14 at 15:23
up vote 3 down vote accepted


Magento started with this concept but it was too slow, so they decided to have tables for every eav_type on its own.

you find the following tables (maybe I forget some)

  • catalog_category_entity_*
  • catalog_procuct_entity_*
  • customer_entity_*
  • customer_address_entity_*

The basic data are stored in the entity table, e.g. customer_entity

share|improve this answer
Oh...Yes.. I got it..thanks Fabian...But What the tables(in my question) for..? For what purpose still we having that..? – Elavarasan Aug 26 '14 at 15:31
Backwards compatibility? And you can build your own EAV-type based upon these tables. – Fabian Blechschmidt Aug 26 '14 at 15:32

As far as I know these are left is so you can build your own models that use EAV. The standard eav in Magento, Customers, Products etc have their own tables.

For the customer attributes each table starts with customer_entity

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.