Request: Schema suggestion for items which change over time...

[Jake Peavy]

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?

--
-jp

At birth, Chuck Norris came out feet first so he could roundhouse kick the
doctor in the face. Nobody delivers Chuck Norris but Chuck Norris

Re: Request: Schema suggestion for items which change over time...

[Mogens Melander]

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]