AlertErrors


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
AlertId int 4 null
Alerts.Id FK_dbo.AlertErrors_dbo.Alerts_AlertIdC
AlertSettingsId int 4 null
AlertSettings.Id FK_dbo.AlertErrors_dbo.AlertSettings_AlertSettingsIdC
AlertEventId int 4 √ null
AlertEvents.Id FK_dbo.AlertErrors_dbo.AlertEvents_AlertEventIdR
RecordId int 4 √ null
AlertMessageId int 4 √ null
AlertMessages.Id FK_dbo.AlertErrors_dbo.AlertMessages_AlertMessageIdR
ErrorMessage nvarchar 1073741823 √ null
DateLogged datetime 16,3 ('1900-01-01T00:00:00.000')

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.AlertErrors Primary key Asc Id
IX_AlertEventId Performance Asc AlertEventId
IX_AlertId Performance Asc AlertId
IX_AlertMessageId Performance Asc AlertMessageId
IX_AlertSettingsId Performance Asc AlertSettingsId

Relationships

Close relationships within degrees of separation