db_calendar_event
Describes an event object in the calendar
| 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 | ||
| user_id | Integer | db_person.id | Owner of the event |
| creator_id | Integer | db_person.id | Creator ID |
| name | String | Summary of the event | |
| description | 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_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 | 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 |