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 | ||
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 | 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 |