Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| prison_code | varchar | 6 | null |
|
|
Prison ID (NOMIS column is Agency ID) |
|||||
| allow_auto_allocation | bool | 1 | false |
|
|
Indicates that the prisons supports auto allocation |
|||||
| is_enabled | bool | 1 | false |
|
|
Indicates if the prison keyworker data has been migrated |
|||||
| capacity | int4 | 10 | null |
|
|
Default capacity for keyworkers at this prison |
|||||
| maximum_capacity | int4 | 10 | null |
|
|
Default extended capacity for keyworkers at this prison |
|||||
| frequency_in_weeks | int4 | 10 | null |
|
|
Key worker session frequency for the prison |
|||||
| has_prisoners_with_high_complexity_needs | bool | 1 | false |
|
|
||||||
| policy_code | varchar | 16 | null |
|
|
||||||
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| prison_configuration_pkey | Primary key | Asc | id |
| prison_configuration_prison_code_policy_code | Must be unique | Asc/Asc | prison_code + policy_code |