TABLES
16
VIEWS
0
COLUMNS
167
Constraints
14
Anomalies
15
Routines
0
Database Properties
Database Type: PostgreSQL - 16.9 (Debian 16.9-1.pgdg130+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| prison_configuration_audit | 0 | 3 | 17 | -1 | Table | |
| allocation_case_note | 0 | 1 | 10 | -1 | Table | |
| allocation_audit | 0 | 3 | 20 | -1 | Table | |
| allocation_case_note_audit | 0 | 2 | 11 | -1 | Table | |
| staff_configuration | 0 | 2 | 7 | -1 | Table | Stores Key worker basic details, including status and capacity. |
| allocation | 0 | 4 | 13 | -1 | Table | |
| staff_role | 0 | 2 | 9 | -1 | Table | |
| prison_configuration | 0 | 2 | 9 | 12 | Table | Records the prisons have can be supported by this service and which have been migrated |
| prison_migration_date_history | 9 | 0 | 2 | -1 | Table | |
| audit_revision | 5 | 0 | 5 | -1 | Table | |
| staff_configuration_audit | 0 | 2 | 13 | -1 | Table | |
| policy | 9 | 0 | 2 | -1 | Table | |
| staff_role_audit | 0 | 3 | 16 | -1 | Table | |
| zz_archived_legacy_keyworker_allocation | 0 | 2 | 15 | -1 | Table | Records the Key Worker assignment history of offenders on remand or serving custodial sentences held within an establishment. |
| prison_statistic | 0 | 2 | 13 | -1 | Table | Records the results of each statistic snapshot |
| reference_data | 5 | 0 | 5 | -1 | Table |