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