Table: Monitored_Event_Action
Columns
NameTypeConstraintsDescription
monitored_event_action_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
monitored_event_KEYintNOT NULLKey to parent record.
email_staffbitNOT NULLIndicates whether all staff specified by this record should be emailed when the event occurs.
contact_email_KEYintSpecifes non-staff email address to notify when event occurs.
lookup_table_namenvarchar (128)NOT NULLTable that specifies entity to notify.
field_namenvarchar (128)NOT NULLField in table_name that specifies entity to notify.
row_KEYintOptional key value that specifies entity to notify.
Primary key
NameColumnsDescription
PK_Monitored_Event_Action$monitored_event_action_KEYmonitored_event_action_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Monitored_Event_Action$contact_email_KEYcontact_email_KEYIndex supports foreign key FK_Monitored_Event_Action__Contact_Email__contact_email_KEY
IX_Monitored_Event_Action$monitored_event_KEYmonitored_event_KEYIndex supports foreign key FK_Monitored_Event_Action__Monitored_Event__monitored_event_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Monitored_Event_Action__Contact_Email__contact_email_KEYcontact_email_KEYContact_Email
FK_Monitored_Event_Action__Monitored_Event__monitored_event_KEYmonitored_event_KEYMonitored_Event

Schema diagram