Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('resync_audit_id_seq'::regclass) |
|
|
Internal primary key |
||||
| prison_number | varchar | 10 | null |
|
|
The prison number of the person whose alerts were resynced |
|||||
| request | jsonb | 2147483647 | null |
|
|
The full resync request |
|||||
| requested_at | timestamp | 29,6 | null |
|
|
The date and time of the resync request |
|||||
| requested_by | varchar | 64 | null |
|
|
The username of the user whose action caused the resync request |
|||||
| requested_by_display_name | varchar | 255 | null |
|
|
The first and last name of the user at the time of the resync request. Does not update if their name changes |
|||||
| source | varchar | 12 | null |
|
|
The system used to perform the action that caused the resync request. Will always be NOMIS |
|||||
| completed_at | timestamp | 29,6 | null |
|
|
The date and time the resync request actions completed |
|||||
| alerts_deleted | _uuid | 2147483647 | null |
|
|
Serialised list of alerts deleted via resync |
|||||
| alerts_created | _uuid | 2147483647 | null |
|
|
Serialised list of alerts created via resync |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_resync_audit | Primary key | Asc | id |
| idx_resync_audit_prison_number | Performance | Asc | prison_number |