Reminders Schema

ext_reminders - Reminders

Schema: ext_reminders | Auto-generated on 2026-03-30

---

reminders

Scheduled reminder definitions.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
title	text	NO	—
message	text	YES	—
frequency	text	NO	—
target_id	uuid	YES	—
target_type	text	YES	—
starts_at	timestamptz	NO	—
ends_at	timestamptz	YES	—
day_of_week	smallint	YES	—
day_of_month	smallint	YES	—
is_active	boolean	NO	true
last_fired_at	timestamptz	YES	—
next_fire_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

reminder_recipients

Users assigned to receive a reminder.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
reminder_id	uuid	NO	—
user_id	uuid	NO	—
created_at	timestamptz	NO	now()

reminder_logs

Execution log for sent reminders.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
reminder_id	uuid	NO	—
fired_at	timestamptz	NO	—
recipients_notified	integer	NO	0
created_at	timestamptz	NO	now()