TABLES
15
VIEWS
3
COLUMNS
226
Constraints
23
Anomalies
1
Routines
0
Database Properties
Database Type: PostgreSQL - 18.3 (Debian 18.3-1.pgdg13+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| authorisation_status | 1 | 0 | 5 | -1 | Table | |
| authorisation_audit | 0 | 1 | 21 | -1 | Table | |
| absence_categorisation_link | 0 | 0 | 6 | 71 | Table | |
| absence_type | 2 | 0 | 6 | -1 | Table | |
| absence_sub_type | 2 | 0 | 7 | -1 | Table | |
| absence_reason_category | 2 | 0 | 6 | -1 | Table | |
| absence_reason | 3 | 0 | 5 | 98 | Table | |
| occurrence_audit | 0 | 1 | 22 | -1 | Table | |
| transport | 2 | 0 | 5 | -1 | Table | |
| movement_audit | 0 | 1 | 15 | -1 | Table | |
| occurrence | 1 | 8 | 20 | -1 | Table | |
| authorisation | 0 | 8 | 19 | -1 | Table | |
| occurrence_status | 1 | 0 | 5 | -1 | Table | |
| movement | 0 | 4 | 13 | -1 | Table | |
| accompanied_by | 3 | 0 | 5 | -1 | Table | |
| audited_movement | 0 | 0 | 18 | 0 | View | |
| audited_authorisation | 0 | 0 | 23 | 0 | View | |
| audited_occurrence | 0 | 0 | 25 | 0 | View |