Tables and foreign keys
| From: | Karl DeSaulniers | Date: | Mon, 26 Dec 2011 07:08:43 +0000 |
| Subject: | Tables and foreign keys | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48123@lists.php.net to get a copy of this message | ||
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