<aside>

</aside>

Table user_reminders {
  id                    uuid                  [pk, note: 'ID reminder dành cho từng user']
  reminder_template_id  uuid    [ref: > reminder_templates.id, note: 'Mẫu reminder sử dụng']
  deadline_id           uuid    [ref: > deadlines.id, note: 'Deadline liên quan']
  user_id               uuid    [ref: > users.id, note: 'Người nhận reminder']
  scheduled_at          timestamp              [not null, note: 'Thời điểm dự kiến gửi']
  sent_at               timestamp  [null, note: 'Thực sự đã gửi lúc nào']
  status                reminder_status        [default: 'pending', note: 'pending/sent/failed']
  created_at            timestamp  [default: `now()`]
  updated_at            timestamp  [default: `now()`]
}

Send User Reminder Command

Fail User Reminder Command

Retry User Reminder Command

Get User Reminder Detail Query

List Sent User Reminders By User Query

List Failed User Reminders Query

Get Reminder Delivery Stats Query