ReferralMonitoringStatus


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
ReferralId int 4 null
Referrals.Id FK_dbo.ReferralMonitoringStatus_dbo.Referrals_ReferralIdC
StatusId int 4 null
MonitoringStatus.Id FK_dbo.ReferralMonitoringStatus_dbo.MonitoringStatus_StatusIdC
Date datetime 16,3 null
ReasonChangedId int 4 √ null
MonitoringStatusChangedReasons.Id FK_dbo.ReferralMonitoringStatus_dbo.MonitoringStatusChangedReasons_ReasonChangedIdR
ReasonChangedOther nvarchar 2000 √ null
UserId nvarchar 1073741823 null
DateDeleted datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.ReferralMonitoringStatus Primary key Asc Id
IX_ReasonChangedId Performance Asc ReasonChangedId
IX_ReferralId Performance Asc ReferralId
IX_StatusId Performance Asc StatusId

Relationships

Close relationships within degrees of separation