Table: Schedule_Item_Reminder_Recorded_Event
Keeps track of what [Recorded_Event] is the reminder for a [Schedule_Item].
Columns
NameTypeConstraintsDescription
schedule_item_KEYintNOT NULLThe [Schedule_Item] that the reminder is for.
recorded_event_KEYintNOT NULLThe [Recorded_Event] that is the reminder.
Primary key
NameColumnsDescription
PK_Schedule_Item_Reminder_Recorded_Event$recorded_event_KEY$schedule_item_KEYrecorded_event_KEY, schedule_item_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Schedule_Item_Reminder_Recorded_Event$recorded_event_KEYrecorded_event_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Item_Reminder_Recorded_Event__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Eventon delete cascade;
FK_Schedule_Item_Reminder_Recorded_Event__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Itemon delete cascade;

Schema diagram