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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Question on Primary Keys

Re: Question on Primary Keys

From: Jan Lenders <J.Lenders_at_Betuwe.net>
Date: Mon, 16 Oct 2000 17:01:16 GMT
Message-ID: <8sfc8l$ncm$1@nnrp1.deja.com> 






Okay, but what about an ORDERLINE table, which is dependent on a ORDER
table.


ORDER (PK OrderNum)


ORDERLINE (PK OrderNum, LineNum)


LineNum is unique per OrderNum and does not have to be unique within
the ORDERLINE table.



Your turn...




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Mon Oct 16 2000 - 12:01:16 CDT












Original text of this message













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