Constraints

245 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_dbo.SystemAreaAudit_dbo.AuditActions_ActionId
SystemAudit.ActionId
AuditActions.Id
Cascade on delete
FK_dbo.SystemAreaAudit_dbo.SystemAreas_SystemAreaId
SystemAudit.SystemAreaId
SystemAreas.Id
Cascade on delete
FK_dbo.BloodTestResults_dbo.Investigations_InvestigationId
BloodTestResults.InvestigationId
Investigations.Id
Cascade on delete
FK_dbo.BloodTestResults_dbo.BloodTestPanels_TestPanelId
BloodTestResults.TestPanelId
BloodTestPanels.Id
Restrict delete
FK_dbo.BloodTestResults_dbo.ResultOperators_ResultOperatorId
BloodTestResults.OperatorId
ResultOperators.Id
Restrict delete
FK_dbo.BloodTestResults_dbo.ResultOutcomes_ResultOutcomeId
BloodTestResults.OutcomeId
ResultOutcomes.Id
Restrict delete
FK_dbo.LibraryFiles_dbo.CancerSites_CancerSiteId
LibraryFiles.CancerSiteId
CancerSites.Id
Cascade on delete
FK_dbo.SNOMEDICD10Link_dbo.ICD10_ICD10Id
SNOMEDICD10Link.ICD10Id
ICD10.Id
Cascade on delete
FK_dbo.SNOMEDICD10Link_dbo.SNOMEDDiagnosis_SNOMEDDiagnosisId
SNOMEDICD10Link.SNOMEDDiagnosisId
SNOMEDDiagnosis.Id
Cascade on delete
FK_dbo.GynaecologyReferrals_dbo.Referrals_Id
GynaecologyReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.InvestigationActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id
InvestigationActivityTemplateSchedule.Id
ActivityTemplateSchedule.Id
Restrict delete
FK_dbo.InvestigationActivityTemplateSchedule_dbo.InvestigationTypes_InvestigationTypeId
InvestigationActivityTemplateSchedule.InvestigationTypeId
InvestigationTypes.Id
Cascade on delete
FK_dbo.ManualTimeLines_dbo.Referrals_ReferralId
ManualTimeLines.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.CEAThresholdLevels_dbo.ColorectalReferrals_ReferralId
_Deprecated_21_01_CEAThresholdLevels.ReferralId
ColorectalReferrals.Id
Restrict delete
FK_dbo.BloodTestUnitAssociations_dbo.BloodTests_TestId
BloodTestUnitAssociations.TestId
BloodTests.Id
Cascade on delete
FK_dbo.BloodTestUnitAssociations_dbo.UnitOfMeasurements_UnitId
BloodTestUnitAssociations.UnitId
UnitOfMeasurements.Id
Cascade on delete
FK_dbo.ThyroidStaging_dbo.Staging_DiagnosisId
ThyroidStaging.DiagnosisId
Staging.DiagnosisId
Restrict delete
FK_dbo.ICD10_dbo.ICD10Group_ICD10GroupId
ICD10.ICD10GroupId
ICD10Group.Id
Cascade on delete
FK_dbo.AlertMessages_dbo.AlertStatus_StatusId
AlertMessages.StatusId
AlertStatus.Id
Cascade on delete
FK_dbo.MDTDiscussionActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id
MDTDiscussionActivityTemplateSchedule.Id
ActivityTemplateSchedule.Id
Restrict delete
FK_dbo.LabTestPanelAssociations_dbo.LabTests_TestId
_Deprecated_21_01_LabTestPanelAssociations.TestId
_Deprecated_21_01_LabTests.Id
Cascade on delete
FK_dbo.LabTestPanelAssociations_dbo.LabTestPanels_PanelId
_Deprecated_21_01_LabTestPanelAssociations.PanelId
_Deprecated_21_01_LabTestPanels.Id
Cascade on delete
FK_dbo.BloodTestRangeTypeDefinitions_dbo.CancerSites_CancerSiteId
BloodTestRangeTypeDefinitions.CancerSiteId
CancerSites.Id
Cascade on delete
FK_dbo.BloodTestRangeTypeDefinitions_dbo.BloodTests_BloodTestId
BloodTestRangeTypeDefinitions.BloodTestId
BloodTests.Id
Cascade on delete
FK_dbo.DiagnosisMets_dbo.Diagnosis_DiagnosisId
DiagnosisMets.DiagnosisId
Diagnosis.Id
Cascade on delete
FK_dbo.DiagnosisMets_dbo.MetsLocations_MetsLocationId
DiagnosisMets.LocationId
MetsLocations.Id
Restrict delete
FK_dbo.DiagnosisMets_dbo.MetsCertainties_MetsCertaintyId
DiagnosisMets.CertaintyId
MetsCertainties.Id
Restrict delete
FK_dbo.DiagnosisMets_dbo.MetsTypes_MetsTypeId
DiagnosisMets.TypeId
MetsTypes.Id
Restrict delete
FK_dbo.Patients_dbo.Titles_TitleId
Patients.TitleId
Titles.Id
Restrict delete
FK_dbo.Patients_dbo.Ethnicities_EthnicityId
Patients.EthnicityId
Ethnicities.Id
Restrict delete
FK_dbo.Patients_dbo.GPs_RegisteredGPId
Patients.RegisteredGPId
GPs.Id
Restrict delete
FK_dbo.Patients_dbo.PatientNotificationSMS_NotificationSMSId
Patients.NotificationSMSId
PatientNotificationSMS.Id
Restrict delete
FK_dbo.Patients_dbo.Practices_RegisteredPracticeId
Patients.RegisteredPracticeId
Practices.Id
Restrict delete
FK_dbo.Patients_dbo.NhsNumberStatus_NhsNumberStatusId
Patients.NhsNumberStatusId
NhsNumberStatus.Id
Cascade on delete
FK_dbo.Patients_dbo.Genders_GenderId
Patients.GenderId
Genders.Id
Restrict delete
FK_dbo.AuditRecords_dbo.AuditActions_ActionId
AuditRecords.ActionId
AuditActions.Id
Cascade on delete
FK_dbo.AuditRecords_dbo.RecordTypes_RecordTypeId
AuditRecords.RecordTypeId
RecordTypes.Id
Cascade on delete
FK_dbo.AuditRecords_dbo.Referrals_ReferralId
AuditRecords.ReferralId
Referrals.Id
Restrict delete
FK_dbo.MDTDiscussionActivitySchedule_dbo.ActivitySchedule_Id
MDTDiscussionActivitySchedule.Id
ActivitySchedule.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.TNM_N_Letter_TNM_Rad_NLetterId
BreastInvestigationResults.TNM_Rad_NLetterId
TNM_N_Letter.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.TNM_T_Letter_TNM_Rad_TLetterId
BreastInvestigationResults.TNM_Rad_TLetterId
TNM_T_Letter.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.TNM_M_Letter_TNM_Rad_MLetterId
BreastInvestigationResults.TNM_Rad_MLetterId
TNM_M_Letter.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.BreastSides_SideId
BreastInvestigationResults.SideId
BreastSides.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.TNMEditions_TNMRadEdition_Id
BreastInvestigationResults.TNM_Rad_EditionId
TNMEditions.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.Investigations_InvestigationId
BreastInvestigationResults.InvestigationId
Investigations.Id
Cascade on delete
FK_dbo.BreastInvestigationResults_dbo.BreastSites_SiteId
BreastInvestigationResults.SiteId
BreastSites.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.TNM_T_Value_TNM_Rad_TValueId
BreastInvestigationResults.TNM_Rad_TValueId
TNM_T_Value.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.TNM_M_Value_TNM_Rad_MValueId
BreastInvestigationResults.TNM_Rad_MValueId
TNM_M_Value.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.TNM_N_Value_TNM_Rad_NValueId
BreastInvestigationResults.TNM_Rad_NValueId
TNM_N_Value.Id
Restrict delete
FK_dbo.BreastInvestigationResults_dbo.TNMVersions_TNMRadVersion_Id
BreastInvestigationResults.TNM_Rad_VersionId
TNMVersions.Id
Restrict delete
FK_dbo.ColorectalStaging_dbo.ModifiedDukes_ModifiedDukesId
ColorectalStaging.ModifiedDukesId
ModifiedDukes.Id
Restrict delete
FK_dbo.ColorectalStaging_dbo.Staging_DiagnosisId
ColorectalStaging.DiagnosisId
Staging.DiagnosisId
Restrict delete
FK_dbo.DocumentExportMessages_dbo.DocumentExportMessageStatusTypes_StatusTypeId
DocumentExportMessages.StatusTypeId
DocumentExportMessageStatusTypes.Id
Cascade on delete
FK_dbo.DocumentExportMessages_dbo.LibraryFiles_LibraryFileId
DocumentExportMessages.LibraryFileId
LibraryFiles.Id
Cascade on delete
FK_dbo.DocumentExportMessages_dbo.AspNetUsers_UserId
DocumentExportMessages.UserId
AspNetUsers.Id
Restrict delete
FK_dbo.DocumentExportMessages_dbo.Referrals_ReferralId
DocumentExportMessages.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.BloodTestRanges_dbo.BloodTests_BloodTestId
BloodTestRanges.BloodTestId
BloodTests.Id
Cascade on delete
FK_dbo.BloodTestRanges_dbo.UnitOfMeasurements_UnitId
BloodTestRanges.UnitId
UnitOfMeasurements.Id
Cascade on delete
FK_dbo.BloodTestRanges_dbo.Referrals_ReferralId
BloodTestRanges.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.LibraryResource_dbo.LibraryFiles_Id
LibraryResource.Id
LibraryFiles.Id
Restrict delete
FK_dbo.LungReferrals_dbo.Referrals_Id
LungReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.PortalMessages_dbo.PortalTriggerSources_TriggerSourceId
PortalMessages.TriggerSourceId
PortalTriggerSources.Id
Cascade on delete
FK_dbo.PortalMessages_dbo.PortalMessageTypes_MessageTypeId
PortalMessages.MessageTypeId
PortalMessageTypes.Id
Cascade on delete
FK_dbo.PortalMessages_dbo.PortalMessageStatuses_StatusId
PortalMessages.StatusId
PortalMessageStatuses.Id
Restrict delete
FK_dbo.LabTests_dbo.CancerSites_ThresholdForSite_Id
_Deprecated_21_01_LabTests.ThresholdForSite_Id
CancerSites.Id
Restrict delete
FK_dbo.ProstateReferrals_dbo.Referrals_Id
ProstateReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.DemographicInterfaceMessages_dbo.MessageStatus_StatusId
DemographicInterfaceMessages.StatusId
MessageStatus.Id
Cascade on delete
FK_dbo.PracticeGPAssociations_dbo.GPs_GPId
PracticeGPAssociations.GPId
GPs.Id
Cascade on delete
FK_dbo.PracticeGPAssociations_dbo.Practices_PracticeId
PracticeGPAssociations.PracticeId
Practices.Id
Cascade on delete
FK_dbo.ReviewContacts_dbo.Reviews_ReviewId
ReviewContacts.ReviewId
Reviews.Id
Cascade on delete
FK_dbo.ReviewContacts_dbo.ReviewContactTypes_ContactTypeId
ReviewContacts.ContactTypeId
ReviewContactTypes.Id
Restrict delete
FK_dbo.AlertSettings_dbo.Alerts_AlertId
AlertSettings.AlertId
Alerts.Id
Restrict delete
FK_dbo.BreastReferrals_dbo.Referrals_Id
BreastReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.ReviewInvesitgationTypes_dbo.InvestigationTypes_InvestigationTypeId
ReviewInvestigationTypes.InvestigationTypeId
InvestigationTypes.Id
Cascade on delete
FK_dbo.ReviewInvesitgationTypes_dbo.Reviews_ReviewId
ReviewInvestigationTypes.ReviewId
Reviews.Id
Cascade on delete
FK_dbo.Referrals_dbo.CancerSubSites_CancerSubSiteId
Referrals.CancerSubSiteId
CancerSubSites.Id
Restrict delete
FK_dbo.Referrals_dbo.Consultants_ConsultantId
Referrals.ConsultantId
Consultants.Id
Restrict delete
FK_dbo.Referrals_dbo.Patients_PatientId
Referrals.PatientId
Patients.Id
Cascade on delete
FK_dbo.Referrals_dbo.CNSs_KeyWorkerId
Referrals.KeyWorkerId
CNSs.Id
Restrict delete
FK_dbo.ReferenceDataAudit_dbo.AspNetUsers_UserId
ReferenceDataAudit.UserId
AspNetUsers.Id
Restrict delete
FK_dbo.BloodTestPanelAssociations_dbo.BloodTests_TestId
BloodTestPanelAssociations.TestId
BloodTests.Id
Cascade on delete
FK_dbo.BloodTestPanelAssociations_dbo.BloodTestPanels_PanelId
BloodTestPanelAssociations.PanelId
BloodTestPanels.Id
Cascade on delete
FK_dbo.UserAdminAuditRecords_dbo.UserAdminAuditActions_ActionId
UserAdminAudit.ActionId
UserAdminAuditActions.Id
Cascade on delete
FK_dbo.Tests_dbo.Referrals_Referral_Id
Tests.Referral_Id
Referrals.Id
Restrict delete
FK_dbo.ActivitySchedule_dbo.ActivityScheduleClosedReasons_ActivityScheduleClosedReasonId
ActivitySchedule.ActivityScheduleClosedReasonId
ActivityScheduleClosedReasons.Id
Restrict delete
FK_dbo.ActivitySchedule_dbo.ActivityTimeSpanTypes_RecurrenceTimeSpanTypeId
ActivitySchedule.RecurrenceTimeSpanTypeId
ActivityTimeSpanTypes.Id
Restrict delete
FK_dbo.ActivitySchedule_dbo.ActivityTemplates_ActivityTemplateId
ActivitySchedule.ActivityTemplateId
ActivityTemplates.Id
Restrict delete
FK_dbo.ActivitySchedule_dbo.ActivityScheduleStatusTypes_StatusTypeId
ActivitySchedule.StatusTypeId
ActivityScheduleStatusTypes.Id
Cascade on delete
FK_dbo.ActivitySchedule_dbo.Referrals_ReferralId
ActivitySchedule.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.ActivitySchedule_dbo.ActivityTimeSpanTypes_DurationTimeSpanTypeId
ActivitySchedule.DurationTimeSpanTypeId
ActivityTimeSpanTypes.Id
Restrict delete
FK_dbo.Notes_dbo.Referrals_ReferralId
Notes.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.ColorectalReferrals_dbo.Referrals_Id
ColorectalReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId
AspNetUserLogins.UserId
AspNetUsers.Id
Cascade on delete
FK_dbo.DemographicInterfaceMessageAmendments_dbo.AmendmentFields_AmendmentFieldId
DemographicInterfaceMessageAmendments.AmendmentFieldId
AmendmentFields.Id
Restrict delete
FK_dbo.DemographicInterfaceMessageAmendments_dbo.DemographicInterfaceMessages_MessageId
DemographicInterfaceMessageAmendments.MessageId
DemographicInterfaceMessages.Id
Cascade on delete
FK_dbo.Activities_dbo.ActivityStatusTypes_ActivityStatusId
Activities.ActivityStatusId
ActivityStatusTypes.Id
Cascade on delete
FK_dbo.Activities_dbo.ActivitySchedule_ActivityScheduleId
Activities.ActivityScheduleId
ActivitySchedule.Id
Cascade on delete
FK_dbo.ActivityTemplateSchedule_dbo.ActivityTimeSpanTypes_DurationTimeSpanTypeId
ActivityTemplateSchedule.DurationTimeSpanTypeId
ActivityTimeSpanTypes.Id
Restrict delete
FK_dbo.ActivityTemplateSchedule_dbo.ActivityTemplates_ActivityTemplateId
ActivityTemplateSchedule.ActivityTemplateId
ActivityTemplates.Id
Cascade on delete
FK_dbo.ActivityTemplateSchedule_dbo.ActivityTimeSpanTypes_RecurrenceTimeSpanTypeId
ActivityTemplateSchedule.RecurrenceTimeSpanTypeId
ActivityTimeSpanTypes.Id
Restrict delete
FK_dbo.AspNetUsers_dbo.UserJobRoles_JobRoleId
AspNetUsers.JobRoleId
UserJobRoles.Id
Restrict delete
FK_dbo.AspNetUsers_dbo.Organisations_OrganisationId
AspNetUsers.OrganisationId
Organisations.Id
Restrict delete
FK_dbo.HaematologyReferrals_dbo.Referrals_Id
HaematologyReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.TumourMarkerResultsDefined_dbo.UnitOfMeasurements_UnitId
_Deprecated_21_01_TumourMarkerResultsDefined.UnitId
UnitOfMeasurements.Id
Restrict delete
FK_dbo.TumourMarkerResultsDefined_dbo.TumourMarkerResults_Id
_Deprecated_21_01_TumourMarkerResultsDefined.Id
_Deprecated_21_01_TumourMarkerResults.Id
Restrict delete
FK_dbo.TumourMarkerResultsDefined_dbo.TumourMarkers_TumourMarkerId
_Deprecated_21_01_TumourMarkerResultsDefined.TumourMarkerId
_Deprecated_21_01_TumourMarkers.Id
Cascade on delete
FK_dbo._Deprecated_20_03_PatientPreferredContact_dbo.Patients_PatientId
_Deprecated_20_03_PatientPreferredContact.PatientId
Patients.Id
Restrict delete
FK_dbo.ViewAuditRecords_dbo.RecordTypes_RecordTypeId
ViewAuditRecords.RecordTypeId
RecordTypes.Id
Restrict delete
FK_dbo.ViewAuditRecords_dbo.Referrals_ReferralId
ViewAuditRecords.ReferralId
Referrals.Id
Restrict delete
FK_dbo.HNAActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id
HNAActivityTemplateSchedule.Id
ActivityTemplateSchedule.Id
Restrict delete
FK_dbo.ClinicalReviewActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id
ClinicalReviewActivityTemplateSchedule.Id
ActivityTemplateSchedule.Id
Restrict delete
FK_dbo.ReferralMonitoringStatus_dbo.Referrals_ReferralId
ReferralMonitoringStatus.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.ReferralMonitoringStatus_dbo.MonitoringStatusChangedReasons_ReasonChangedId
ReferralMonitoringStatus.ReasonChangedId
MonitoringStatusChangedReasons.Id
Restrict delete
FK_dbo.ReferralMonitoringStatus_dbo.MonitoringStatus_StatusId
ReferralMonitoringStatus.StatusId
MonitoringStatus.Id
Cascade on delete
FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId
AspNetUserClaims.UserId
AspNetUsers.Id
Cascade on delete
FK_dbo.PortalRegistrationAuditRecords_dbo.Patients_PatientId
PortalRegistrationAuditRecords.PatientId
Patients.Id
Cascade on delete
FK_dbo.BreastSwitchActivitySchedule_dbo.ActivitySchedule_Id
BreastSwitchActivitySchedule.Id
ActivitySchedule.Id
Restrict delete
FK_dbo.UpperGIReferrals_dbo.Referrals_Id
UpperGIReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.TumourMarkerResultsOther_dbo.TumourMarkerResults_Id
_Deprecated_21_01_TumourMarkerResultsOther.Id
_Deprecated_21_01_TumourMarkerResults.Id
Restrict delete
FK_dbo.TesticularReferrals_dbo.Referrals_Id
TesticularReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.BloodTestResultOther_dbo.BloodTestResults_Id
BloodTestResultOther.Id
BloodTestResults.Id
Restrict delete
FK_dbo.ReviewOutcomeRecipients_dbo.OutcomeRecipients_ReviewOutcomeRecipientId
ReviewOutcomeRecipients.ReviewOutcomeRecipientId
OutcomeRecipients.Id
Cascade on delete
FK_dbo.ReviewOutcomeRecipients_dbo.Reviews_ReviewId
ReviewOutcomeRecipients.ReviewId
Reviews.Id
Cascade on delete
FK_dbo.ColorectalSynchronousTumourSites_dbo.SynchronousTumourSites_SynchronousTumourSiteId
ColorectalSynchronousTumourSites.SynchronousTumourSiteId
SynchronousTumourSites.Id
Cascade on delete
FK_dbo.ColorectalSynchronousTumourSites_dbo.ColorectalStaging_ColorectalStagingId
ColorectalSynchronousTumourSites.ColorectalStagingId
ColorectalStaging.DiagnosisId
Restrict delete
FK_dbo.LibraryLetterTemplate_dbo.LibraryFiles_Id
LibraryTemplate.Id
LibraryFiles.Id
Restrict delete
FK_dbo.TumourMarkerResults_dbo.Investigations_InvestigationId
_Deprecated_21_01_TumourMarkerResults.InvestigationId
Investigations.Id
Cascade on delete
FK_dbo.TumourMarkerResults_dbo.ResultOperators_OperatorId
_Deprecated_21_01_TumourMarkerResults.OperatorId
ResultOperators.Id
Restrict delete
FK_dbo.TumourMarkerResults_dbo.ResultOutcomes_OutcomeId
_Deprecated_21_01_TumourMarkerResults.OutcomeId
ResultOutcomes.Id
Restrict delete
FK_dbo.HNAActivitySchedule_dbo.ActivitySchedule_Id
HNAActivitySchedule.Id
ActivitySchedule.Id
Restrict delete
FK_dbo.BreastSwitchActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id
BreastSwitchActivityTemplateSchedule.Id
ActivityTemplateSchedule.Id
Restrict delete
FK_dbo.UserPermissions_dbo.UserPermissionLevels_UserPermissionLevelId
UserPermissions.UserPermissionLevelId
UserPermissionLevels.Id
Restrict delete
FK_dbo.UserPermissions_dbo.UserPermissionSections_SectionId
UserPermissions.SectionId
UserPermissionSections.Id
Cascade on delete
FK_dbo.UserPermissions_dbo.CancerSites_CancerSiteId
UserPermissions.CancerSiteId
CancerSites.Id
Cascade on delete
FK_dbo.UserPermissions_dbo.AspNetUsers_UserId
UserPermissions.UserId
AspNetUsers.Id
Cascade on delete
FK_dbo.AlertEventMessages_dbo.AlertMessages_MessageId
AlertEventMessages.MessageId
AlertMessages.Id
Cascade on delete
FK_dbo.AlertEventMessages_dbo.AlertEvents_EventId
AlertEventMessages.EventId
AlertEvents.Id
Cascade on delete
FK_dbo.SkinReferrals_dbo.Referrals_Id
SkinReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.Consultants_dbo.ConsultantTitles_TitleId
Consultants.TitleId
ConsultantTitles.Id
Restrict delete
FK_dbo.LabTestResultOther_dbo.LabTestResults_Id
_Deprecated_21_01_LabTestResultOther.Id
_Deprecated_21_01_LabTestResults.Id
Restrict delete
FK_dbo.CancerSubSites_dbo.CancerSites_CancerSiteId
CancerSubSites.CancerSiteId
CancerSites.Id
Cascade on delete
FK_dbo.BreastStaging_dbo.NPIPrognosis_NPIPrognosisId
BreastStaging.NPIPrognosisId
NPIPrognosis.Id
Restrict delete
FK_dbo.BreastStaging_dbo.MenopausalStatus_MenopausalStatusId
BreastStaging.MenopausalStatusId
MenopausalStatus.Id
Restrict delete
FK_dbo.BreastStaging_dbo.Staging_DiagnosisId
BreastStaging.DiagnosisId
Staging.DiagnosisId
Restrict delete
FK_dbo.BreastStaging_dbo.LymphNodeScores_LymphNodeScoreId
BreastStaging.LymphNodeScoreId
LymphNodeScores.Id
Restrict delete
FK_dbo.BreastStaging_dbo.TumourGrades_TumourGradeId
BreastStaging.TumourGradeId
TumourGrades.Id
Restrict delete
FK_dbo.CancerSiteSettings_dbo.TimelineEventStartDateTypes_TimelineEventStartDateTypeId
CancerSiteSettings.TimelineEventStartDateTypeId
TimelineEventStartDateTypes.Id
Cascade on delete
FK_dbo.CancerSiteSettings_dbo.CancerSites_CancerSiteId
CancerSiteSettings.CancerSiteId
CancerSites.Id
Cascade on delete
FK_dbo.CancerSiteSettings_dbo.BloodTests_PrincipalTumourMarkerId
CancerSiteSettings.PrincipalTumourMarkerId
BloodTests.Id
Restrict delete
FK_dbo.Reviews_dbo.Referrals_ReferralID
Reviews.ReferralID
Referrals.Id
Cascade on delete
FK_dbo.Reviews_dbo.Activities_ActivityId
Reviews.ActivityId
Activities.Id
Restrict delete
FK_dbo.Reviews_dbo.Organisations_OrganisationId
Reviews.OrganisationId
Organisations.Id
Restrict delete
FK_dbo.Reviews_dbo.CNSs_CareProfessionalId
Reviews.CareProfessionalId
CNSs.Id
Restrict delete
FK_dbo.Reviews_dbo.ReviewOutcomes_OutcomeId
Reviews.OutcomeId
ReviewOutcomes.Id
Restrict delete
FK_dbo.ClinicalReviewActivitySchedule_dbo.ActivitySchedule_Id
ClinicalReviewActivitySchedule.Id
ActivitySchedule.Id
Restrict delete
FK_dbo.Diagnosis_dbo.Consultants_ConsultantAtDiagnosisId
Diagnosis.ConsultantAtDiagnosisId
Consultants.Id
Restrict delete
FK_dbo.Diagnosis_dbo.Organisations_OrganisationId
Diagnosis.OrganisationId
Organisations.Id
Restrict delete
FK_dbo.Diagnosis_dbo.Referrals_ReferralId
Diagnosis.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.Diagnosis_dbo.BasisOfDiagnosis_BasisOfDiagnosisId
Diagnosis.BasisOfDiagnosisId
BasisOfDiagnosis.Id
Restrict delete
FK_dbo.Diagnosis_dbo.SNOMEDMorphologies_SNOMEDMorphologyId
Diagnosis.SNOMEDMorphologyId
SNOMEDMorphologies.Id
Restrict delete
FK_dbo.Diagnosis_dbo.TumourStatus_TumourStatusId
Diagnosis.TumourStatusId
TumourStatus.Id
Restrict delete
FK_dbo.Diagnosis_dbo.CNSIndicationCodes_CNSIndicationCodeId
Diagnosis.CNSIndicationCodeId
CNSIndicationCodes.Id
Restrict delete
FK_dbo.Diagnosis_dbo.SNOMED_CT_MorphologyId
Diagnosis.MorphologyId
SNOMED_CT.Id
Restrict delete
FK_dbo.Diagnosis_dbo.ICD10_ICD10Id
Diagnosis.ICD10Id
ICD10.Id
Restrict delete
FK_dbo.Diagnosis_dbo.ICD10Group_ICD10GroupId
Diagnosis.ICD10GroupId
ICD10Group.Id
Restrict delete
FK_dbo.Diagnosis_dbo.Lateralities_LateralityId
Diagnosis.LateralityId
Lateralities.Id
Restrict delete
FK_dbo.Diagnosis_dbo.GradesOfDifferentiation_GradeOfDifferentiationId
Diagnosis.GradeOfDifferentiationId
GradesOfDifferentiation.Id
Restrict delete
FK_dbo.Diagnosis_dbo.SNOMEDDiagnosis_SNOMEDDiagnosisId
Diagnosis.SNOMEDDiagnosisId
SNOMEDDiagnosis.Id
Restrict delete
FK_dbo.TesticularStaging_dbo.Staging_DiagnosisId
TesticularStaging.DiagnosisId
Staging.DiagnosisId
Restrict delete
FK_dbo.Staging_dbo.TNMVersions_TNMVersion_Id
Staging.TNMVersion_Id
TNMVersions.Id
Restrict delete
FK_dbo.Staging_dbo.TNMGroupings_TNM_FI_TNMGroupingId
Staging.TNM_FI_TNMGroupingId
TNMGroupings.Id
Restrict delete
FK_dbo.Staging_dbo.TNMEditions_TNMEdition_Id
Staging.TNMEdition_Id
TNMEditions.Id
Restrict delete
FK_dbo.Staging_dbo.Diagnosis_DiagnosisId
Staging.DiagnosisId
Diagnosis.Id
Restrict delete
FK_dbo.Staging_dbo.TNM_M_Letter_TNM_FI_MLetterId
Staging.TNM_FI_MLetterId
TNM_M_Letter.Id
Restrict delete
FK_dbo.Staging_dbo.Organisations_TNM_FI_OrganisationId
Staging.TNM_FI_OrganisationId
Organisations.Id
Restrict delete
FK_dbo.Staging_dbo.TNM_T_Letter_TNM_FI_TLetterId
Staging.TNM_FI_TLetterId
TNM_T_Letter.Id
Restrict delete
FK_dbo.Staging_dbo.TNM_M_Value_TNM_FI_MValueId
Staging.TNM_FI_MValueId
TNM_M_Value.Id
Restrict delete
FK_dbo.Staging_dbo.TNM_N_Letter_TNM_FI_NLetterId
Staging.TNM_FI_NLetterId
TNM_N_Letter.Id
Restrict delete
FK_dbo.Staging_dbo.TNM_N_Value_TNM_FI_NValueId
Staging.TNM_FI_NValueId
TNM_N_Value.Id
Restrict delete
FK_dbo.Staging_dbo.TNM_T_Value_TNM_FI_TValueId
Staging.TNM_FI_TValueId
TNM_T_Value.Id
Restrict delete
FK_dbo.Alerts_dbo.AlertTypes_TypeId
Alerts.TypeId
AlertTypes.Id
Cascade on delete
FK_dbo.Alerts_dbo.DateComparisons_DateComparisonId
Alerts.DateComparisonId
DateComparisons.Id
Restrict delete
FK_dbo.Alerts_dbo.AlertRecipients_RecipientId
Alerts.RecipientId
AlertRecipients.Id
Cascade on delete
FK_dbo.Alerts_dbo.AlertMethods_MethodId
Alerts.MethodId
AlertMethods.Id
Cascade on delete
FK_dbo.Alerts_dbo.CancerSites_CancerSiteId
Alerts.CancerSiteId
CancerSites.Id
Cascade on delete
FK_dbo.DemographicInterfaceMessageErrors_dbo.DemographicInterfaceMessages_MessageId
DemographicInterfaceMessageErrors.MessageId
DemographicInterfaceMessages.Id
Cascade on delete
FK_dbo.DemographicInterfaceMessageErrors_dbo.Severities_SeverityId
DemographicInterfaceMessageErrors.SeverityId
Severities.Id
Cascade on delete
FK_dbo.LabTestResults_dbo.LabTestPanels_PanelId
_Deprecated_21_01_LabTestResults.PanelId
_Deprecated_21_01_LabTestPanels.Id
Restrict delete
FK_dbo.LabTestResults_dbo.ResultOperators_ResultOperatorId
_Deprecated_21_01_LabTestResults.ResultOperatorId
ResultOperators.Id
Restrict delete
FK_dbo.LabTestResults_dbo.ResultOutcomes_ResultOutcomeId
_Deprecated_21_01_LabTestResults.ResultOutcomeId
ResultOutcomes.Id
Restrict delete
FK_dbo.LabTestResults_dbo.Investigations_InvestigationId
_Deprecated_21_01_LabTestResults.InvestigationId
Investigations.Id
Cascade on delete
FK_dbo.InvestigationReviewStatuses_dbo.Investigations_InvestigationId
InvestigationReviewStatuses.InvestigationId
Investigations.Id
Cascade on delete
FK_dbo.LabTestResultDefined_dbo.LabTestResults_Id
_Deprecated_21_01_LabTestResultDefined.Id
_Deprecated_21_01_LabTestResults.Id
Restrict delete
FK_dbo.LabTestResultDefined_dbo.LabTests_LabTestId
_Deprecated_21_01_LabTestResultDefined.LabTestId
_Deprecated_21_01_LabTests.Id
Cascade on delete
FK_dbo.ProstateStaging_dbo.Staging_DiagnosisId
ProstateStaging.DiagnosisId
Staging.DiagnosisId
Restrict delete
FK_dbo.ProstateStaging_dbo.GleasonTertiaryScores_FinalGleasonTertiaryScoreId
ProstateStaging.FinalGleasonTertiaryScoreId
GleasonTertiaryScores.Id
Restrict delete
FK_dbo.DocumentActions_dbo.LibraryFiles_LibraryFileId
DocumentActions.LibraryFileId
LibraryFiles.Id
Restrict delete
FK_dbo.DocumentActions_dbo.Referrals_ReferralId
DocumentActions.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.TumourMarkers_dbo.UnitOfMeasurements_UnitId
_Deprecated_21_01_TumourMarkers.UnitId
UnitOfMeasurements.Id
Restrict delete
FK_dbo.TumourMarkers_dbo.CancerSites_ThresholdForSite_Id
_Deprecated_21_01_TumourMarkers.ThresholdForSite_Id
CancerSites.Id
Restrict delete
FK_dbo.AlertErrors_dbo.Alerts_AlertId
AlertErrors.AlertId
Alerts.Id
Cascade on delete
FK_dbo.AlertErrors_dbo.AlertEvents_AlertEventId
AlertErrors.AlertEventId
AlertEvents.Id
Restrict delete
FK_dbo.AlertErrors_dbo.AlertSettings_AlertSettingsId
AlertErrors.AlertSettingsId
AlertSettings.Id
Cascade on delete
FK_dbo.AlertErrors_dbo.AlertMessages_AlertMessageId
AlertErrors.AlertMessageId
AlertMessages.Id
Restrict delete
FK_dbo.AlertEvents_dbo.Alerts_AlertId
AlertEvents.AlertId
Alerts.Id
Restrict delete
FK_dbo.AlertEvents_dbo.EventStatus_StatusId
AlertEvents.StatusId
AlertEventStatus.Id
Cascade on delete
FK_dbo.AlertEvents_dbo.Referrals_ReferralId
AlertEvents.ReferralId
Referrals.Id
Restrict delete
FK_dbo.AlertEvents_dbo.AlertSettings_SettingsId
AlertEvents.SettingsId
AlertSettings.Id
Restrict delete
FK_dbo.BreastSwitches_dbo.BreastSwitchChangeReasonTypes_ReasonForChangeId
BreastSwitches.ReasonForChangeId
BreastSwitchChangeReasonTypes.Id
Restrict delete
FK_dbo.BreastSwitches_dbo.Organisations_OrganisationId
BreastSwitches.OrganisationId
Organisations.Id
Restrict delete
FK_dbo.BreastSwitches_dbo.Consultants_AuthorisedByConsultantId
BreastSwitches.AuthorisedByConsultantId
Consultants.Id
Restrict delete
FK_dbo.BreastSwitches_dbo.Activities_ActivityId
BreastSwitches.ActivityId
Activities.Id
Restrict delete
FK_dbo.BreastSwitches_dbo.CNSs_AuthorisedByCNSId
BreastSwitches.AuthorisedByCNSId
CNSs.Id
Restrict delete
FK_dbo.BreastSwitches_dbo.GPs_AuthorisedByGPId
BreastSwitches.AuthorisedByGPId
GPs.Id
Restrict delete
FK_dbo.BreastSwitches_dbo.Referrals_ReferralId
BreastSwitches.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.Investigations_dbo.TNM_N_Value_TNM_Rad_NValueId
Investigations.TNM_Rad_NValueId
TNM_N_Value.Id
Restrict delete
FK_dbo.Investigations_dbo.TNM_T_Value_TNM_Rad_TValueId
Investigations.TNM_Rad_TValueId
TNM_T_Value.Id
Restrict delete
FK_dbo.Investigations_dbo.TNM_M_Value_TNM_Rad_MValueId
Investigations.TNM_Rad_MValueId
TNM_M_Value.Id
Restrict delete
FK_dbo.Investigations_dbo.TNMVersions_TNMRadVersion_Id
Investigations.TNMRadVersion_Id
TNMVersions.Id
Restrict delete
FK_dbo.Investigations_dbo.TNM_N_Letter_TNM_Rad_NLetterId
Investigations.TNM_Rad_NLetterId
TNM_N_Letter.Id
Restrict delete
FK_dbo.Investigations_dbo.Referrals_ReferralId
Investigations.ReferralId
Referrals.Id
Cascade on delete
FK_dbo.Investigations_dbo.TNM_M_Letter_TNM_Rad_MLetterId
Investigations.TNM_Rad_MLetterId
TNM_M_Letter.Id
Restrict delete
FK_dbo.Investigations_dbo.InvestigationTypes_InvestigationTypeId
Investigations.InvestigationTypeId
InvestigationTypes.Id
Cascade on delete
FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite1Id
Investigations.AnatomicalSite1Id
AnatomicalSites.Id
Restrict delete
FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite2Id
Investigations.AnatomicalSite2Id
AnatomicalSites.Id
Restrict delete
FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite3Id
Investigations.AnatomicalSite3Id
AnatomicalSites.Id
Restrict delete
FK_dbo.Investigations_dbo.Organisations_OrganisationId
Investigations.OrganisationId
Organisations.Id
Restrict delete
FK_dbo.Investigations_dbo.Activities_ActivityId
Investigations.ActivityId
Activities.Id
Restrict delete
FK_dbo.Investigations_dbo.InvestigationOutcomes_InvestigationOutcomeId
Investigations.InvestigationOutcomeId
InvestigationOutcomes.Id
Restrict delete
FK_dbo.Investigations_dbo.TNMEditions_TNMRadEdition_Id
Investigations.TNMRadEdition_Id
TNMEditions.Id
Restrict delete
FK_dbo.Investigations_dbo.TNM_T_Letter_TNM_Rad_TLetterId
Investigations.TNM_Rad_TLetterId
TNM_T_Letter.Id
Restrict delete
FK_dbo.Investigations_dbo.AnatomicalSides_AnatomicalSideId
Investigations.AnatomicalSideId
AnatomicalSides.Id
Restrict delete
FK_dbo.PracticeCCGMappings_dbo.CCGs_CCG_Id
PracticeCCGMappings.CCG_Id
CCGs.Id
Cascade on delete
FK_dbo.ThyroidReferrals_dbo.Referrals_Id
ThyroidReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.BloodTestResultDefined_dbo.UnitOfMeasurements_UnitId
BloodTestResultDefined.UnitId
UnitOfMeasurements.Id
Restrict delete
FK_dbo.BloodTestResultDefined_dbo.BloodTests_BloodTestId
BloodTestResultDefined.BloodTestId
BloodTests.Id
Cascade on delete
FK_dbo.BloodTestResultDefined_dbo.BloodTestResults_Id
BloodTestResultDefined.Id
BloodTestResults.Id
Restrict delete
FK_dbo.InvestigationActivitySchedule_dbo.ActivitySchedule_Id
InvestigationActivitySchedule.Id
ActivitySchedule.Id
Restrict delete
FK_dbo.InvestigationActivitySchedule_dbo.InvestigationTypes_InvestigationTypeId
InvestigationActivitySchedule.InvestigationTypeId
InvestigationTypes.Id
Cascade on delete
FK_dbo.UrologyIReferrals_dbo.Referrals_Id
UrologyReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.ActivityTemplates_dbo.CancerSites_CancerSiteId
ActivityTemplates.CancerSiteId
CancerSites.Id
Cascade on delete
FK_dbo.HeadAndNeckReferrals_dbo.Referrals_Id
HeadAndNeckReferrals.Id
Referrals.Id
Restrict delete
FK_dbo.PSAThresholdLevels_dbo.ProstateReferrals_ReferralId
_Deprecated_21_01_PSAThresholdLevels.ReferralId
ProstateReferrals.Id
Restrict delete
FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId
AspNetUserRoles.RoleId
AspNetRoles.Id
Cascade on delete
FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId
AspNetUserRoles.UserId
AspNetUsers.Id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
BloodTestRangeTypeDefinitions MustHaveOneBound ([HasUpperBound]=(1) OR [HasLowerBound]=(1))