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_utc | datetime | Date recipent read the notification in UTC. | |
dismissed_date_utc | datetime | Date recipent dismissed (don't show me this again) the notification in UTC. | |
update_date_utc | 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_utc@recorded_event_KEY | staff_KEY, dismissed_date_utc, 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; |