Ciel Facturation Facile Démo version 20.0 free download
Ciel Compta Librale version 20.0 free download
Category:Accounting software
Category:Accounting software companies
Category:French brandsQ:
Composite Foreign Key Constraints
I am working on a project and have come across a scenario where I need to be sure that two foreign keys point to a single primary key. I can achieve this by adding a unique key to the foreign keys table, but I don't want to add the unique key to the primary key. Is there another way to achieve this?
Thanks
A:
You could use a Unique Constraint for the Primary Key of table B and two foreign keys that reference this column.
If that isn't possible, you can always add a surrogate key to the primary key.
NHL and the NHL Shield are registered trademarks and NHL Mobile name and logo, NHL GameCenter and Unlimited NHL are trademarks of the National Hockey League. NHL and NHL team marks are the property of the NHL and its teams.
2014-15 SCHEDULE
CGY@ANA
Mar. 19, 2014
7:00 PM
MTL
@OTT
Mar. 20, 2014
7:00 PM
CGY
@CBJ
Mar. 21, 2014
6:30 PM
OTT
@MTL
Mar. 23, 2014
7:00 PM
MTL
@CGY
Mar. 25, 2014
6:30 PM
OTT
@CGY
Mar. 27, 2014
6:30 PM
CGY
@OTT
Mar. 29, 2014
7:00 PM
MTL
@OTT
Apr. 1, 2014
6:30 PM
CGY
@OTT
Apr. 3, 2014
7:00 PM
MTL
@CGY
Apr. 6, 2014
6:30 PM
OTT
@MTL
Apr. 8, 2014
7:00 PM
MTL
@CGY
Apr. 10, 2014
7:00 PM
CGY
@OTT
Apr. 13, 2014
6:30 PM be359ba680
Related links:
Comments