List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:June 14 2007 4:33pm
Subject:Re: Request: Schema suggestion for items which change over time...
View as plain text  
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.

Thread
Request: Schema suggestion for items which change over time...Jake Peavy14 Jun
  • Re: Request: Schema suggestion for items which change over time...Mogens Melander14 Jun