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