Tables


SchemaSpy Analysis of case_notes.public

Generated on Tue May 20 12:58 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 5
VIEWS 0
COLUMNS 53
Constraints 3
Anomalies 1
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
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