Database schema — overview (as-is JI)

All 46 production tables reverse-engineered from JI Tables - 1.pdf, grouped into 6 areas. Per-table edges are intentionally suppressed; arrows between areas show the count of inferred FK relationships crossing that boundary. Source DDL contains zero explicit FK constraints — every relationship is inferred from column-naming conventions. Drill into a per-area detail diagram below for in-area FK lines and full column listings.

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

Source: docs/architecture/asis/database/ji_schema_overview.png