Re: Modeling question...

From: Volker Hetzer <>
Date: Fri, 25 Jul 2008 16:05:47 +0200
Message-ID: <g6cmjq$9s9$>

Bob Badour schrieb:
>>> Ooooh! Reinventing EAV with levels...
>> Possibly. I had a look at
>> and didn't find
>> anything exciting.
>> All my attributes (key value pairs) are (for the purpose of this
>> discussion) strings, so the Data tables hierarchy ends with
>> EAV_Objects in the first image of that link.
>> My problem is that, that I haveTest three different "Objects_1"
>> tables and I'd like to avoid having to replicate the EAV_Objects-Table
>> for each "Objects_1"-Table.
>> OTOH, I could have the "level" entities all be children of an id table
>> and
>> put the key value pairs into a child of that table. I need to try this
>> out.
>> Thanks for providing the pointer!
>> Volker

> Just to be clear, I was more than offering a pointer. I was also 
> ridiculing the idea of EAV.

I got that. :-)
But "we want to be able to create and delete attributes" is a customer requirement. I think it's different from "I am too lazy to do a proper data
model". There are plenty of "normal" attributes left to model ERD like.

Lots of Greetings!

For email replies, please substitute the obvious.
Received on Fri Jul 25 2008 - 16:05:47 CEST

Original text of this message