245 Foreign Key Constraints
Constraint Name | Child Column | Parent Column | Delete Rule | ||
---|---|---|---|---|---|
FK_dbo.SystemAreaAudit_dbo.AuditActions_ActionId |
|
|
Cascade on delete | ||
FK_dbo.SystemAreaAudit_dbo.SystemAreas_SystemAreaId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestResults_dbo.Investigations_InvestigationId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestResults_dbo.BloodTestPanels_TestPanelId |
|
|
Restrict delete | ||
FK_dbo.BloodTestResults_dbo.ResultOperators_ResultOperatorId |
|
|
Restrict delete | ||
FK_dbo.BloodTestResults_dbo.ResultOutcomes_ResultOutcomeId |
|
|
Restrict delete | ||
FK_dbo.LibraryFiles_dbo.CancerSites_CancerSiteId |
|
|
Cascade on delete | ||
FK_dbo.SNOMEDICD10Link_dbo.ICD10_ICD10Id |
|
|
Cascade on delete | ||
FK_dbo.SNOMEDICD10Link_dbo.SNOMEDDiagnosis_SNOMEDDiagnosisId |
|
|
Cascade on delete | ||
FK_dbo.GynaecologyReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.InvestigationActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id |
|
|
Restrict delete | ||
FK_dbo.InvestigationActivityTemplateSchedule_dbo.InvestigationTypes_InvestigationTypeId |
|
|
Cascade on delete | ||
FK_dbo.ManualTimeLines_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.CEAThresholdLevels_dbo.ColorectalReferrals_ReferralId |
|
|
Restrict delete | ||
FK_dbo.BloodTestUnitAssociations_dbo.BloodTests_TestId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestUnitAssociations_dbo.UnitOfMeasurements_UnitId |
|
|
Cascade on delete | ||
FK_dbo.ThyroidStaging_dbo.Staging_DiagnosisId |
|
|
Restrict delete | ||
FK_dbo.ICD10_dbo.ICD10Group_ICD10GroupId |
|
|
Cascade on delete | ||
FK_dbo.AlertMessages_dbo.AlertStatus_StatusId |
|
|
Cascade on delete | ||
FK_dbo.MDTDiscussionActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id |
|
|
Restrict delete | ||
FK_dbo.LabTestPanelAssociations_dbo.LabTests_TestId |
|
|
Cascade on delete | ||
FK_dbo.LabTestPanelAssociations_dbo.LabTestPanels_PanelId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestRangeTypeDefinitions_dbo.CancerSites_CancerSiteId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestRangeTypeDefinitions_dbo.BloodTests_BloodTestId |
|
|
Cascade on delete | ||
FK_dbo.DiagnosisMets_dbo.Diagnosis_DiagnosisId |
|
|
Cascade on delete | ||
FK_dbo.DiagnosisMets_dbo.MetsLocations_MetsLocationId |
|
|
Restrict delete | ||
FK_dbo.DiagnosisMets_dbo.MetsCertainties_MetsCertaintyId |
|
|
Restrict delete | ||
FK_dbo.DiagnosisMets_dbo.MetsTypes_MetsTypeId |
|
|
Restrict delete | ||
FK_dbo.Patients_dbo.Titles_TitleId |
|
|
Restrict delete | ||
FK_dbo.Patients_dbo.Ethnicities_EthnicityId |
|
|
Restrict delete | ||
FK_dbo.Patients_dbo.GPs_RegisteredGPId |
|
|
Restrict delete | ||
FK_dbo.Patients_dbo.PatientNotificationSMS_NotificationSMSId |
|
|
Restrict delete | ||
FK_dbo.Patients_dbo.Practices_RegisteredPracticeId |
|
|
Restrict delete | ||
FK_dbo.Patients_dbo.NhsNumberStatus_NhsNumberStatusId |
|
|
Cascade on delete | ||
FK_dbo.Patients_dbo.Genders_GenderId |
|
|
Restrict delete | ||
FK_dbo.AuditRecords_dbo.AuditActions_ActionId |
|
|
Cascade on delete | ||
FK_dbo.AuditRecords_dbo.RecordTypes_RecordTypeId |
|
|
Cascade on delete | ||
FK_dbo.AuditRecords_dbo.Referrals_ReferralId |
|
|
Restrict delete | ||
FK_dbo.MDTDiscussionActivitySchedule_dbo.ActivitySchedule_Id |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.TNM_N_Letter_TNM_Rad_NLetterId |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.TNM_T_Letter_TNM_Rad_TLetterId |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.TNM_M_Letter_TNM_Rad_MLetterId |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.BreastSides_SideId |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.TNMEditions_TNMRadEdition_Id |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.Investigations_InvestigationId |
|
|
Cascade on delete | ||
FK_dbo.BreastInvestigationResults_dbo.BreastSites_SiteId |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.TNM_T_Value_TNM_Rad_TValueId |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.TNM_M_Value_TNM_Rad_MValueId |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.TNM_N_Value_TNM_Rad_NValueId |
|
|
Restrict delete | ||
FK_dbo.BreastInvestigationResults_dbo.TNMVersions_TNMRadVersion_Id |
|
|
Restrict delete | ||
FK_dbo.ColorectalStaging_dbo.ModifiedDukes_ModifiedDukesId |
|
|
Restrict delete | ||
FK_dbo.ColorectalStaging_dbo.Staging_DiagnosisId |
|
|
Restrict delete | ||
FK_dbo.DocumentExportMessages_dbo.DocumentExportMessageStatusTypes_StatusTypeId |
|
|
Cascade on delete | ||
FK_dbo.DocumentExportMessages_dbo.LibraryFiles_LibraryFileId |
|
|
Cascade on delete | ||
FK_dbo.DocumentExportMessages_dbo.AspNetUsers_UserId |
|
|
Restrict delete | ||
FK_dbo.DocumentExportMessages_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestRanges_dbo.BloodTests_BloodTestId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestRanges_dbo.UnitOfMeasurements_UnitId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestRanges_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.LibraryResource_dbo.LibraryFiles_Id |
|
|
Restrict delete | ||
FK_dbo.LungReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.PortalMessages_dbo.PortalTriggerSources_TriggerSourceId |
|
|
Cascade on delete | ||
FK_dbo.PortalMessages_dbo.PortalMessageTypes_MessageTypeId |
|
|
Cascade on delete | ||
FK_dbo.PortalMessages_dbo.PortalMessageStatuses_StatusId |
|
|
Restrict delete | ||
FK_dbo.LabTests_dbo.CancerSites_ThresholdForSite_Id |
|
|
Restrict delete | ||
FK_dbo.ProstateReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.DemographicInterfaceMessages_dbo.MessageStatus_StatusId |
|
|
Cascade on delete | ||
FK_dbo.PracticeGPAssociations_dbo.GPs_GPId |
|
|
Cascade on delete | ||
FK_dbo.PracticeGPAssociations_dbo.Practices_PracticeId |
|
|
Cascade on delete | ||
FK_dbo.ReviewContacts_dbo.Reviews_ReviewId |
|
|
Cascade on delete | ||
FK_dbo.ReviewContacts_dbo.ReviewContactTypes_ContactTypeId |
|
|
Restrict delete | ||
FK_dbo.AlertSettings_dbo.Alerts_AlertId |
|
|
Restrict delete | ||
FK_dbo.BreastReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.ReviewInvesitgationTypes_dbo.InvestigationTypes_InvestigationTypeId |
|
|
Cascade on delete | ||
FK_dbo.ReviewInvesitgationTypes_dbo.Reviews_ReviewId |
|
|
Cascade on delete | ||
FK_dbo.Referrals_dbo.CancerSubSites_CancerSubSiteId |
|
|
Restrict delete | ||
FK_dbo.Referrals_dbo.Consultants_ConsultantId |
|
|
Restrict delete | ||
FK_dbo.Referrals_dbo.Patients_PatientId |
|
|
Cascade on delete | ||
FK_dbo.Referrals_dbo.CNSs_KeyWorkerId |
|
|
Restrict delete | ||
FK_dbo.ReferenceDataAudit_dbo.AspNetUsers_UserId |
|
|
Restrict delete | ||
FK_dbo.BloodTestPanelAssociations_dbo.BloodTests_TestId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestPanelAssociations_dbo.BloodTestPanels_PanelId |
|
|
Cascade on delete | ||
FK_dbo.UserAdminAuditRecords_dbo.UserAdminAuditActions_ActionId |
|
|
Cascade on delete | ||
FK_dbo.Tests_dbo.Referrals_Referral_Id |
|
|
Restrict delete | ||
FK_dbo.ActivitySchedule_dbo.ActivityScheduleClosedReasons_ActivityScheduleClosedReasonId |
|
|
Restrict delete | ||
FK_dbo.ActivitySchedule_dbo.ActivityTimeSpanTypes_RecurrenceTimeSpanTypeId |
|
|
Restrict delete | ||
FK_dbo.ActivitySchedule_dbo.ActivityTemplates_ActivityTemplateId |
|
|
Restrict delete | ||
FK_dbo.ActivitySchedule_dbo.ActivityScheduleStatusTypes_StatusTypeId |
|
|
Cascade on delete | ||
FK_dbo.ActivitySchedule_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.ActivitySchedule_dbo.ActivityTimeSpanTypes_DurationTimeSpanTypeId |
|
|
Restrict delete | ||
FK_dbo.Notes_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.ColorectalReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId |
|
|
Cascade on delete | ||
FK_dbo.DemographicInterfaceMessageAmendments_dbo.AmendmentFields_AmendmentFieldId |
|
|
Restrict delete | ||
FK_dbo.DemographicInterfaceMessageAmendments_dbo.DemographicInterfaceMessages_MessageId |
|
|
Cascade on delete | ||
FK_dbo.Activities_dbo.ActivityStatusTypes_ActivityStatusId |
|
|
Cascade on delete | ||
FK_dbo.Activities_dbo.ActivitySchedule_ActivityScheduleId |
|
|
Cascade on delete | ||
FK_dbo.ActivityTemplateSchedule_dbo.ActivityTimeSpanTypes_DurationTimeSpanTypeId |
|
|
Restrict delete | ||
FK_dbo.ActivityTemplateSchedule_dbo.ActivityTemplates_ActivityTemplateId |
|
|
Cascade on delete | ||
FK_dbo.ActivityTemplateSchedule_dbo.ActivityTimeSpanTypes_RecurrenceTimeSpanTypeId |
|
|
Restrict delete | ||
FK_dbo.AspNetUsers_dbo.UserJobRoles_JobRoleId |
|
|
Restrict delete | ||
FK_dbo.AspNetUsers_dbo.Organisations_OrganisationId |
|
|
Restrict delete | ||
FK_dbo.HaematologyReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.TumourMarkerResultsDefined_dbo.UnitOfMeasurements_UnitId |
|
|
Restrict delete | ||
FK_dbo.TumourMarkerResultsDefined_dbo.TumourMarkerResults_Id |
|
|
Restrict delete | ||
FK_dbo.TumourMarkerResultsDefined_dbo.TumourMarkers_TumourMarkerId |
|
|
Cascade on delete | ||
FK_dbo._Deprecated_20_03_PatientPreferredContact_dbo.Patients_PatientId |
|
|
Restrict delete | ||
FK_dbo.ViewAuditRecords_dbo.RecordTypes_RecordTypeId |
|
|
Restrict delete | ||
FK_dbo.ViewAuditRecords_dbo.Referrals_ReferralId |
|
|
Restrict delete | ||
FK_dbo.HNAActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id |
|
|
Restrict delete | ||
FK_dbo.ClinicalReviewActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id |
|
|
Restrict delete | ||
FK_dbo.ReferralMonitoringStatus_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.ReferralMonitoringStatus_dbo.MonitoringStatusChangedReasons_ReasonChangedId |
|
|
Restrict delete | ||
FK_dbo.ReferralMonitoringStatus_dbo.MonitoringStatus_StatusId |
|
|
Cascade on delete | ||
FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId |
|
|
Cascade on delete | ||
FK_dbo.PortalRegistrationAuditRecords_dbo.Patients_PatientId |
|
|
Cascade on delete | ||
FK_dbo.BreastSwitchActivitySchedule_dbo.ActivitySchedule_Id |
|
|
Restrict delete | ||
FK_dbo.UpperGIReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.TumourMarkerResultsOther_dbo.TumourMarkerResults_Id |
|
|
Restrict delete | ||
FK_dbo.TesticularReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.BloodTestResultOther_dbo.BloodTestResults_Id |
|
|
Restrict delete | ||
FK_dbo.ReviewOutcomeRecipients_dbo.OutcomeRecipients_ReviewOutcomeRecipientId |
|
|
Cascade on delete | ||
FK_dbo.ReviewOutcomeRecipients_dbo.Reviews_ReviewId |
|
|
Cascade on delete | ||
FK_dbo.ColorectalSynchronousTumourSites_dbo.SynchronousTumourSites_SynchronousTumourSiteId |
|
|
Cascade on delete | ||
FK_dbo.ColorectalSynchronousTumourSites_dbo.ColorectalStaging_ColorectalStagingId |
|
|
Restrict delete | ||
FK_dbo.LibraryLetterTemplate_dbo.LibraryFiles_Id |
|
|
Restrict delete | ||
FK_dbo.TumourMarkerResults_dbo.Investigations_InvestigationId |
|
|
Cascade on delete | ||
FK_dbo.TumourMarkerResults_dbo.ResultOperators_OperatorId |
|
|
Restrict delete | ||
FK_dbo.TumourMarkerResults_dbo.ResultOutcomes_OutcomeId |
|
|
Restrict delete | ||
FK_dbo.HNAActivitySchedule_dbo.ActivitySchedule_Id |
|
|
Restrict delete | ||
FK_dbo.BreastSwitchActivityTemplateSchedule_dbo.ActivityTemplateSchedule_Id |
|
|
Restrict delete | ||
FK_dbo.UserPermissions_dbo.UserPermissionLevels_UserPermissionLevelId |
|
|
Restrict delete | ||
FK_dbo.UserPermissions_dbo.UserPermissionSections_SectionId |
|
|
Cascade on delete | ||
FK_dbo.UserPermissions_dbo.CancerSites_CancerSiteId |
|
|
Cascade on delete | ||
FK_dbo.UserPermissions_dbo.AspNetUsers_UserId |
|
|
Cascade on delete | ||
FK_dbo.AlertEventMessages_dbo.AlertMessages_MessageId |
|
|
Cascade on delete | ||
FK_dbo.AlertEventMessages_dbo.AlertEvents_EventId |
|
|
Cascade on delete | ||
FK_dbo.SkinReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.Consultants_dbo.ConsultantTitles_TitleId |
|
|
Restrict delete | ||
FK_dbo.LabTestResultOther_dbo.LabTestResults_Id |
|
|
Restrict delete | ||
FK_dbo.CancerSubSites_dbo.CancerSites_CancerSiteId |
|
|
Cascade on delete | ||
FK_dbo.BreastStaging_dbo.NPIPrognosis_NPIPrognosisId |
|
|
Restrict delete | ||
FK_dbo.BreastStaging_dbo.MenopausalStatus_MenopausalStatusId |
|
|
Restrict delete | ||
FK_dbo.BreastStaging_dbo.Staging_DiagnosisId |
|
|
Restrict delete | ||
FK_dbo.BreastStaging_dbo.LymphNodeScores_LymphNodeScoreId |
|
|
Restrict delete | ||
FK_dbo.BreastStaging_dbo.TumourGrades_TumourGradeId |
|
|
Restrict delete | ||
FK_dbo.CancerSiteSettings_dbo.TimelineEventStartDateTypes_TimelineEventStartDateTypeId |
|
|
Cascade on delete | ||
FK_dbo.CancerSiteSettings_dbo.CancerSites_CancerSiteId |
|
|
Cascade on delete | ||
FK_dbo.CancerSiteSettings_dbo.BloodTests_PrincipalTumourMarkerId |
|
|
Restrict delete | ||
FK_dbo.Reviews_dbo.Referrals_ReferralID |
|
|
Cascade on delete | ||
FK_dbo.Reviews_dbo.Activities_ActivityId |
|
|
Restrict delete | ||
FK_dbo.Reviews_dbo.Organisations_OrganisationId |
|
|
Restrict delete | ||
FK_dbo.Reviews_dbo.CNSs_CareProfessionalId |
|
|
Restrict delete | ||
FK_dbo.Reviews_dbo.ReviewOutcomes_OutcomeId |
|
|
Restrict delete | ||
FK_dbo.ClinicalReviewActivitySchedule_dbo.ActivitySchedule_Id |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.Consultants_ConsultantAtDiagnosisId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.Organisations_OrganisationId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.Diagnosis_dbo.BasisOfDiagnosis_BasisOfDiagnosisId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.SNOMEDMorphologies_SNOMEDMorphologyId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.TumourStatus_TumourStatusId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.CNSIndicationCodes_CNSIndicationCodeId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.SNOMED_CT_MorphologyId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.ICD10_ICD10Id |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.ICD10Group_ICD10GroupId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.Lateralities_LateralityId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.GradesOfDifferentiation_GradeOfDifferentiationId |
|
|
Restrict delete | ||
FK_dbo.Diagnosis_dbo.SNOMEDDiagnosis_SNOMEDDiagnosisId |
|
|
Restrict delete | ||
FK_dbo.TesticularStaging_dbo.Staging_DiagnosisId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNMVersions_TNMVersion_Id |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNMGroupings_TNM_FI_TNMGroupingId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNMEditions_TNMEdition_Id |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.Diagnosis_DiagnosisId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNM_M_Letter_TNM_FI_MLetterId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.Organisations_TNM_FI_OrganisationId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNM_T_Letter_TNM_FI_TLetterId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNM_M_Value_TNM_FI_MValueId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNM_N_Letter_TNM_FI_NLetterId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNM_N_Value_TNM_FI_NValueId |
|
|
Restrict delete | ||
FK_dbo.Staging_dbo.TNM_T_Value_TNM_FI_TValueId |
|
|
Restrict delete | ||
FK_dbo.Alerts_dbo.AlertTypes_TypeId |
|
|
Cascade on delete | ||
FK_dbo.Alerts_dbo.DateComparisons_DateComparisonId |
|
|
Restrict delete | ||
FK_dbo.Alerts_dbo.AlertRecipients_RecipientId |
|
|
Cascade on delete | ||
FK_dbo.Alerts_dbo.AlertMethods_MethodId |
|
|
Cascade on delete | ||
FK_dbo.Alerts_dbo.CancerSites_CancerSiteId |
|
|
Cascade on delete | ||
FK_dbo.DemographicInterfaceMessageErrors_dbo.DemographicInterfaceMessages_MessageId |
|
|
Cascade on delete | ||
FK_dbo.DemographicInterfaceMessageErrors_dbo.Severities_SeverityId |
|
|
Cascade on delete | ||
FK_dbo.LabTestResults_dbo.LabTestPanels_PanelId |
|
|
Restrict delete | ||
FK_dbo.LabTestResults_dbo.ResultOperators_ResultOperatorId |
|
|
Restrict delete | ||
FK_dbo.LabTestResults_dbo.ResultOutcomes_ResultOutcomeId |
|
|
Restrict delete | ||
FK_dbo.LabTestResults_dbo.Investigations_InvestigationId |
|
|
Cascade on delete | ||
FK_dbo.InvestigationReviewStatuses_dbo.Investigations_InvestigationId |
|
|
Cascade on delete | ||
FK_dbo.LabTestResultDefined_dbo.LabTestResults_Id |
|
|
Restrict delete | ||
FK_dbo.LabTestResultDefined_dbo.LabTests_LabTestId |
|
|
Cascade on delete | ||
FK_dbo.ProstateStaging_dbo.Staging_DiagnosisId |
|
|
Restrict delete | ||
FK_dbo.ProstateStaging_dbo.GleasonTertiaryScores_FinalGleasonTertiaryScoreId |
|
|
Restrict delete | ||
FK_dbo.DocumentActions_dbo.LibraryFiles_LibraryFileId |
|
|
Restrict delete | ||
FK_dbo.DocumentActions_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.TumourMarkers_dbo.UnitOfMeasurements_UnitId |
|
|
Restrict delete | ||
FK_dbo.TumourMarkers_dbo.CancerSites_ThresholdForSite_Id |
|
|
Restrict delete | ||
FK_dbo.AlertErrors_dbo.Alerts_AlertId |
|
|
Cascade on delete | ||
FK_dbo.AlertErrors_dbo.AlertEvents_AlertEventId |
|
|
Restrict delete | ||
FK_dbo.AlertErrors_dbo.AlertSettings_AlertSettingsId |
|
|
Cascade on delete | ||
FK_dbo.AlertErrors_dbo.AlertMessages_AlertMessageId |
|
|
Restrict delete | ||
FK_dbo.AlertEvents_dbo.Alerts_AlertId |
|
|
Restrict delete | ||
FK_dbo.AlertEvents_dbo.EventStatus_StatusId |
|
|
Cascade on delete | ||
FK_dbo.AlertEvents_dbo.Referrals_ReferralId |
|
|
Restrict delete | ||
FK_dbo.AlertEvents_dbo.AlertSettings_SettingsId |
|
|
Restrict delete | ||
FK_dbo.BreastSwitches_dbo.BreastSwitchChangeReasonTypes_ReasonForChangeId |
|
|
Restrict delete | ||
FK_dbo.BreastSwitches_dbo.Organisations_OrganisationId |
|
|
Restrict delete | ||
FK_dbo.BreastSwitches_dbo.Consultants_AuthorisedByConsultantId |
|
|
Restrict delete | ||
FK_dbo.BreastSwitches_dbo.Activities_ActivityId |
|
|
Restrict delete | ||
FK_dbo.BreastSwitches_dbo.CNSs_AuthorisedByCNSId |
|
|
Restrict delete | ||
FK_dbo.BreastSwitches_dbo.GPs_AuthorisedByGPId |
|
|
Restrict delete | ||
FK_dbo.BreastSwitches_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.Investigations_dbo.TNM_N_Value_TNM_Rad_NValueId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.TNM_T_Value_TNM_Rad_TValueId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.TNM_M_Value_TNM_Rad_MValueId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.TNMVersions_TNMRadVersion_Id |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.TNM_N_Letter_TNM_Rad_NLetterId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.Referrals_ReferralId |
|
|
Cascade on delete | ||
FK_dbo.Investigations_dbo.TNM_M_Letter_TNM_Rad_MLetterId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.InvestigationTypes_InvestigationTypeId |
|
|
Cascade on delete | ||
FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite1Id |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite2Id |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.AnatomicalSites_AnatomicalSite3Id |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.Organisations_OrganisationId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.Activities_ActivityId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.InvestigationOutcomes_InvestigationOutcomeId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.TNMEditions_TNMRadEdition_Id |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.TNM_T_Letter_TNM_Rad_TLetterId |
|
|
Restrict delete | ||
FK_dbo.Investigations_dbo.AnatomicalSides_AnatomicalSideId |
|
|
Restrict delete | ||
FK_dbo.PracticeCCGMappings_dbo.CCGs_CCG_Id |
|
|
Cascade on delete | ||
FK_dbo.ThyroidReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.BloodTestResultDefined_dbo.UnitOfMeasurements_UnitId |
|
|
Restrict delete | ||
FK_dbo.BloodTestResultDefined_dbo.BloodTests_BloodTestId |
|
|
Cascade on delete | ||
FK_dbo.BloodTestResultDefined_dbo.BloodTestResults_Id |
|
|
Restrict delete | ||
FK_dbo.InvestigationActivitySchedule_dbo.ActivitySchedule_Id |
|
|
Restrict delete | ||
FK_dbo.InvestigationActivitySchedule_dbo.InvestigationTypes_InvestigationTypeId |
|
|
Cascade on delete | ||
FK_dbo.UrologyIReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.ActivityTemplates_dbo.CancerSites_CancerSiteId |
|
|
Cascade on delete | ||
FK_dbo.HeadAndNeckReferrals_dbo.Referrals_Id |
|
|
Restrict delete | ||
FK_dbo.PSAThresholdLevels_dbo.ProstateReferrals_ReferralId |
|
|
Restrict delete | ||
FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId |
|
|
Cascade on delete | ||
FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId |
|
|
Cascade on delete |
Check Constraints
Table | Constraint Name | Constraint |
---|---|---|
BloodTestRangeTypeDefinitions | MustHaveOneBound | ([HasUpperBound]=(1) OR [HasLowerBound]=(1)) |