Hi, On Thu, June 14, 2007 18:16, Jake Peavy wrote: > Hi all, > > Can someone suggest a good method or normalized schema for storing product > information (id, description, price) which changes over time so that as a > product is gradually discounted, an order will reflect the cost of that > particular product at that particular time? >
One method could be to store product(id, description, price) and orderitem(id,orderid,productid,quantity,price) This way your orders will reflect the item-price at the time the order was created. -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]