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_utc | datetime | NOT NULL | |
create_date_utc | 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__Event_Class_Type__event_class_type_KEY | event_class_type_KEY | Event_Class_Type |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Monitored_Event_Action__Monitored_Event__monitored_event_KEY | monitored_event_KEY | Monitored_Event_Action |