Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
Public primary key |
|||||
| alert_code_id | int8 | 19 | null |
|
|
Foreign key to alert code categorising the alert |
|||||
| prison_number | varchar | 10 | null |
|
|
The prison number of the person the alert is for |
|||||
| description | text | 2147483647 | √ | null |
|
|
The description of the alert |
||||
| varchar | 40 | √ | null |
|
|
Migrated from NOMIS. Not populated or displayed in DPS |
|||||
| active_from | date | 13 | null |
|
|
The date the alert is or was active from |
|||||
| active_to | date | 13 | √ | null |
|
|
The date the alert expired or will expire |
||||
| deleted_at | timestamp | 29,6 | √ | null |
|
|
The date the alert was soft deleted |
||||
| created_at | timestamp | 29,6 | null |
|
|
The date and time the alert was created. Used for ordering |
|||||
| last_modified_at | timestamp | 29,6 | √ | null |
|
|
The date and time the alert was last modified |
||||
| prison_code_when_created | varchar | 6 | √ | null |
|
|
The location of the person at the time the alert was created |
||||
| version | int4 | 10 | 0 |
|
|
Supports bulk Hibernate operations |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| alert_pk | Primary key | Asc | id |
| idx_alert_active_from | Performance | Asc | active_from |
| idx_alert_active_to | Performance | Asc | active_to |
| idx_alert_alert_code | Performance | Asc | alert_code_id |
| idx_alert_created_at | Performance | Asc | created_at |
| idx_alert_deleted_at | Performance | Asc | deleted_at |
| idx_alert_last_modified_at | Performance | Asc | last_modified_at |
| idx_alert_prison_number | Performance | Asc | prison_number |