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.
