Action Entities
The action_entities table contains data about which entities are in which tasks (actions).
This table can be used to determine which tasks have which entities targeted, as well as metadata about the action entities such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| action_id | The numerical identifier of the action this action entity assignment is in. Relates to the id column in the actions table. |
INT8 | Yes |
| entity_id | The numerical identifier of the entity this action entity assignment is linked to. Relates to the id column in the entities table. |
INT8 | Yes |
| completed_at | The UTC timestamp when the todos in this task were completed for the linked entity. | TIMESTAMP | 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 |
| status | deprecated, always all_pending. |
VARCHAR | Yes |
| pending_count | deprecated, always 0. |
INT4 | Yes |
| completed_count | deprecated, always 0. |
INT4 | Yes |