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 | |||
Name | Type | Constraints | Description |
schedule_item_KEY | int | NOT NULL | The [Schedule_Item_Reminder] that owns this link. |
reminder_date_utc | datetime | NOT NULL | The date the reminder is to be recorded. This value must match the value in [Schedule_Item_Reminder]. |
Primary key | |||
Name | Columns | Description | |
PK_Schedule_Item_Pending_Reminder$schedule_item_KEY | schedule_item_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Schedule_Item_Pending_Reminder$reminder_date_utc | reminder_date_utc | Required for looking up what next reminder to show next quickly. |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Schedule_Item_Pending_Reminder__Schedule_Item__schedule_item_KEY | schedule_item_KEY | Schedule_Item | on delete cascade; |