Table: Schedule_Item_Pending_Reminder
Reminders that have not yet been recorded, indexed by [reminder_date] so that lookups are fast. When a reminder is recorded this record is deleted.
Columns
NameTypeConstraintsDescription
schedule_item_KEYintNOT NULLThe [Schedule_Item_Reminder] that owns this link.
reminder_date_utcdatetimeNOT NULLThe date the reminder is to be recorded. This value must match the value in [Schedule_Item_Reminder].
Primary key
NameColumnsDescription
PK_Schedule_Item_Pending_Reminder$schedule_item_KEYschedule_item_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Schedule_Item_Pending_Reminder$reminder_date_utcreminder_date_utcRequired for looking up what next reminder to show next quickly.
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Item_Pending_Reminder__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Itemon delete cascade;

Schema diagram