database design question

Jacob Fugal lukfugl at gmail.com
Fri Sep 19 11:33:03 MDT 2008


On Thu, Sep 18, 2008 at 1:14 PM, Dan Telschow <dan_tel at hotmail.com> wrote:
> You could add an ID to the Product Option table and include that in the
> mapping table (ProductOutlet):
>
>        ProductOutlet:
>           FK to Product
>          FK to Outlet
>           FK to ProductOption
>           price (overrides default price)
>           quantity
>
> If you do it this way, I'm not sure you need the FK to product in the
> ProductOutlet table since the FK to ProductOption would point to the
> product.  You could keep it for convenience.

He'd want to keep the foreign key to Product because not all products
have product options (i.e. some ProductOutlet rows would have the
foreign key to ProductOption null). But other than that observation,
this sounds best to me as well.



More information about the PLUG mailing list