On Thu, Sep 18, 2008 at 1:14 PM, Dan Telschow <[EMAIL PROTECTED]> 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. /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
