db_calendar_event
- Former user (Deleted)
- Rashmi Likhite
- Former user (Deleted)
Owned by Former user (Deleted)
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 |