TABLES
8
VIEWS
0
COLUMNS
84
Constraints
5
Anomalies
3
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 |
|---|---|---|---|---|---|---|
| resync_audit | 0 | 1 | 10 | -1 | Table | Audit of alert changes caused by a resync call driven by a prisoner level change to alerts |
| audit_event | 0 | 1 | 14 | -1 | Table | Detailed change history of alerts. Became the system of record for alert changes from 20th of June 2024 |
| alert_code | 1 | 1 | 11 | 213 | Table | Second level categorisation of alerts grouped by type |
| alert | 1 | 2 | 12 | -1 | Table | Individual alerts associated with a person identifier (prison number) |
| bulk_plan | 1 | 0 | 16 | -1 | Table | Bulk alert journey session data |
| plan_person | 0 | 2 | 2 | -1 | Table | Joining table for people included in a bulk alert journey |
| alert_type | 1 | 0 | 10 | -1 | Table | First level categorisation of alerts |
| person_summary | 3 | 0 | 9 | -1 | Table | Data for the people who are included in a bulk alert journey. Domain events cause the summary data to be updated keeping it accurate |