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
This way your orders will reflect the item-price at the time the
order was created.
+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.