Re: Tables and foreign keys

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 <[email protected]>wrote:

> 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
>
>