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: composed foreign key question

Re: composed foreign key question

From: Moritz Klein <mklein_at_students.uni-mainz.de>
Date: Mon, 19 Sep 2005 19:02:24 +0200
Message-ID: <dgmqni$d91$1@news1.zdv.uni-mainz.de>


Mark C. Stock schrieb:

> we might not communicating here ;-)

> with your existing (contract,lookupdate) as an FK to option_prices, i'm
> suggesting a 3-column PK of (contract,lookupdate,id) with id being
> system-assigned -- your last comment sounds like you might be considering a
> single-column SA PK?

Yes that was my intend, I forgot to mention the pk will be composed of fk + SA. Received on Mon Sep 19 2005 - 12:02:24 CDT

Original text of this message

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