can we have one attribute with multiple values in an eav design?
Posted
by Shekhar
on Stack Overflow
See other posts from Stack Overflow
or by Shekhar
Published on 2010-03-16T05:51:39Z
Indexed on
2010/03/16
5:56 UTC
Read the original article
Hit count: 398
Filed under:
database-design
|eav
i am doing a database design using EAV. I am facing an issue when i try to model an entity with attribute having multiple values?
For example
Entity
id | name | description
1 | configuration1 | configuration1
Attribute
id | entityId | name | type
1 | 1 |att1 | string
2 | 1 |att2 | int
3 |1 | att3 | List (How will i model this?)
Value
id | attributeId | value
1 | 1 | a
2 | 2 | 1
3 | 3 | b
4 | 3 | c
5 | 3 |d
Is this the correct way to handle list of values?
Please provide any helpful link to model this?
Thanks
Shekhar
© Stack Overflow or respective owner
