Here is a sample table:
item
item_id int
name char
attrib1 char
attrib2 char
attrib3 char
One problem with the above is that the list of attributes is fixed. I am
looking for a way to assign new, previously undefined, attributes to items
without changing the table structure. Is it ever appropriate to do the
following?
item
item_id int
name char
details
item_id int
attribute_name char
attribute_value char
If this is a reasonable technique are their guidelines for its use? When is it
approptiate? When not?
Thanks,
Bob