Can a Compound key be set as a primary key to another table?
Posted
by Nikos
on Stack Overflow
See other posts from Stack Overflow
or by Nikos
Published on 2010-02-22T21:08:48Z
Indexed on
2010/05/24
16:41 UTC
Read the original article
Hit count: 514
Can a compound key be set as a primary key to another table?
For instance i have the tables:
Books
-with Primary Key:Product_ID
Client
-with Primary key:Client_ID
Clients_Books
-with Compound Primary Key:Product_Id
andClient_ID
I want to set this compound Primary key from Clients_Books as a Primary Key to another table named: Order_Details. But I don't want to use the Product_ID and the Client_ID from the Books, Clients tables.
Does this make sense? All opinions more than welcome.
© Stack Overflow or respective owner