<aside>

</aside>

Table notification_logs {
  id             uuid      [pk, note: 'Khóa chính record log gửi thông báo']
  notification_id uuid     [ref: > notifications.id, note: 'Thông báo đã attempt gửi']
  channel        varchar   [not null, note: 'Kênh gửi (email, push, sms)']
  status         varchar   [not null, note: 'Kết quả gửi (sent, failed, queued)']
  detail         text      [note: 'Chi tiết lỗi nếu gửi thất bại hoặc response từ gateway']
  attempted_at   timestamp [default: `now()`, note: 'Thời điểm hệ thống attempt gửi']
}

Send Pending Notifications Command

Retry Failed Notification Command

Log Notification Attempt Command

List Notification Logs By Notification Query

List Notification Logs By User Query

Get Notification Log Detail Query

List Failed Notifications Query