267 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| FK__PatientEv__Evalu__6FE99F9F |
|
|
Restrict delete | ||
| FK__PatientEv__PatientAdmin |
|
|
Cascade on delete | ||
| FK__PatientIFSP__PatientAdmin |
|
|
Cascade on delete | ||
| FK_EnrollmentPaysources_Enrollments |
|
|
Restrict delete | ||
| FK_EnrollmentPaysources_AccessUser |
|
|
Restrict delete | ||
| FK_PasswordPolicy_PasswordComplexity |
|
|
Restrict delete | ||
| FK_Categories_AccessUser1 |
|
|
Restrict delete | ||
| FK_Categories_SecurableItems |
|
|
Restrict delete | ||
| FK_Categories_AccessUser |
|
|
Restrict delete | ||
| FK__DisReaInP__Disch__2E86BBED |
|
|
Cascade on delete | ||
| FK__Authorize__RoomI__638EB5B2 |
|
|
Cascade on delete | ||
| FK__Authorize__AuthI__629A9179 |
|
|
Cascade on delete | ||
| FK__UserInSupportLevel__AccessUser |
|
|
Cascade on delete | ||
| FK__UserInSupportLevel__SupportLevel |
|
|
Cascade on delete | ||
| FK_AccessUserPatient_AccessUser |
|
|
Cascade on delete | ||
| FK__PatientAssignment__PatientAdmin |
|
|
Cascade on delete | ||
| FK_Message_AccessUser |
|
|
Restrict delete | ||
| FK_Message_Message |
|
|
Restrict delete | ||
| FK_StoredProcinFlexForm_StoredProc |
|
|
Restrict delete | ||
| FK_StoredProcinFlexForm_FlexForm |
|
|
Restrict delete | ||
| FK_ActivityCategorySecurity_ActivityCategory |
|
|
Restrict delete | ||
| FK__iTemplate__Archi__31EF9A82 |
|
|
Restrict delete | ||
| FK_Objective_AccessUser1 |
|
|
Restrict delete | ||
| FK_Objective_Goal |
|
|
Restrict delete | ||
| FK_Objective_CustomConfig1 |
|
|
Restrict delete | ||
| FK_Objective_AccessUser |
|
|
Restrict delete | ||
| FK_Objective_CustomConfig2 |
|
|
Restrict delete | ||
| FK_Objective_CustomConfig3 |
|
|
Restrict delete | ||
| FK_Objective_CustomConfig |
|
|
Restrict delete | ||
| FK__UserInSit__UserI__14C6E9EA |
|
|
Cascade on delete | ||
| FK__UserInSite__SPID__13D2C5B1 |
|
|
Cascade on delete | ||
| FK_Security_SecurableItems1 |
|
|
Restrict delete | ||
| FK_Security_SecurableItems |
|
|
Restrict delete | ||
| FK_AlertMessage_AlertReportConfig |
|
|
Restrict delete | ||
| FK__PatientAlias__Patient |
|
|
Cascade on delete | ||
| FK_PatientEvaluationICD9_PatientEvaluation |
|
|
Restrict delete | ||
| FK_PatientEvaluationICD9_Diagnosis |
|
|
Restrict delete | ||
| FK__UserFieldsInLev__UserFields |
|
|
Cascade on delete | ||
| FK__UserInCustomConfig__Accessuser |
|
|
Cascade on delete | ||
| FK__UserInCustomConfig__CustomConfig |
|
|
Cascade on delete | ||
| FK_iTemplate_AccessUser |
|
|
Restrict delete | ||
| FK_iTemplate_AccessUser2 |
|
|
Restrict delete | ||
| FK_iTemplate_AccessUser1 |
|
|
Restrict delete | ||
| FK_Invoice_RateType |
|
|
Restrict delete | ||
| FK__INVOICE__fkInvoi__4AB9B19E |
|
|
Restrict delete | ||
| FK__Invoice__Billing |
|
|
Restrict delete | ||
| FK_DocumentSigns_documents |
|
|
Restrict delete | ||
| FK_DocumentSigns_AccessUser |
|
|
Restrict delete | ||
| FK__UserFieldVal__AccessUser |
|
|
Cascade on delete | ||
| FK__UserFieldVal__UserFields |
|
|
Cascade on delete | ||
| FK_Attendances_Enrollments |
|
|
Restrict delete | ||
| FK_ClaimCPT_Claim |
|
|
Restrict delete | ||
| FK_ClaimCPT_CPTCode |
|
|
Restrict delete | ||
| FK__Specialty__speci__69DC8BE5 |
|
|
Cascade on delete | ||
| FK_ProcCodeInCPT_CPTCode |
|
|
Restrict delete | ||
| FK__Rate__PayGroup__624BE676 |
|
|
Restrict delete | ||
| FK__Rate__UserID__536D5C82 |
|
|
Restrict delete | ||
| FK__Rate__PayGroup__546180BB |
|
|
Restrict delete | ||
| FK__Rate__Patientid__4F9CCB9E |
|
|
Restrict delete | ||
| FK__Rate__PayGroup__60639E04 |
|
|
Restrict delete | ||
| FK__Documents__TrackingFieldValues |
|
|
Cascade on delete | ||
| FK__CategoryT__catID__6E17311D |
|
|
Cascade on delete | ||
| FK_ErrorCodeInPaySourceInPrgType_ClearingHouseError |
|
|
Restrict delete | ||
| FK_TaggedRecord_TaggedRecord |
|
|
Restrict delete | ||
| FK__DecReaInP__decli__07D70320 |
|
|
Cascade on delete | ||
| FK__AuthRevie__authI__6A46A039 |
|
|
Cascade on delete | ||
| FK__PatientDiag__PatientAdmin |
|
|
Cascade on delete | ||
| FK_Activity_ActivityStatus |
|
|
Restrict delete | ||
| FK_Activity_ActivityCategory |
|
|
Restrict delete | ||
| FK_Activity_ActivityShowTimeAs |
|
|
Restrict delete | ||
| FK_PatientAdministration_RateType |
|
|
Restrict delete | ||
| FK_PatientAdministration_Patient |
|
|
Cascade on delete | ||
| FK__PatientAdmin__CaseCat |
|
|
Restrict delete | ||
| FK_PatientInsurance_Patient |
|
|
Cascade on delete | ||
| FK__PatientIn__Insur__43EBED27 |
|
|
Cascade on delete | ||
| FK_UserInGroups_UserGroup |
|
|
Cascade on delete | ||
| FK_UserInGroups_AccessUser1 |
|
|
Cascade on delete | ||
| FK_AuthorizeICD9_PatientEvaluation |
|
|
Restrict delete | ||
| FK_AuthorizeICD9_Diagnosis |
|
|
Restrict delete | ||
| FK_ClaimICD9_Diagnosis |
|
|
Restrict delete | ||
| FK_ClaimICD9_Claim |
|
|
Restrict delete | ||
| FK__UserInSpe__fkspe__2F9BA70E |
|
|
Cascade on delete | ||
| FK__UserInSpe__userI__2EA782D5 |
|
|
Cascade on delete | ||
| FK_AlertValue_AlertReportConfig |
|
|
Restrict delete | ||
| FK__PatientDo__docSt__41448AA6 |
|
|
Cascade on delete | ||
| FK__PatientDo__docNa__4050666D |
|
|
Cascade on delete | ||
| FK__PatientDo__patie__3F5C4234 |
|
|
Cascade on delete | ||
| FK__PatientDo__docGr__4238AEDF |
|
|
Cascade on delete | ||
| FK__PatientRe__Decli__762C88DA |
|
|
Restrict delete | ||
| FK__PatientRe__PatientAdmin |
|
|
Cascade on delete | ||
| FK__PatientRe__OutSi__753864A1 |
|
|
Restrict delete | ||
| FK_Fields_DataDictionary |
|
|
Restrict delete | ||
| FK_FlexFormSettings_RegExp |
|
|
Restrict delete | ||
| FK_FlexFormSettings_StoredProc |
|
|
Restrict delete | ||
| FK_FlexFormSettings_Fields |
|
|
Restrict delete | ||
| FK_FlexFormSettings_FlexForm |
|
|
Restrict delete | ||
| FK_raFiles_checkLog |
|
|
Restrict delete | ||
| FK_raFiles_AccessUser |
|
|
Restrict delete | ||
| FK__FieldsInS__FKFie__4D77B966 |
|
|
Restrict delete | ||
| FK__FieldsInS__FKSPI__4E6BDD9F |
|
|
Restrict delete | ||
| FK_Claim2_Claim |
|
|
Restrict delete | ||
| FK_DaycareInvoices_AccessUser |
|
|
Restrict delete | ||
| FK_ClaimNotes_Claim |
|
|
Restrict delete | ||
| FK__PatientIDs__Patient |
|
|
Cascade on delete | ||
| FK_CheckLogTransaction_checkLog |
|
|
Restrict delete | ||
| FK__PatientIn__fkPat__57DEA292 |
|
|
Cascade on delete | ||
| FK__IFSPRevie__IFSPI__74AE54BC |
|
|
Cascade on delete | ||
| FK_UserInGroupClient_AccessUser |
|
|
Restrict delete | ||
| FK_UserInGroupClient_Groups |
|
|
Restrict delete | ||
| FK_PatientEvaluationCPT_PatientEvaluation |
|
|
Restrict delete | ||
| FK_PatientEvaluationCPT_CPTCode |
|
|
Restrict delete | ||
| FK_SubclaimCPT_scClaim |
|
|
Restrict delete | ||
| FK_SubclaimCPT_CPTCode |
|
|
Restrict delete | ||
| FK__CaseSite__caseID__6641052B |
|
|
Cascade on delete | ||
| FK_NyeisFfileImport_raFiles |
|
|
Restrict delete | ||
| FK_StatusInLevel_Statuses |
|
|
Restrict delete | ||
| FK_StatusInLevel_AppLevels |
|
|
Restrict delete | ||
| FK__PayrollEm__fkPay__3DBFA933 |
|
|
Cascade on delete | ||
| FK__PayrollEm__fkPer__3BD760C1 |
|
|
Cascade on delete | ||
| FK__PayrollEm__fkUse__3CCB84FA |
|
|
Cascade on delete | ||
| FK__BillingIn__fkInv__2C002054 |
|
|
Cascade on delete | ||
| FK__UserFieldCho__UserFields |
|
|
Cascade on delete | ||
| FK_UserPasswords_AccessUser |
|
|
Restrict delete | ||
| FK_PaysourceInSite_AgencySite |
|
|
Restrict delete | ||
| FK_UserInDiscipline_DiscInDisTypeInProgType |
|
|
Cascade on delete | ||
| FK_UserInDiscipline_AccessUser |
|
|
Cascade on delete | ||
| FK_iCommunicateInDocuments_iCommunicate |
|
|
Restrict delete | ||
| FK_CustomConfig_Patient |
|
|
Restrict delete | ||
| FK_CustomConfig_AccessUser |
|
|
Restrict delete | ||
| FK__ClaimTran__fkChe__0D1C71D8 |
|
|
Restrict delete | ||
| FK__ClaimTran__fkTra__0C284D9F |
|
|
Cascade on delete | ||
| FK_GroupAddons_UserGroup |
|
|
Restrict delete | ||
| FK_Activity_Visit_Activity |
|
|
Restrict delete | ||
| FK__CaseCateg__casei__0E8400AF |
|
|
Cascade on delete | ||
| FK__Paysource__fkCas__55374011 |
|
|
Cascade on delete | ||
| FK__PatientPr__Presc__69D19EED |
|
|
Restrict delete | ||
| FK__PatientPr__Admit__4EF38B7F |
|
|
Cascade on delete | ||
| FK__ClaimMedi__Modif__49A4C67D |
|
|
Cascade on delete | ||
| FK__ClaimMedi__Servi__47BC7E0B |
|
|
Cascade on delete | ||
| FK__ClaimMedi__Admit__46C859D2 |
|
|
Cascade on delete | ||
| FK__ClaimMedi__Proce__48B0A244 |
|
|
Cascade on delete | ||
| FK_FormSubmissions_FormDesigns |
|
|
Restrict delete | ||
| FK_EnrollmentCasePaysources_Enrollments |
|
|
Restrict delete | ||
| FK_EnrollmentCasePaysources_Paysource |
|
|
Restrict delete | ||
| FK_ActivityCategory_ActivityAssignmentTypes |
|
|
Restrict delete | ||
| FK__UserInLan__fkLan__43A29FBB |
|
|
Cascade on delete | ||
| FK__UserInLan__fkUse__42AE7B82 |
|
|
Cascade on delete | ||
| FK__History_D__Archi__4B6F7563 |
|
|
Restrict delete | ||
| FK_InvoiceTransReason_InvoiceTransaction |
|
|
Cascade on delete | ||
| FK__UserInReg__userI__2BCB162A |
|
|
Cascade on delete | ||
| FK__UserInReg__fkReg__2CBF3A63 |
|
|
Cascade on delete | ||
| FK_cf_Form_cf_FormTemplate |
|
|
Restrict delete | ||
| FK__PatientCa__Admit__3D3EEF98 |
|
|
Cascade on delete | ||
| FK__History_P__Archi__4E4BE20E |
|
|
Restrict delete | ||
| FK_Claim |
|
|
Cascade on delete | ||
| FK_UserID |
|
|
Restrict delete | ||
| FK__PatientLanguage__Language |
|
|
Cascade on delete | ||
| FK__PatientLanguage__Patient |
|
|
Cascade on delete | ||
| FK_ActivityStatusInCategory_ActivityStatus |
|
|
Restrict delete | ||
| FK_ActivityStatusInCategory_ActivityCategory |
|
|
Restrict delete | ||
| FK__ScanUploa__fkUpl__77EAB41A |
|
|
Cascade on delete | ||
| FK_PatientContactCustom_PatientContact |
|
|
Restrict delete | ||
| FK_DaycareTransactions_AccessUser |
|
|
Restrict delete | ||
| FK_DaycareTransactions_DaycareInvoices |
|
|
Restrict delete | ||
| FK_DaycareTransactions_Patient |
|
|
Restrict delete | ||
| FK__ActionInS__FKSPI__533092BC |
|
|
Restrict delete | ||
| FK_ActivityStatus_ActivityShowTimeAs |
|
|
Restrict delete | ||
| FK_ServiceTypeInCPTCode_CPTCode |
|
|
Restrict delete | ||
| FK__PayrollIn__fkPBI__1EA62536 |
|
|
Cascade on delete | ||
| FK__PayrollIn__fkUse__1DB200FD |
|
|
Restrict delete | ||
| FK_ActivityAssignmentTypeControls_ActivityAssignmentTypes |
|
|
Restrict delete | ||
| FK__InvTransCheckID__CheckLogID |
|
|
Restrict delete | ||
| FK__InvTransCheckID__TransID |
|
|
Cascade on delete | ||
| FK__History__Archive__0FF8DE83 |
|
|
Restrict delete | ||
| FK__payrollex__fkPay__7EF86FB3 |
|
|
Restrict delete | ||
| FK__PayrollEx__fkRat__7B27DECF |
|
|
Cascade on delete | ||
| FK__PayrollEx__fkUse__7A33BA96 |
|
|
Cascade on delete | ||
| FK__PayrollEx__fkExc__793F965D |
|
|
Cascade on delete | ||
| FK_UserSubTab_UserGroup |
|
|
Restrict delete | ||
| FK_SubclaimICD9_Diagnosis |
|
|
Restrict delete | ||
| FK_SubclaimICD9_scClaim |
|
|
Restrict delete | ||
| FK_ControlInSQL_ActivityAssignmentTypeControls |
|
|
Restrict delete | ||
| FK_cf_Control_Extend_cf_Control1 |
|
|
Cascade on delete | ||
| FK__PatientEv__EvalI__725BF7F6 |
|
|
Cascade on delete | ||
| FK_AuthMonthlyAmount_Authorize |
|
|
Cascade on delete | ||
| FK__Outsideso__sourc__0AB36FCB |
|
|
Cascade on delete | ||
| FK__VoidReaso__CatID__7CDB1D17 |
|
|
Cascade on delete | ||
| FK__GroupInCo__Group__145DA0ED |
|
|
Cascade on delete | ||
| FK__Objective__fkObj__4FFE54FF |
|
|
Restrict delete | ||
| FK__Objective__fkGoa__50F27938 |
|
|
Restrict delete | ||
| FK__ScanEIDat__VerBy__46FD63FC |
|
|
Restrict delete | ||
| FK__ScanEIDat__Heade__2141CF68 |
|
|
Cascade on delete | ||
| FK_scClaim_iTemplate |
|
|
Restrict delete | ||
| FK_ra_835Import_raFiles |
|
|
Restrict delete | ||
| FK_AgingBucket_AgingType |
|
|
Restrict delete | ||
| FK_cf_ControlTemplate_Extend_cf_ControlTemplate1 |
|
|
Cascade on delete | ||
| FK_Enrollments_PatientAdministration |
|
|
Restrict delete | ||
| FK_Enrollments_Classes |
|
|
Restrict delete | ||
| FK_Enrollments_ClassRooms |
|
|
Restrict delete | ||
| FK_Enrollments_ClassRates |
|
|
Restrict delete | ||
| FK_FormDigitalSignatures_SignatureTypes |
|
|
Restrict delete | ||
| FK_FormDigitalSignatures_FormDesigns |
|
|
Restrict delete | ||
| Modifier_Billing |
|
|
Restrict delete | ||
| FK_cf_ControlTemplate_cf_FormTemplate |
|
|
Cascade on delete | ||
| FK_cf_ControlTemplate_cf_ControlTemplate |
|
|
Restrict delete | ||
| FK_OutsideSource_SourceType |
|
|
Restrict delete | ||
| FK__CustomCon__fkDis__22F6A45E |
|
|
Restrict delete | ||
| FK__CustomCon__fkCon__22028025 |
|
|
Restrict delete | ||
| FK_Goal_CustomConfig3 |
|
|
Restrict delete | ||
| FK_Goal_CustomConfig1 |
|
|
Restrict delete | ||
| FK_Goal_CustomConfig2 |
|
|
Restrict delete | ||
| FK_Goal_CustomConfig |
|
|
Restrict delete | ||
| FK_Goal_AccessUser1 |
|
|
Restrict delete | ||
| FK_Goal_AccessUser |
|
|
Restrict delete | ||
| FK_Goal_Authorize |
|
|
Restrict delete | ||
| FK__PatientPr__patie__7F0CB2F5 |
|
|
Cascade on delete | ||
| FK__AccessLog__Useri__4D0B430D |
|
|
Cascade on delete | ||
| FK_GroupInAction_UserGroup |
|
|
Cascade on delete | ||
| FK__UserPhone__useri__6DAD1CC9 |
|
|
Cascade on delete | ||
| FK__StatusInP__statu__71B2B7D7 |
|
|
Cascade on delete | ||
| FK_cf_Control_cf_Form |
|
|
Cascade on delete | ||
| FK_cf_Control_cf_Control |
|
|
Restrict delete | ||
| FK__PatientContact__PatientAdmin |
|
|
Cascade on delete | ||
| FK__ClaimTran__fkInv__094BE0F4 |
|
|
Restrict delete | ||
| FK__ClaimTran__fkTra__0857BCBB |
|
|
Cascade on delete | ||
| FK__ActivityH__Archi__78C13EC7 |
|
|
Restrict delete | ||
| FK_AuthorizeTherapist_AccessUser |
|
|
Cascade on delete | ||
| FK_QlOptionSecurity_Reports |
|
|
Restrict delete | ||
| FK_QlOptionSecurity_Categories |
|
|
Restrict delete | ||
| FK_QlOptionSecurity_SecurableItems |
|
|
Restrict delete | ||
| FK_ClaimArchive_Claim |
|
|
Cascade on delete | ||
| FK__AgencyPro__fkABI__06CE9BA5 |
|
|
Restrict delete | ||
| FK__CustomConfigInProgType__CustomConfig |
|
|
Cascade on delete | ||
| FK_AgingCalculations_AgingType |
|
|
Restrict delete | ||
| FK_ClaimServiceRate_AccountCodes |
|
|
Restrict delete | ||
| FK__claimserv__fkPII__1F9A496F |
|
|
Cascade on delete | ||
| FK__ClaimServ__UserI__4AD81681 |
|
|
Restrict delete | ||
| FK_ClaimServiceRate_Claim |
|
|
Cascade on delete | ||
| FK__History_C__Archi__42701B0E |
|
|
Restrict delete | ||
| FK_AttendanceHistory_Attendances |
|
|
Restrict delete | ||
| FK_AttendanceHistory_AccessUser |
|
|
Restrict delete | ||
| FK__PayrollEm__fkUse__3712ABA4 |
|
|
Cascade on delete | ||
| ActivityAssignment_FK_Activity_ID |
|
|
Restrict delete | ||
| FK__UserIDLis__userI__34605C2B |
|
|
Cascade on delete | ||
| FK__UserIDLis__fkSta__35548064 |
|
|
Cascade on delete | ||
| FK__PatientInCustomConfig__CustomConfig |
|
|
Cascade on delete | ||
| FK__PatientInCustomConfig__Patient |
|
|
Cascade on delete | ||
| FK__ClaimTran__VoidB__04872BD7 |
|
|
Restrict delete | ||
| FK__ClaimTran__fkTra__0393079E |
|
|
Cascade on delete | ||
| FK_iCommunicatePropertiesID_accessuser |
|
|
Restrict delete | ||
| FK_iCommunicatePropertiesID_iCommunicate |
|
|
Restrict delete | ||
| FK__AccessUser__UserPayType |
|
|
Restrict delete | ||
| Company_has_many_users |
|
|
Restrict delete | ||
| FK__AccessUser__UserCat |
|
|
Restrict delete | ||
| FK__AccessUser__UserPayCat |
|
|
Restrict delete | ||
| FK_ScanSCData_ScanFormHeader |
|
|
Cascade on delete | ||
| FK__claim__fkAdmitID__1F44785D |
|
|
Restrict delete | ||
| FK_AccessUserCustom_AccessUser |
|
|
Restrict delete | ||
| FK__RoomsTher__userI__666B225D |
|
|
Cascade on delete | ||
| FK__RoomsTher__RoomI__6576FE24 |
|
|
Cascade on delete | ||
| FK_Invoice |
|
|
Cascade on delete | ||
| FK_UserID_Inv |
|
|
Restrict delete | ||
| FK__CategoryG__catID__6FFF798F |
|
|
Cascade on delete | ||
| FK__CategoryG__Group__70F39DC8 |
|
|
Cascade on delete | ||
| FK_GapsCustom_Gaps |
|
|
Restrict delete | ||
| FK_claimerror_Claim |
|
|
Cascade on delete | ||
| FK__SiteInPro__sitei__11EA7D3F |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|