Constraints

71 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK__AgencySub__Agenc__18EBB532
AgencySubTab.AgencyID
Agency.AgencyID
Cascade on delete
FK_AgencySubTab_Subtab
AgencySubTab.SubTabID
Subtab.SubTabID
Cascade on delete
FK_AppAddons_Addon
AppAddons.fkAddonID
Addons.pkAddonID
Restrict delete
FK_AppAddons_Apps
AppAddons.fkAppID
Apps.pkAppID
Restrict delete
FK_FormDigitalSignatures_SignatureTypes
FormSignatures.SignatureTypeID
SignatureTypes.pkSignatureTypeId
Restrict delete
FK_FormDigitalSignatures_FormDesigns
FormSignatures.FormDesignID
FormDesigns.ID
Restrict delete
FK__ProcCodeP__fkPro__65EBFF70
ProcCodePackage.fkPrimProcCodeID
ProcCode.ProcCodeID
Cascade on delete
FK__categoryInCategoryType__catId
categoryInCategoryType.fkCatID
Category.catID
Cascade on delete
FK__categoryInCategoryType__catTypeID
categoryInCategoryType.fkCatTypeID
CategoryType.CatTypeID
Cascade on delete
FK_AgencyApps_Agency
AgencyApps.fkAgencyID
Agency.AgencyID
Restrict delete
FK_AgencyApps_AppID
AgencyApps.fkAppID
Apps.pkAppID
Restrict delete
FK_ActionInBillingMethod_Forms
ActionInBillingMethod.fkFormID
Forms.FormID
Cascade on delete
FK_ActionInBillingMethod_BillingMethod
ActionInBillingMethod.fkInvLogID
BillingMethod.InvLogID
Cascade on delete
FK_FieldsInStoredProc_StoredProc
FieldsInStoredProc.fkSPID
StoredProc.pkSPID
Cascade on delete
FK_FieldsInStoredProc_Fields
FieldsInStoredProc.fkFieldID
Fields.pkFieldID
Cascade on delete
FK__BillingMethodInProgType__ProgramType
BillingMethodInProgType.fkProgramID
ProgramType.ProgramID
Restrict delete
FK__BillingMethodInProgType__BillingMethod
BillingMethodInProgType.fkInvLogID
BillingMethod.InvLogID
Restrict delete
FK__AgencyBBS__fkCle__23E931E9
AgencyBBS.fkClearinghouseID
ClearingHouse.ClearingHouseID
Cascade on delete
FK_LegalStamp_Agreement
LegalStamp.fkAgreementID
Agreement.pkAgreementID
Restrict delete
FK_LegalStamp_LegalContent
LegalStamp.fkLegalContentID
LegalContent.pkLegalContentID
Restrict delete
FK__ScanForms__ScanF__01142BA1
ScanFormsBillingType.ScanFormID
ScanForms.ScanFormID
Cascade on delete
FK__ScanForms__Billi__02084FDA
ScanFormsBillingType.BillingTypeID
Billingtype.BillingTypeID
Cascade on delete
FK__ProcCodeInClaimType__ClaimTypeInProgType
ProcCodeInClaimType.fkCPID
ClaimTypeInProgType.CPID
Cascade on delete
FK__ProcCodeInClaimType__ProcCode
ProcCodeInClaimType.fkprocCodeID
ProcCode.ProcCodeID
Cascade on delete
FK__reportInCategory__ReportId
reportInCategory.fkReportID
Reports.ReportID
Cascade on delete
FK__reportInCategory__catID
reportInCategory.fkCatID
Category.catID
Cascade on delete
FK_InvoiceItem_Agency
InvoiceItem.fkAgencyID
Agency.AgencyID
Restrict delete
FK__DisTypeID__Progr__766C7FFC
DisTypeIDInProgType.ProgramID
ProgramType.ProgramID
Cascade on delete
FK__DisTypeID__DisTy__75785BC3
DisTypeIDInProgType.DisTypeID
DisciplineType.DisTypeID
Cascade on delete
FK__ClaimTypeInProgType__Claimtype
ClaimTypeInProgType.fkClaimTypeID
Claimtype.ClaimTypeID
Cascade on delete
FK__ClaimTypeInProgType__ProgType
ClaimTypeInProgType.fkProgramID
ProgramType.ProgramID
Cascade on delete
FK_AgencyProgramType_ProgramType
AgencyProgramType.ProgramID
ProgramType.ProgramID
Restrict delete
FK_AgencyProgramType_Agency
AgencyProgramType.AgencyID
Agency.AgencyID
Restrict delete
FK__agencyInCategoryType__AgencyId
agencyInCategoryType.fkAgencyID
Agency.AgencyID
Cascade on delete
FK__agencyInCategoryType__catTypeID
agencyInCategoryType.fkCatTypeID
CategoryType.CatTypeID
Cascade on delete
FK_AgencyAddon_Addon
AgencyAddons.fkAddonID
Addons.pkAddonID
Restrict delete
FK_AgencyAddon_Agency
AgencyAddons.fkAgencyID
Agency.AgencyID
Restrict delete
FK_AgencyPaymentInfo_Agency
AgencyPaymentInfo.fkAgencyID
Agency.AgencyID
Restrict delete
FK__ReportInc__IncID__18AC8967
ReportIncludeFile.IncID
CriteriaInclude.IncID
Cascade on delete
FK__ReportInc__Repor__4E88ABD4
ReportIncludeFile.ReportID
Reports.ReportID
Cascade on delete
FK_AgencyConfirmation_ConfirmationTypes
AgencyConfirmation.ConfirmationID
ConfirmationTypes.pkConfirmTypeID
Restrict delete
FK_AgencyConfirmation_Agency
AgencyConfirmation.AgencyID
Agency.AgencyID
Restrict delete
FK__ServiceTypeInClaimType__ClaimTypeInProgType
ServiceTypeInClaimType.fkCPID
ClaimTypeInProgType.CPID
Cascade on delete
FK__ServiceTypeInClaimType__ServiceType
ServiceTypeInClaimType.fkserviceTypeID
ServiceType.serviceTypeid
Cascade on delete
FK__ReportGroupListing__OutputSource
ReportGroupListing.fkOutSrcID
OutputSource.pkOutSrcID
Cascade on delete
FK__ReportGrou__RGID__17B8652E
ReportGroupListing.RGID
ReportGroup.RGID
Cascade on delete
FK_AppLayers_AppID
AppLayers.fkAppID
Apps.pkAppID
Restrict delete
FK_ClaimActionsNew
ActionInDataSource.fkActionId
ClaimActionsNew.ActionID
Restrict delete
FK_ActionInDataSource
ActionInDataSource.fkDataSourceId
DataSources.pkDataSourceID
Restrict delete
FK__ActionInS__FKSPI__4ACDF4E0
ActionInStoredProc .FKSPID
StoredProc.pkSPID
Restrict delete
FK__ScanForms__ScanF__7B5B524B
ScanFormsIncs_link.ScanFormID
ScanForms.ScanFormID
Cascade on delete
FK__ScanForms__ScanI__7C4F7684
ScanFormsIncs_link.ScanIncID
ScanIncludes.ScanIncID
Cascade on delete
FK_Agreement_Agency
Agreement.fkAgencyID
Agency.AgencyID
Restrict delete
FK__ModifierInClaimType__Modifier
ModifierInClaimType.fkmodifierID
Modifier.ModifierID
Cascade on delete
FK__ModifierInClaimType__ClaimTypeInProgType
ModifierInClaimType.fkCPID
ClaimTypeInProgType.CPID
Cascade on delete
FK__PlaceServiceInProgType__ProgType
PlaceServiceInProgType.ProgramID
ProgramType.ProgramID
Cascade on delete
FK__PlaceServiceInProgType__PlaceService
PlaceServiceInProgType.POSID
PlaceService.POSID
Cascade on delete
FK__PackageDe__fkPac__6D8D2138
PackageDetail.fkPackID
ProcCodePackage.PackID
Cascade on delete
FK_ServiceOrder_Agreement
ServiceOrder.fkAgreementID
Agreement.pkAgreementID
Restrict delete
FK_RuleErrorInCP_ClaimTypeInProgType
RuleErrorInCP.fkCPID
ClaimTypeInProgType.CPID
Cascade on delete
FK__IDTypeINProgType__PatIDTypes
IDTypesInProgramType.IDTypeID
PatientIDTypes.IDTypeID
Cascade on delete
FK_IDTypesInProgramType_ProgramType
IDTypesInProgramType.programID
ProgramType.ProgramID
Cascade on delete
FK__FormsIncl__FormI__74AE54BC
FormsIncludeFile.FormID
Forms.FormID
Cascade on delete
FK__OutputSrc__OutputFormat
OutputSource.fkOutputID
OutputFormat.pkOutputID
Cascade on delete
FK__OutputSrc__Reports
OutputSource.fkReportID
Reports.ReportID
Cascade on delete
FK__FormInPro__fkPro__1C7D1A4B
FormInProgType.fkProgramID
ProgramType.ProgramID
Cascade on delete
FK__FormInPro__fkFor__1B88F612
FormInProgType.fkFormID
Forms.FormID
Cascade on delete
FK__AgencySca__ScanF__7E37BEF6
AgencyScanForms.ScanFormID
ScanForms.ScanFormID
Cascade on delete
FK__AgencySca__Agenc__7F2BE32F
AgencyScanForms.AgencyID
Agency.AgencyID
Cascade on delete
FK_CaseRuleInValue_CaseRuleValues
CaseRuleInValue.fkCaseRuleValID
CaseRuleValues.pkCaseRuleValID
Restrict delete
FK_CaseRuleInValue_CaseRule
CaseRuleInValue.fkCaseRuleID
CaseRule.pkCaseRuleID
Restrict delete

Check Constraints

Table Constraint Name Constraint