| application_credentials_application_information_fk |
application_credentials.application_information_id |
application_information.id |
Restrict delete |
| application_information_application_categories_fk |
application_information.application_category_id |
application_categories.id |
Restrict delete |
| application_information_manufacturer_fk |
application_information.manufacturer_id |
manufacturers.id |
Restrict delete |
| card_case_authorizations_card_case_fk |
card_case_authorizations.card_case_id |
card_cases.id |
Restrict delete |
| card_case_authorizations_insurance_policy_fk |
card_case_authorizations.insurance_policy_id |
insurance_policies.id |
Restrict delete |
| card_case_claim_transactions_card_case_fk |
card_case_claim_transactions.card_case_id |
card_cases.id |
Restrict delete |
| card_case_claim_transactions_claim_transaction_fk |
card_case_claim_transactions.claim_transaction_id |
claim_transactions.id |
Restrict delete |
| card_case_claims_card_case_fk |
card_case_claims.card_case_id |
card_cases.id |
Restrict delete |
| card_case_claims_claims_fk |
card_case_claims.claim_id |
claims.id |
Restrict delete |
| card_case_details_card_case_fk |
card_case_details.card_case_id |
card_cases.id |
Restrict delete |
| card_case_details_delay_reason_fk |
card_case_details.delay_reason_id |
reasons.id |
Restrict delete |
| card_case_details_previous_procedure_fk |
card_case_details.previous_procedure_id |
procedures.id |
Restrict delete |
| card_case_details_procedure_change_reason_fk |
card_case_details.procedure_change_reason_id |
reasons.id |
Restrict delete |
| card_case_details_procedure_modifier_fk |
card_case_details.procedure_modifier_id |
procedure_modifiers.id |
Restrict delete |
| card_case_facts_anesthesiologist_fk |
card_case_facts.anesthesiologist_id |
employees.id |
Restrict delete |
| card_case_facts_attending_fk |
card_case_facts.attending_id |
employees.id |
Restrict delete |
| card_case_facts_card_case_fk |
card_case_facts.card_case_id |
card_cases.id |
Restrict delete |
| card_case_facts_cardiologist_id_fk |
card_case_facts.cardiologist_id |
employees.id |
Restrict delete |
| card_case_facts_cardiologist_specialty_id_fk |
card_case_facts.cardiologist_specialty_id |
specialties.id |
Restrict delete |
| card_case_facts_case_priority_fk |
card_case_facts.case_priority_id |
exam_priorities.id |
Restrict delete |
| card_case_facts_delay_reason_fk |
card_case_facts.delay_reason_id |
reasons.id |
Restrict delete |
| card_case_facts_modality_fk |
card_case_facts.modality_id |
modalities.id |
Restrict delete |
| card_case_facts_ordering_fk |
card_case_facts.ordering_id |
employees.id |
Restrict delete |
| card_case_facts_ordering_provider_fk |
card_case_facts.ordering_provider_id |
employees.id |
Restrict delete |
| card_case_facts_performing_fk |
card_case_facts.performing_id |
employees.id |
Restrict delete |
| card_case_facts_performing_specialty_fk |
card_case_facts.performing_specialty_id |
specialties.id |
Restrict delete |
| card_case_facts_resident_id_fk |
card_case_facts.resident_id |
employees.id |
Restrict delete |
| card_case_facts_resource_fk |
card_case_facts.resource_id |
resources.id |
Restrict delete |
| card_case_facts_scheduler_fk |
card_case_facts.scheduler_id |
employees.id |
Restrict delete |
| card_case_facts_service_fk |
card_case_facts.service_id |
services.id |
Restrict delete |
| card_case_facts_site_class_fk |
card_case_facts.site_class_id |
site_classes.id |
Restrict delete |
| card_case_facts_site_fk |
card_case_facts.site_id |
sites.id |
Restrict delete |
| card_case_facts_technologist_fk |
card_case_facts.technologist_id |
employees.id |
Restrict delete |
| card_case_metadata_card_case_fk |
card_case_metadata.card_case_id |
card_cases.id |
Restrict delete |
| card_case_metadata_exam_metadata_type_fk |
card_case_metadata.card_case_metadata_type_id |
exam_metadata_types.id |
Restrict delete |
| card_case_metadata_external_system_fk |
card_case_metadata.external_system_id |
external_systems.id |
Restrict delete |
| card_case_metrics_card_case_fk |
card_case_metrics.card_case_id |
card_cases.id |
Restrict delete |
| card_case_personnel_anesthesiologist_fk |
card_case_personnel.anesthesiologist_id |
employees.id |
Restrict delete |
| card_case_personnel_assisting_physician1_fk |
card_case_personnel.assisting_physician1_id |
employees.id |
Restrict delete |
| card_case_personnel_assisting_physician2_fk |
card_case_personnel.assisting_physician2_id |
employees.id |
Restrict delete |
| card_case_personnel_assisting_physician3_fk |
card_case_personnel.assisting_physician3_id |
employees.id |
Restrict delete |
| card_case_personnel_attending_fk |
card_case_personnel.attending_id |
employees.id |
Restrict delete |
| card_case_personnel_authorizing_fk |
card_case_personnel.authorizing_id |
employees.id |
Restrict delete |
| card_case_personnel_begin_case_fk |
card_case_personnel.begin_case_id |
employees.id |
Restrict delete |
| card_case_personnel_card_case_fk |
card_case_personnel.card_case_id |
card_cases.id |
Restrict delete |
| card_case_personnel_checkin_fk |
card_case_personnel.checkin_id |
employees.id |
Restrict delete |
| card_case_personnel_end_case_fk |
card_case_personnel.end_case_id |
employees.id |
Restrict delete |
| card_case_personnel_nurse1_fk |
card_case_personnel.nurse1_id |
employees.id |
Restrict delete |
| card_case_personnel_nurse2_fk |
card_case_personnel.nurse2_id |
employees.id |
Restrict delete |
| card_case_personnel_nurse3_fk |
card_case_personnel.nurse3_id |
employees.id |
Restrict delete |
| card_case_personnel_ordering_fk |
card_case_personnel.ordering_id |
employees.id |
Restrict delete |
| card_case_personnel_performing_fk |
card_case_personnel.performing_id |
employees.id |
Restrict delete |
| card_case_personnel_scheduler_fk |
card_case_personnel.scheduler_id |
employees.id |
Restrict delete |
| card_case_personnel_signin_fk |
card_case_personnel.signin_id |
employees.id |
Restrict delete |
| card_case_personnel_technologist_fk |
card_case_personnel.technologist_id |
employees.id |
Restrict delete |
| card_case_procedure_mappings_card_case_fk |
card_case_procedure_mappings.card_case_id |
card_cases.id |
Restrict delete |
| card_case_procedure_mappings_procedure_fk |
card_case_procedure_mappings.procedure_id |
procedures.id |
Restrict delete |
| card_case_times_card_case_fk |
card_case_times.card_case_id |
card_cases.id |
Restrict delete |
| card_cases_case_priority_fk |
card_cases.case_priority_id |
exam_priorities.id |
Restrict delete |
| card_cases_current_report_fk |
card_cases.current_report_id |
card_reports.id |
Restrict delete |
| card_cases_current_status_fk |
card_cases.current_status_id |
external_system_statuses.id |
Restrict delete |
| card_cases_external_system_fk |
card_cases.external_system_id |
external_systems.id |
Restrict delete |
| card_cases_first_final_report_fk |
card_cases.first_final_report_id |
card_reports.id |
Restrict delete |
| card_cases_first_prelim_report_fk |
card_cases.first_prelim_report_id |
card_reports.id |
Restrict delete |
| card_cases_first_report_fk |
card_cases.first_report_id |
card_reports.id |
Restrict delete |
| card_cases_last_final_report_fk |
card_cases.last_final_report_id |
card_reports.id |
Restrict delete |
| card_cases_last_prelim_report_fk |
card_cases.last_prelim_report_id |
card_reports.id |
Restrict delete |
| card_cases_order_fk |
card_cases.order_id |
orders.id |
Restrict delete |
| card_cases_patient_mrn_fk |
card_cases.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| card_cases_resource_fk |
card_cases.resource_id |
resources.id |
Restrict delete |
| card_cases_service_fk |
card_cases.service_id |
services.id |
Restrict delete |
| card_cases_site_class_fk |
card_cases.site_class_id |
site_classes.id |
Restrict delete |
| card_cases_site_fk |
card_cases.site_id |
sites.id |
Restrict delete |
| card_cases_site_sublocation_fk |
card_cases.site_sublocation_id |
site_sublocations.id |
Restrict delete |
| card_cases_visit_fk |
card_cases.visit_id |
visits.id |
Restrict delete |
| card_reports_card1_fk |
card_reports.card1_id |
employees.id |
Restrict delete |
| card_reports_card2_fk |
card_reports.card2_id |
employees.id |
Restrict delete |
| card_reports_card3_fk |
card_reports.card3_id |
employees.id |
Restrict delete |
| card_reports_card4_fk |
card_reports.card4_id |
employees.id |
Restrict delete |
| card_reports_card_case_fk |
card_reports.card_case_id |
card_cases.id |
Restrict delete |
| card_reports_report_status_fk |
card_reports.report_status_id |
external_system_statuses.id |
Restrict delete |
| card_reports_transcriptionist_fk |
card_reports.transcriptionist_id |
employees.id |
Restrict delete |
| claim_current_carrier_fk |
claims.current_carrier_id |
insurance_carriers.id |
Restrict delete |
| claim_current_claim_transaction_fk |
claims.current_claim_transaction_id |
claim_transactions.id |
Restrict delete |
| claim_current_external_system_fk |
claims.external_system_id |
external_systems.id |
Restrict delete |
| claim_current_external_system_status_fk |
claims.current_claim_status_id |
external_system_statuses.id |
Restrict delete |
| claim_first_claim_transaction_fk |
claims.first_claim_transaction_id |
claim_transactions.id |
Restrict delete |
| claim_patient_mrn_fk |
claims.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| claim_site_class_fk |
claims.site_class_id |
site_classes.id |
Restrict delete |
| claim_site_fk |
claims.site_id |
sites.id |
Restrict delete |
| claim_transaction_billing_employee_fk |
claim_transactions.billing_employee_id |
employees.id |
Restrict delete |
| claim_transaction_carrier_fk |
claim_transactions.carrier_id |
insurance_carriers.id |
Restrict delete |
| claim_transaction_claim_denial_reason_fk |
claim_transactions.claim_denial_reason_id |
reasons.id |
Restrict delete |
| claim_transaction_claim_fk |
claim_transactions.claim_id |
claims.id |
Restrict delete |
| claim_transaction_claim_status_external_system_status_fk |
claim_transactions.claim_status_id |
external_system_statuses.id |
Restrict delete |
| claim_transaction_claim_transaction_type_fk |
claim_transactions.claim_transaction_type_id |
claim_transaction_types.id |
Restrict delete |
| claim_transaction_cms_hcpcs_code_fk |
claim_transactions.cms_hcpcs_code_id |
cms_hcpcs_codes.id |
Restrict delete |
| claim_transaction_cms_modifiers_claim_fk |
claim_transaction_cms_modifiers.claim_transaction_id |
claim_transactions.id |
Restrict delete |
| claim_transaction_cms_modifiers_modifier_fk |
claim_transaction_cms_modifiers.cms_modifier_id |
cms_modifiers.id |
Restrict delete |
| claim_transaction_diagnoses_claim_transaction_fk |
claim_transaction_diagnoses.claim_transaction_id |
claim_transactions.id |
Restrict delete |
| claim_transaction_diagnoses_icd_code_fk |
claim_transaction_diagnoses.icd_code_id |
icd_codes.id |
Restrict delete |
| claim_transaction_facts_billing_employee_id_fk |
claim_transaction_facts.billing_employee_id |
employees.id |
Restrict delete |
| claim_transaction_facts_claim_denial_reason_id_fk |
claim_transaction_facts.claim_denial_reason_id |
reasons.id |
Restrict delete |
| claim_transaction_facts_claim_id_fk |
claim_transaction_facts.claim_id |
claims.id |
Restrict delete |
| claim_transaction_facts_claim_status_id_fk |
claim_transaction_facts.claim_status_id |
external_system_statuses.id |
Restrict delete |
| claim_transaction_facts_claim_transaction_id_fk |
claim_transaction_facts.claim_transaction_id |
claim_transactions.id |
Restrict delete |
| claim_transaction_facts_claim_transaction_type_id_fk |
claim_transaction_facts.claim_transaction_type_id |
claim_transaction_types.id |
Restrict delete |
| claim_transaction_facts_cms_hcpcs_code_id_fk |
claim_transaction_facts.cms_hcpcs_code_id |
cms_hcpcs_codes.id |
Restrict delete |
| claim_transaction_facts_insurance_carrier_id_fk |
claim_transaction_facts.insurance_carrier_id |
insurance_carriers.id |
Restrict delete |
| claim_transaction_facts_insurance_carrier_plan_grouping_id_fk |
claim_transaction_facts.insurance_carrier_plan_grouping_id |
insurance_carrier_plan_groupings.id |
Restrict delete |
| claim_transaction_facts_insurance_carrier_plan_id_fk |
claim_transaction_facts.insurance_carrier_plan_id |
insurance_carrier_plans.id |
Restrict delete |
| claim_transaction_facts_insurance_policy_id_fk |
claim_transaction_facts.insurance_policy_id |
insurance_policies.id |
Restrict delete |
| claim_transaction_facts_ordering_employee_id_fk |
claim_transaction_facts.ordering_employee_id |
employees.id |
Restrict delete |
| claim_transaction_facts_performing_employee_id_fk |
claim_transaction_facts.performing_employee_id |
employees.id |
Restrict delete |
| claim_transaction_facts_posting_employee_id_fk |
claim_transaction_facts.posting_employee_id |
employees.id |
Restrict delete |
| claim_transaction_facts_site_class_id_fk |
claim_transaction_facts.site_class_id |
site_classes.id |
Restrict delete |
| claim_transaction_facts_site_id_fk |
claim_transaction_facts.site_id |
sites.id |
Restrict delete |
| claim_transaction_facts_universal_event_type_id_fk |
claim_transaction_facts.universal_event_type_id |
universal_event_types.id |
Restrict delete |
| claim_transaction_insurance_policy_fk |
claim_transactions.insurance_policy_id |
insurance_policies.id |
Restrict delete |
| claim_transaction_ordering_employee_fk |
claim_transactions.ordering_employee_id |
employees.id |
Restrict delete |
| claim_transaction_performing_employee_fk |
claim_transactions.performing_employee_id |
employees.id |
Restrict delete |
| claim_transaction_posting_employee_fk |
claim_transactions.posting_employee_id |
employees.id |
Restrict delete |
| claim_visit_fk |
claims.visit_id |
visits.id |
Restrict delete |
| clinical_role_fk |
employee_clinical_role_mappings.clinical_role_id |
clinical_roles.id |
Restrict delete |
| cms_gpci_revision_fk |
cms_gpci.cms_hcpcs_code_revision_id |
cms_hcpcs_code_revisions.id |
Restrict delete |
| cms_hcpcs_codes_cms_modifier_fk |
cms_hcpcs_codes.cms_modifier_id |
cms_modifiers.id |
Restrict delete |
| cms_hcpcs_codes_modality_fk |
cms_hcpcs_codes.modality_id |
modalities.id |
Restrict delete |
| cms_hcpcs_codes_revision_fk |
cms_hcpcs_codes.cms_hcpcs_code_revision_id |
cms_hcpcs_code_revisions.id |
Restrict delete |
| demo_type_fk |
employee_demos.demographic_type_id |
demographic_types.id |
Restrict delete |
| demo_types_fk |
patient_demos.demographic_type_id |
demographic_types.id |
Restrict delete |
| departments_specialties_fk |
specialties.department_id |
departments.id |
Restrict delete |
| dicom_protocol_external_system_fk |
dicom_protocols.external_system_id |
external_systems.id |
Restrict delete |
| dicom_protocol_rad_pacs_modality_fk |
dicom_protocols.rad_pacs_modality_id |
rad_pacs_modalities.id |
Restrict delete |
| dicom_series_dicom_protocol_fk |
dicom_series.dicom_protocol_id |
dicom_protocols.id |
Restrict delete |
| dicom_series_dicom_study_fk |
dicom_series.dicom_study_id |
dicom_studies.id |
Restrict delete |
| dicom_series_equipment_model_fk |
dicom_series.equipment_model_id |
equipment_models.id |
Restrict delete |
| dicom_series_equipment_serial_number_fk |
dicom_series.equipment_serial_number_id |
equipment_serial_numbers.id |
Restrict delete |
| dicom_series_external_system_fk |
dicom_series.external_system_id |
external_systems.id |
Restrict delete |
| dicom_series_manufacturer_fk |
dicom_series.manufacturer_id |
manufacturers.id |
Restrict delete |
| dicom_series_rad_pacs_aet_fk |
dicom_series.rad_pacs_aet_id |
rad_pacs_aets.id |
Restrict delete |
| dicom_series_rad_pacs_bodypart_fk |
dicom_series.rad_pacs_bodypart_id |
rad_pacs_bodyparts.id |
Restrict delete |
| dicom_series_rad_pacs_modality_fk |
dicom_series.rad_pacs_modality_id |
rad_pacs_modalities.id |
Restrict delete |
| dicom_series_software_version_fk |
dicom_series.software_version_id |
software_versions.id |
Restrict delete |
| dicom_studies_card_case_fk |
dicom_studies.card_case_id |
card_cases.id |
Restrict delete |
| dicom_study_accession_external_system_fk |
dicom_studies.accession_external_system_id |
external_systems.id |
Restrict delete |
| dicom_study_external_system_fk |
dicom_studies.external_system_id |
external_systems.id |
Restrict delete |
| dicom_study_procedure_id_fk |
dicom_studies.procedure_id |
procedures.id |
Restrict delete |
| dicom_study_rad_exams_fk |
dicom_studies.rad_exam_id |
rad_exams.id |
Restrict delete |
| employee_clinical_role_mappings_department_fk |
employee_clinical_role_mappings.department_id |
departments.id |
Restrict delete |
| employee_clinical_role_mappings_employee_fk |
employee_clinical_role_mappings.employee_id |
employees.id |
Restrict delete |
| employee_demos_employee_fk |
employee_demos.employee_id |
employees.id |
Restrict delete |
| employee_specialty_mappings_employee_fk |
employee_specialty_mappings.employee_id |
employees.id |
Restrict delete |
| equipment_model_manufacturer_id_fk |
equipment_models.manufacturer_id |
manufacturers.id |
Restrict delete |
| exam_fk |
rad_reports.rad_exam_id |
rad_exams.id |
Restrict delete |
| exam_id_fk |
rad_exam_metadata.rad_exam_id |
rad_exams.id |
Restrict delete |
| exam_metadata_fk |
rad_exam_metadata.exam_metadata_type_id |
exam_metadata_types.id |
Restrict delete |
| exam_metric_fk |
rad_exam_metrics.rad_exam_id |
rad_exams.id |
Restrict delete |
| exams_exam_metadata_fk |
rad_exam_details.rad_exam_id |
rad_exams.id |
Restrict delete |
| exams_exam_personnel_fk |
rad_exam_personnel.rad_exam_id |
rad_exams.id |
Restrict delete |
| exams_exam_times_fk |
rad_exam_times.rad_exam_id |
rad_exams.id |
Restrict delete |
| exams_rad_pacs_metadata_fk |
rad_pacs_metadata.rad_exam_id |
rad_exams.id |
Restrict delete |
| external_system_fk |
identifiers.external_system_id |
external_systems.id |
Restrict delete |
| external_system_id_fk |
visits.external_system_id |
external_systems.id |
Restrict delete |
| external_system_role_mappings_external_system_fk |
external_system_role_mappings.external_system_id |
external_systems.id |
Restrict delete |
| external_system_role_mappings_external_system_role_fk |
external_system_role_mappings.external_system_role_id |
external_system_roles.id |
Restrict delete |
| external_system_site_fk |
external_systems.metasite_id |
metasites.id |
Restrict delete |
| external_system_statuses_external_system_status_fk |
external_system_statuses.external_system_id |
external_systems.id |
Restrict delete |
| external_system_statuses_universal_event_type_fk |
external_system_statuses.universal_event_type_id |
universal_event_types.id |
Restrict delete |
| hcpcs_proc_hcpcs_mappings_fk |
procedure_hcpcs_mappings.cms_hcpcs_code_id |
cms_hcpcs_codes.id |
Restrict delete |
| icd_code_revision_fk |
icd_codes.icd_code_revision_id |
icd_code_revisions.id |
Restrict delete |
| identifier_type_fk |
identifiers.identifier_type_id |
identifier_types.id |
Restrict delete |
| insurance_carrier_demographic_insurance_carrier_fk |
insurance_carrier_demographics.insurance_carrier_id |
insurance_carriers.id |
Restrict delete |
| insurance_carrier_demographics_demographic_type_fk |
insurance_carrier_demographics.demographic_type_id |
demographic_types.id |
Restrict delete |
| insurance_carrier_external_system_fk |
insurance_carriers.external_system_id |
external_systems.id |
Restrict delete |
| insurance_carrier_plan_grouping_fk |
insurance_carrier_plans.insurance_carrier_plan_grouping_id |
insurance_carrier_plan_groupings.id |
Restrict delete |
| insurance_carrier_plan_insurance_carrier_fk |
insurance_carrier_plans.insurance_carrier_id |
insurance_carriers.id |
Restrict delete |
| insurance_policy_insurance_carrier_plan_fk |
insurance_policies.insurance_carrier_plan_id |
insurance_carrier_plans.id |
Restrict delete |
| insurance_policy_relationship_type_fk |
insurance_policies.relationship_type_id |
relationship_types.id |
Restrict delete |
| location_fk |
site_sublocations.site_location_id |
site_locations.id |
Restrict delete |
| metasites_metasite_associations_fk |
metasite_associations.metasite_id |
metasites.id |
Restrict delete |
| modalities_rad_pacs_metadata_fk |
rad_pacs_metadata.rad_pacs_modality_id |
rad_pacs_modalities.id |
Restrict delete |
| modalities_resources_fk |
resources.modality_id |
modalities.id |
Restrict delete |
| order_metadata_exam_metadata_type_fk |
order_metadata.order_metadata_type_id |
exam_metadata_types.id |
Restrict delete |
| order_metadata_external_system_fk |
order_metadata.external_system_id |
external_systems.id |
Restrict delete |
| order_metadata_order_fk |
order_metadata.order_id |
orders.id |
Restrict delete |
| order_procedure_mappings_order_fk |
order_procedure_mappings.order_id |
orders.id |
Restrict delete |
| order_procedure_mappings_procedure_fk |
order_procedure_mappings.procedure_id |
procedures.id |
Restrict delete |
| orders_current_status_id |
orders.current_status_id |
external_system_statuses.id |
Restrict delete |
| orders_departments_fk |
orders.department_id |
departments.id |
Restrict delete |
| orders_exam_priorities_fk |
orders.exam_priority_id |
exam_priorities.id |
Restrict delete |
| orders_external_system_id |
orders.external_system_id |
external_systems.id |
Restrict delete |
| orders_master_order_fk |
orders.master_order_id |
orders.id |
Restrict delete |
| orders_ordering_department_fk |
orders.ordering_department_id |
ordering_departments.id |
Restrict delete |
| orders_ordering_provider_fk |
orders.ordering_provider_id |
employees.id |
Restrict delete |
| orders_ordering_provider_groups_fk |
orders.ordering_provider_group_id |
provider_groups.id |
Restrict delete |
| orders_patient_mrn_id_fk |
orders.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| orders_resources_fk |
orders.resource_id |
resources.id |
Restrict delete |
| orders_site_class_fk |
orders.site_class_id |
site_classes.id |
Restrict delete |
| orders_site_fk |
orders.site_id |
sites.id |
Restrict delete |
| patient_demos_history_patient_mrn_fk |
patient_demos_history.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| patient_demos_patient_mrn_fk |
patient_demos.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| patient_events_event_reason_id_fk |
patient_events.event_reason_id |
reasons.id |
Restrict delete |
| patient_events_history_event_reason_fk |
patient_events_history.event_reason_id |
reasons.id |
Restrict delete |
| patient_events_history_operator_employee_id |
patient_events_history.operator_employee_id |
employees.id |
Restrict delete |
| patient_events_history_postevent_site_sublocation_fk |
patient_events_history.postevent_site_sublocation_id |
site_sublocations.id |
Restrict delete |
| patient_events_history_site_class_fk |
patient_events_history.site_class_id |
site_classes.id |
Restrict delete |
| patient_events_history_universal_event_type_fk |
patient_events_history.external_system_status_id |
external_system_statuses.id |
Restrict delete |
| patient_events_history_visit_fk |
patient_events_history.visit_id |
visits.id |
Restrict delete |
| patient_events_operator_employee_id |
patient_events.operator_employee_id |
employees.id |
Restrict delete |
| patient_events_patient_mrn_fk |
patient_events_history.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| patient_events_site_class_fk |
patient_events.site_class_id |
site_classes.id |
Restrict delete |
| patient_events_site_sublocation_after_event_fk |
patient_events.postevent_site_sublocation_id |
site_sublocations.id |
Restrict delete |
| patient_events_universal_event_type_fk |
patient_events.external_system_status_id |
external_system_statuses.id |
Restrict delete |
| patient_events_visit_fk |
patient_events.visit_id |
visits.id |
Restrict delete |
| patient_mrn_id_fk |
visits.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| patient_mrns_extsys_fk |
patient_mrns.external_system_id |
external_systems.id |
Restrict delete |
| patient_mrns_patient_fk |
patient_mrns.patient_id |
patients.id |
Restrict delete |
| patient_types_site_classes_fk |
site_classes.patient_type_id |
patient_types.id |
Restrict delete |
| people_clinicians_fk |
employees.person_id |
people.id |
Restrict delete |
| people_exam_personnel_fk |
rad_exam_personnel.scheduler_id |
employees.id |
Restrict delete |
| people_exam_personnel_fk1 |
rad_exam_personnel.signin_id |
employees.id |
Restrict delete |
| people_exam_personnel_fk10 |
rad_exam_personnel.authorizing_id |
employees.id |
Restrict delete |
| people_exam_personnel_fk2 |
rad_exam_personnel.checkin_id |
employees.id |
Restrict delete |
| people_exam_personnel_fk4 |
rad_exam_personnel.begin_exam_id |
employees.id |
Restrict delete |
| people_exam_personnel_fk5 |
rad_exam_personnel.end_exam_id |
employees.id |
Restrict delete |
| people_exam_personnel_fk7 |
rad_exam_personnel.performing_id |
employees.id |
Restrict delete |
| people_exam_personnel_fk8 |
rad_exam_personnel.attending_id |
employees.id |
Restrict delete |
| people_exam_personnel_fk9 |
rad_exam_personnel.ordering_id |
employees.id |
Restrict delete |
| people_logins_fk |
identifiers.employee_id |
employees.id |
Restrict delete |
| people_reports_fk |
rad_reports.transcriptionist_id |
employees.id |
Restrict delete |
| people_reports_fk1 |
rad_reports.rad1_id |
employees.id |
Restrict delete |
| people_reports_fk2 |
rad_reports.rad2_id |
employees.id |
Restrict delete |
| people_reports_fk3 |
rad_reports.rad3_id |
employees.id |
Restrict delete |
| people_reports_fk4 |
rad_reports.rad4_id |
employees.id |
Restrict delete |
| people_residents_fk |
residents.employee_id |
employees.id |
Restrict delete |
| procedure_modifiers_exam_metadata_fk |
rad_exam_details.procedure_modifier_id |
procedure_modifiers.id |
Restrict delete |
| procedures_exam_metadata_fk |
rad_exam_details.previous_procedure_id |
procedures.id |
Restrict delete |
| procedures_proc_hcpcs_mappings_fk |
procedure_hcpcs_mappings.procedure_id |
procedures.id |
Restrict delete |
| provider_groups_external_system_fk |
provider_groups.external_system_id |
external_systems.id |
Restrict delete |
| rad_exam_authorizations_insurance_policy_fk |
rad_exam_authorizations.insurance_policy_id |
insurance_policies.id |
Restrict delete |
| rad_exam_authorizations_rad_exam_fk |
rad_exam_authorizations.rad_exam_id |
rad_exams.id |
Restrict delete |
| rad_exam_claim_transactions_claim_transaction_fk |
rad_exam_claim_transactions.claim_transaction_id |
claim_transactions.id |
Restrict delete |
| rad_exam_claim_transactions_rad_exam_fk |
rad_exam_claim_transactions.rad_exam_id |
rad_exams.id |
Restrict delete |
| rad_exam_claims_claim_fk |
rad_exam_claims.claim_id |
claims.id |
Restrict delete |
| rad_exam_claims_rad_exam_fk |
rad_exam_claims.rad_exam_id |
rad_exams.id |
Restrict delete |
| rad_exam_current_report_fk |
rad_exams.current_report_id |
rad_reports.id |
Restrict delete |
| rad_exam_depts_site_fk |
rad_exam_departments.site_id |
sites.id |
Restrict delete |
| rad_exam_details_delay_reason_fk |
rad_exam_details.delay_reason_id |
reasons.id |
Restrict delete |
| rad_exam_details_procedure_change_reason_fk |
rad_exam_details.procedure_change_reason_id |
reasons.id |
Restrict delete |
| rad_exam_exam_priority_fk |
rad_exams.exam_priority_id |
exam_priorities.id |
Restrict delete |
| rad_exam_external_system_status_fk |
rad_exams.current_status_id |
external_system_statuses.id |
Restrict delete |
| rad_exam_external_system_statuses_external_system_fk |
rad_exam_external_system_statuses.external_system_id |
external_systems.id |
Restrict delete |
| rad_exam_external_system_statuses_external_system_status_fk |
rad_exam_external_system_statuses.external_system_status_id |
external_system_statuses.id |
Restrict delete |
| rad_exam_external_system_statuses_rad_exam_fk |
rad_exam_external_system_statuses.rad_exam_id |
rad_exams.id |
Restrict delete |
| rad_exam_extsys_fk |
rad_exams.external_system_id |
external_systems.id |
Restrict delete |
| rad_exam_facts_delay_exam_priority_id_fk |
rad_exam_facts.exam_priority_id |
exam_priorities.id |
Restrict delete |
| rad_exam_facts_delay_reason_id_fk |
rad_exam_facts.delay_reason_id |
reasons.id |
Restrict delete |
| rad_exam_facts_equipment_model_id_fk |
rad_exam_facts.equipment_model_id |
equipment_models.id |
Restrict delete |
| rad_exam_facts_equipment_serial_number_id_fk |
rad_exam_facts.equipment_serial_number_id |
equipment_serial_numbers.id |
Restrict delete |
| rad_exam_facts_manufacturer_id_fk |
rad_exam_facts.manufacturer_id |
manufacturers.id |
Restrict delete |
| rad_exam_facts_modality_id_fk |
rad_exam_facts.modality_id |
modalities.id |
Restrict delete |
| rad_exam_facts_ordering_department_id_fk |
rad_exam_facts.ordering_department_id |
ordering_departments.id |
Restrict delete |
| rad_exam_facts_ordering_provider_group_id_fk |
rad_exam_facts.ordering_provider_group_id |
provider_groups.id |
Restrict delete |
| rad_exam_facts_ordering_provider_id_fk |
rad_exam_facts.ordering_provider_id |
employees.id |
Restrict delete |
| rad_exam_facts_procedure_id_fk |
rad_exam_facts.procedure_id |
procedures.id |
Restrict delete |
| rad_exam_facts_procedure_specialty_id_fk |
rad_exam_facts.procedure_specialty_id |
specialties.id |
Restrict delete |
| rad_exam_facts_rad_exam_department_id_fk |
rad_exam_facts.rad_exam_department_id |
rad_exam_departments.id |
Restrict delete |
| rad_exam_facts_rad_exam_id_fk |
rad_exam_facts.rad_exam_id |
rad_exams.id |
Restrict delete |
| rad_exam_facts_rad_pacs_aet_id_fk |
rad_exam_facts.rad_pacs_aet_id |
rad_pacs_aets.id |
Restrict delete |
| rad_exam_facts_rad_pacs_bodypart_id_fk |
rad_exam_facts.rad_pacs_bodypart_id |
rad_pacs_bodyparts.id |
Restrict delete |
| rad_exam_facts_rad_pacs_modality_id_fk |
rad_exam_facts.rad_pacs_modality_id |
rad_pacs_modalities.id |
Restrict delete |
| rad_exam_facts_radiologist_id_fk |
rad_exam_facts.radiologist_id |
employees.id |
Restrict delete |
| rad_exam_facts_radiologist_specialty_id_fk |
rad_exam_facts.radiologist_specialty_id |
specialties.id |
Restrict delete |
| rad_exam_facts_resident_id_fk |
rad_exam_facts.resident_id |
employees.id |
Restrict delete |
| rad_exam_facts_resource_id_fk |
rad_exam_facts.resource_id |
resources.id |
Restrict delete |
| rad_exam_facts_scheduler_id_fk |
rad_exam_facts.scheduler_id |
employees.id |
Restrict delete |
| rad_exam_facts_scheduling_rad_exam_department_id_fk |
rad_exam_facts.scheduling_rad_exam_department_id |
rad_exam_departments.id |
Restrict delete |
| rad_exam_facts_scheduling_service_id_fk |
rad_exam_facts.scheduling_service_id |
services.id |
Restrict delete |
| rad_exam_facts_scheduling_site_id_fk |
rad_exam_facts.scheduling_site_id |
sites.id |
Restrict delete |
| rad_exam_facts_scheduling_specialty_id_fk |
rad_exam_facts.scheduling_specialty_id |
specialties.id |
Restrict delete |
| rad_exam_facts_service_id_fk |
rad_exam_facts.service_id |
services.id |
Restrict delete |
| rad_exam_facts_site_class_id_fk |
rad_exam_facts.site_class_id |
site_classes.id |
Restrict delete |
| rad_exam_facts_site_id_fk |
rad_exam_facts.site_id |
sites.id |
Restrict delete |
| rad_exam_facts_site_location_id_fk |
rad_exam_facts.site_location_id |
site_locations.id |
Restrict delete |
| rad_exam_facts_technologist_id_fk |
rad_exam_facts.technologist_id |
employees.id |
Restrict delete |
| rad_exam_first_final_report_fk |
rad_exams.first_final_report_id |
rad_reports.id |
Restrict delete |
| rad_exam_first_prelim_report_fk |
rad_exams.first_prelim_report_id |
rad_reports.id |
Restrict delete |
| rad_exam_first_report_fk |
rad_exams.first_report_id |
rad_reports.id |
Restrict delete |
| rad_exam_last_final_report_fk |
rad_exams.last_final_report_id |
rad_reports.id |
Restrict delete |
| rad_exam_last_prelim_report_fk |
rad_exams.last_prelim_report_id |
rad_reports.id |
Restrict delete |
| rad_exam_metadata_external_system_id_fk |
rad_exam_metadata.external_system_id |
external_systems.id |
Restrict delete |
| rad_exam_order_fk |
rad_exams.order_id |
orders.id |
Restrict delete |
| rad_exam_patient_mrn_fk |
rad_exams.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| rad_exam_procedure_fk |
rad_exams.procedure_id |
procedures.id |
Restrict delete |
| rad_exam_rad_exam_dept_fk |
rad_exams.rad_exam_department_id |
rad_exam_departments.id |
Restrict delete |
| rad_exam_resource_fk |
rad_exams.resource_id |
resources.id |
Restrict delete |
| rad_exam_service_fk |
rad_exams.service_id |
services.id |
Restrict delete |
| rad_exam_site_class_fk |
rad_exams.site_class_id |
site_classes.id |
Restrict delete |
| rad_exam_site_fk |
rad_exams.site_id |
sites.id |
Restrict delete |
| rad_exam_site_sublocation_fk |
rad_exams.site_sublocation_id |
site_sublocations.id |
Restrict delete |
| rad_exam_visit_fk |
rad_exams.visit_id |
visits.id |
Restrict delete |
| rad_pacs_aets_rad_pacs_metadata_fk |
rad_pacs_metadata.rad_pacs_aet_id |
rad_pacs_aets.id |
Restrict delete |
| rad_pacs_bodyparts_rad_pacs_metadata_fk |
rad_pacs_metadata.rad_pacs_bodypart_id |
rad_pacs_bodyparts.id |
Restrict delete |
| rad_pacs_external_system_fk |
rad_pacs_metadata.external_system_id |
external_systems.id |
Restrict delete |
| rad_pacs_metadata_equipment_model_fk |
rad_pacs_metadata.equipment_model_id |
equipment_models.id |
Restrict delete |
| rad_pacs_metadata_equipment_serial_number_fk |
rad_pacs_metadata.equipment_serial_number_id |
equipment_serial_numbers.id |
Restrict delete |
| rad_pacs_specialities_rad_pacs_metadata_fk |
rad_pacs_metadata.rad_pacs_speciality_id |
rad_pacs_specialities.id |
Restrict delete |
| rad_pacs_station_names_rad_pacs_metadata_fk |
rad_pacs_metadata.rad_pacs_station_name_id |
rad_pacs_station_names.id |
Restrict delete |
| radonc_case_authorizations_insurance_policy_fk |
radonc_case_authorizations.insurance_policy_id |
insurance_policies.id |
Restrict delete |
| radonc_case_claims_claim_fk |
radonc_case_claims.claim_id |
claims.id |
Restrict delete |
| radonc_case_claims_radonc_case_fk |
radonc_case_claims.radonc_case_id |
radonc_cases.id |
Restrict delete |
| radonc_caseauthorizations_radonc_case_fk |
radonc_case_authorizations.radonc_case_id |
radonc_cases.id |
Restrict delete |
| radonc_cases_exam_priority_fk |
radonc_cases.exam_priority_id |
exam_priorities.id |
Restrict delete |
| radonc_cases_external_system_status_fk |
radonc_cases.current_status_id |
external_system_statuses.id |
Restrict delete |
| radonc_cases_extsys_fk |
radonc_cases.external_system_id |
external_systems.id |
Restrict delete |
| radonc_cases_order_fk |
radonc_cases.order_id |
orders.id |
Restrict delete |
| radonc_cases_patient_mrn_fk |
radonc_cases.patient_mrn_id |
patient_mrns.id |
Restrict delete |
| radonc_cases_procedure_fk |
radonc_cases.procedure_id |
procedures.id |
Restrict delete |
| radonc_cases_site_class_fk |
radonc_cases.site_class_id |
site_classes.id |
Restrict delete |
| radonc_cases_site_fk |
radonc_cases.site_id |
sites.id |
Restrict delete |
| radonc_cases_site_sublocation_fk |
radonc_cases.site_sublocation_id |
site_sublocations.id |
Restrict delete |
| radonc_cases_visit_fk |
radonc_cases.visit_id |
visits.id |
Restrict delete |
| reasons_extsys_fk |
reasons.external_system_id |
external_systems.id |
Restrict delete |
| rep_atech1_emp_fk |
rad_exam_personnel.assisting_tech1_id |
employees.id |
Restrict delete |
| rep_atech2_emp_fk |
rad_exam_personnel.assisting_tech2_id |
employees.id |
Restrict delete |
| rep_atech3_emp_fk |
rad_exam_personnel.assisting_tech3_id |
employees.id |
Restrict delete |
| rep_tech_emp_fk |
rad_exam_personnel.technologist_id |
employees.id |
Restrict delete |
| report_status_fk |
rad_reports.report_status_id |
external_system_statuses.id |
Restrict delete |
| resource_extsys_fk |
resources.external_system_id |
external_systems.id |
Restrict delete |
| resource_rad_pacs_aet_fk |
resources.rad_pacs_aet_id |
rad_pacs_aets.id |
Restrict delete |
| resource_site_fk |
resources.site_id |
sites.id |
Restrict delete |
| scheduling_task_external_system_fk |
scheduling_tasks.external_system_id |
external_systems.id |
Restrict delete |
| scheduling_task_gropuing_external_system_fk |
scheduling_task_groupings.external_system_id |
external_systems.id |
Restrict delete |
| scheduling_task_rad_exam_department_fk |
scheduling_task_groupings.rad_exam_department_id |
rad_exam_departments.id |
Restrict delete |
| scheduling_task_scheduling_task_grouping_fk |
scheduling_tasks.scheduling_task_grouping_id |
scheduling_task_groupings.id |
Restrict delete |
| scheduling_task_service_fk |
scheduling_task_groupings.service_id |
services.id |
Restrict delete |
| scheduling_task_site_fk |
scheduling_task_groupings.site_id |
sites.id |
Restrict delete |
| scheduling_task_specialty_fk |
scheduling_task_groupings.specialty_id |
specialties.id |
Restrict delete |
| services_department_fk |
services.department_id |
departments.id |
Restrict delete |
| services_site_fk |
services.site_id |
sites.id |
Restrict delete |
| site_classes_cms_facility_type_fk |
site_classes.cms_facility_type_id |
cms_facility_types.id |
Restrict delete |
| site_classes_external_system_id_fk |
site_classes.external_system_id |
external_systems.id |
Restrict delete |
| site_cms_gpci_fk |
sites.cms_gpci_id |
cms_gpci.id |
Restrict delete |
| site_location_external_system_id_fk |
site_locations.external_system_id |
external_systems.id |
Restrict delete |
| site_location_fk |
site_locations.site_id |
sites.id |
Restrict delete |
| sites_metasite_associations_fk |
metasite_associations.site_id |
sites.id |
Restrict delete |
| sites_procedures_fk |
procedures.external_system_id |
external_systems.id |
Restrict delete |
| sites_site_classes_fk |
site_classes.site_id |
sites.id |
Restrict delete |
| software_versions_rad_pacs_metadata_fk |
rad_pacs_metadata.software_version_id |
software_versions.id |
Restrict delete |
| specialties_procedures_fk |
procedures.specialty_id |
specialties.id |
Restrict delete |
| specialty_fk |
employee_specialty_mappings.specialty_id |
specialties.id |
Restrict delete |
| visit_diagnoses_icd_code_fk |
visit_diagnoses.icd_code_id |
icd_codes.id |
Restrict delete |
| visit_diagnoses_visit_fk |
visit_diagnoses.visit_id |
visits.id |
Restrict delete |
| visit_fk |
patient_demos.visit_id |
visits.id |
Restrict delete |
| visit_insurance_policies_insurance_policy_fk |
visit_insurance_policies.insurance_policy_id |
insurance_policies.id |
Restrict delete |
| visit_insurance_policies_visit_fk |
visit_insurance_policies.visit_id |
visits.id |
Restrict delete |
| visits_orders_fk |
orders.visit_id |
visits.id |
Restrict delete |
| visits_site_fk |
visits.site_id |
sites.id |
Restrict delete |