podoc:calendar_sql_table
This is an old revision of the document!
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
Is referenced by tables
None.
Related sequences
Related indexes
Related functions
None.
Related views
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.1192826412.txt.gz · Last modified: 2007/10/19 20:40 by Luud