AlertEvents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
AlertErrors.AlertEventId FK_dbo.AlertErrors_dbo.AlertEvents_AlertEventIdR
AlertEventMessages.EventId FK_dbo.AlertEventMessages_dbo.AlertEvents_EventIdC
SettingsId int 4 null
AlertSettings.Id FK_dbo.AlertEvents_dbo.AlertSettings_SettingsIdR
RecordId int 4 null
DateOfEvent datetime 16,3 √ null
StatusId int 4 null
AlertEventStatus.Id FK_dbo.AlertEvents_dbo.EventStatus_StatusIdC
AlertId int 4 ((0))
Alerts.Id FK_dbo.AlertEvents_dbo.Alerts_AlertIdR
ReferralId int 4 √ null
Referrals.Id FK_dbo.AlertEvents_dbo.Referrals_ReferralIdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.AlertEvents Primary key Asc Id
IX_AlertId Performance Asc AlertId
IX_ReferralId Performance Asc ReferralId
IX_SettingsId Performance Asc SettingsId
IX_StatusId Performance Asc StatusId

Relationships

Close relationships within degrees of separation