Action Assignments

The action_assignments table contains data about which turfs (action assignment groups) are assigned to which entities assigned to tasks (action entities).

This table can be used to determine which entity is assigned to which turf within a task, as well as metadata about the assignment such as when it was created.

Columns

Column Name Description Type Nullable
id The numerical identifier of the action assignment. INT8 No
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
action_entity_id The numerical identifier of the entity assigned to the task (action entity). Relates to the id column in the action_entities table. INT8 Yes
action_assignment_group_id The numerical identifier of the turf the entity assignment is assigned to. Relates to the id column in the action_assignment_groups table. INT8 Yes
action_id The numerical identifier of the task this entity turf assignment is in. Relates to the id column in the actions table. INT8 Yes