Re: Tables and foreign keys

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <karl@xxxxxxxxxxxxxxx>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
>
>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux