Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| action | varchar | 40 | null |
|
|
The audit event type |
|||||
| description | text | 2147483647 | null |
|
|
A human readable description of what changed as a result of the action |
|||||
| actioned_at | timestamp | 29,6 | null |
|
|
The date and time the event happened |
|||||
| actioned_by | varchar | 64 | null |
|
|
The username of the user who performed the actioned recorded by the event |
|||||
| actioned_by_display_name | varchar | 255 | null |
|
|
The first and last name of the user at the time of the event. Does not update if their name changes |
|||||
| source | varchar | 12 | null |
|
|
The system used to perform the action. Either DPS if it was via the Alerts API or NOMIS if via the Prison API or the NOMIS application |
|||||
| active_case_load_id | varchar | 6 | √ | null |
|
|
The active caseload of the user at the time of the event |
||||
| description_updated | bool | 1 | √ | null |
|
|
Whether the alert description changed as a result of the action |
||||
| bool | 1 | √ | null |
|
|
Whether the alert authorised by property changed as a result of the action. Note this property can no longer be updated in DPS or NOMIS however the API supports changing it |
|||||
| active_from_updated | bool | 1 | √ | null |
|
|
Whether the alert active from property changed as a result of the action |
||||
| active_to_updated | bool | 1 | √ | null |
|
|
Whether the alert active to property changed as a result of the action |
||||
| alert_id | uuid | 2147483647 | null |
|
|
Foreign key to alert |
|||||
| version | int4 | 10 | 0 |
|
|
Supports bulk Hibernate operations |
|||||
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
Primary key |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| audit_event_pk | Primary key | Asc | id |
| idx_audit_event_action | Performance | Asc | action |
| idx_audit_event_actioned_at | Performance | Asc | actioned_at |
| idx_audit_event_actioned_by | Performance | Asc/Asc | actioned_by + actioned_at |
| idx_audit_event_alert_id | Performance | Asc | alert_id |