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 ..?