TABLES
13
VIEWS
1
COLUMNS
141
Constraints
19
Anomalies
1
Routines
0
Database Properties
Database Type: PostgreSQL - 18.0 (Debian 18.0-1.pgdg13+3)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| reference_data_domain_link | 0 | 2 | 2 | -1 | Table | |
| temporary_absence_authorisation_audit | 0 | 1 | 22 | -1 | Table | |
| temporary_absence_movement_audit | 0 | 1 | 16 | -1 | Table | |
| temporary_absence_occurrence_audit | 0 | 1 | 18 | -1 | Table | |
| hmpps_domain_event | 0 | 0 | 4 | -1 | Table | |
| reference_data_domain | 2 | 0 | 2 | -1 | Table | |
| reference_data_link | 0 | 2 | 4 | 64 | Table | |
| temporary_absence_movement | 0 | 2 | 15 | -1 | Table | |
| audit_revision | 4 | 0 | 5 | -1 | Table | |
| temporary_absence_authorisation | 1 | 5 | 21 | -1 | Table | |
| hmpps_domain_event_audit | 0 | 1 | 6 | -1 | Table | |
| temporary_absence_occurrence | 0 | 3 | 17 | -1 | Table | |
| reference_data | 12 | 1 | 7 | 158 | Table | |
| temporary_absence_occurrence_status | 0 | 0 | 2 | 0 | View |