Table: Alert_Level
Tags: read-only Content:
1 | Critical
2 | Warning
3 | Alert
4 | Information
Columns
Name | Type | Constraints | Description
alert_level_KEY | int | NOT NULL | 1=Critical 2=Warning 3=Alert 4=Information
description | nvarchar (20) | NOT NULL | Name of alert level.

Primary key
Name | Columns | Description
PK_Alert_Level$alert_level_KEY | alert_level_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Alert_Level__description | description | Each description must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Monitored_Event__Alert_Level__alert_level_KEY | alert_level_KEY | Monitored_Event | on delete cascade;
FK_Recorded_Event__Alert_Level__alert_level_KEY | alert_level_KEY | Recorded_Event | on delete cascade;