ERD Diagram
Visual entity-relationship diagrams for the MPAC Cloud Platform unified schema (svc-portal). Diagrams are split by domain for readability.
For column-level details, constraints, and design rationale, see the Refined Schema Design.
Full Overview
High-level relationships between all 26 tables.
1. Tenant Hierarchy
PSP → Merchant → Store multi-tenant model.
2. Users & RBAC
Unified role-based access control with three permission scopes: PLATFORM, MERCHANT, STORE.
Permission Resolution Flow
3. Device Management
Unified device/terminal model with two independent status axes.
Device Status Model
4. Delivery & Billing
Device delivery lifecycle and billing tracking.
Delivery Lifecycle
5. Auth & Audit
Authentication infrastructure and audit logging (existing tables retained as-is, plus new audit_logs).