Projections

CQRS read models

BC: reporting, outbox · Status: CDC proof complete

Purpose

Specialised read models fed asynchronously from the write path. Reporting and compliance never query primary tables directly.

Capabilities

Area	Status	Notes
Outbox → Kafka	✅	Transactional outbox
reporting_proj tables	✅	CDC-fed projections
Reconciliation watermark	✅	/reporting/reconciliation
OpenSearch / ClickHouse	⬜	Production scale path

Submodule docs

• CDC & reporting

Code

backend/limen-server/src/main/java/com/fordsworth/limen/reporting/
backend/limen-server/src/main/java/com/fordsworth/limen/outbox/

Related

• Architecture doctrine — Projections