Campaigns Entities
The campaigns_entities table contains data about which entities belong to which campaign.
This table can be used to determine which entities are in which campaigns and their latest assessment level, as well as metadata about the entity-campaign relationship 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 the entity is in. Relates to the id column in the campaigns table. |
INT8 | No |
| entity_id | The numerical identifier of the entity that is in the campaign. Relates to the id column in the entities table. |
INT8 | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| latest_assessment_id | The numerical identifier of the latest assessment on the entity in the campaign. Relates to the id column in the assessments table. |
INT4 | Yes |
| latest_assessment_level | The numerical assessment level of the latest assessment on the entity in the campaign. 0 means unassessed. |
INT4 | Yes |