db_calendar_event

Describes an event object in the calendar

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
kindInteger Kind of event. Meeting, Vacation, etc.
scheduling_impactInteger Indicates if this is impacts scheduling and if yes, whether it is working or non-working.
object_typeInteger  
object_idInteger  
owner_idIntegerdb_person.idOwner of the event
creator_idIntegerdb_person.idCreator ID
summaryString Summary of the event
detailString Detail of the event
sharingInteger  
is_all_dayBoolean (t or f) Is this an all day event?
tz_independentBoolean (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_utcDate Start date of the event
end_date_utcDate Finish date of the event
repeat_sub_typeInteger 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_patternString ICalendar Repeat pattern
repeat_until_utcDate Date until which this event repeats
work_calendar_idIntegerdb_working_calendar.id 
project_idIntegerdb_project.id