Table: Recorded_Event_Notification
Columns
NameTypeConstraintsDescription
recorded_event_notification_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
recorded_event_KEYintNOT NULLKey of parent Recorded_Event record.
staff_KEYintKey of staff member who should see the event record in their portal, etc. Null for non staff.
contact_email_KEYintKey if someone was notified via email.
read_date_utcdatetimeDate recipent read the notification in UTC.
dismissed_date_utcdatetimeDate recipent dismissed (don't show me this again) the notification in UTC.
update_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Recorded_Event_Notification$recorded_event_notification_KEYrecorded_event_notification_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Recorded_Event_Notification$contact_email_KEYcontact_email_KEYIndex supports foreign key FK_Recorded_Event_Notification__Contact_Email__contact_email_KEY
IX_Recorded_Event_Notification$recorded_event_KEYrecorded_event_KEYIndex supports foreign key FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEY
IX_Recorded_Event_Notification$staff_KEY$dismissed_date_utc@recorded_event_KEYstaff_KEY, dismissed_date_utc, recorded_event_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_Notification__Contact_Email__contact_email_KEYcontact_email_KEYContact_Emailon delete set null;
FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Eventon delete cascade;
FK_Recorded_Event_Notification__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram