TABLES
17
VIEWS
0
COLUMNS
161
Constraints
19
Anomalies
6
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 | 2 | 10 | -1 | Table | |
| prison_configuration_audit | 0 | 2 | 17 | -1 | Table | |
| allocation_audit | 0 | 2 | 19 | -1 | Table | |
| recorded_event_audit | 0 | 2 | 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 | -1 | Table | |
| allocation | 0 | 3 | 13 | -1 | Table | |
| staff_role | 0 | 1 | 10 | -1 | Table | |
| prison_configuration | 0 | 1 | 10 | 12 | Table | Records the prisons have can be supported by this service and which have been migrated |
| audit_revision | 5 | 0 | 5 | -1 | Table | |
| prisoner_statistic | 0 | 2 | 6 | -1 | Table | |
| staff_configuration_audit | 0 | 2 | 11 | -1 | Table | |
| policy | 14 | 0 | 2 | -1 | Table | |
| staff_role_audit | 0 | 2 | 16 | -1 | Table | |
| case_note_type_recorded_event_type | 0 | 1 | 5 | -1 | Table | |
| prison_statistic | 1 | 1 | 11 | -1 | Table | Records the results of each statistic snapshot |
| reference_data | 5 | 0 | 5 | -1 | Table |