Table: Monitored_Event
Columns
NameTypeConstraintsDescription
monitored_event_KEYintNOT NULLAUTO-INCREMENT: Database assigned key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
event_type_KEYintNOT NULLKey of the event type that's being monitored.
event_class_type_KEYintNOT NULLKey of object type.
event_class_property_type_KEYintKey of property type for the given object type.
detailsnvarchar (-1)NOT NULLXML blob with details about testing for the event that aren't practical to store in column form.
next_check_datedatetimeDate by which this event must be checked (if polled).
last_check_datedatetime
recurrence_rulenvarchar (-1)NOT NULLiCalendar expression for computing the next_check_date.
last_check_statenvarchar (-1)NOT NULLXML blob with context-specific state information for state transition comparisons.
alert_level_KEYint
Primary key
NameColumnsDescription
PK_Monitored_Event$monitored_event_KEYmonitored_event_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Monitored_Event$alert_level_KEYalert_level_KEYIndex supports foreign key FK_Monitored_Event__Alert_Level__alert_level_KEY
IX_Monitored_Event$event_class_property_type_KEYevent_class_property_type_KEYIndex supports foreign key FK_Monitored_Event__Event_Class_Property_Type__event_class_property_type_KEY
IX_Monitored_Event$event_class_type_KEYevent_class_type_KEYIndex supports foreign key FK_Monitored_Event__Event_Class_Type__event_class_type_KEY
IX_Monitored_Event$event_type_KEYevent_type_KEYIndex supports foreign key FK_Monitored_Event__Event_Type__event_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Monitored_Event__Event_Class_Type__event_class_type_KEYevent_class_type_KEYEvent_Class_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Monitored_Event_Action__Monitored_Event__monitored_event_KEYmonitored_event_KEYMonitored_Event_Action

Schema diagram