Old CalendarDatabaseSchema

From Open-Xchange
Revision as of 11:37, 10 August 2007 by Sebastian.kauss (talk | contribs) (New page: ==Calendar Database Schema informations== This page contains all informations about the internal structure of appointments and related object and some other useful informations about the ...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Calendar Database Schema informations

This page contains all informations about the internal structure of appointments and related object and some other useful informations about the content of the tables use by the calendar module.

Table prg_dates

The main table of appointments a detailed description which information are stored in this table is described in the table [[#prg_dates_structure | prg_dates structure].

Reminder response
Field Type Description
created_from Text UID of the user who created this appointment (e.g. 'sally')
creating_date Timestamp with time zone The date when this appointment was created
changed_from Text UID of user who modified this appointment last (e.g. 'peter')
changing_date Timestamp with time zone The date when this appointment was modified last
user_right Text Owner of the of the appointment.

Is normally the same like the UID in created_from except in a private shared folder when the appointment was created by another user that is not the owner of the shared folder.

group_right Text s for private, g for group appointment
sid Text Unused
tid Text The folder id where the appointment was saved (i.e. the ID of the calendar-folder)
fid Number The folder id where the appointment was saved.

If the appointment was stored in a private folder the folder id is always "-1". If the appointment was stored in a public folder the folder id is the id of the public folder and therefore equals with tid

order_crit Text Not unused anymore
timestampfield01 Timestamp with time zone starting time
timestampfield02 timestamp with time zone ending time
intfield01 Integer The unique id of the appointment
intfield02 Integer Only used if the appointment was a recurrence. The id must be unique too
intfield03 Integer Unused
intfield04 Integer The duration of the appointment in days.

Is used if the appointment is a recurrence because in this case the field timestampfield02 stores end date of recurrence

intfield05 Integer The recurrence position of an exception from a recurrence appointment.

Must be > 1 or NULL if it is a normal appointment.

intfield06 Integer Not used anymore
intfield07 Integer Unused
field01 Text The subject of the appointment. This field must not be null.
field02 Text Location
field03 Text 'Display As'-Type holds possible values are:

date1 = Reserved date2 = Temporary date3 = Absent date4 = free

field04 Text Comment/Note
field05 Text Possible values are 'gtz' if the appointment is stored as a full time appointment or NULL if it is a normal appointment.
field06 Text Holds a string representation of the recurrence information.
A detailed description is descriped in  Recurrence field struture.

This field must not be NULL.

field07 Text Comma-separated list of sequence numbers.

Every number is the position of a deleted appointment of the recurrence appointment.

field08 Text Comma-separated list of a id's.

Every id is a reference of a modified exception of the recurrence appointment.

field09 Text Unused
field10 Text Completely unused
field11 Text Completely unused
field12 Text Completely unused
field13 Text Completely unused
field14 Text Completely unused
field15 Text Completely unused


Table: prg_dates_members

In progress

Table: prg_date_resources

In progress

Table: prg_date_rights

In progress

Table: prg_date_notification

Table: prg_dates_times

This table is not used anymore