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

2007-06-14 Thread 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 > partic

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

2007-06-14 Thread 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