Table: Monitored_Event
Columns
Name | Type | Constraints | Description
monitored_event_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned key for this table
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
event_type_KEY | int | NOT NULL | Key of the event type that's being monitored.
event_class_type_KEY | int | NOT NULL | Key of object type.
event_class_property_type_KEY | int |  | Key of property type for the given object type.
details | nvarchar (-1) | NOT NULL | XML blob with details about testing for the event that aren't practical to store in column form.
next_check_date | datetime |  | Date by which this event must be checked (if polled).
last_check_date | datetime |  |
recurrence_rule | nvarchar (-1) | NOT NULL | iCalendar expression for computing the next_check_date.
last_check_state | nvarchar (-1) | NOT NULL | XML blob with context-specific state information for state transition comparisons.
alert_level_KEY | int |  |

Primary key
Name | Columns | Description
PK_Monitored_Event$monitored_event_KEY | monitored_event_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Monitored_Event$alert_level_KEY | alert_level_KEY | Index supports foreign key FK_Monitored_Event__Alert_Level__alert_level_KEY
IX_Monitored_Event$event_class_property_type_KEY | event_class_property_type_KEY | Index supports foreign key FK_Monitored_Event__Event_Class_Property_Type__event_class_property_type_KEY
IX_Monitored_Event$event_class_type_KEY | event_class_type_KEY | Index supports foreign key FK_Monitored_Event__Event_Class_Type__event_class_type_KEY
IX_Monitored_Event$event_type_KEY | event_type_KEY | Index supports foreign key FK_Monitored_Event__Event_Type__event_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Monitored_Event__Alert_Level__alert_level_KEY | alert_level_KEY | Alert_Level | on delete cascade;
FK_Monitored_Event__Event_Class_Property_Type__event_class_property_type_KEY | event_class_property_type_KEY | Event_Class_Property_Type |
FK_Monitored_Event__Event_Class_Type__event_class_type_KEY | event_class_type_KEY | Event_Class_Type |
FK_Monitored_Event__Event_Type__event_type_KEY | event_type_KEY | Event_Type |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Monitored_Event_Action__Monitored_Event__monitored_event_KEY | monitored_event_KEY | Monitored_Event_Action |