User Tools

Site Tools


podoc:calendar_sql_table

Database Table Description of "calendar"

Name

calendar

Description

A listing of all datebook events.

Purpose

It needs to be kept track of somewhere, eh?

Schema

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)
);

References tables

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

Is referenced by tables

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

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= 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);
Data change history
podoc/calendar_sql_table.txt · Last modified: 2007/10/19 16:42 by Luud