Constraints

Cascade on delete

fk_manual_concept_statement

manual_payment_concepts.statement_id

Cascade on delete

fk_sjr_job

scheduled_job_run.scheduled_job_id

scheduled_job.id

Cascade on delete

fk_chatbot_msg_conv

chatbot_messages.conversation_id

chatbot_conversations.id

Cascade on delete

fk_protocol_categories_protocol

protocol_categories.protocol_id

protocols.id

Cascade on delete

fk_billing_codes_location_business_line

billing_codes.location_business_line_id

Restrict delete

tenant_role_permissions_ibfk_1

tenant_role_permissions.tenant_role_id

tenant_roles.id

Cascade on delete

fk_announcement_attachments_announcement

announcement_attachments.announcement_id

announcements.id

Cascade on delete

fk_sja_run

scheduled_job_action.run_id

scheduled_job_run.id

Cascade on delete

fk_sja_job

scheduled_job_action.scheduled_job_id

scheduled_job.id

Cascade on delete

fk_encounter_cpt_codes_location

encounter_cpt_codes.location_business_line_id

Restrict delete

fk_encounter_cpt_codes_encounter

encounter_cpt_codes.encounter_id

encounters.id

Cascade on delete

fk_encounter_cpt_codes_cpt

encounter_cpt_codes.cpt_code_id

Restrict delete

fk_sp_maladaptive_behaviors_intensity

service_plan_maladaptive_behaviors.intensity_key_id

catalog_intensity_keys.id

Restrict delete

fk_sp_maladaptive_behaviors_plan

service_plan_maladaptive_behaviors.service_plan_id

service_plans.id

Cascade on delete

fk_sp_maladaptive_behaviors_behavior

service_plan_maladaptive_behaviors.maladaptive_behavior_id

maladaptive_behaviors.id

Restrict delete

fk_sp_maladaptive_behaviors_goal

service_plan_maladaptive_behaviors.behavior_goal_id

behavior_goals.id

Restrict delete

fk_sp_maladaptive_behaviors_location

service_plan_maladaptive_behaviors.location_business_line_id

Restrict delete

fk_sig_rcpt_request

signature_recipients.signature_request_id

signature_requests.id

Cascade on delete

fk_encounter_rules_rule_type

encounter_rules.rule_type_id

encounter_rule_types.id

Cascade on delete

fk_encounter_rules_case

encounter_rules.case_id

cases.id

Cascade on delete

fk_encounter_rules_cpt

encounter_rules.cpt_code_id

Cascade on delete

fk_encounter_rules_encounter_type

encounter_rules.encounter_type_id

Cascade on delete

fk_encounter_rules_location

encounter_rules.location_business_line_id

Restrict delete

fk_encounter_rules_scope_location

encounter_rules.scope_location_id

Cascade on delete

payer_clearinghouses_ibfk_1

payer_clearinghouses.payer_id

payers.id

Restrict delete

payer_clearinghouses_ibfk_2

payer_clearinghouses.clearinghouse_id

clearinghouses.id

Restrict delete

credential_billing_codes_ibfk_1

credential_billing_codes.credential_id

credentials.id

Cascade on delete

credential_billing_codes_ibfk_2

credential_billing_codes.billing_code_id

billing_codes.id

Cascade on delete

fk_ch_sub_claim_submission

clearinghouse_submission_claims.submission_id

clearinghouse_submissions.id

Cascade on delete

fk_ch_sub_claim_batch

clearinghouse_submission_claims.billing_batch_id

billing_batches.id

Restrict delete

fk_ch_sub_claim_claim

clearinghouse_submission_claims.claim_id

claims.id

Restrict delete

fk_invoices_location_business_line

invoices.location_business_line_id

Restrict delete

fk_invoices_billing_batch

invoices.billing_batch_id

billing_batches.id

Restrict delete

fk_treatment_targets_location

treatment_targets.location_business_line_id

clearinghouse_submission_claims.id

Restrict delete

fk_ai_rs_cpt_ruleset

ai_rule_set_cpt_codes.rule_set_id

ai_rule_sets.id

Cascade on delete

fk_ch_response_claim

clearinghouse_response_events.claim_id

claims.id

Restrict delete

fk_ch_response_submission_claim

clearinghouse_response_events.submission_claim_id

Restrict delete

fk_client_addresses_client

client_addresses.client_id

Restrict delete

fk_client_addresses_address

client_addresses.address_id

addresses.id

Restrict delete

fk_client_addresses_pos

client_addresses.place_of_service_id

place_of_service.id

Restrict delete

fk_cpt_codes_location_business_line

cpt_codes.location_business_line_id

Restrict delete

fk_ai_rule_ruleset

ai_rules.rule_set_id

ai_rule_sets.id

Cascade on delete

fk_antecedents_location_business_line

antecedents.location_business_line_id

Restrict delete

fk_prompt_profile_id

ai_prompt_profile_cpt_codes.profile_id

ai_prompt_profiles.id

Cascade on delete

user_credentials_ibfk_1

user_credentials.user_id

users.id

Cascade on delete

