Assessments
The assessments table contains data about assessments made on entities.
This table can be used to determine what entities received which assessments and who made the assessment, as well as metadata about the assessment such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| level | The numeric level of the assessment. 0 means unassessed. |
INT4 | No |
| campaign_id | The numerical identifier of the campaign this assessment is in. Relates to the id column in the campaigns table. |
INT8 | No |
| owner_id | The numerical identifier of entity this assessment is on. Relates to the id column in the entities table. |
INT8 | No |
| owner_type | The name of the class of object this assessment is on. Always Entity. |
VARCHAR | No |
| created_by_id | The numerical identifier of the user that created this assessment. Relates to the id column in the users table. An ID of 1 typically means a machine-created assessment, such as over the API. |
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 |
| updated_by_id | This column is unused and always blank. | INT4 | Yes |