database design question
james at thelances.net
Thu Sep 18 13:02:05 MDT 2008
yes. Really the main differences between options at the outlet level
is going to be inventory. So amazon could have 5 size 11 air jordan's
and ebay could have 10 size 11 air jordan's.
On Thu, Sep 18, 2008 at 12:29 PM, Dan Telschow <dan_tel at hotmail.com> wrote:
> Are we to assume that options can be different between Product Outlets?
> James Lance wrote:
>> I thought I would see if any of you DBA's out there have any advice.
>> I'm building an inventory system that deals with inventory tracking,
>> and also with where inventory is being sold (outlets). I'm having a
>> bit of a problem with dealing with outlet over rides. For example, I
>> have a pair of shoes and the shoes are available in different sizes.
>> I'm selling these shoes on amazon.com and ebay.com. I want my price
>> to be different for amazon than with ebay. I'm trying to build the
>> tables that deal with the outlet differences. Let me put up a
>> simplified version of the current database:
>> type (can be master or normal. If master then see options table)
>> Product Option:
>> FK to Product
>> Now I have the Outlet:
>> FK to Product
>> FK to Outlet
>> price (overrides default price)
>> Now here comes the part that I'm confused about. How should I deal
>> with the Product options? I've thought of a few ways to deal with
>> them, but none seem very good. The ProductOutlet table is a many to
>> many relationship. It seems odd to me to add an option table that
>> refers to a many to many lookup table.
>> FK to ProductOutlet (navigating back to product gets tedious, I can
>> add more FK's)
>> FK to ProductOption
>> Does anyone have any suggestions for how I could deal with this? I'm
>> really not even certain if I should keep the way that I'm dealing with
>> products and their options.
>> James Lance
>> PLUG: http://plug.org, #utah on irc.freenode.net
>> Unsubscribe: http://plug.org/mailman/options/plug
>> Don't fear the penguin.
>> No virus found in this incoming message.
>> Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database:
>> 270.6.21/1678 - Release Date: 9/18/2008 9:01 AM
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
More information about the PLUG