Old CalendarDatabaseSchema
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].
| 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