Modeling database

Поиск
Список
Период
Сортировка
От Norton Glitz
Тема Modeling database
Дата
Msg-id CA+hofyzGK1MbTFWYOPR3bDO+A2FqjPje9qZHVTp1aAO7XN=pFA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Modeling database  (James Keener <jim@jimkeener.com>)
Список pgsql-novice
Hello,

In my site users will choose one subscription to have a certain amount of properties to advertise.

For example, if he bought a subscription with 5 ads, he can advertise 3 houses and 2 apartments.

The user can also modify the subscription, for like 10 ads. Now the same user can advertise 5 more properties. But he can also decrease the amount of ads, for example 2. But in this case he will have already more than 2 ads running.

Is there a way for everytime the subscription changes, if he has more ads than the subscription allows it just turn off the amount that is more than hired?

I'm not sure how to model this problem yet. Any answer would be awesome.

Thank you

В списке pgsql-novice по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Password settings requirements
Следующее
От: James Keener
Дата:
Сообщение: Re: Modeling database