Action Assignment Group Users
The action_assignment_group_users table contains data about which turfs (action assignment groups) are assigned to which users.
This table can be used to determine which user is assigned to which turf, as well as metadata about the user assignment such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the action assignment group user. | INT8 | No |
| action_assignment_group_id | The numerical identifier of the turf assigned to the user. Relates to the id column in the action_assignment_groups table. |
INT8 | Yes |
| user_id | The numerical identifier of the user the turf is assigned to. Relates to the id column in the users table. |
INT8 | Yes |
| start_address_id | The numerical identifier of the address the user will start on if using driving directions for this turf assigned to a user. Relates to the id column in the addresses table. |
INT4 | Yes |
| end_address_id | The numerical identifier of the address the user will end on if using driving directions for this turf assigned to a user. Relates to the id column in the addresses table. |
INT4 | Yes |
| exclude_completed_actions | Whether completed actions are excluded in driving directions or not for this turf assigned to a user. | 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 |