🏠 Overview › 🧩 Components ›🧩 Message Dispatch Logs Table

Message Dispatch Logs Table

Component Detail

Data Layer low complexity backend
0
Dependencies
0
Dependents
0
Entities
0
Integrations

Description

Persists a durable audit record for every outbound email and SMS, capturing channel, recipient, template, provider message ID, status, and timestamp to support compliance verification and deduplication lookups.

Feature: Email/SMS Notifications

message-dispatch-logs-table

Responsibilities

  • Store dispatch records with channel, recipient reference, template ID, status, and provider message ID
  • Support compliance audit queries for sensitive communications such as assignment receipts and expense decisions
  • Provide deduplication lookup data by idempotency key within the active time window
  • Track delivery status updates received from provider webhooks

Interfaces

insert(record)
findByIdempotencyKey(key)
findByUserId(userId, limit)
updateStatus(dispatchId, status, providerTimestamp)
findByDateRange(from, to)