TABLES
17
VIEWS
0
COLUMNS
168
Constraints
12
Anomalies
13
Routines
0
Database Properties
Database Type: PostgreSQL - 16.9 (Debian 16.9-1.pgdg120+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| keyworker_session | 0 | 1 | 10 | -1 | Table | |
| prison_configuration_audit | 0 | 3 | 17 | -1 | Table | |
| allocation_audit | 0 | 3 | 20 | -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 | 8 | 0 | 2 | -1 | Table | |
| audit_revision | 4 | 0 | 5 | -1 | Table | |
| batch_history | 0 | 0 | 3 | -1 | Table | Records the results of batch runs |
| keyworker_entry | 0 | 1 | 10 | -1 | Table | |
| staff_configuration_audit | 0 | 2 | 13 | -1 | Table | |
| policy | 8 | 0 | 2 | -1 | Table | |
| staff_role_audit | 0 | 3 | 16 | -1 | Table | |
| keyworker_stats | 0 | 0 | 12 | -1 | Table | Records the results of each statistic snapshot |
| 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. |
| reference_data | 5 | 0 | 5 | -1 | Table |