Top "Entity-attribute-value" questions

A method of modelling and storing data by breaking it into three parts: the entities, their attributes and their values.

Symfony2 - how to create form based on dynamic parameters from db? (EAV)

I would like to create form based on dynamic parameters that are stored in DB. So I've created an entity …

forms symfony entity-attribute-value
Table Module vs. Domain Model

I asked about Choosing a method to store user profiles the other day and received an interesting response from David …

database design-patterns database-design entity-attribute-value
Should I use EAV model?

I'm am designing my database/domain for an eCommerce application and I'm having a hard time figuring out how to …

php database-design magento entity-attribute-value doctrine-orm
How to design a database schema to support tagging with categories?

I am trying to so something like Database Design for Tagging, except each of my tags are grouped into categories. …

sql schema tags foreign-keys entity-attribute-value
SQL Server, where field is int?

how can I accomplish: select * from table where column_value is int I know I can probably inner join to …

sql sql-server-2005 tsql entity-attribute-value
EAV over SQL Server

I'm interested in playing around with the EAV model over an SQL Server Database. Is anybody able to point me …

sql-server entity-attribute-value
How to store key value pairs in MySQL?

I am new to databases and MySQL in particular. Suppose I need to store flat key-value data structures in MySQL. …

mysql sql entity-attribute-value
MySQL Update multiple rows on a single column based on values from that same column

I have a table that looks like the following: ID Key Value Order 1 gender m 0 2 gender f 0 34 age 10 0 35 age 80 0 To …

mysql entity-attribute-value
How do you model custom attributes of entities?

Let's say we're having an application which should be able to store all kind of products. Each product has at …

sql sql-server database-design schema entity-attribute-value
Improving a query using a lot of inner joins to wp_postmeta, a key/value table

am working with a wordpress website that is performing the following query, but I see this query is doing many …

mysql sql database wordpress entity-attribute-value