Re: [GENERAL] Recurring bookings

2016-01-21 Thread cpolish
On 2016-01-21 02:15, John R Pierce wrote: > >How can I have recurring bookings for a call? > >Eg: if the call_frequency is weekly, how can I see a list of dates which > >this account will be called upon? I recommend "Developing time-oriented database applications in SQL", Richard T. Snodgrass, ISB

Re: [GENERAL] Recurring bookings

2016-01-21 Thread John R Pierce
On 1/21/2016 2:05 AM, Kevin Waterson wrote: So far this is what I have.. (see below). How can I have recurring bookings for a call? Eg: if the call_frequency is weekly, how can I see a list of dates which this account will be called upon? your call frequency table probably should have a fiel

[GENERAL] Recurring bookings

2016-01-21 Thread Kevin Waterson
So far this is what I have.. (see below). How can I have recurring bookings for a call? Eg: if the call_frequency is weekly, how can I see a list of dates which this account will be called upon? Kind regards Kevin CREATE TABLE call_frequency ( id SERIAL PRIMARY KEY NOT NULL, name