Skip to main content
Reference

Entity-relationship diagram

DraftLast reviewed 2026-06-24

The full OpenTRMS schema currently spans 41 tables, so this page splits the backend ERD into domain slices generated from docs/ERD.mermaid. Each slice keeps the local tables readable and adds one-field stubs when a foreign-key edge crosses into another domain.

DomainTables
AUTHORIZATION4
REFERENCE DATA7
DEAL LIFECYCLE6
VALUATION & P&L3
ACCOUNTING2
SETTLEMENT & PAYMENT5
CLOSEOUT3
WORKFLOW3
EVENT STORE2
AUDIT6

Download the full Mermaid source

Domain slices

AUTHORIZATION (4 tables)

REFERENCE DATA (7 tables)

DEAL LIFECYCLE (6 tables)

VALUATION & P&L (3 tables)

ACCOUNTING (2 tables)

SETTLEMENT & PAYMENT (5 tables)

CLOSEOUT (3 tables)

WORKFLOW (3 tables)

EVENT STORE (2 tables)

AUDIT (6 tables)

Full diagram

Expand the full 41-table ERD