calendar

A listing of all datebook events.

It needs to be kept track of somewhere, eh?

CREATE TABLE calendar (
  identifier            integer NOT NULL PRIMARY KEY,
  users                 integer NOT NULL REFERENCES users(identifier),
  start_date            timestamp,
  end_date              timestamp,
  date_of_creation      timestamp,
  remark                text,
  client                integer REFERENCES users(identifier)
);

• users references users(identifier)
• client references users(identifier)

• album(event) references identifier
• folder(event) references identifier

• calendar_id_sequence

• calendar_client_idx
• calendar_id_idx
• calendar_user_idx

None.

None.

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE calendar (
  identifier            integer NOT NULL PRIMARY KEY,
  users                 integer NOT NULL REFERENCES users(identifier),
  start_date            timestamp,
  end_date              timestamp,
  date_of_creation      timestamp,
  remark                text
);

= Version 2.34 =

-- Track clients with datebook entries..
ALTER TABLE calendar ADD client integer REFERENCES users(identifier);