Magento – Storing product attributes of different types in a product aggregate
I use the EAV (Entity-Attribute-Value) pattern in an inventory management system I'm developing. It's very comparable to a typical webshop framework like Magento. Attributes have a data type, like numeric, varchar, text. The attribute definitions are stored in one table…