Actions
The actions table contains data about tasks (actions).
This table can be used to determine which tasks exist in which campaigns, their names and settings, and the like, 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 |
| campaign_id | The numerical identifier of the campaign this task is in. Relates to the id column in the campaigns table. |
INT4 | Yes |
| created_by_id | The numerical identifier of the user this task was created by. Relates to the id column in the users table. |
INT8 | No |
| name | The name of the task on the user interface. | VARCHAR | Yes |
| text | The description of the task on the user interface. | VARCHAR | Yes |
| due_date | The date the task is due. | DATE | Yes |
| active | deprecated, always TRUE |
BOOL | Yes |
| completed | deprecated, always FALSE |
BOOL | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was last updated. | TIMESTAMP | No |
| targets_query_json | A JSON representation of the query parameters used to add entities to the task. | JSON | Yes |
| quick_check_in | Whether quick checking is active for the task. | BOOL | Yes |
| entity_type_id | The numerical identifier of the entity type this task is operating on. Relates to the id column in the entity_types table. |
INT8 | Yes |
| canvassing_enabled | Whether canvassing is active for the task. | BOOL | Yes |
| canvassing_type | The type of canvass enabled for the task. 0 for phone banks, 1 for text banks, and 2 for home visits. |
INT4 | Yes |
| notification_enabled | Whether notifications are enabled for the task. | BOOL | Yes |
| householding_enabled | Whether householding is enabled for the task. | BOOL | Yes |