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 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() |
|
|
||||||
| allocation_order | varchar | 15 | null |
|
|
||||||
| version | int4 | 10 | 0 |
|
|
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 |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| prison_config_allocation_order_valid | ((allocation_order)::text = ANY ((ARRAY['BY_ALLOCATIONS'::character varying, 'BY_NAME'::character varying])::text[])) |