Database — Working Patterns, Tickets & Stats

11 tables: working-pattern records and their daily breakdown, judge tickets, jurisdiction split, fee rates, annual leave, and monthly/booking statistics. TBL_JUDGES_MONTHLY_STATS is wide (≈70 columns) and dominates the cluster footprint.

Source PNG: docs/architecture/asis/database/ji_schema_judges-patterns.png · See the companion reference for trigger bodies and external-reference inventory.

Source: docs/architecture/asis/database/ji_schema_judges-patterns.png