Turf Assignments
The turf_assignments table contains data about user assignments and restrictions in the organization.
This table can be used to determine what users have assignments, 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 object. | INT8 | No |
| user_id | The numerical identifier of the user this assignment relates to. Relates to the id column in the users table. |
INT8 | No |
| campaign_id | The numerical identifier of the campaign this assignment relates to. Relates to the id column in the campaigns table. |
INT8 | No |
| restriction_enabled | Whether the user is limited to entities in this assignment or not. | 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 |