Re: Need schema design advice

On Sun, Oct 12, 2008 at 8:10 PM, Ben Chobot <bench@silentmedia.com> wrote:
> On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote:
> > could you provide a brief explanation of EAV ?
>
> (...) in an EAV model you would do something like:
> create table eav
> (
> kind text primary key,
> attr text,
> value text
> );
> insert into eav (kind, attr, value) values ('car','wheels','4');
> insert into eav (kind, attr, value) values ('bike','wheels','2');
> insert into eav (kind, attr, value) values ('small
> boat','displacement','1000');
> insert into eav (kind, attr, value) values ('big
> boat','displacement','300000');

Truly Hideous (TM).

Martin, I recommend you read the following:
http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-table-vs-many.html