<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()`]
}

Generate User Reminders For Deadline Command

Cancel User Reminders For Deadline Command

Create User Reminder Command

Update User Reminder Schedule Command

Remove User Reminder Command

List User Reminders By Deadline Query

List User Reminders By User Query

List Pending User Reminders Query