Dear Karl
Foreign key is a good option (provided you use InnoDB database) to automate
the deletion/updation of cart details when you remove cart.
Besides 1:1 cardinality is good or bad can only be decided on the semantics
of your tables.
As a an aside, if it is 1:1 cardinality, then you can probably merge the
two tables
regds
amit
The difference between fiction and reality? Fiction has to make sense.
On Mon, Dec 26, 2011 at 12:38 PM, Karl DeSaulniers k...@designdrumm.comwrote:
Hello all,
I have two database tables. Cart and a cartdetails.
I want the information for the cartdetails to be based on/autofilled info
from cart.
I want the ability to delete from cart and cartdetails to automatically
clear as well.
Would a foreign key be best suited for this? What kind of cardnaility
would I use 1:1 ?
Hope I make sense.
Hope everyone had a great holidays!
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com