reminder_text
Table: reminder_text
The reminder_text table stores the text content associated with each reminder.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| reminderId | smallint(6) | NO | References the linked reminder |
| reminderText | varchar(2000) | YES | The actual SMS or message content |
Indexes
FKC71AB4DAC5416964— Index onreminderIdfor faster lookup
Foreign Key Relations
reminderId→reminder.reminderId
Usage Notes
- Each reminder can have an optional message stored in this table.
- Useful for storing multi-line or long text reminders separate from the main
remindertable. - The foreign key ensures text is always linked to a valid reminder.