TABLES
18
VIEWS
0
COLUMNS
178
Constraints
19
Anomalies
16
Routines
0
Database Properties
Database Type: PostgreSQL - 16.10 (Debian 16.10-1.pgdg13+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| recorded_event | 0 | 3 | 10 | -1 | Table | |
| prison_configuration_audit | 0 | 3 | 19 | -1 | Table | |
| allocation_audit | 0 | 3 | 20 | -1 | Table | |
| recorded_event_audit | 0 | 3 | 11 | -1 | Table | |
| staff_configuration | 0 | 2 | 7 | -1 | Table | Stores Key worker basic details, including status and capacity. |
| reference_data_policy | 0 | 2 | 3 | 84 | Table | |
| allocation | 0 | 4 | 13 | -1 | Table | |
| staff_role | 0 | 2 | 9 | -1 | Table | |
| prison_configuration | 0 | 2 | 10 | 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 | 13 | 0 | 2 | -1 | Table | |
| staff_role_audit | 0 | 3 | 16 | -1 | Table | |
| case_note_type_recorded_event_type | 0 | 1 | 5 | -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 | 7 | 0 | 5 | 60 | Table |