Re: model inherited object
From: <j.andersen.lv_at_gmail.com>
Date: 28 Jun 2006 03:53:06 -0700
Message-ID: <1151491986.043268.313570_at_b68g2000cwa.googlegroups.com>
Date: 28 Jun 2006 03:53:06 -0700
Message-ID: <1151491986.043268.313570_at_b68g2000cwa.googlegroups.com>
Bob Badour wrote:
> j.andersen.lv_at_gmail.com wrote:
--- snip ---
> >
> > Hi Phil,
> >
> > My suggestion is to use three tables! One for the objects, one for the
> > attributes and one for the classifier defining the objects and
> > attributes,
> > as well as domain values, ie. OBJECTLIST, ATTRIBUTELIST, DOMAIN1LIST,
> > DOMAIN2LIST, etc.
>
> And how do you propose to declare the integrity constraints to the dbms?
> Simple foreign key references suddenly require cartwheels and backflips.
>
> I reiterate my earlier observation regarding ignorant cranks.
Best wishes,
John, Latvia Received on Wed Jun 28 2006 - 12:53:06 CEST