Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
Public primary key |
|||||
| alert_code_id | int4 | 10 | √ | null |
|
|
Foreign key to alert code categorising the alerts affected by the bulk plan |
||||
| description | text | 2147483647 | √ | null |
|
|
Description set on all new alerts created by the bulk plan |
||||
| version | int4 | 10 | null |
|
|
Supports bulk Hibernate operations |
|||||
| created_at | timestamp | 29,6 | null |
|
|
The date and time the bulk plan was created |
|||||
| created_by | varchar | 64 | null |
|
|
The username of the user who created the bulk plan |
|||||
| created_by_display_name | varchar | 255 | null |
|
|
The first and last name of the user at the time the bulk plan was created. Does not update if their name changes |
|||||
| cleanup_mode | varchar | 64 | √ | null |
|
|
The processed used to modify existing alerts associated with people not part of the bulk plan |
||||
| started_at | timestamp | 29,6 | √ | null |
|
|
The date and time the bulk plan was started |
||||
| started_by | varchar | 64 | √ | null |
|
|
The username of the user who started the bulk plan |
||||
| started_by_display_name | varchar | 255 | √ | null |
|
|
The first and last name of the user at the time the bulk plan was started. Does not update if their name changes |
||||
| completed_at | timestamp | 29,6 | √ | null |
|
|
The date and time the bulk plan actions completed |
||||
| created_count | int4 | 10 | √ | null |
|
|
The number of alerts that will be or have been created by the bulk plan |
||||
| updated_count | int4 | 10 | √ | null |
|
|
The number of alerts that will be or have been updated by the bulk plan |
||||
| unchanged_count | int4 | 10 | √ | null |
|
|
The number of alerts that will be or have been unaffected by the bulk plan |
||||
| expired_count | int4 | 10 | √ | null |
|
|
The number of alerts that will be or have been expired by the bulk plan |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| bulk_plan_pkey | Primary key | Asc | id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| ch_bulk_plan_cleanup_mode | (((cleanup_mode)::text = ANY ((ARRAY['KEEP_ALL'::character varying, 'EXPIRE_FOR_PRISON_NUMBERS_NOT_SPECIFIED'::character varying])::text[]))) |