Referrals


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
ActivitySchedule.ReferralId FK_dbo.ActivitySchedule_dbo.Referrals_ReferralIdC
AlertEvents.ReferralId FK_dbo.AlertEvents_dbo.Referrals_ReferralIdR
AuditRecords.ReferralId FK_dbo.AuditRecords_dbo.Referrals_ReferralIdR
BloodTestRanges.ReferralId FK_dbo.BloodTestRanges_dbo.Referrals_ReferralIdC
BreastReferrals.Id FK_dbo.BreastReferrals_dbo.Referrals_IdR
BreastSwitches.ReferralId FK_dbo.BreastSwitches_dbo.Referrals_ReferralIdC
ColorectalReferrals.Id FK_dbo.ColorectalReferrals_dbo.Referrals_IdR
Diagnosis.ReferralId FK_dbo.Diagnosis_dbo.Referrals_ReferralIdC
DocumentActions.ReferralId FK_dbo.DocumentActions_dbo.Referrals_ReferralIdC
DocumentExportMessages.ReferralId FK_dbo.DocumentExportMessages_dbo.Referrals_ReferralIdC
GynaecologyReferrals.Id FK_dbo.GynaecologyReferrals_dbo.Referrals_IdR
HaematologyReferrals.Id FK_dbo.HaematologyReferrals_dbo.Referrals_IdR
HeadAndNeckReferrals.Id FK_dbo.HeadAndNeckReferrals_dbo.Referrals_IdR
Investigations.ReferralId FK_dbo.Investigations_dbo.Referrals_ReferralIdC
LungReferrals.Id FK_dbo.LungReferrals_dbo.Referrals_IdR
ManualTimeLines.ReferralId FK_dbo.ManualTimeLines_dbo.Referrals_ReferralIdC
Notes.ReferralId FK_dbo.Notes_dbo.Referrals_ReferralIdC
ProstateReferrals.Id FK_dbo.ProstateReferrals_dbo.Referrals_IdR
ReferralMonitoringStatus.ReferralId FK_dbo.ReferralMonitoringStatus_dbo.Referrals_ReferralIdC
Reviews.ReferralID FK_dbo.Reviews_dbo.Referrals_ReferralIDC
SkinReferrals.Id FK_dbo.SkinReferrals_dbo.Referrals_IdR
TesticularReferrals.Id FK_dbo.TesticularReferrals_dbo.Referrals_IdR
Tests.Referral_Id FK_dbo.Tests_dbo.Referrals_Referral_IdR
ThyroidReferrals.Id FK_dbo.ThyroidReferrals_dbo.Referrals_IdR
UpperGIReferrals.Id FK_dbo.UpperGIReferrals_dbo.Referrals_IdR
UrologyReferrals.Id FK_dbo.UrologyIReferrals_dbo.Referrals_IdR
ViewAuditRecords.ReferralId FK_dbo.ViewAuditRecords_dbo.Referrals_ReferralIdR
PatientId int 4 null
Patients.Id FK_dbo.Referrals_dbo.Patients_PatientIdC
CancerSiteId int 4 null
scrCareId int 4 √ null
PPI nvarchar 40 √ null
DateRegisteredOnRM datetime 16,3 null
DateStartedRM datetime 16,3 null
DateDeleted datetime 16,3 √ null
ConsultantId int 4 √ null
Consultants.Id FK_dbo.Referrals_dbo.Consultants_ConsultantIdR
KeyWorkerId int 4 √ null
CNSs.Id FK_dbo.Referrals_dbo.CNSs_KeyWorkerIdR
CancerSubSiteId int 4 √ null
CancerSubSites.Id FK_dbo.Referrals_dbo.CancerSubSites_CancerSubSiteIdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Referrals Primary key Asc Id
IX_CancerSubSiteId Performance Asc CancerSubSiteId
IX_ConsultantId Performance Asc ConsultantId
IX_KeyWorkerId Performance Asc KeyWorkerId
IX_PatientId Performance Asc PatientId

Relationships

Close relationships within degrees of separation