Re: Attribute-value approach for table design




Ming wrote:
I am thinking to put the new fields into a new table, which will has
Attribute Name, TextValue, DateValue, NumberValue, and BooleanValue column.

I don't think you'll find much support for the notorious EAV
(Entity-Attribute-Value) 'design flaw' around here :(

Jamie.

--

.