The combination of those options or attributes (size, color, make, model, whatever) about the product all together make up a unique SKU....
The way Will has the structure of the database table one could infer that there is a "one product to many SKU relationship" and also a "one SKU to many Option relationship". The "SKU_prodID" and "prodID" should be a "one to one relationship", not a "one to many relationship" otherwise you'll get one product representing multiple SKUs and multiple options for one product, when it should be "one SKU with multiple options" for each single product. Unless I missed something? Which is totally possible... ----- Original Message ----- From: "Will Tomlinson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, September 06, 2005 7:27 PM Subject: SPAM-LOW: Re: Have brain lock, need schema/query help! > >An SKU incorporates options such as colour and size.... >> >>A product could be "ColdFusion coffee mug" while an SKU might be >>"ColdFusion Coffee Mug, Size XXL, white" >> >>I guess a product is a promotional unit, while an SKU is an inventory >>unit. > > > Exactly! Thanks! This is definitely a brain buster for me. > > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217518 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
