Entity Relationship Diagram

Complete ER Diagram

From	To	Cardinality	Delete Behavior	Purpose
Vendor	User	1:N	Cascade	Tenant users
Vendor	Contact	1:N	Cascade	Tenant contacts
Vendor	Campaign	1:N	Cascade	Tenant campaigns
Vendor	MessageLog	1:N	Cascade	Tenant-isolated message history
Vendor	Template	1:N	Cascade	Vendor-level templates
Vendor	Webhook	1:N	Cascade	Tenant event subscriptions
Vendor	ApiLog	1:N	Default	API audit events
Vendor	Wallet	1:0..1	Cascade	Tenant billing account
Vendor	WabaAccount	N:0..1	Set Null	Optional dedicated WABA assignment
WabaAccount	PhoneNumber	1:N	Cascade	Meta phone numbers
WabaAccount	Template	1:N	Set Null	Optional WABA-level template scope
WabaAccount	MessageLog	1:N	Default	Direct WABA trace for analytics
PhoneNumber	MessageLog	1:N	Restrict	Required routing identity
Contact	MessageLog	1:N	Set Null	Optional contact link
Campaign	MessageLog	1:N	Set Null	Optional campaign grouping
Wallet	Transaction	1:N	Cascade	Billing ledger

Vendor is the tenant root.
Tenant-owned records use vendorId.
Shared WABAs are platform resources selected at send time.
Dedicated WABA assignment uses Vendor.dedicatedWabaId and is enforced by application logic.
MessageLog.phoneNumberId is required for routing and auditability.
MessageLog.recipientMobile preserves recipient identity even if contact data changes.
MessageLog.idempotencyKey is unique per vendor with @@unique([vendorId, idempotencyKey]).