TABLES
25
VIEWS
0
COLUMNS
320
Constraints
29
Anomalies
0
Routines
0
Database Properties
Database Type: PostgreSQL - 17.6 (Debian 17.6-2.pgdg13+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| period_length_history | 0 | 1 | 19 | -1 | Table | |
| charge_history | 0 | 1 | 19 | -1 | Table | |
| sentence_type | 2 | 0 | 16 | 54 | Table | |
| recall | 1 | 1 | 15 | -1 | Table | |
| uploaded_document | 0 | 1 | 9 | -1 | Table | |
| sentence | 5 | 4 | 18 | -1 | Table | |
| flyway_schema_history | 0 | 0 | 10 | 116 | Table | |
| court_appearance_history | 0 | 1 | 20 | -1 | Table | |
| sentence_history | 0 | 1 | 19 | -1 | Table | |
| court_case | 4 | 2 | 13 | -1 | Table | |
| appearance_charge | 0 | 2 | 5 | -1 | Table | |
| court_appearance | 6 | 2 | 19 | -1 | Table | |
| recall_sentence_history | 0 | 1 | 10 | -1 | Table | |
| court_case_history | 0 | 1 | 14 | -1 | Table | |
| charge | 4 | 3 | 18 | -1 | Table | |
| charge_outcome | 1 | 0 | 8 | 26 | Table | |
| next_court_appearance | 0 | 2 | 6 | -1 | Table | |
| period_length | 1 | 2 | 18 | -1 | Table | |
| recall_history | 1 | 0 | 18 | -1 | Table | |
| legacy_sentence_types | 0 | 2 | 12 | 198 | Table | |
| recall_type | 2 | 0 | 3 | -1 | Table | |
| recall_sentence | 0 | 2 | 8 | -1 | Table | |
| appearance_charge_history | 0 | 0 | 9 | -1 | Table | |
| appearance_outcome | 1 | 0 | 9 | 22 | Table | |
| appearance_type | 1 | 0 | 5 | -1 | Table |