TABLES
5
VIEWS
0
COLUMNS
53
Constraints
3
Anomalies
1
Routines
0
Database Properties
Database Type: PostgreSQL - 17.8 (Debian 17.8-1.pgdg13+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| case_note_amendment | 0 | 1 | 9 | -1 | Table | Amendments added to case notes after creation |
| case_note_deleted | 0 | 0 | 11 | -1 | Table | Audit history of case notes hard deleted from the case_note table |
| case_note_type | 2 | 0 | 6 | 66 | Table | First level categorisation of case notes |
| case_note | 1 | 1 | 14 | -1 | Table | Individual case notes associated with a person identifier (prison number) |
| case_note_sub_type | 1 | 2 | 13 | 406 | Table | Second level categorisation of case notes grouped by type |