Table: Schedule_Item_Reminder_Recorded_Event | |||
Keeps track of what [Recorded_Event] is the reminder for a [Schedule_Item]. | |||
Columns | |||
Name | Type | Constraints | Description |
schedule_item_KEY | int | NOT NULL | The [Schedule_Item] that the reminder is for. |
recorded_event_KEY | int | NOT NULL | The [Recorded_Event] that is the reminder. |
Primary key | |||
Name | Columns | Description | |
PK_Schedule_Item_Reminder_Recorded_Event$recorded_event_KEY$schedule_item_KEY | recorded_event_KEY, schedule_item_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Schedule_Item_Reminder_Recorded_Event$recorded_event_KEY | recorded_event_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Schedule_Item_Reminder_Recorded_Event__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event | on delete cascade; |
FK_Schedule_Item_Reminder_Recorded_Event__Schedule_Item__schedule_item_KEY | schedule_item_KEY | Schedule_Item | on delete cascade; |