Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Inherit compound key

Re: Inherit compound key

From: Bill MacLean <NSbmaclean_at_worldnet.att.net>
Date: 1998/01/09
Message-ID: <694m9j$q6o@bgtnsc01.worldnet.att.net>#1/1

I am not sure if D2000 will do this (I do not use Designer 2000). I know that both and Infomodeler and Erwin will. By the way, what you are doing is referred to by many as "unifying a foreign key".

Thanks,

Bill

Ulrich Brandes <ulrich.brandes_at_technet.net> wrote in article <349D867B.D1A219F5_at_technet.net>...
> Hi,
>
> I have the following problem while using Designer/2000:
>
> I have two tables with a two columns compound primary key. Both tables
> have one key component (MANDANT) in common. I have an additional Table
> which should act as an intersection table between these two tables. If I
> try to inherit the compound keys to the intersection table I get a
> compound key with four columns instead of three. But I want a only three
> column based compound key on that intersection table, based on the fact
> that an insert on the intersection table should only be possible if the
> mandant exits in both tables. Is it possible to define a constraint for
> this or is it necessary to handle that situation via a program routine.
>
> Thanks in advance...
>
>
> Ulrich
>
>
  Received on Fri Jan 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US