can we have one attribute with multiple values in an eav design?
- by Shekhar
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