Table: Recorded_Event_Notification
Columns
Name | Type | Constraints | Description
recorded_event_notification_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table
recorded_event_KEY | int | NOT NULL | Key of parent Recorded_Event record.
staff_KEY | int |  | Key of staff member who should see the event record in their portal, etc. Null for non staff.
contact_email_KEY | int |  | Key if someone was notified via email.
read_date | datetime |  | Date recipent read the notification.
dismissed_date | datetime |  | Date recipent dismissed (don't show me this no more) the notification.
update_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Recorded_Event_Notification$recorded_event_notification_KEY | recorded_event_notification_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Recorded_Event_Notification$contact_email_KEY | contact_email_KEY | Index supports foreign key FK_Recorded_Event_Notification__Contact_Email__contact_email_KEY
IX_Recorded_Event_Notification$recorded_event_KEY | recorded_event_KEY | Index supports foreign key FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEY
IX_Recorded_Event_Notification$staff_KEY$dismissed_date@recorded_event_KEY | staff_KEY, dismissed_date, recorded_event_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Recorded_Event_Notification__Contact_Email__contact_email_KEY | contact_email_KEY | Contact_Email | on delete set null;
FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event | on delete cascade;
FK_Recorded_Event_Notification__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;