...
| Column | Type | References | Comments | ||||
|---|---|---|---|---|---|---|---|
| id | Integer | Primary key | |||||
| vdb_id | Integer | ||||||
| kind | Integer | Kind of event. Meeting, Vacation, etc. | |||||
| scheduling_impact | Integer | Indicates if this is impacts scheduling and if yes, whether it is working or non-working. | |||||
| object_type | Integer | ||||||
| object_id | Integer | ||||||
| owner_id | Integer | db_person.id | Owner of the event | ||||
| creator_id | Integer | db_person.id | Creator ID | ||||
| summary | String | Summary of the event | |||||
| detail | String | Detail of the event | |||||
| sharing | Integer | ||||||
| is_all_day | Boolean (t or f) | Is this an all day event? | |||||
| tz_independent | Boolean (t or f) | Is this a timezone independent event e.g. Christmas 25th Dec. On the other hand, a company wide CEO presentation at 10:00 AM EST will be as per each user's timezone | |||||
| start_date_utc | Date | Start date of the event | |||||
| end_date_utc | Date | Finish date of the event | |||||
| repeat_type | String | Type this event repeats e.g. EVERY_WEEK | repeat_sub_type | Integer | The sub-type qualifier for the repeat type. e.g. if EVERY_MONTH, then whether it is on a specific day of the week or last day of month etc. | ||
| repeat_pattern | String | Calendar | ICalendar Repeat pattern | ||||
| repeat_until_utc | Date | Date until which this event repeats | |||||
| work_calendar_id | Integer | db_working_calendar.id | |||||
| project_id | Integer | db_project.id |
...