Database Documentation Index
Database documentation for the current Prisma schema.
Start Here​
-
Database Design
Architecture overview, WABA design, message lifecycle, and queue readiness. -
Schema Reference
Tables, constraints, indexes, and query examples. -
ER Diagram
Entity relationships and cardinality. -
Schema Diagram
Visual architecture, data flows, and index map. -
UML Diagram
Object-oriented model view. -
Normalization Review
Normalization and controlled denormalization notes.
Current Schema Highlights​
| Feature | Current Design |
|---|---|
| Tenant | Vendor |
| WABA model | Unified WabaAccount |
| Shared WABA | WabaAccount.isShared = true |
| Dedicated WABA | Vendor.dedicatedWabaId |
| Dedicated uniqueness | Application-enforced, not DB-enforced |
| Message routing | Required MessageLog.phoneNumberId |
| WABA analytics | Optional MessageLog.wabaId |
| Recipient audit | Required MessageLog.recipientMobile |
| Idempotency | @@unique([vendorId, idempotencyKey]) |
| Queue readiness | status, priority, retryCount, nextRetryAt, expiresAt |
Model List​
- Vendor
- User
- WabaAccount
- PhoneNumber
- Contact
- MessageLog
- Campaign
- Wallet
- Transaction
- Template
- Webhook
- ApiLog
Key Statistics​
| Metric | Value |
|---|---|
| Models | 12 |
| Enums | 6 |
| Tenant-owned models | 8 |
| Message lifecycle timestamps | 4 |
| Message queue fields | priority, retryCount, nextRetryAt, expiresAt |
| Idempotency scope | Per vendor |