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

Primary key
Name | Columns | Description
PK_Recorded_Event_Notification | recorded_event_notification_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Recorded_Event_Notification__Contact_Email__contact_email_KEY | contact_email_KEY | Contact_Email (contact_email_KEY) |
FK_Recorded_Event_Notification__Recorded_Event__recorded_event_KEY | recorded_event_KEY | Recorded_Event (recorded_event_KEY) |
FK_Recorded_Event_Notification__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |