From: | Kevin Waterson <kevin(dot)waterson(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Recurring bookings |
Date: | 2016-01-21 10:05:54 |
Message-ID: | CAJSapQ1_Knd8xb6bCR5ZT4ttGX8k2Od9pG7mV5=SJw71ftdv9g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 varchar(25) NOT NULL,
description VARCHAR(200) NOT NULL
);
COMMENT ON TABLE call_frequency IS 'How often a call is scheduled';
INSERT INTO call_frequency( name, description ) VALUES ('Once Only',
'Single non-recurring call' );
INSERT INTO call_frequency( name, description ) VALUES ('Hourly', 'Every
hour' );
INSERT INTO call_frequency( name, description ) VALUES ('Daily', 'Every
day' );
INSERT INTO call_frequency( name, description ) VALUES ('Weekly', 'Every
week' );
INSERT INTO call_frequency( name, description ) VALUES ('Bi-Weekly', 'Every
second week' );
INSERT INTO call_frequency( name, description ) VALUES ('Monthly', 'Every
Month' );
INSERT INTO call_frequency( name, description ) VALUES ('Yearly', 'Every
Year' );
CREATE TABLE callcard (
id SERIAL PRIMARY KEY NOT NULL,
account_id INT NOT NULL REFERENCES accounts(id),
user_id INT NOT NULL REFERENCES users(id),
call_type_id INT NOT NULL REFERENCES call_types(id),
call_frequency_id INT NOT NULL REFERENCES call_frequency(id),
duration TSRANGE NOT NULL
);
COMMENT ON TABLE callcard IS 'Table of scheduled calls';
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-01-21 10:15:01 | Re: Recurring bookings |
Previous Message | Félix GERZAGUET | 2016-01-21 09:50:30 | Re: Import Schema converting tinyint to Boolean? |