Table: Alert_Level | |||||||||||
Tags: read-only Content:
| |||||||||||
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; |