user_credentials_ibfk_2

user_credentials.credential_id

credentials.id

Cascade on delete

fk_ai_templatefield_template

ai_generation_template_fields.template_id

ai_generation_templates.id

Cascade on delete

fk_encounters_client

encounters.client_id

Restrict delete

fk_encounters_service_location

encounters.location_id

Null on delete

fk_encounters_rendering_user

encounters.rendering_user_id

users.id

Restrict delete

fk_encounters_supervising_user

encounters.supervising_user_id

users.id

Null on delete

fk_encounters_parent

encounters.parent_encounter_id

encounters.id

Null on delete

fk_encounters_case

encounters.case_id

cases.id

Restrict delete

fk_encounters_type

encounters.encounter_type_id

Restrict delete

fk_encounters_location

encounters.location_business_line_id

Restrict delete

fk_encounter_types_parent

encounter_types.parent_encounter_type_id

Null on delete

fk_encounter_types_location

encounter_types.location_business_line_id

Restrict delete

fk_ch_era_remittance

clearinghouse_era_imports.remittance_advice_id

remittance_advices.id

Restrict delete

fk_catalog_intensity_keys_location

catalog_intensity_keys.location_business_line_id

Restrict delete

case_staff_assignments_ibfk_1

case_staff_assignments.case_id

cases.id

Cascade on delete

fk_user_hr_documents_document

user_hr_documents.hr_document_id

hr_documents.id

Cascade on delete

fk_user_hr_documents_user

user_hr_documents.user_id

users.id

Cascade on delete

fk_encounter_participants_caregiver

encounter_participants.caregiver_id

caregivers.id

Null on delete

fk_encounter_participants_encounter

encounter_participants.encounter_id

encounters.id

Cascade on delete

fk_encounter_participants_location

encounter_participants.location_business_line_id

Restrict delete

fk_encounter_participants_user

encounter_participants.user_id

users.id

Null on delete

sp_maladaptive_behavior_topographies_ibfk_1

sp_maladaptive_behavior_topographies.sp_maladaptive_behavior_id

Cascade on delete

fk_session_outcomes_catalog

session_outcomes.catalog_session_outcome_id

catalog_session_outcomes.id

Null on delete

fk_session_outcomes_lbl

session_outcomes.location_business_line_id

Cascade on delete

maladaptive_behaviors_ibfk_1

maladaptive_behaviors.location_business_line_id

catalog_maladaptive_behaviors.id

Cascade on delete

maladaptive_behaviors_ibfk_2

maladaptive_behaviors.catalog_maladaptive_behavior_id

Null on delete

fk_encounter_type_cpts_location

encounter_type_cpts.location_business_line_id

Restrict delete

fk_encounter_type_cpts_encounter_type

encounter_type_cpts.encounter_type_id

Cascade on delete

fk_encounter_type_cpts_cpt

encounter_type_cpts.cpt_code_id

Cascade on delete

sp_maladaptive_behavior_intensity_assignments_ibfk_1

sp_maladaptive_behavior_intensity_assignments.sp_maladaptive_behavior_id

Cascade on delete

sp_maladaptive_behavior_intensity_assignments_ibfk_2

sp_maladaptive_behavior_intensity_assignments.intensity_key_id

catalog_intensity_keys.id

Restrict delete

fk_sps_line_statement

staff_payment_statement_lines.statement_id

Cascade on delete

fk_encounter_type_sub_events_parent

encounter_type_sub_events.parent_encounter_type_id

Cascade on delete

fk_encounter_type_sub_events_location

encounter_type_sub_events.location_business_line_id

Restrict delete

fk_encounter_type_sub_events_child

encounter_type_sub_events.child_encounter_type_id

Cascade on delete

fk_sps_history_statement

staff_payment_statement_status_history.statement_id

Cascade on delete

fk_diagnoses_client

diagnoses.client_id

Cascade on delete

invoice_items_ibfk_1

invoice_items.invoice_id

invoices.id

Cascade on delete

fk_address_time_windows_parent

address_time_windows.address_id

addresses.id

Cascade on delete

fk_users_location_business_line

users.location_business_line_id

Restrict delete

user_rates_ibfk_2

user_rates.user_id

users.id

Cascade on delete

user_rates_ibfk_1

user_rates.location_business_line_id

Cascade on delete

user_rates_ibfk_4

user_rates.client_id

Null on delete

user_rates_ibfk_3

user_rates.cpt_code_id

Cascade on delete

sp_maladaptive_behavior_protocol_modifications_ibfk_1

sp_maladaptive_behavior_protocol_modifications.sp_maladaptive_behavior_id

Cascade on delete

sp_maladaptive_behavior_function_assignments_ibfk_1

sp_maladaptive_behavior_function_assignments.sp_maladaptive_behavior_id

Cascade on delete

sp_maladaptive_behavior_function_assignments_ibfk_2

sp_maladaptive_behavior_function_assignments.hypothesized_function_id

hypothesized_functions.id

Restrict delete

fk_encounter_rule_types_location

encounter_rule_types.location_business_line_id

Restrict delete

fk_sp_mb_functions_behavior

