ERD Design

This section documents the database schema design for the MPAC Cloud Platform (svc-portal).

Documents

Refined Schema Design

The unified database schema that merges PSP Admin (terminal lifecycle management) and User & Role (fine-grained RBAC) into the svc-portal database. Covers 26 tables across 5 domains:

• Tenant Hierarchy — PSPs, Merchants, Stores
• User & Role (RBAC) — Users, Roles, Permissions, Store Access
• Device Management — Devices, Models, Profiles, Activation/Status History
• Delivery & Billing — Delivery Orders, Returns, Billing Records
• Auth & Audit — JWT Keys, Sessions, MFA, Audit Logs

ERD Diagram

Visual entity-relationship diagrams organized by domain, showing all tables, key columns, and relationships.