database design question

James Lance 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:
>>
>> Product:
>>  name
>>  sku
>>  price
>>  manufacturer
>>  weight
>>  box-dimensions
>>  type (can be master or normal.  If master then see options table)
>>  ...etc...
>>
>> Product Option:
>>  FK to Product
>>  sku
>>  desc
>>  value
>>
>> Now I have the Outlet:
>>
>> Outlet:
>>  name
>>  url
>>  ...etc...
>>
>> ProductOutlet:
>>  FK to Product
>>  FK to Outlet
>>  price (overrides default price)
>>  quantity
>>
>>
>> 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.
>>
>> ProductOptionOutlet?
>>  FK to ProductOutlet (navigating back to product gets tedious, I can
>> add more FK's)
>>  FK to ProductOption
>>  quantity
>>
>> 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.
>>
>> Thanks,
>> 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 mailing list