I am building a model with the following requirements:
- Items may have attributes
- Attributes may be of type: 'Choice', 'FreeText', 'Number'
I am not quite sure how to relate the item to attribute properly. I currently have a table: 'ItemAttribute' which has both the item key and the attribute key and then just a value field which currently is simply a varchar field.
However, I would like to keep the integrity between the 'Choice' and the ItemAttribute which my current design does not help with.
How would you design this?
Thanks so much for your suggestions