824 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||
|---|---|---|---|---|---|---|---|
| FK_tblSURGERY_UROLOGY_CHARLSON_MAPPING_tblSURGERY_UROLOGY |
|
|
Cascade on delete | ||||
| FK_SNOMEDCTMap_SNOMEDCTMapType |
|
|
Restrict delete | ||||
| FK_SNOMEDCTMap_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblSURGERY_DAHNO_GMC_CODES_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblASSESSMENT_HN_LONG_TERM_COMPS_tblMAIN_ASSESSMENT |
|
|
Cascade on delete | ||||
| FK_tblASSESSMENT_HN_LONG_TERM_COMPS_ltblLongTermComplications |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_PUBLISHED_REFERRALS_tblTREATMENT_SUMMARY_PUBLISHED |
|
|
Restrict delete | ||||
| FK_tblChemotherapyToxicitySymptoms_ltblAcuteToxicity |
|
|
Restrict delete | ||||
| FK_tblChemotherapyToxicitySymptoms_tblMAIN_CHEMOTHERAPY |
|
|
Restrict delete | ||||
| FK_CNSContactID |
|
|
Restrict delete | ||||
| FK_ConcernID |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CONSULTANT_NEUTROPENIC_SEPSIS_tblAO_NEUTROPENIC_SEPSIS |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CONSULTANT_NEUTROPENIC_SEPSIS_ltblCONSULTANTS |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblANU_VisualFieldsLeft |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblFABClassification |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_OrganisationSites5 |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_OrganisationSites6 |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblANU_Left |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblANU_VisualFieldsRight |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_OrganisationSites3 |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_OrganisationSites4 |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblPAED_RENAL |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_OrganisationSites2 |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblINRG_STAGING |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblPaedRiskGroup |
|
|
Restrict delete | ||||
| FK_tblPAEDIATRIC_MDT_ltblANU_Right |
|
|
Restrict delete | ||||
| FK_DisHistopathologyLinkage_ltblAuditActionType |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_ltblANU_Left |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_ltblANU_VisualFieldsRight |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_ltblANU_Right |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_ltblINRG_STAGING |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_ltblANU_VisualFieldsLeft |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblBRAIN_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblBRAIN_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblMAIN_CHEMOTHERAPY_ltblTreatmentIntent |
|
|
Restrict delete | ||||
| FK_tblMAIN_CHEMOTHERAPY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblMAIN_CHEMOTHERAPY_ltblTreatmentCompletedAsPlanned |
|
|
Restrict delete | ||||
| FK_tblMAIN_CHEMOTHERAPY_PrimaryInductionFailure |
|
|
Restrict delete | ||||
| FK_tblMAIN_CHEMOTHERAPY_ltblAdjunctiveTherapy |
|
|
Restrict delete | ||||
| FK_tblMAIN_CHEMOTHERAPY_ltblChemotherapyNotCompleteReason |
|
|
Restrict delete | ||||
| FK_tblMDT_MEETINGS_ltblCONSULTANTS |
|
|
Restrict delete | ||||
| FK_DisRadiologyLinkage_ltblAuditActionType |
|
|
Restrict delete | ||||
| FK_CNSContactID_GroupData |
|
|
Restrict delete | ||||
| FK_ConcernGroupID |
|
|
Restrict delete | ||||
| FK_tblBREAST_MDT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblBREAST_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblBREAST_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblBREAST_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblBREAST_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK__MirthErro__Messa__7D15B6A2 |
|
|
Cascade on delete | ||||
| FK_tblCHEMOTHERAPY_UROLOGY_tblMAIN_CHEMOTHERAPY |
|
|
Cascade on delete | ||||
| FK_tblPALLIATIVE_HOLISTIC_ASSESSMENT_tblPALLIATIVE_CONTACT |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_DERMATOLOGY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblHAEM_RELAPSE_TRANSFORM_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_MacmillanImportStatus_SummaryId |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HEAD_NECK_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_ltblHNReconstructionSubGroup_ltblHNReconstructionGroup1 |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_SENT_tblTERTIARY_REFERRALS |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_OTHER_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblSARCOMA_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblSARCOMA_MDT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblSARCOMA_MDTltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblSARCOMA_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblSARCOMA_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblSARCOMA_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblEdocsSouthampton_tblEdocs |
|
|
Restrict delete | ||||
| FK_tblSURGERY_GYNAECOLOGY_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblCNSInfoAdvice_ltblCNS_ACTIVITIES |
|
|
Restrict delete | ||||
| FK_tblCNSInfoAdvice_tblCNSContact |
|
|
Restrict delete | ||||
| FK_lnkChildhoodPrincipalTreatmentCentre_ltblChildhoodPrincipalTreatmentCentre |
|
|
Restrict delete | ||||
| FK_lnkChildhoodPrincipalTreatmentCentre_ltblTreatmentModality |
|
|
Restrict delete | ||||
| FK_ltblUpperGISurgicalComplications_ltblNOGCASurgicalComplications |
|
|
Restrict delete | ||||
| FK_tblINITIAL_PAEDIATRICS_tblINITIAL_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_tblINITIAL_PAEDIATRICS_ltblYN |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_ELECTRONIC_MESSAGES_PayloadID |
|
|
Restrict delete | ||||
| FK_tblPATHOLOGY_UPPER_GI_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK__aspnet_Pa__Appli__0C326F40 |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__5C835C1E |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__5111A972 |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__6AD17B75 |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__3DC9CAD4 |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__3B226853 |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__76432E21 |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__2409F8D1 |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__3163F3EF |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__01B4E0CD |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__17A421EC |
|
|
Restrict delete | ||||
| FK__aspnet_Pa__Appli__459FF6C6 |
|
|
Restrict delete | ||||
| FK_RDCTest_tblRDCClinicalTriageDiagnosticTesting |
|
|
Restrict delete | ||||
| FK_tblSURGERY_LUNG_ltblRegionalAnaestheticTechnique |
|
|
Restrict delete | ||||
| FK_tblSURGERY_LUNG_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblSURGERY_HAEMATOLOGY_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblPATHOLOGY_DERMATOLOGY_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_tblTRACKING_COMMENTS_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_TimedPathwayEventOther_TimedPathwayEvent |
|
|
Restrict delete | ||||
| FK_tblPresentationHeadNeckSiteOfPreviousCancerICD10_ltblSitePreviousHeadNeckCancerICD10 |
|
|
Restrict delete | ||||
| FK_tblPresentationHeadNeckSiteOfPreviousCancerICD10_tblINITIAL_ASSESSMENT |
|
|
Cascade on delete | ||||
| FK_tblPALLIATIVE_CONTACT_tblPALLIATIVE_CARE |
|
|
Cascade on delete | ||||
| FK_tblMetsMDT_ltblMetastaticType |
|
|
Restrict delete | ||||
| FK_tblMetsMDT_tblMAIN_REFERRALS |
|
|
Restrict delete | ||||
| FK_tblMetsMDT_ltblMetastaticState |
|
|
Restrict delete | ||||
| FK_tblPATHOLOGY_SARCOMA_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_tblAO_COMPLICATIONS_TREATMENT_tblAO_REFERRAL |
|
|
Restrict delete | ||||
| FK_tblPALLIATIVE_MDT_tblPALLIATIVE_CARE |
|
|
Cascade on delete | ||||
| FK_DocumentExport_DocumentExportMessageStatus |
|
|
Restrict delete | ||||
| FK_DocumentExport_DocumentExportReferralType |
|
|
Restrict delete | ||||
| FK_DocumentExport_DocumentExportType |
|
|
Restrict delete | ||||
| FK_tblASSESSMENT_UPPER_GI_tblMAIN_ASSESSMENT |
|
|
Cascade on delete | ||||
| FK_tblPalliativeMDTMoves_tblMDT_LIST_From |
|
|
Restrict delete | ||||
| FK_tblPalliativeMDTMoves_tblMDT_LIST_To |
|
|
Restrict delete | ||||
| FK_tblPalliativeMDTMoves_ltblMDTMoveReason |
|
|
Restrict delete | ||||
| FK_TimedPathway_ltblCANCER_SITES |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HEAD_NECK_SYMP_SITE_ltblHNReferringSymptomSite1 |
|
|
Restrict delete | ||||
| FK_TimedPathwayAssociation_TimedPathwayVersion |
|
|
Restrict delete | ||||
| FK_TimedPathwayAssociation_tblAUDIT |
|
|
Restrict delete | ||||
| FK_TimedPathwayAssociation_tblMAIN_REFERRALS |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_OrganisationSites3 |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_OrganisationSites2 |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_ltblYNNK1 |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_ltblYNNK |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblUROLOGY_MDT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblUROLOGY_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__18984625 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__3EBDEF0D |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__47883F38 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__32581828 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__6CB9C3E7 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__3FB21346 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__3C168C8C |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__0D269379 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__46941AFF |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__02A90506 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__24FE1D0A |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__25F24143 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__198C6A5E |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__7737525A |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__52F9F1E4 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__782B7693 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__5E6BA490 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__334C3C61 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__039D293F |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__5205CDAB |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__6BC59FAE |
|
|
Restrict delete | ||||
| FK__aspnet_Me__Appli__5D778057 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__3D0AB0C5 |
|
|
Restrict delete | ||||
| FK__aspnet_Me__UserI__0E1AB7B2 |
|
|
Restrict delete | ||||
| FK_tblPALLIATIVE_CARE_tblDEMOGRAPHICS |
|
|
Cascade on delete | ||||
| FK_ltblTERTIARY_REFERRALS_STATUS_ltblTERTIARY_REFERRALS_STATUS_SUMMARY |
|
|
Restrict delete | ||||
| FK_tblCHEMOTHERAPY_GYNAECOLOGY_tblMAIN_CHEMOTHERAPY |
|
|
Cascade on delete | ||||
| FK_DisAntiCancerDrugsLinkage_ltblAuditActionType |
|
|
Restrict delete | ||||
| FK_tblMetastases_ltblMetastaticSite |
|
|
Restrict delete | ||||
| FK_tblMetastases_ltblMetastaticType |
|
|
Restrict delete | ||||
| FK_tblMetastases_tblMAIN_REFERRALS |
|
|
Restrict delete | ||||
| FK_tblMetastases_ltblMetastaticState |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_PUBLISHED_tblTREATMENT_SUMMARY |
|
|
Cascade on delete | ||||
| FK_tblMAIN_ASSESSMENT_StratifiedFollowupType |
|
|
Restrict delete | ||||
| FK_tblMAIN_ASSESSMENT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblPALLIATIVE_EPISODE_INPATIENT_tblPALLIATIVE_EPISODE |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__56CA82C8 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__7BFC0777 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__1D5CFB42 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__10F7245D |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__55D65E8F |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__11EB4896 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__6148113B |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__076DBA23 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__4382A42A |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__4B58D01C |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__708A54CB |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__428E7FF1 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__6F963092 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__4A64ABE3 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__067995EA |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__3628A90C |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__1C68D709 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__623C3574 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__40DB41A9 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__28CEADEE |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__29C2D227 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__UserI__371CCD45 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__3FE71D70 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__RoleI__7B07E33E |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_ELECTRONIC_ltblTERTIARY_REFERRALS_STATUS |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblFABClassification |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblPaedRiskGroup |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblANU_VisualFieldsRight |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblPAED_RENAL |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_OrganisationSites3 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_OrganisationSites2 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_OrganisationSites5 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblANU_Left |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_OrganisationSites4 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_OrganisationSites7 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_OrganisationSites6 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblPOSTInductionMRD |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblANU_Right |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblINRG_STAGING |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblANU_VisualFieldsLeft |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_PAEDIATRICS_ltblPAED_STAGE |
|
|
Restrict delete | ||||
| FK_tblCOSD_CTYA_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblAO_ASSESSMENT_ltblAOAssessmentOutcome |
|
|
Restrict delete | ||||
| FK_tblAO_ASSESSMENT_ltblAOAssessmentLocation |
|
|
Restrict delete | ||||
| FK_tblAO_ASSESSMENT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_NBCAMetastasisMapping_NBCAMetastases |
|
|
Restrict delete | ||||
| FK_NOGCAPlannedTreatmentMap_ltblNOGCATreatments |
|
|
Restrict delete | ||||
| FK_NOGCAPlannedTreatmentMap_ltblTREATMENT_TYPE |
|
|
Restrict delete | ||||
| FK_NOGCAPlannedTreatmentMap_ltblINTENT |
|
|
Restrict delete | ||||
| FK_tblSURGERY_PAEDIATRICS_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_RDCTestPerformed_ltblRDCClinicalTriageDiagnosticTesting |
|
|
Restrict delete | ||||
| FK_RDCTestPerformed_RDCTest |
|
|
Restrict delete | ||||
| FK_tblBREAST_VISITS_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_ltblSitePreviousHeadNeckCancerICD10_ltblDIAGNOSIS |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_LUNG_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblRDCPresentation_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblROOT_CAUSE_EVENTS_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblOTHER_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblOTHER_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblOTHER_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblOTHER_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblOTHER_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_lnkPretextAnnotationFactors_tblMAIN_REFERRALS |
|
|
Restrict delete | ||||
| FK_lnkPretextAnnotationFactors_ltblPAED_EXT |
|
|
Restrict delete | ||||
| FK_lnkTYAPrincipalTreatmentCentre_ltblTYAPrincipalTreatmentCentre |
|
|
Restrict delete | ||||
| FK_lnkTYAPrincipalTreatmentCentre_ltblTreatmentModality |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSMENT_RESULT_tblAO_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSMENT_RESULT_ltblAO_UKONS_SCORE |
|
|
Restrict delete | ||||
| FK_ltblMDT_MEETING_TYPE_ORDER_1 |
|
|
Restrict delete | ||||
| FK_ltblMDT_MEETING_TYPE_ORDER_3 |
|
|
Restrict delete | ||||
| FK_ltblMDT_MEETING_TYPE_ORDER_2 |
|
|
Restrict delete | ||||
| FK_ltblMDT_MEETING_TYPE_ORDER_5 |
|
|
Restrict delete | ||||
| FK_ltblMDT_MEETING_TYPE_ORDER_4 |
|
|
Restrict delete | ||||
| FK_ltblMDT_MEETING_TYPE_ORDER_7 |
|
|
Restrict delete | ||||
| FK_ltblMDT_MEETING_TYPE_ORDER_6 |
|
|
Restrict delete | ||||
| FK_ltblMDT_MEETING_TYPE_ORDER_8 |
|
|
Restrict delete | ||||
| FK_ltblCNS_NAME_aspnet_Users |
|
|
Restrict delete | ||||
| FK_RoleID |
|
|
Restrict delete | ||||
| FK_tblASSESSMENT_HEAD_NECK_tblMAIN_ASSESSMENT |
|
|
Cascade on delete | ||||
| FK_tblMAIN_PALLIATIVE_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblMDTMoves_tblMDT_LIST_From |
|
|
Restrict delete | ||||
| FK_tblMDTMoves_tblMDT_LIST_MDT_ID |
|
|
Restrict delete | ||||
| FK_tblMDTMoves_ltblMDTMoveReason |
|
|
Restrict delete | ||||
| FK_tblMDTMoves_tblMDT_LIST |
|
|
Cascade on delete | ||||
| FK_tblMDTMoves_tblMDT_LIST_To |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CNS_NEUTROPENIC_SEPSIS_ltblCNS_NAME |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CNS_NEUTROPENIC_SEPSIS_tblAO_NEUTROPENIC_SEPSIS |
|
|
Restrict delete | ||||
| FK_TimedPathwayEvent_TimedPathwayVersion |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_Practice |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_ltblCareProfessional |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_PredictedBreachStatus |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_tblDEMOGRAPHICS |
|
|
Cascade on delete | ||||
| FK_tblMAIN_REFERRALS_ltblFasterDiagnosisDelayReason |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_ltblFasterDiagnosisCancerSite |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_CancerReferralSubsites |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_ltblBankedTissue |
|
|
Restrict delete | ||||
| FK_ReferralRoute_ltblReferralRoute |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_ltblFasterDiagnosisCommunicationMethod |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_GP |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_ltblCA_STATUS |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_ltblAPP_TYPE |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_ltblFasterDiagnosisExclusionReason |
|
|
Restrict delete | ||||
| FK_tblMAIN_REFERRALS_Branch |
|
|
Restrict delete | ||||
| FK_SurgicalAccessMap_ltblSURGICAL_ACCESS |
|
|
Restrict delete | ||||
| FK_tblAO_NEUTROPENIC_SEPSIS_tblAO_REFERRAL |
|
|
Restrict delete | ||||
| FK_tblAO_NEUTROPENIC_SEPSIS_ltblAO_ADMINISTRATION_SERVICE |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BREAST_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK__aspnet_Pe__PathI__16AFFDB3 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__3A2E441A |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__0B3E4B07 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__44ABD28D |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__00C0BC94 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__2315D498 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__754F09E8 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__5B8F37E5 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__501D8539 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__69DD573C |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__3CD5A69B |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__306FCFB6 |
|
|
Restrict delete | ||||
| FK_WellbeingEvents_ltblWellbeingEvent |
|
|
Restrict delete | ||||
| FK_WellbeingEvents_ltblPOINT_OF_PATHWAY |
|
|
Restrict delete | ||||
| FK_WellbeingEvents_ltblYN |
|
|
Restrict delete | ||||
| FK_WellbeingEvents_tblCNSContact |
|
|
Cascade on delete | ||||
| FK_tblSUPPORTIVE_TREATMENT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblAO_OUTCOME_ltblAO_DISCHARGE_DESTINATION |
|
|
Restrict delete | ||||
| FK_tblAO_OUTCOME_ltblAO_FUNCTION_OUTCOME |
|
|
Restrict delete | ||||
| FK_tblAO_OUTCOME_ltblAO_FUNCTION_OUTCOME1 |
|
|
Restrict delete | ||||
| FK_tblAO_OUTCOME_ltblAO_FUNCTION_OUTCOME2 |
|
|
Restrict delete | ||||
| FK_tblAO_OUTCOME_ltblAO_FUNCTION_OUTCOME3 |
|
|
Restrict delete | ||||
| FK_tblAO_OUTCOME_ltblAO_FUNCTION_OUTCOME4 |
|
|
Restrict delete | ||||
| FK_tblAO_OUTCOME_ltblAO_FUNCTION_OUTCOME5 |
|
|
Restrict delete | ||||
| FK_tblAO_OUTCOME_tblAO_REFERRAL |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_ELECTRONIC_VALIDATION_eTertiaryValidationTypes |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_ELECTRONIC_VALIDATION_PayloadID |
|
|
Restrict delete | ||||
| FK_tblPathwayUpdateEvents_NextActionID |
|
|
Restrict delete | ||||
| FK_tblPathwayUpdateEvents_CareID |
|
|
Restrict delete | ||||
| FK_tblPathwayUpdateEvents_OrganisationID_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblPathwayUpdateEvents_NextActionSpecificID |
|
|
Restrict delete | ||||
| FK_tblPathwayUpdateEvents_OwnerID |
|
|
Restrict delete | ||||
| FK_TimedPathwayVersion_TimedPathway |
|
|
Restrict delete | ||||
| FK_tblTELETHERAPY_DERMATOLOGY_tblMAIN_TELETHERAPY |
|
|
Cascade on delete | ||||
| FK_ltblInvestigationsOrdered_ltblInvestigationsOrderedGroups |
|
|
Restrict delete | ||||
| FK_tblBREAST_IMAGING_tblMAIN_IMAGING |
|
|
Cascade on delete | ||||
| FK_tblRDCDiagnosis_ltblRDCFinalDiagnosisStatus |
|
|
Restrict delete | ||||
| FK_tblRDCDiagnosis_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblNonPrimaryPathway_NonPrimaryDiagnosisID_2 |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_ltblHAEM_ICD03_GROUP |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_ltblOUT_PATIENT_REFERRAL |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_NonPrimaryDiagnosisID_1 |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_ltblNonPrimaryPathwayType |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_ltblSNOMedCT |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_ltblNonPrimaryWHOTumourGrade |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_ltblYNNK |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_ltblHAEM_ICD03 |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryPathway_tblMAIN_REFERRALS |
|
|
Restrict delete | ||||
| FK_OrganisationSites_Organisations |
|
|
Restrict delete | ||||
| FK_OrgDeletedReason |
|
|
Restrict delete | ||||
| FK_OrganisationSites_ltblTERTIARY_REFERRALS_VERSION |
|
|
Restrict delete | ||||
| FK_tblPATHOLOGY_PAEDIATRIC_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| HistoricData_ReferralTypeID |
|
|
Restrict delete | ||||
| HistoricData_RecordTypeID |
|
|
Restrict delete | ||||
| HistoricData_FieldNameID |
|
|
Restrict delete | ||||
| HistoricData_ReleaseBuildID |
|
|
Restrict delete | ||||
| FK_MacmillanValidTransitions_Destination_MacmillanImportStatus |
|
|
Restrict delete | ||||
| FK_MacmillanValidTransitions_Source_MacmillanImportStatus |
|
|
Restrict delete | ||||
| FK_DisRadiotherapyLinkage_ltblAuditActionType |
|
|
Restrict delete | ||||
| FK_tblSURGERY_COLORECTAL_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblSURGERY_COLORECTAL_TransanalTME |
|
|
Restrict delete | ||||
| FK_tblSURGERY_COLORECTAL_PelvicSidewallClearance |
|
|
Restrict delete | ||||
| FK_tblAHP_CONTACTS_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblAHP_CONTACTS_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblDEMOGRAPHICS_GP |
|
|
Restrict delete | ||||
| FK_ltblGENDER_N1_9_SEX |
|
|
Restrict delete | ||||
| FK_tblDEMOGRAPHICS_Practice |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__3845FBA8 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__5A9B13AC |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__7ED87422 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__2221B05F |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__2F7BAB7D |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__393A1FE1 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__15BBD97A |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__3BE18262 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__2E878744 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__3AED5E29 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__67F50ECA |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__7FCC985B |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__68E93303 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__4E353CC7 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__745AE5AF |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__4F296100 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__212D8C26 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__7366C176 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__43B7AE54 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__09560295 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__UserI__0A4A26CE |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__14C7B541 |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__42C38A1B |
|
|
Restrict delete | ||||
| FK__aspnet_Pe__PathI__59A6EF73 |
|
|
Restrict delete | ||||
| FK_tblCUP_CATEGORY_tblREFERRAL_CUP |
|
|
Cascade on delete | ||||
| FK_ltblTeletherapyNotCompleteReason_ltblNOGCANotCompleteReason |
|
|
Restrict delete | ||||
| FK_tblSPINAL_CORD_COMPRESSION_tblDEMOGRAPHICS |
|
|
Cascade on delete | ||||
| FK_tblTREATMENT_SUMMARY_PUBLISHED_CNS_REFERRALS_tblTREATMENT_SUMMARY_PUBLISHED |
|
|
Restrict delete | ||||
| FK_tblBRACHYTHERAPY_DERMATOLOGY_tblMAIN_BRACHYTHERAPY |
|
|
Cascade on delete | ||||
| FK_tblOTHER_TREATMENT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_lnkUpperGIPostoperativeComplications_ltblUpperGISurgicalComplications |
|
|
Restrict delete | ||||
| FK_lnkUpperGIPostoperativeComplications_tblMAIN_SURGERY |
|
|
Restrict delete | ||||
| FK_GroupID |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_PUBLISHED_CNS_CARE_PLAN_tblTREATMENT_SUMMARY_PUBLISHED |
|
|
Restrict delete | ||||
| FK_tblCHEMOTHERAPY_PAEDIATRIC_tblMAIN_CHEMOTHERAPY |
|
|
Cascade on delete | ||||
| FK_tblPATHOLOGY_BREAST_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_tblTERTIARY_REFERRAL_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_PracticeGP_Branch |
|
|
Restrict delete | ||||
| FK_PracticeGP_Practice |
|
|
Restrict delete | ||||
| FK_PracticeGP_GP |
|
|
Restrict delete | ||||
| FK_ltblHNReconstruction_ltblHNReconstructionSubGroup |
|
|
Restrict delete | ||||
| FK_tblMAIN_CHEMO_TREATMENT_tblMAIN_CHEMOTHERAPY |
|
|
Cascade on delete | ||||
| FK_TimedPathwayEventInvestigation_ltblIMAGING_MOD |
|
|
Restrict delete | ||||
| FK_TimedPathwayEventInvestigation_TimedPathwayEvent |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_ltblTREATMENT_SUMMARY_AIM |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_COLORECTAL_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_SomaticTestingLung_EGFR |
|
|
Restrict delete | ||||
| FK_SomaticTestingLung_PDL1 |
|
|
Restrict delete | ||||
| FK_SomaticTestingLung_SomaticTesting |
|
|
Restrict delete | ||||
| FK_SomaticTestingLung_RosFusions |
|
|
Restrict delete | ||||
| FK_SomaticTestingLung_ALKFusions |
|
|
Restrict delete | ||||
| FK_tblUNPLANNED_RETURN_TO_THEATRE_ltblPROCEDURES |
|
|
Restrict delete | ||||
| FK_tblUNPLANNED_RETURN_TO_THEATRE_tblMAIN_SURGERY |
|
|
Restrict delete | ||||
| FK_tblUNPLANNED_RETURN_TO_THEATRE_ltblLATERALITY |
|
|
Restrict delete | ||||
| FK_tblUNPLANNED_RETURN_TO_THEATRE_ltblCONSULTANTS |
|
|
Restrict delete | ||||
| FK_tblPATHOLOGY_BRAIN_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_ltblChemotherapyNotCompleteReason_ltblNOGCANotCompleteReason |
|
|
Restrict delete | ||||
| FK_ltblChemotherapyNotCompleteReason_ltblSACTChangeReasons |
|
|
Restrict delete | ||||
| FK_lnkPathologySynchronousTumour_lnkPathologySynchronousTumour |
|
|
Restrict delete | ||||
| FK_lnkPathologySynchronousTumour_tblMAIN_PATHOLOGY |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_GYNAECOLOGY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_GYNAECOLOGY_OrganisationSites |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CNS_ltblCNS_NAME |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CNS_tblAO_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UPPER_GI_DiabetesIndicator |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UPPER_GI_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_UPPER_GI_ltblCholangiocarcinoma |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UPPER_GI_ltblLiverCirrhosisType |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_UPPER_GI_ltblPAED_STAGE |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UPPER_GI_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UPPER_GI_LiverSurveillanceScans |
|
|
Cascade on delete | ||||
| FK_tblPresentationHeadNeckSiteOfPreviousCancer_ltblSitePreviousHeadNeckCancer |
|
|
Restrict delete | ||||
| FK_tblPresentationHeadNeckSiteOfPreviousCancer_tblINITIAL_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_tblPALLIATIVE_CONTACT_BACK_UP_tblPALLIATIVE_CARE |
|
|
Cascade on delete | ||||
| FK_tblASSESSMENT_GYNAECOLOGY_tblMAIN_ASSESSMENT |
|
|
Cascade on delete | ||||
| FK_tblDEFINITIVE_TREATMENT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_lnkAO_ASSESSED_BY_CNS_MSCC_tblAO_MSCC |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CNS_MSCC_ltblCNS_NAME |
|
|
Restrict delete | ||||
| FK_tblDERMATOLOGY_RECURRENCES_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblLUNG_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblLUNG_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblLUNG_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblLUNG_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblLUNG_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_CancerReferralSubsites_ltblCANCER_SITES |
|
|
Restrict delete | ||||
| FK_tblMAIN_BRACHYTHERAPY_ltblAdjunctiveTherapy |
|
|
Restrict delete | ||||
| FK_tblMAIN_BRACHYTHERAPY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblMAIN_BRACHYTHERAPY_ltblTreatmentIntent |
|
|
Restrict delete | ||||
| FK_TimedPathwayEventClinic_TimedPathwayEvent |
|
|
Restrict delete | ||||
| FK_tblCUP_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblCUP_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblCUP_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblCUP_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblCUP_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_lnkPAL_REASON_REFERRAL_NEW_ltblPAL_REASON_REFERRAL_NEW |
|
|
Restrict delete | ||||
| FK_lnkPAL_REASON_REFERRAL_NEW_tblPALLIATIVE_CARE |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_RECEIVED_tblTERTIARY_REFERRALS |
|
|
Restrict delete | ||||
| FK_eReferralMessageAmendments_eReferralMessageAmendments |
|
|
Cascade on delete | ||||
| FK__aspnet_Pr__UserI__717E7904 |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__57BEA701 |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__7CF02BB0 |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__3810F17E |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__0861DE5C |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__4C4CF455 |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__2AB6F660 |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__4476C863 |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__12DF6CCF |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__1E511F7B |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__41CF65E2 |
|
|
Restrict delete | ||||
| FK__aspnet_Pr__UserI__633059AD |
|
|
Restrict delete | ||||
| FK_tblASSESSMENT_HN_INV_ORD_SITES_tblASSESSMENT_HN_INV_ORD |
|
|
Cascade on delete | ||||
| FK_tblASSESSMENT_HN_INV_ORD_SITES_ltblInvestigationSite |
|
|
Cascade on delete | ||||
| FK_GermlineTestsOffered_GermlineTesting |
|
|
Restrict delete | ||||
| FK_GermlineTestsOffered_GermlineTest |
|
|
Restrict delete | ||||
| FK_tblPATHOLOGY_COLORECTAL_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_tblCNSCarePlan_tblCNSContact |
|
|
Cascade on delete | ||||
| FK_tblMAIN_TRIAL_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblCNSClinicalActivity_tblCNSContact |
|
|
Restrict delete | ||||
| FK_tblCNSClinicalActivity_ltblCNS_CLINICAL_ACTIVITY |
|
|
Restrict delete | ||||
| FK_tblSCORES_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_MacmillanFileUpload_UserId |
|
|
Restrict delete | ||||
| FK_TimedPathwayEventLink_tblMAIN_REFERRALS |
|
|
Restrict delete | ||||
| FK_TimedPathwayEventLink_TimedPathwayEvent |
|
|
Restrict delete | ||||
| FK_tblPOSSUM_SCORE_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_TimedPathwayEventDatePatientInformed_TimedPathwayEvent |
|
|
Restrict delete | ||||
| FK_tblPATHOLOGY_HAEMATOLOGY_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_lnkPatientAddress_tblDEMOGRAPHICS |
|
|
Restrict delete | ||||
| FK_lnkPatientAddress_tblAddress |
|
|
Restrict delete | ||||
| FK_NOGCAProforma_NOGCADieteticInvolvement |
|
|
Restrict delete | ||||
| FK_NOGCAProformaData_tblMAIN_REFERRALS |
|
|
Restrict delete | ||||
| FK_NOGCAProforma_NOGCANutritionalSupportDuringAdmin |
|
|
Restrict delete | ||||
| FK_NOGCAProformaData_DieteticInvolvementBeforeTreatment |
|
|
Restrict delete | ||||
| FK_NOGCAProformaData_NOGCANutritionalSupportOnDischarge |
|
|
Restrict delete | ||||
| FK_tblCARE_PLAN_SARCOMA_tblMAIN_CARE_PLAN |
|
|
Cascade on delete | ||||
| FK_tblINITIAL_ASSESSMENT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblINITIAL_ASSESSMENT_ltblYN |
|
|
Restrict delete | ||||
| FK_tblINITIAL_ASSESSMENT_CurrentPhysicalActivity |
|
|
Restrict delete | ||||
| FK_tblINITIAL_ASSESSMENT_ltblYN2 |
|
|
Restrict delete | ||||
| FK_tblINITIAL_ASSESSMENT_ltblYN1 |
|
|
Restrict delete | ||||
| FK_tblINITIAL_ASSESSMENT_ClinicalFrailtyScale |
|
|
Restrict delete | ||||
| FK_tblINITIAL_ASSESSMENT_TobaccoAddiction |
|
|
Restrict delete | ||||
| FK_TimedPathwayEventMDT_TimedPathwayEvent |
|
|
Restrict delete | ||||
| FK_ltblLongTermComplications_ltblLongTermComplicationGroups |
|
|
Restrict delete | ||||
| FK_ltblHAEM_ICD03_GROUP_ICD03Categories |
|
|
Restrict delete | ||||
| FK_tblCOLORECTAL_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblCOLORECTAL_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblCOLORECTAL_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblCOLORECTAL_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblCOLORECTAL_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UROLOGY_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UROLOGY_ltblYNNK1 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UROLOGY_ltblYNNK |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UROLOGY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_UROLOGY_OrganisationSites2 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_UROLOGY_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_TertiaryReferralReturns_tblTERTIARY_REFERRALS |
|
|
Restrict delete | ||||
| FK_TertiaryReferralReturns_AuditID |
|
|
Restrict delete | ||||
| FK_TertiaryReferralReturns_PayloadID |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_TOXICITIES_MAPPING_ltblTREATMENT_TOXICITIES |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_TOXICITIES_MAPPING_tblTREATMENT_SUMMARY |
|
|
Restrict delete | ||||
| FK_ltblCONSULTANTS_ProfessionalRegistrationBody |
|
|
Restrict delete | ||||
| FK_tblMAIN_CHEMO_ADMINISTRATION_tblMAIN_CHEMO_TREATMENT |
|
|
Cascade on delete | ||||
| FK_tblMAIN_CHEMO_ADMINISTRATION_AdminMeasurementID |
|
|
Restrict delete | ||||
| FK_tblPalliativeMetastases_ltblMetastaticType |
|
|
Restrict delete | ||||
| FK_tblPalliativeMetastases_ltblMetastaticSite |
|
|
Restrict delete | ||||
| FK_tblPalliativeMetastases_tblPALLIATIVE_CARE |
|
|
Restrict delete | ||||
| FK_tblPalliativeMetastases_ltblMetastaticState |
|
|
Restrict delete | ||||
| FK_tblMAIN_TELETHERAPY_ltblTreatmentCompletedAsPlanned |
|
|
Restrict delete | ||||
| FK_tblMAIN_TELETHERAPY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblMAIN_TELETHERAPY_ltblTeletherapyNotCompleteReason |
|
|
Restrict delete | ||||
| FK_tblMAIN_TELETHERAPY_ltblAdjunctiveTherapy |
|
|
Restrict delete | ||||
| FK_tblMAIN_TELETHERAPY_ltblTreatmentIntent |
|
|
Restrict delete | ||||
| FK_ltblHNProcedure_ltblHNProcedureGroup |
|
|
Restrict delete | ||||
| FK_tblMAIN_CARE_PLAN_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblMAIN_CARE_PLAN_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblCHEMOTHERAPY_DERMATOLOGY_tblMAIN_CHEMOTHERAPY |
|
|
Cascade on delete | ||||
| FK_tblCNSContactType_ltblCNS_CONTACT |
|
|
Restrict delete | ||||
| FK_tblCNSContactType_tblCNSContact |
|
|
Restrict delete | ||||
| FK_tblCNSTriage_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblCNSTriage_TriagedBy |
|
|
Cascade on delete | ||||
| FK_tblCNSTriage_ltblCNSOutcome |
|
|
Cascade on delete | ||||
| FK_AspNetUsers_AssociatedCNSId |
|
|
Restrict delete | ||||
| FK_AspNetUsers_AdminUserID |
|
|
Restrict delete | ||||
| FK_tblMAIN_IMAGING_LikertScore |
|
|
Restrict delete | ||||
| FK_tblMAIN_IMAGING_ltblIMAGING_MOD |
|
|
Restrict delete | ||||
| FK_tblMAIN_IMAGING_ltblTransperinealBiopsyTechnique |
|
|
Restrict delete | ||||
| FK_tblMAIN_IMAGING_ltblTransrectalBiopsyTechnique |
|
|
Restrict delete | ||||
| FK_tblMAIN_IMAGING_ltblBiopsyAnaesthetic |
|
|
Restrict delete | ||||
| FK_tblMAIN_IMAGING_PiradsCategoryId |
|
|
Restrict delete | ||||
| FK_tblMAIN_IMAGING_ltblPortalVeinInvasion |
|
|
Restrict delete | ||||
| FK_TimedPathwayEventTriage_ltblTimedPathwayEventTriageType |
|
|
Restrict delete | ||||
| FK_TimedPathwayEventTriage_TimedPathwayEvent |
|
|
Restrict delete | ||||
| FK_BRAFSomaticTestingColorectal_ltblMutationResults |
|
|
Restrict delete | ||||
| FK_SomaticTestingColorectal_SomaticTesting |
|
|
Restrict delete | ||||
| FK_MisMatchSomaticTestingColorectal_ltblMismatchRepair |
|
|
Restrict delete | ||||
| FK_KRASSomaticTestingColorectal_ltblMutationResults |
|
|
Restrict delete | ||||
| FK_NRASSomaticTestingColorectal_ltblMutationResults |
|
|
Restrict delete | ||||
| FK_MSISomaticTestingColorectal_ltblMSIResults |
|
|
Restrict delete | ||||
| FK_tblTeletherapyToxicitySymptoms_tblMAIN_TELETHERAPY |
|
|
Restrict delete | ||||
| FK_tblTeletherapyToxicitySymptoms_ltblTeletherapyToxicity |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_SARCOMA_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_SARCOMA_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblASSESSMENT_UROLOGY_tblMAIN_ASSESSMENT |
|
|
Cascade on delete | ||||
| FK_Organisations_ltblRDC_CancerAlliances |
|
|
Cascade on delete | ||||
| FK__aspnet_Us__Appli__1A808E97 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__3440609A |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__26E6657C |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__53EE161D |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__04914D78 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__487C6371 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__40A6377F |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__791F9ACC |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__0F0EDBEB |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__3DFED4FE |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__5F5FC8C9 |
|
|
Restrict delete | ||||
| FK__aspnet_Us__Appli__6DADE820 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_ltblPOSTInductionMRD |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites2 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_ltblPaedRiskGroup |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites4 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites3 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_ltblELNGeneticRisk |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_ltblALLRiskGroupAllocation |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_ltblFABClassification |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_HAEMATOLOGY_ltblRISSStaging |
|
|
Restrict delete | ||||
| FK_tblMONITORING_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblHNProcedureNeeded_tblMAIN_SURGERY_SurgeryID |
|
|
Restrict delete | ||||
| FK_tblHNProcedureNeeded_ltblHNProcedureNeeded |
|
|
Restrict delete | ||||
| FK_tblTNM_VERSION_HISTORY_LOCAL_TNMCodingEditions |
|
|
Restrict delete | ||||
| FK_tblTNM_VERSION_HISTORY_LOCAL_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblAllTreatmentDeclined_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblAUDIT_RECORD_ltblAUDIT_RECORD_TYPE |
|
|
Restrict delete | ||||
| FK_tblAUDIT_RECORD_ltblAUDIT_TYPE |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__6053ED02 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__27DA89B5 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__3EF2F937 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__6EA20C59 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__058571B1 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__419A5BB8 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__10030024 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__353484D3 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__497087AA |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__7A13BF05 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__1B74B2D0 |
|
|
Restrict delete | ||||
| FK__aspnet_Ro__Appli__54E23A56 |
|
|
Restrict delete | ||||
| FK_tblCNSInitialReferral_L_ACCEPTED |
|
|
Cascade on delete | ||||
| FK_tblCNSInitialReferral_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblCNSInitialReferral_L_DETAILS |
|
|
Restrict delete | ||||
| FK_tblCNSInitialReferral_ltblCNS_REASON_REF |
|
|
Cascade on delete | ||||
| FK_tblCNSInitialReferral_L_VERBAL |
|
|
Restrict delete | ||||
| FK_tblCNSInitialReferral_L_CONTACT |
|
|
Cascade on delete | ||||
| FK_tblCNSInitialReferral_ltblCNS_SOURCE_REF |
|
|
Cascade on delete | ||||
| FK_tblCNSInitialReferral_L_WRITTEN |
|
|
Restrict delete | ||||
| FK_tblCNSInitialReferral_REASON_CNS_NOT_PRESENT |
|
|
Cascade on delete | ||||
| FK_tblSURGERY_BRAIN_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_SomaticTesting_SomaticPerformedStatus |
|
|
Restrict delete | ||||
| FK_SomaticTesting_OrganisationSites |
|
|
Restrict delete | ||||
| FK_SomaticTesting_tblINITIAL_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_DisSurgeryLinkage_ltblAuditActionType |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_NEW_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId |
|
|
Cascade on delete | ||||
| FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId |
|
|
Cascade on delete | ||||
| FK_tblHEAD_NECK_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblHEAD_NECK_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblHEAD_NECK_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblHEAD_NECK_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblHEAD_NECK_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblINITIAL_BRAIN_ltblYN |
|
|
Restrict delete | ||||
| FK_tblINITIAL_BRAIN_tblINITIAL_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_GermlineTesting_ClinicalGeneticistOfferStatus |
|
|
Restrict delete | ||||
| FK_GermlineTesting_GermlineTestingOfferStatus |
|
|
Restrict delete | ||||
| FK_GermlineTesting_OrganisationSites |
|
|
Restrict delete | ||||
| FK_GermlineTesting_tblINITIAL_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_tblPALLIATIVE_EPISODE_tblPALLIATIVE_CARE |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblGradeOfComplications |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_LiverTransplantWaitingListIndicator |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblMinimallyInvasiveApproach |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblNeckDissection |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblSurgicalPathway |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblLeakSeverity |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblOesophagealConduit |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblBloodProductUtilisation |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblConduitNecrosisFailure |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblOpenApproach |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblNumberOfUnitsTransfused |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblERASPathwayCompleted |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblSurgicalApproach |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblChangeInLevelOfCare |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblLiverSurgeryType |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblChyleLeakSeverity |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblAnastomosis |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UPPER_GI_ltblRecurrentNerveInjury |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BRAIN_ltblANU_VisualFieldsLeft |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BRAIN_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BRAIN_ltblANU_Right |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BRAIN_ltblANU_VisualFieldsRight |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BRAIN_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BRAIN_ltblANU_Left |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BRAIN_ltblINRG_STAGING |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_BRAIN_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblPATHOLOGY_UROLOGY_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_tblPATHOLOGY_UROLOGY_ltblNuclearGrade |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CONSULTANT_tblAO_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CONSULTANT_ltblCONSULTANTS |
|
|
Restrict delete | ||||
| FK_ltblDIAGNOSIS_ltblFasterDiagnosisCancerSite |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_PUBLISHED_TOXICITIES_tblTREATMENT_SUMMARY_PUBLISHED |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UROLOGY_ltblBiopsyAnaesthetic |
|
|
Restrict delete | ||||
| FK_tblSURGERY_UROLOGY_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblSURGERY_UROLOGY_ltblProstateBiopsyTechnique2 |
|
|
Restrict delete | ||||
| FK_tblUSER_PROFILE_ltblUSER_DEPARTMENT |
|
|
Restrict delete | ||||
| FK_tblUSER_PROFILE_ltblADMIN_USER |
|
|
Restrict delete | ||||
| FK_tblUSER_PROFILE_ltblCNS_NAME |
|
|
Restrict delete | ||||
| FK_tblTNM_VERSION_HISTORY_GLOBAL_TNMCodingEditions |
|
|
Restrict delete | ||||
| FK_SomaticTestingPaediatric_SomaticTesting |
|
|
Restrict delete | ||||
| FK_SomaticTestingPaediatric_ALKFusions |
|
|
Restrict delete | ||||
| FK_tblMAIN_SURGERY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblMAIN_SURGERY_SNOMEDProcedure_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblMAIN_SURGERY_SNOMEDProcedure2_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblMAIN_SURGERY_ltblTreatmentIntent |
|
|
Restrict delete | ||||
| FK_tblMAIN_SURGERY_SNOMEDProcedure3_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblMAIN_SURGERY_ltblAdjunctiveTherapy |
|
|
Restrict delete | ||||
| FK_tblMAIN_SURGERY_ltblSURGICAL_ACCESS |
|
|
Restrict delete | ||||
| FK_eReferralMessageErrors_eReferralErrorSeverity |
|
|
Restrict delete | ||||
| FK_eReferralMessageErrors_eReferralMessages |
|
|
Cascade on delete | ||||
| FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId |
|
|
Cascade on delete | ||||
| FK_tblPATHOLOGY_LUNG_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_Branch_Practice |
|
|
Restrict delete | ||||
| FK_tblGYNAECOLOGY_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblGYNAECOLOGY_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblGYNAECOLOGY_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblGYNAECOLOGY_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblGYNAECOLOGY_MDT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblGYNAECOLOGY_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblSURGERY_HEAD_NECK_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblSURGERY_HEAD_NECK_ltblSurgicalAccessHN |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryMetastases_ltblMetastaticSite |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryMetastases_ltblMetastaticType |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryMetastases_tblNonPrimaryPathway |
|
|
Restrict delete | ||||
| FK_tblNonPrimaryMetastases_ltblMetastaticState |
|
|
Restrict delete | ||||
| FK_SomaticTestingHaematology_SomaticTesting |
|
|
Restrict delete | ||||
| FK_SomaticTestingHaematology_ALKFusions |
|
|
Restrict delete | ||||
| FK_ltblIMAGING_MOD_ltblIMAGING_MOD_GROUP |
|
|
Restrict delete | ||||
| FK_tblREFERRAL_CUP_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblPATHOLOGY_GYNAECOLOGY_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_SomaticTestsPerformed_SomaticTesting |
|
|
Restrict delete | ||||
| FK_SomaticTestsPerformed_SomaticTest |
|
|
Restrict delete | ||||
| FK_tblHolisticAssessment_tblCNSContact |
|
|
Cascade on delete | ||||
| FK_tblChemotherapyDrugRegimen_ltblHanaDrugRegimen |
|
|
Restrict delete | ||||
| FK_tblChemotherapyDrugRegimen_tblMAIN_CHEMOTHERAPY |
|
|
Restrict delete | ||||
| FK_tblPATHOLOGY_HEAD_NECK_tblMAIN_PATHOLOGY |
|
|
Cascade on delete | ||||
| FK_tblMDT_LIST_ltblCONSULTANTS |
|
|
Restrict delete | ||||
| FK_tblMDT_LIST_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblCNSTriageContactType_ltblCNS_CONTACT |
|
|
Restrict delete | ||||
| FK_tblCNSTriageContactType_tblCNSTriage |
|
|
Restrict delete | ||||
| FK_tblFAMILY_HISTORY_tblINITIAL_ASSESSMENT |
|
|
Cascade on delete | ||||
| FK_tblUGI_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblUGI_MDT_ltblPAED_STAGE |
|
|
Restrict delete | ||||
| FK_tblUGI_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblUGI_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblUGI_MDT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblUGI_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblUGI_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_RECIEVED_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tmpPALLIATIVE_CARE_DOWNLOAD_ltblPALLIATIVE_CARE_DOWNLOAD_SECTIONS |
|
|
Restrict delete | ||||
| FK_tblSKIN_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblSKIN_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblSKIN_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblSKIN_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblSKIN_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_MacmillanRecordUpload_FileId |
|
|
Restrict delete | ||||
| FK_MacmillanRecordUpload_Status |
|
|
Restrict delete | ||||
| FK_MacmillanRecordUpload_CNSRecordId |
|
|
Restrict delete | ||||
| FK_lnkDiagnosisAddress_tblMAIN_REFERRALS1 |
|
|
Restrict delete | ||||
| FK_lnkDiagnosisAddress_tblAddress1 |
|
|
Restrict delete | ||||
| FK_MacmillanCNSReferences_CNSContactId |
|
|
Restrict delete | ||||
| FK_tblHIGH_GRADE_DYSPLASIA_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblTREATMENT_SUMMARY_REFERRAL_MAPPING_tblTREATMENT_SUMMARY |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_REFERRAL_MAPPING_ltblTREATMENT_SUMMARY_REFERRALS |
|
|
Restrict delete | ||||
| FK_tblSURGERY_BREAST_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_lnkPAL_REF_INVESTIGATIONS_tblPALLIATIVE_CARE |
|
|
Restrict delete | ||||
| FK_lnkPAL_REF_INVESTIGATIONS_ltblPALLIATIVE_INVESTIGATIONS |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_ltblMDTDiscussionType |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_SNOMEDCTConcepts |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_ltblNonPrimaryPathwayOptions |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblHAEMATOLOGY_MDT_ltblFABClassification |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_ltblRISSStaging |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_ltblPOSTInductionMRD |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_ltblELNGeneticRisk |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_OrganisationMiscSites |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_OrganisationSites4 |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_OrganisationSites3 |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_OrganisationSites2 |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_ltblPaedRiskGroup |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblHAEMATOLOGY_MDT_OrganisationSites1 |
|
|
Restrict delete | ||||
| FK_tblPresentationHeadNeckActualSymptoms_tblINITIAL_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_tblPresentationHeadNeckActualSymptoms_ltblActualSymptoms |
|
|
Restrict delete | ||||
| FK_tblPALLIATIVE_INPATIENTS_tblPALLIATIVE_CARE |
|
|
Cascade on delete | ||||
| FK_tblPSATrackerUrology_ltblTrackingStatus |
|
|
Restrict delete | ||||
| FK_tblPSATrackerUrology_tblREFERRAL_UROLOGY |
|
|
Restrict delete | ||||
| FK_tblRDCClinicalTriageDiagnosticTesting_ltblRDCResultOfReferral |
|
|
Restrict delete | ||||
| FK_tblRDCClinicalTriageDiagnosticTesting_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_CNSCarePlanSections_CarePlan |
|
|
Restrict delete | ||||
| FK_CNSCarePlanSections_ConcernGroupID |
|
|
Restrict delete | ||||
| FK_lnkPretextAnnotationFactorsMDT_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_lnkPretextAnnotationFactorsMDT_ltblPAED_EXT |
|
|
Restrict delete | ||||
| FK_tblROOT_CAUSE_NOTES_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblPALLIATIVE_EPISODE_OUTPATIENT_tblPALLIATIVE_EPISODE |
|
|
Restrict delete | ||||
| FK_eReferralMessages_aspnet_Users |
|
|
Restrict delete | ||||
| FK_eReferralMessages_eReferralMessageType |
|
|
Restrict delete | ||||
| FK_eReferralMessages_aspnet_Users_Amendments |
|
|
Restrict delete | ||||
| FK_eReferralMessages_eReferralProcessingStatus |
|
|
Restrict delete | ||||
| FK_tblASSESSMENT_HN_INV_ORD_tblASSESSMENT_HEAD_NECK |
|
|
Cascade on delete | ||||
| FK_tblASSESSMENT_HN_INV_ORD_ltblInvestigationsOrdered |
|
|
Cascade on delete | ||||
| FK_tblTERTIARY_REFERRALS_IPTF_tblTERTIARY_REFERRALS |
|
|
Restrict delete | ||||
| FK_tblMAIN_PATHOLOGY_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId |
|
|
Cascade on delete | ||||
| FK_tblColorectalTracker_ltblTrackingStatus |
|
|
Restrict delete | ||||
| FK_tblColorectalTracker_tblREFERRAL_COLORECTAL |
|
|
Restrict delete | ||||
| FK_tblBreastTracker_ltblTrackingStatus |
|
|
Restrict delete | ||||
| FK_tblBreastTracker_tblREFERRAL_BREAST |
|
|
Restrict delete | ||||
| FK_lnkAO_REFERRAL_PATIENT_TYPE_tblAO_REFERRAL |
|
|
Restrict delete | ||||
| FK_lnkAO_REFERRAL_PATIENT_TYPE_ltblAOPatientType |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CONSULTANT_MSCC_tblAO_MSCC |
|
|
Restrict delete | ||||
| FK_lnkAO_ASSESSED_BY_CONSULTANT_MSCC_ltblCONSULTANTS |
|
|
Restrict delete | ||||
| FK_tblSURGERY_SARCOMA_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblINPATIENT_ADMISSIONS_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblSURGERY_DERMATOLOGY_tblMAIN_SURGERY |
|
|
Cascade on delete | ||||
| FK_tblSURGERY_DERMATOLOGY_ltblCLINICIAN_GRADE |
|
|
Restrict delete | ||||
| FK_tblTREATMENT_SUMMARY_PUBLISHED_TREATMENTS_tblTREATMENT_SUMMARY_PUBLISHED |
|
|
Cascade on delete | ||||
| FK_tblLinkedReferrals_tblDEMOGRAPHICS |
|
|
Restrict delete | ||||
| FK_tblLinkedReferrals_tblMAIN_REFERRALS |
|
|
Restrict delete | ||||
| FK_tblLinkedReferrals_ltblReferralLinkType |
|
|
Restrict delete | ||||
| FK_tblLinkedReferrals_tblMAIN_REFERRALS1 |
|
|
Restrict delete | ||||
| FK_tblCNSContact_L_PRIVACY |
|
|
Restrict delete | ||||
| FK_tblCNSContact_POINT_OF_PATHWAY |
|
|
Restrict delete | ||||
| FK_WhenTreatmentSummaryCompleted |
|
|
Restrict delete | ||||
| FK_tblCNSContact_L_CONTACT_PLACE |
|
|
Cascade on delete | ||||
| FK_tblCNSContact_L_PT_STATUS |
|
|
Restrict delete | ||||
| FK_tblCNSContact_tblMAIN_REFERRALS |
|
|
Cascade on delete | ||||
| FK_tblCNSContact_CarePlanCompletedBy |
|
|
Restrict delete | ||||
| FK_TreatmentSummarySharedWith |
|
|
Restrict delete | ||||
| FK_tblCNSContact_L_REFERRAL_1 |
|
|
Restrict delete | ||||
| FK_tblCNSContact_CarePlanStatus |
|
|
Restrict delete | ||||
| FK_tblCNSContact_L_REFERRAL_2 |
|
|
Restrict delete | ||||
| FK_tblCNSContact_L_REFERRAL_3 |
|
|
Restrict delete | ||||
| FK_tblCNSContact_L_CNS |
|
|
Cascade on delete | ||||
| FK_HNAStatus |
|
|
Restrict delete | ||||
| FK_TreatmentSummaryCompleted |
|
|
Restrict delete | ||||
| FK_tblCNSContact_ltblPOINT_OF_PATHWAY |
|
|
Restrict delete | ||||
| FK_tblCNSContact_HNATypeOffered |
|
|
Restrict delete | ||||
| FK_tblCNSContact_L_ORGANISATION_OrganisationSites |
|
|
Restrict delete | ||||
| FK_tblCNSContact_ltblYN |
|
|
Restrict delete | ||||
| FK_tblAO_MSCC_tblAO_REFERRAL |
|
|
Restrict delete | ||||
| FK_tblAuditReferenceData_ltblReferenceDataType |
|
|
Restrict delete | ||||
| FK_tblAuditReferenceData_AspNetUsers |
|
|
Restrict delete | ||||
| FK_tblAuditReferenceData_ltblAuditActionType |
|
|
Restrict delete | ||||
| FK_DisOscopyLinkage_ltblAuditActionType |
|
|
Restrict delete | ||||
| FK_tblTERTIARY_REFERRALS_PayloadID |
|
|
Restrict delete | ||||
| FK_tblPresentationHeadNeckActualSiteOfSymptoms_tblINITIAL_ASSESSMENT |
|
|
Restrict delete | ||||
| FK_tblPresentationHeadNeckActualSiteOfSymptoms_ltblActualSiteOfSymptoms |
|
|
Restrict delete | ||||
| FK_ltblPAL_WARDS_ltblAOAssessmentLocation |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| tblMAIN_ASSESSMENT | CHK_StratifiedOnly | ([N14_9_FOLLOW_UP]=(5) OR [StratifiedFollowupType] IS NULL) |
| tblMAIN_REFERRALS | InformedOrExcluded | ([L_PT_INFORMED_DATE] IS NULL OR [FasterDiagnosisExclusionDate] IS NULL) |
| CNSCarePlanSections | RequireAtLeastOneField | (coalesce(nullif(rtrim([ConcernDetails]),''),nullif(rtrim([PatientActions]),''),nullif(rtrim([CNSActions]),'')) IS NOT NULL) |
| tblCNSContact | CK__tblCNSCon__PAM_L__3BBD265B | ([PAM_Level]=(4) OR [PAM_Level]=(3) OR [PAM_Level]=(2) OR [PAM_Level]=(1)) |
| tblCNSContact | CK__tblCNSCon__PAM_S__3AC90222 | ([PAM_Score]>=(0) AND [PAM_Score]<=(999)) |