Calendar Event Actions
The calendar_event_actions table contains data about tasks (actions) created as part of the event (calendar event) workflow, such as turnout, confirm, double confirm, and attendance automatically created tasks.
This table can be used to determine which tasks were created for which event (or when they will be created if they're scheduled), as well as metadata about the tasks such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| calendar_event_id | The numerical identifier of the event that this task is attached to. Relates to the id column in the calendar_events table. |
INT8 | No |
| action_id | The numerical identifier of the task that this calendar event action is attached to, once the task is created. Relates to the id column in the actions table. |
INT8 | Yes |
| action_purpose | The type of task. One of recruit, confirm, double_confirm, or log_attendance. |
VARCHAR | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| create_action_days_before_event_start | The number of days before the start of the event this task will be (or was) automatically created. | INT4 | Yes |