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 |