Re: FK versus PK

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 22 Feb 2005 21:20:00 -0500
Message-ID: <7oGdnZhaCevFdYbfRVn-pg@comcast.com>

"David Aldridge" <slimdave_at_yahoo.com> wrote in message news:1109115506.402451.115950_at_o13g2000cwo.googlegroups.com...
> It could also be the case that the column is only part of the primary
> key and is also a foreign key ... that would probably be a more common
> case.
>

.... such as ORDER_ID and ITEM_NO as a 2-column PK in a dependent table (ORDER_ITEMS dependent on ORDERS) with ORDER_ID being the FK to ORDERS

++ mcs Received on Tue Feb 22 2005 - 20:20:00 CST