Table: dbo.Recorded_Event_Notification
Columns
NameTypeConstraintsDescription
recorded_event_notification_KEYint (4)NOT NULLDatabase assigned primary key for this table
recorded_event_KEYint (4)NOT NULLKey of parent Recorded_Event record.
staff_KEYint (4)Key of staff member who should see the event record in their portal, etc. Null for non staff.
contact_email_KEYint (4)Key if someone was notified via email.
read_datedatetime (8, 3)Date recipent read the notification.
dismissed_datedatetime (8, 3)Date recipent dismissed (don't show me this no more) the notification.
update_datedatetime (8, 3)NOT NULLThe date and time this row was last modified.
Primary key
NameColumnsDescription
PK_Recorded_Event_Notificationrecorded_event_notification_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Recorded_Event_Notification__Contact_Email__contact_email_KEYcontact_email_KEYContact_Email (contact_email_KEY)
FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEYrecorded_event_KEYRecorded_Event (recorded_event_KEY)
FK_Recorded_Event_Notification__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram