Table: Alert_Level
Tags: read-only

Content:
1Critical
2Warning
3Alert
4Information
Columns
NameTypeConstraintsDescription
alert_level_KEYintNOT NULL1=Critical
2=Warning
3=Alert
4=Information
descriptionnvarchar (20)NOT NULLName of alert level.
Primary key
NameColumnsDescription
PK_Alert_Level$alert_level_KEYalert_level_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Alert_Level__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Monitored_Event__Alert_Level__alert_level_KEYalert_level_KEYMonitored_Eventon delete cascade;
FK_Recorded_Event__Alert_Level__alert_level_KEYalert_level_KEYRecorded_Eventon delete cascade;

Schema diagram