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 18:23:16 +0200
Message-ID: <dgmolg$d6t$1@news1.zdv.uni-mainz.de>


Mark C. Stock schrieb:

> don't use a single-column SA PK if it's dependent -- use the parent's PK as
> an FK, and add an ID column which is SA. it may make little difference at
> this point, but i've found it best as the design grows and evolves to always
> model dependent tables with the parent's PK + a date or ID column

Only to mention it (so you don't get wrong picture of me): I was going to do exactly that. Use contract and lookupdate in option_prices table for foreign key and add a SA primary key.

Greetz,

    Moritz Received on Mon Sep 19 2005 - 11:23:16 CDT

Original text of this message

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