Skip to content

Reminders Schema

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


Scheduled reminder definitions.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
titletextNO—
messagetextYES—
frequencytextNO—
target_iduuidYES—
target_typetextYES—
starts_attimestamptzNO—
ends_attimestamptzYES—
day_of_weeksmallintYES—
day_of_monthsmallintYES—
is_activebooleanNOtrue
last_fired_attimestamptzYES—
next_fire_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Users assigned to receive a reminder.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
reminder_iduuidNO—
user_iduuidNO—
created_attimestamptzNOnow()

Execution log for sent reminders.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
reminder_iduuidNO—
fired_attimestamptzNO—
recipients_notifiedintegerNO0
created_attimestamptzNOnow()