AlertValue


Description

Alert threshold values storing specific threshold values and parameters for alert condition evaluation. This table manages the numeric values, thresholds, and parameters used in alert calculations and condition checking for automated alert triggering.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null

Primary key - Unique identifier for each alert value record

AlertReportConfigId int 4 null
AlertReportConfig.Id FK_AlertValue_AlertReportConfig R

Alert config reference - Links to AlertReportConfig for the associated alert configuration

Value int 4 null

Threshold value - Numeric value used for alert condition evaluation

CreatedDate datetime 16,3 null

Creation timestamp - Date and time when the alert value was created

Indexes

Constraint Name Type Sort Column(s)
PK_AlertValue Primary key Asc Id

Relationships