service_plan_maladaptive_behavior_functions.service_plan_maladaptive_behavior_id

Cascade on delete

fk_sp_mb_functions_function

service_plan_maladaptive_behavior_functions.hypothesized_function_id

hypothesized_functions.id

Restrict delete

fk_user_hr_doc_files_doc

user_hr_document_files.user_hr_document_id

user_hr_documents.id

Cascade on delete

fk_notifications_source

notifications.notification_source_id

notification_sources.id

Restrict delete

fk_notifications_delivery_method

notifications.delivery_method_id

delivery_methods.id

Restrict delete

fk_intervention_location_business_line

intervention.location_business_line_id

sp_maladaptive_behavior_measures.id

Restrict delete

fk_php_payer

payer_health_plans.payer_id

payers.id

Cascade on delete

sp_maladaptive_behavior_baselines_ibfk_1

sp_maladaptive_behavior_baselines.sp_maladaptive_behavior_measure_id

Cascade on delete

fk_ch_sub_batch

clearinghouse_submissions.billing_batch_id

billing_batches.id

Restrict delete

fk_hr_documents_location

hr_documents.location_business_line_id

catalog_client_participation.id

Cascade on delete

client_participation_ibfk_1

client_participation.catalog_client_participation_id

Null on delete

caregivers_ibfk_1

caregivers.client_id

Cascade on delete

sp_maladaptive_behavior_function_interventions_ibfk_4

sp_maladaptive_behavior_function_interventions.consequence_intervention_id

consequence_interventions.id

Restrict delete

sp_maladaptive_behavior_function_interventions_ibfk_3

sp_maladaptive_behavior_function_interventions.antecedent_intervention_id

antecedent_interventions.id

Restrict delete

sp_maladaptive_behavior_function_interventions_ibfk_2

sp_maladaptive_behavior_function_interventions.hypothesized_function_id

hypothesized_functions.id

Restrict delete

sp_maladaptive_behavior_function_interventions_ibfk_1

sp_maladaptive_behavior_function_interventions.sp_maladaptive_behavior_id

assessment_section_definitions.id

Cascade on delete

fk_sched_restrict_cond_parent

scheduling_restriction_conditions.scheduling_restriction_id

scheduling_restrictions.id

Cascade on delete

fk_sddt_section

section_definition_document_types.section_definition_id

Cascade on delete

fk_sddt_doc_type

section_definition_document_types.document_type_id

document_types.id

Cascade on delete

fk_client_moods_catalog

client_moods.catalog_client_mood_id

catalog_client_moods.id

Null on delete

fk_client_moods_location_business_line

client_moods.location_business_line_id

service_plan_caregiver_competency_procedures.id

Restrict delete

client_clinical_document_files_ibfk_1

client_clinical_document_files.client_clinical_document_id

client_clinical_documents.id

Cascade on delete

fk_ccp_previous

service_plan_caregiver_competency_procedures.previous_version_id

Restrict delete

fk_ccp_category

service_plan_caregiver_competency_procedures.category_id

service_plan_categories.id

Cascade on delete

sp_maladaptive_behavior_objectives_ibfk_1

sp_maladaptive_behavior_objectives.sp_maladaptive_behavior_id

Cascade on delete

clearinghouses_ibfk_1

clearinghouses.location_business_line_id

Restrict delete

fk_announcement_recipients_announcement

announcement_recipients.announcement_id

announcements.id

Cascade on delete

fk_remittance_lines_claim

remittance_lines.claim_id

claims.id

Restrict delete

fk_remittance_lines_advice

remittance_lines.remittance_advice_id

remittance_advices.id

Cascade on delete

credential_cpt_codes_ibfk_1

credential_cpt_codes.credential_id

credentials.id

Cascade on delete

credential_cpt_codes_ibfk_2

credential_cpt_codes.cpt_code_id

Cascade on delete

fk_user_signatures_user

user_signatures.user_id

users.id

Cascade on delete

user_role_assignments_ibfk_1

user_role_assignments.tenant_role_id

tenant_roles.id

Cascade on delete

fk_client_pharmacy_client

client_pharmacies.client_id

Cascade on delete

fk_client_files_client

client_files.client_id

Cascade on delete

payer_contracted_rates_ibfk_1

payer_contracted_rates.payer_id

payers.id

Restrict delete

fk_payer_contracted_rates_cpt_code

payer_contracted_rates.billing_code_id

Restrict delete

fk_sp_mb_barriers_behavior

sp_maladaptive_behavior_barriers.service_plan_maladaptive_behavior_id

Cascade on delete

fk_sp_mb_barriers_location

sp_maladaptive_behavior_barriers.location_business_line_id

Restrict delete

fk_environmental_changes_location_business_line

environmental_changes.location_business_line_id

Restrict delete

fk_dolr_daily_operation_log

daily_operation_log_reminders.daily_operation_log_id

daily_operation_logs.id

Cascade on delete

fk_announcement_targets_announcement

announcement_targets.announcement_id

announcements.id

Cascade on delete

payers_ibfk_1

payers.location_business_line_id