-- -- Table cal_user_prefs would stores custom information -- about each indivdual user. This would include time zone -- which is the first day of the week, monday or sunday, -- and the likes. -- CREATE TABLE cal_party_prefs ( calendar_id integer, -- -- Maps to a party -- party_id integer, -- -- default_view stores whether the user wants -- list, month, day, week, or year as his/her default view. -- default_view varchar(10) DEFAULT 'day'::character varying, -- -- the default number of minutes for each appointment -- default_duration integer DEFAULT 60, -- -- the default start time in daily view in military time 00 - 23 -- default to 07 or 7 am -- daily_start numeric(2, 0) DEFAULT 7, -- -- the default end time in daily view in military time 00 - 23 -- default to 18 or 6 pm -- daily_end numeric(2, 0) DEFAULT 18, time_zone integer, -- -- Which day of the week will be displayed first in month and week view -- first_day_of_week varchar(9) DEFAULT 'Sunday'::character varying, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cal_pty_prefs_time_zone_fk REFERENCES calendars (), CONSTRAINT cal_party_prefs_un REFERENCES calendars (), CONSTRAINT cal_party_prefs_time_zone_check REFERENCES calendars (), CONSTRAINT cal_pty_prefs_1st_day_ck REFERENCES calendars (), CONSTRAINT cal_pty_prefs_cal_id_fk REFERENCES calendars (), CONSTRAINT cal_pty_prefs_daily_end REFERENCES calendars (), CONSTRAINT cal_pty_prefs_daily_start REFERENCES calendars (), CONSTRAINT cal_pty_prefs_default_duration REFERENCES calendars (), CONSTRAINT cal_pty_prefs_default_view_ck REFERENCES calendars (), CONSTRAINT cal_pty_prefs_party_id_fk REFERENCES calendars () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cal_party_prefs_un REFERENCES parties (), CONSTRAINT cal_party_prefs_time_zone_check REFERENCES parties (), CONSTRAINT cal_pty_prefs_1st_day_ck REFERENCES parties (), CONSTRAINT cal_pty_prefs_cal_id_fk REFERENCES parties (), CONSTRAINT cal_pty_prefs_daily_end REFERENCES parties (), CONSTRAINT cal_pty_prefs_daily_start REFERENCES parties (), CONSTRAINT cal_pty_prefs_default_duration REFERENCES parties (), CONSTRAINT cal_pty_prefs_default_view_ck REFERENCES parties (), CONSTRAINT cal_pty_prefs_party_id_fk REFERENCES parties (), CONSTRAINT cal_pty_prefs_time_zone_fk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cal_pty_prefs_time_zone_fk REFERENCES timezones (), CONSTRAINT cal_party_prefs_time_zone_check REFERENCES timezones (), CONSTRAINT cal_party_prefs_un REFERENCES timezones (), CONSTRAINT cal_pty_prefs_1st_day_ck REFERENCES timezones (), CONSTRAINT cal_pty_prefs_cal_id_fk REFERENCES timezones (), CONSTRAINT cal_pty_prefs_daily_end REFERENCES timezones (), CONSTRAINT cal_pty_prefs_daily_start REFERENCES timezones (), CONSTRAINT cal_pty_prefs_default_duration REFERENCES timezones (), CONSTRAINT cal_pty_prefs_default_view_ck REFERENCES timezones (), CONSTRAINT cal_pty_prefs_party_id_fk REFERENCES timezones () ); CREATE UNIQUE INDEX cal_party_prefs_un ON cal_party_prefs (calendar_id, party_id); CREATE TRIGGER RI_ConstraintTrigger_c_341034 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341035 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341039 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341040 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341044 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341045 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
