Alerts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
AlertErrors.AlertId FK_dbo.AlertErrors_dbo.Alerts_AlertIdC
AlertEvents.AlertId FK_dbo.AlertEvents_dbo.Alerts_AlertIdR
AlertSettings.AlertId FK_dbo.AlertSettings_dbo.Alerts_AlertIdR
CancerSiteId int 4 null
CancerSites.Id FK_dbo.Alerts_dbo.CancerSites_CancerSiteIdC
TypeId int 4 null
AlertTypes.Id FK_dbo.Alerts_dbo.AlertTypes_TypeIdC
MethodId int 4 null
AlertMethods.Id FK_dbo.Alerts_dbo.AlertMethods_MethodIdC
RecipientId int 4 null
AlertRecipients.Id FK_dbo.Alerts_dbo.AlertRecipients_RecipientIdC
DateComparisonId int 4 √ null
DateComparisons.Id FK_dbo.Alerts_dbo.DateComparisons_DateComparisonIdR
Active bit 1 null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Alerts Primary key Asc Id
IX_CancerSiteId Performance Asc CancerSiteId
IX_DateComparisonId Performance Asc DateComparisonId
IX_MethodId Performance Asc MethodId
IX_RecipientId Performance Asc RecipientId
IX_TypeId Performance Asc TypeId

Relationships

Close relationships within degrees of separation