Re: Design / Implementation problem
От | Filip Rembiałkowski |
---|---|
Тема | Re: Design / Implementation problem |
Дата | |
Msg-id | 92869e660703190707l2627ada9t60c1bd72aa057c1d@mail.gmail.com обсуждение исходный текст |
Ответ на | Design / Implementation problem (Naz Gassiep <naz@mira.net>) |
Ответы |
Re: Design / Implementation problem
|
Список | pgsql-general |
hmmm. just a general notice: A customer loyalty program, which expires earned points, not to let the customer "win" anything valuable? If I were your client, I wouldn't be happy with this. 2007/3/18, Naz Gassiep <naz@mira.net>: > > We are running a customer loyalty program whereby customers earn points > for purchasing products. Each > product has a value of points that are earned by purchasing it, and a > value of points required to > redeem it. > > In order to prevent customers from stockpiling points, we want to place > an expiry date on points so > that unused points expire and are lost if they are not redeemed within a > certain period of time. This > will be calculated on a FIFO basis, I.e., the oldest points will expire > first. > > We will assume the expiry period is 12 months. > -- Filip Rembiałkowski
В списке pgsql-general по дате отправления: