Space

rails generate migration remove_unused_indexes

And paste

remove_index :audit_details, name: "index_audit_details_on_audit_id"
remove_index :audits, name: "index_audits_on_created_at"
remove_index :audits, name: "audits_enity_index"
remove_index :audits, name: "index_audits_on_entity_id"
remove_index :audits, name: "audit_created_by_index"
remove_index :bill_details, name: "index_bill_details_on_service_request_detail_id"
remove_index :bills, name: "index_bills_on_sevice_request_id"
remove_index :address_details, name: "country"
remove_index :leave_availd_details, name: "lad_employee_date_status"
remove_index :service_requests, name: "index_service_requests_on_patient_id"
remove_index :service_requests, name: "index_service_requests_on_visit_id"
remove_index :transaction_details, name: "index_transaction_details_20122017_on_created_by"
remove_index :transaction_details, name: "index_transaction_details_20122017_on_location_id"
remove_index :bills, name: "pa_visit_pack_treat"
remove_index :bills, name: "index_bills_on_clinician_id"
remove_index :bill_details, name: "index_bill_details_on_clinician_id"
remove_index :bill_details, name: "idx_item_with_detail_id"
remove_index :bill_details, name: "idx_location_id"
remove_index :bill_details, name: "idx_station_id"
remove_index :bills, name: "index_bills_on_bill_category_id"
remove_index :bills, name: "index_bills_on_location_id"
remove_index :bills, name: "index_bills_on_luxury_type_id"
remove_index :bills, name: "index_bills_on_package_id"
remove_index :bills, name: "index_bills_on_treatment_id"
remove_index :service_requests, name: "service_requests_encounter_id_idx"
remove_index :patients, name: "index_patients_on_title_id"
remove_index :service_requests, name: "index_service_requests_on_location_id"
remove_index :patients, name: "blood_group_id"
remove_index :patients, name: "fki_photograph_id"
remove_index :item_reorder_levels, name: "index_item_reorder_levels_on_item_id"
remove_index :item_reorder_levels, name: "index_item_reorder_levels_on_item_unit_denomination_id"
remove_index :patients, name: "patient_category"
remove_index :patients, name: "relogion_id"
remove_index :service_rate_corporates, name: "index_service_rate_corporates_on_bed_category_id"
remove_index :service_rate_corporates, name: "index_service_rate_corporates_on_corporate_id"
remove_index :item_reorder_levels, name: "index_item_reorder_levels_on_inventory_head_id"
remove_index :visits, name: "index_visits_on_employee_id"
remove_index :visits, name: "visits_visit_type_name_visit_type_id_idx"
remove_index :visits, name: "bill_category_id"
remove_index :schedulable_entities, name: "index_schedulable_entities_on_clinician_id"
remove_index :schedulable_entities, name: "index_schedulable_entities_on_equipment_id"
remove_index :uploaded_documents, name: "uploaded_documents_encounter_id_idx"
remove_index :visits, name: "index_visits_on_clinician_id"
remove_index :visits, name: "index_visits_on_corporate_id"
remove_index :visits, name: "index_visits_on_counter_id"
remove_index :visits, name: "index_visits_on_station_id"
remove_index :visits, name: "index_visits_on_user_id"
remove_index :leave_availd_details, name: "index_leave_availd_details_on_leave_type_id"
remove_index :menu_lists, name: "menu_lists_notification_name_idx"
remove_index :appointments, name: "index_appointment_criticality"
remove_index :appointments, name: "index_appointments_on_app_end_date_time"
remove_index :appointments, name: "index_appointments_on_appointment_category_id"
remove_index :appointments, name: "index_appointments_on_service_request_detail_id"
remove_index :nanda_domain_category_codes, name: "n_diagnosis_idx"
remove_index :employees, name: "e_depart_design"
remove_index :employees, name: "e_status"
remove_index :personnel_bank_details, name: "ebd_pf_ot_id"
remove_index :emergency_forms, name: "emergency_forms_encounter_id_patient_id_idx"
remove_index :personnel_bank_details, name: "employee_salary_type"
remove_index :clinicians, name: "fki_type"
remove_index :account_configurations, name: "index_account_configurations_on_general_account_id"
remove_index :account_services_mappings, name: "index_account_mapping_on_general_account_id"
remove_index :account_services_mappings, name: "index_account_mapping_on_location_id"
remove_index :account_services_mappings, name: "index_account_mapping_on_service_id"
remove_index :advance_details, name: "index_advance_details_on_patient_id"
remove_index :advance_details, name: "index_advance_details_on_transaction_detail_id"
remove_index :advance_details, name: "index_advance_details_on_visit_id"
remove_index :advance_visits, name: "index_advance_visits_on_patient_id"
remove_index :advance_visits, name: "index_advance_visits_on_visit_id"
remove_index :bill_category_corporates, name: "index_bill_category_corporates_on_bill_category_id"
remove_index :bill_category_corporates, name: "index_bill_category_corporates_on_corporate_id"
remove_index :corporates, name: "index_corporates_on_parent_id"
remove_index :department_shift_details, name: "index_department_shift_details_on_department_id"
remove_index :department_shift_details, name: "index_department_shift_details_on_shift_timing_id"
remove_index :personnel_bank_details, name: "index_employee_bank_details_on_bank_id"
remove_index :personnel_bank_details, name: "index_employee_bank_details_on_employee_over_time_id"
remove_index :personnel_bank_details, name: "index_employee_bank_details_on_salary_type_id"
remove_index :employee_dependent_details, name: "index_employee_dependent_details_on_employee_id"
remove_index :employee_experiences, name: "index_employee_experiences_on_employee_id"
remove_index :employee_passport_driving_details, name: "index_employee_passport_driving_details_on_employee_id"
remove_index :employees, name: "index_employees_on_designation_id"
remove_index :employees, name: "index_employees_on_employee_type_id"
remove_index :employees, name: "index_employees_on_location_id"
remove_index :general_accounts, name: "index_general_accounts_on_external_account_id"
remove_index :general_accounts, name: "index_general_accounts_on_location_id"
remove_index :inventory_heads, name: "index_inventory_heads_on_location_id"
remove_index :inventory_heads, name: "index_inventory_heads_on_role_id"
remove_index :items, name: "index_items_on_dispensing_unit_id"
remove_index :holiday_masters, name: "index_name"
remove_index :personnels, name: "index_name_weekly_app_query"
remove_index :packages, name: "index_packages_on_treatment_id"
remove_index :roles_users, name: "index_roles_users_on_sub_role_id"
remove_index :roles_users, name: "index_roles_users_on_user_id"
remove_index :service_groups, name: "index_service_group_on_clinical_system_id"
remove_index :service_groups, name: "index_service_group_on_department_service_group"
remove_index :services, name: "index_services_on_service_type_id"
remove_index :states, name: "index_states_on_country_id"
remove_index :titles, name: "index_titles_on_sex_id"
remove_index :nanda_domain_category_codes, name: "n_diagnosis_code_idx"
remove_index :allowance_deductions, name: "name"
remove_index :clinicians, name: "personnel_id"
remove_index :snapshots, name: "snapshots_encounter_id_idx"
remove_index :employee_transfer_details, name: "transfer_department_id"
remove_index :employee_transfer_details, name: "transfer_designation_id"
remove_index :employee_transfer_details, name: "transfer_employee_id"
remove_index :upload_files, name: "upload_employee_hr_name"
remove_index :ai_inrs_interface_result_t, name: "ai_inrs_interface_result_t_idx1"
remove_index :ai_tmmt_test_map_mast_t, name: "ai_tmmt_test_map_mast_t_idx1"
remove_index :allowance_deduction_details, name: "allowance_deduction_employee_id"
remove_index :employee_appraisals, name: "apprisal_designation_id"
remove_index :employee_appraisal_details, name: "apprisal_employee_apprisal_id"
remove_index :employee_check_lists, name: "check_check_list_id"
remove_index :employee_check_lists, name: "check_personnel_id"
remove_index :clinical_demographics, name: "clinical_demographics_patient_id_encounter_id_idx"
remove_index :complaints, name: "complaints_encounter_id_idx"
remove_index :corporate_status_details, name: "corporate_transaction"
remove_index :delayed_jobs, name: "delayed_jobs_priority"
remove_index :employee_advance_accounts, name: "eaa_employee_date"
remove_index :employee_advance_account_details, name: "eaad_employee_date"
remove_index :employee_leave_balances, name: "elb_employee_leave"
remove_index :employee_leave_encashments, name: "ele_employee_date"
remove_index :employee_extra_duty_details, name: "employee_extra_duty_employee_id"
remove_index :extra_duty_approval_details, name: "employee_extra_duty_id"
remove_index :employee_stations, name: "employee_station_employee_id"
remove_index :employee_stations, name: "employee_station_station_id"
remove_index :employee_payslip_details, name: "epd_payslip_comp_type"
remove_index :employee_personal_informations, name: "epi_employee_name"
remove_index :employee_swipes, name: "eswipe_employee_date"
remove_index :extra_duty_approval_details, name: "extra_duty_approval_compoff_id"
remove_index :extra_duty_compoff_details, name: "extra_duty_comp_off_employee_id"
remove_index :employee_extra_duty_details, name: "extra_duty_shift_timing_id"
remove_index :family_histories, name: "family_histories_patient_id_idx"
remove_index :clinicianreferals, name: "fki_clinician_id"
remove_index :patient_forms, name: "fki_frommaster_key"
remove_index :vital_signs, name: "fki_inpatient_vital_sign"
remove_index :patient_forms, name: "fki_patient_fkey"
remove_index :lab_heads, name: "fki_role_lab"
remove_index :formula_masters, name: "fm_employee_comp"
remove_index :employee_gratuity_details, name: "gratuity_employee_id"
remove_index :health_parameters, name: "health_parameters_encounter_id_idx"
remove_index :abdomino_pelvic_ultrasounds, name: "index_abdomino_pelvic_ultrasounds_on_patient_id"
remove_index :accident_emergency_details, name: "index_accident_emergency_details_on_patient_id"
remove_index :accident_emergency_details, name: "index_accident_emergency_details_on_title_id"
remove_index :adt_requests, name: "index_adt_requests_on_patient_id"
remove_index :adt_requests, name: "index_adt_requests_on_visit_id"
remove_index :allowance_deduction_details, name: "index_allowance_deduction_details_on_allowance_deduction_id"
remove_index :allowance_deduction_details, name: "index_allowance_deduction_details_on_salary_type_id"
remove_index :angiograms, name: "index_angiograms_on_encounter_id"
remove_index :angiograms, name: "index_angiograms_on_patient_id"
remove_index :assets, name: "index_assets_on_inventory_transaction_detail_id"
remove_index :asymptomatic_symptoms, name: "index_asymptomatic_symptoms_on_cytome_retinitis_proforma_id"
remove_index :bangiograms, name: "index_bangiograms_on_encounter_id"
remove_index :bangiograms, name: "index_bangiograms_on_patient_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_bed_category_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_bed_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_corporate_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_inpatient_detail_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_station_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_station_unit_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_treatment_id"
remove_index :bed_component_rates, name: "index_bed_component_rates_on_bed_rate_category_id"
remove_index :bed_component_rates, name: "index_bed_component_rates_on_bed_rate_component_id"
remove_index :bed_component_rates, name: "index_bed_component_rates_on_corporate_id"
remove_index :bed_reservations, name: "index_bed_reservations_on_bed_category_id"
remove_index :bed_reservations, name: "index_bed_reservations_on_bed_id"
remove_index :bed_reservations, name: "index_bed_reservations_on_clinician_id"
remove_index :bed_reservations, name: "index_bed_reservations_on_corporate_id"
remove_index :bed_reservations, name: "index_bed_reservations_on_patient_id"
remove_index :bed_reservations, name: "index_bed_reservations_on_treatment_id"
remove_index :beds, name: "index_beds_on_bed_category_id"
remove_index :beds, name: "index_beds_on_floor_id"
remove_index :blood_bags, name: "index_blood_bags_on_donor_detail_id"
remove_index :blood_bank_components, name: "index_blood_bank_components_on_location_id"
remove_index :blood_component_prices, name: "index_blood_component_prices_on_location_id"
remove_index :blood_discard_causes, name: "index_blood_discard_causes_on_location_id"
remove_index :blood_issue_details, name: "index_blood_issue_details_on_blood_bank_component_master_id"
remove_index :blood_issue_details, name: "index_blood_issue_details_on_blood_bank_hospital_list_id"
remove_index :blood_issue_details, name: "index_blood_issue_details_on_donor_visit_detail_id"
remove_index :blood_issue_details, name: "index_blood_issue_details_on_recipient_component_detail_id"
remove_index :blood_issue_return_details, name: "index_blood_issue_return_details_on_blood_issue_detail_id"
remove_index :bloodbank_details, name: "index_bloodbank_details_on_hospital_id"
remove_index :brand_names, name: "index_brand_names_on_drug_brand_id"
remove_index :brand_names, name: "index_brand_names_on_drug_id"
remove_index :breakdowns, name: "index_breakdowns_on_equipment_id"
remove_index :cataract_io_complications, name: "index_cataract_io_complications_on_cataract_post_op_procedure_i"
remove_index :cataract_io_complications, name: "index_cataract_io_complications_on_patient_id"
remove_index :cataract_post_op_procedures, name: "index_cataract_post_op_procedures_on_cataract_proforma_id"
remove_index :cataract_post_op_procedures, name: "index_cataract_post_op_procedures_on_encounter_id"
remove_index :cataract_post_op_procedures, name: "index_cataract_post_op_procedures_on_patient_id"
remove_index :cataract_proformas, name: "index_cataract_proformas_on_patient_id"
remove_index :cataract_surgery_appointments, name: "index_cataract_surgery_appointments_on_cataract_proforma_id"
remove_index :cataract_surgery_appointments, name: "index_cataract_surgery_appointments_on_encounter_id"
remove_index :cataract_surgery_appointments, name: "index_cataract_surgery_appointments_on_patient_id"
remove_index :catheterization_reports, name: "index_catheterization_reports_on_encounter_id"
remove_index :catheterization_reports, name: "index_catheterization_reports_on_patient_id"
remove_index :chief_complaints, name: "index_chief_complaints_on_encounter_id"
remove_index :chronological_milestones, name: "index_chronological_milestones_on_encounter_id"
remove_index :chronological_milestones, name: "index_chronological_milestones_on_patient_id"
remove_index :clinician_shares, name: "index_clinician_shares_on_bill_detail_id"
remove_index :clinician_shares, name: "index_clinician_shares_on_clinician_id"
remove_index :clinicianreferals, name: "index_clinicianreferals_on_patient_id"
remove_index :clinicianreferals, name: "index_clinicianreferals_on_visit_id"
remove_index :consignments, name: "index_consignments_on_inventory_transaction_detail_id"
remove_index :consignments, name: "index_consignments_on_invoice_id"
remove_index :consignments, name: "index_consignments_on_item_id"
remove_index :corporate_status_details, name: "index_corporate_status_details_on_corporate_id"
remove_index :corporate_status_details, name: "index_corporate_status_details_on_visit_id"
remove_index :cross_consultations, name: "index_cross_consultations_on_encounter_id"
remove_index :cross_consultations, name: "index_cross_consultations_on_patient_id"
remove_index :crossmatch_details, name: "index_crossmatch_details_on_blood_bank_component_master_id"
remove_index :crossmatch_details, name: "index_crossmatch_details_on_blood_bank_hospital_list_id"
remove_index :crossmatch_details, name: "index_crossmatch_details_on_donor_visit_detail_id"
remove_index :crossmatch_details, name: "index_crossmatch_details_on_recipient_component_detail_id"
remove_index :ct_scans, name: "index_ct_scans_on_encounter_id"
remove_index :ct_scans, name: "index_ct_scans_on_patient_id"
remove_index :cytome_retinitis_proformas, name: "index_cytome_retinitis_proformas_on_encounter_id"
remove_index :cytome_retinitis_proformas, name: "index_cytome_retinitis_proformas_on_patient_id"
remove_index :diabetes_feet_examinations, name: "index_diabetes_feet_examinations_on_encounter_id"
remove_index :diabetes_feet_examinations, name: "index_diabetes_feet_examinations_on_patient_id"
remove_index :diagrams, name: "index_diagrams_on_encounter_id"
remove_index :diagrams, name: "index_diagrams_on_patient_id"
remove_index :diet_plan_details, name: "index_diet_plan_details_on_diet_plan_id"
remove_index :diet_plan_details, name: "index_diet_plan_details_on_kitchen_item_id"
remove_index :discard_blood_unit_details, name: "index_discard_blood_unit_details_on_donor_visit_detail_id"
remove_index :disease_registries, name: "index_disease_registries_on_patient_id"
remove_index :dispatch_specimens, name: "index_dispatch_specimens_on_lab_test_request_detail_id"
remove_index :doctor_rounds, name: "index_doctor_rounds_on_bed_id"
remove_index :doctor_rounds, name: "index_doctor_rounds_on_department_id"
remove_index :doctor_rounds, name: "index_doctor_rounds_on_doctor_id"
remove_index :doctor_rounds, name: "index_doctor_rounds_on_patient_id"
remove_index :donor_adverse_reactions, name: "index_donor_adverse_reactions_on_donor_detail_id"
remove_index :donor_blood_unit_components, name: "index_donor_blood_unit_components_on_blood_bank_component_maste"
remove_index :donor_blood_unit_components, name: "index_donor_blood_unit_components_on_blood_group_id"
remove_index :donor_blood_unit_components, name: "index_donor_blood_unit_components_on_donor_visit_detail_id"
remove_index :donor_details, name: "index_donor_details_on_area_id"
remove_index :donor_details, name: "index_donor_details_on_blood_group_id"
remove_index :donor_details, name: "index_donor_details_on_city_id"
remove_index :donor_details, name: "index_donor_details_on_location_id"
remove_index :donor_medical_history_news, name: "index_donor_medical_history_news_on_donor_condition_id"
remove_index :donor_medical_history_news, name: "index_donor_medical_history_news_on_donor_detail_id"
remove_index :donor_visit_details, name: "index_donor_visit_details_on_area_id"
remove_index :donor_visit_details, name: "index_donor_visit_details_on_blood_bank_donor_type_master_id"
remove_index :donor_visit_details, name: "index_donor_visit_details_on_blood_bank_hospital_list_id"
remove_index :donor_visit_details, name: "index_donor_visit_details_on_city_id"
remove_index :donor_visit_details, name: "index_donor_visit_details_on_donor_detail_id"
remove_index :drug_prescription_details, name: "index_drug_prescription_details_on_item_id"
remove_index :drug_prescription_details, name: "index_drug_prescription_details_on_prescription_master_id"
remove_index :drugs_interactions, name: "index_drugs_interactions_on_drug1_id"
remove_index :drugs_interactions, name: "index_drugs_interactions_on_drug2_id"
remove_index :duty_rosters, name: "index_duty_rosters_on_location_id"
remove_index :duty_rosters, name: "index_duty_rosters_on_shift_timing_id"
remove_index :early_obstetric_ultrasounds, name: "index_early_obstetric_ultrasounds_on_patient_id"
remove_index :echo_cardios, name: "index_echo_cardios_on_patient_id"
remove_index :echo_dopplers, name: "index_echo_dopplers_on_patient_id"
remove_index :employee_advance_accounts, name: "index_employee_advance_accounts_on_loan_type_id"
remove_index :employee_duty_roasters, name: "index_employee_duty_roasters_on_allocation_id"
remove_index :employee_duty_roasters, name: "index_employee_duty_roasters_on_location_id"
remove_index :employee_duty_roasters, name: "index_employee_duty_roasters_on_personnel_id"
remove_index :employee_duty_roasters, name: "index_employee_duty_roasters_on_shift_timing_id"
remove_index :employee_leave_balances, name: "index_employee_leave_balances_on_leave_type_id"
remove_index :employee_onduty_details, name: "index_employee_onduty_details_on_employee_id"
remove_index :employee_ot_definitions, name: "index_employee_ot_definitions_on_employee_id"
remove_index :employee_payslip_details, name: "index_employee_payslip_details_on_component_id"
remove_index :employee_siblings, name: "index_employee_siblings_on_employee_id"
remove_index :employee_swipe_cards, name: "index_employee_swipe_cards_on_employee_id"
remove_index :employee_swipe_cards, name: "index_employee_swipe_cards_on_swipe_card_id"
remove_index :employee_working_details, name: "index_employee_working_details_on_employee_id"
remove_index :endoiphthalmitis_followup_notes, name: "index_endoiphthalmitis_followup_notes_on_encounter_id"
remove_index :endoiphthalmitis_followup_notes, name: "index_endoiphthalmitis_followup_notes_on_patient_id"
remove_index :endophthalmitis_management_details, name: "index_endophthalmitis_management_details_on_encounter_id"
remove_index :endophthalmitis_management_details, name: "index_endophthalmitis_management_details_on_patient_id"
remove_index :equipments, name: "index_equipments_on_asset_id"
remove_index :equipments, name: "index_equipments_on_item_id"
remove_index :form_used, name: "index_form_used_on_form_id"
remove_index :form_used, name: "index_form_used_on_user_id"
remove_index :formula_masters, name: "index_formula_masters_on_allowance_deduction_id"
remove_index :formula_masters, name: "index_formula_masters_on_salary_type_id"
remove_index :frequently_used_forms, name: "index_frequently_used_forms_on_form_master_id"
remove_index :frequently_used_forms, name: "index_frequently_used_forms_on_user_id"
remove_index :general_allergies, name: "index_general_allergies_on_general_proforma_id"
remove_index :general_allergies, name: "index_general_allergies_on_history_id"
remove_index :general_asso_decreasedvisions, name: "index_general_asso_decreasedvisions_on_general_proforma_id"
remove_index :general_medication_histories, name: "index_general_medication_histories_on_general_proforma_id"
remove_index :general_medication_histories, name: "index_general_medication_histories_on_history_id"
remove_index :general_medications, name: "index_general_medications_on_general_proforma_id"
remove_index :general_medicine_prescriptions, name: "index_general_medicine_prescriptions_on_general_proforma_id"
remove_index :general_nonophth_surgical_histories, name: "index_general_nonophth_surgical_histories_on_general_proforma_i"
remove_index :general_nonophth_surgical_histories, name: "index_general_nonophth_surgical_histories_on_history_id"
remove_index :general_ocular_injections, name: "index_general_ocular_injections_on_general_proforma_id"
remove_index :general_ocular_injections, name: "index_general_ocular_injections_on_history_id"
remove_index :general_past_medical_diseases, name: "index_general_past_medical_diseases_on_general_proforma_id"
remove_index :general_past_medical_diseases, name: "index_general_past_medical_diseases_on_history_id"
remove_index :general_past_ocular_diseases, name: "index_general_past_ocular_diseases_on_general_proforma_id"
remove_index :general_past_ocular_diseases, name: "index_general_past_ocular_diseases_on_history_id"
remove_index :general_proformas_bak, name: "index_general_proformas_bak_on_episode_id"
remove_index :general_proformas_bak, name: "index_general_proformas_bak_on_patient_id"
remove_index :general_proformas, name: "index_general_proformas_on_encounter_id"
remove_index :general_proformas, name: "index_general_proformas_on_patient_id"
remove_index :general_surgical_histories, name: "index_general_surgical_histories_on_general_proforma_id"
remove_index :general_surgical_histories, name: "index_general_surgical_histories_on_history_id"
remove_index :histories, name: "index_histories_on_encounter_id"
remove_index :histories, name: "index_histories_on_patient_id"
remove_index :hiv_aids_proformas, name: "index_hiv_aids_proformas_on_encounter_id"
remove_index :hiv_aids_proformas, name: "index_hiv_aids_proformas_on_patient_id"
remove_index :holter_reports, name: "index_holter_reports_on_encounter_id"
remove_index :holter_reports, name: "index_holter_reports_on_patient_id"
remove_index :immunization_schedules, name: "index_immunization_schedules_on_encounter_id"
remove_index :duty_rosters, name: "index_in_clinic_id"
remove_index :inpatient_details, name: "index_inpatient_details_on_admit_clinician_id"
remove_index :inpatient_details, name: "index_inpatient_details_on_consult_clinician_id"
remove_index :inpatient_details, name: "index_inpatient_details_on_corporate_id"
remove_index :intraocular_pressures, name: "index_intraocular_pressures_on_cornea_proforma_id"
remove_index :intraocular_pressures, name: "index_intraocular_pressures_on_general_proforma_id"
remove_index :intravenous_antibiotics_measures, name: "index_intravenous_antibiotics_measures_on_endophthalmitis_manag"
remove_index :intravireal_ganciclovir_contents, name: "index_intravireal_ganciclovir_contents_on_cytome_retinitis_prof"
remove_index :inventory_statuses, name: "index_inventory_statuses_on_inventory_head_id"
remove_index :inventory_statuses, name: "index_inventory_statuses_on_item_with_detail_id"
remove_index :inv_tran_details, name: "index_inventory_transaction_details_on_inventory_transaction_id"
remove_index :inv_tran_details, name: "index_inventory_transaction_details_on_item_with_detail_id"
remove_index :inventory_transactions, name: "index_inventory_transactions_on_from_inventory_head_id"
remove_index :inventory_transactions, name: "index_inventory_transactions_on_to_inventory_head_id"
remove_index :invoice_details, name: "index_invoice_details_on_invoice_id"
remove_index :invoice_details, name: "index_invoice_details_on_item_id"
remove_index :invoice_details, name: "index_invoice_details_on_tax_profile_id"
remove_index :invoices, name: "index_invoices_on_purchase_order_id"
remove_index :ip_supplementary_bills, name: "index_ip_supplementary_bills_on_inpatient_detail_id"
remove_index :item_stock_statuses, name: "index_iss_on_date"
remove_index :item_stock_statuses, name: "index_iss_on_inventory_head_id"
remove_index :item_stock_statuses, name: "index_iss_on_item_with_detail_id"
remove_index :item_indent_details, name: "index_item_indent_details_on_item_id"
remove_index :item_indent_details, name: "index_item_indent_details_on_item_indent_id"
remove_index :item_indent_details, name: "index_item_indent_details_on_item_unit_denomination_id"
remove_index :item_indents, name: "index_item_indents_on_from_inventory_head_id"
remove_index :item_indents, name: "index_item_indents_on_to_inventory_head_id"
remove_index :item_tax_profiles, name: "index_item_tax_profiles_on_buying_tax_profile_id"
remove_index :item_tax_profiles, name: "index_item_tax_profiles_on_item_id"
remove_index :item_tax_profiles, name: "index_item_tax_profiles_on_selling_tax_profile_id"
remove_index :item_with_details, name: "index_item_with_details_on_item_id"
remove_index :item_with_details, name: "index_item_with_details_on_manufacturer_id"
remove_index :item_with_details, name: "index_item_with_details_on_tax_profile_id"
remove_index :lab_entitles, name: "index_lab_entitles_on_lab_head_id"
remove_index :lab_entitles, name: "index_lab_entitles_on_user_id"
remove_index :lab_package_tests, name: "index_lab_package_tests_on_lab_package_id"
remove_index :lab_package_tests, name: "index_lab_package_tests_on_lab_test_id"
remove_index :lab_test_fields, name: "index_lab_test_fields_on_lab_test_id"
remove_index :lab_test_rates, name: "index_lab_test_rates_on_lab_test_id"
remove_index :lab_test_reference_values, name: "index_lab_test_reference_values_on_region_id"
remove_index :lab_test_reference_values, name: "index_lab_test_reference_values_on_service_unit_id"
remove_index :lab_test_request_details, name: "index_lab_test_request_details_on_lab_test_request_id"
remove_index :lab_test_request_details, name: "index_lab_test_request_details_on_service_id"
remove_index :lab_test_request_details, name: "index_lab_test_request_details_on_specimen_collected_date_time"
remove_index :lab_test_requests, name: "index_lab_test_requests_on_patient_id"
remove_index :lab_test_requests, name: "index_lab_test_requests_on_request_date"
remove_index :lab_test_requests, name: "index_lab_test_requests_on_visit_id"
remove_index :lab_test_results, name: "index_lab_test_results_on_lab_test_request_detail_id"
remove_index :lab_test_results, name: "index_lab_test_results_on_service_unit_id"
remove_index :lab_test_specimens, name: "index_lab_test_specimens_on_collected_time"
remove_index :lab_test_specimens, name: "index_lab_test_specimens_on_lab_test_request_detail_id"
remove_index :lab_test_specimens, name: "index_lab_test_specimens_on_specimen_number"
remove_index :lab_tests, name: "index_lab_tests_on_lab_category_id"
remove_index :lab_tests, name: "index_lab_tests_on_lab_test_mode_id"
remove_index :lasik_pre_proformas, name: "index_lasik_pre_proformas_on_encounter_id"
remove_index :lasik_pre_proformas, name: "index_lasik_pre_proformas_on_patient_id"
remove_index :lasik_proformas, name: "index_lasik_proformas_on_encounter_id"
remove_index :lasik_proformas, name: "index_lasik_proformas_on_patient_id"
remove_index :leave_profile_details, name: "index_leave_profile_details_on_leave_type_id"
remove_index :macular_cnvm_proformas, name: "index_macular_cnvm_proformas_on_current_diagnosis_idiopathic_cn"
remove_index :macular_cnvm_proformas, name: "index_macular_cnvm_proformas_on_current_diagnosis_idiopathic_po"
remove_index :macular_cnvm_proformas, name: "index_macular_cnvm_proformas_on_patient_id"
remove_index :macular_concomitant_treatments, name: "index_macular_concomitant_treatments_on_macular_cnvm_proforma_i"
remove_index :macular_eye_drops, name: "index_macular_eye_drops_on_macular_cnvm_proforma_id"
remove_index :macular_intraocular_pressures, name: "index_macular_intraocular_pressures_on_macular_cnvm_proforma_id"
remove_index :macular_tablets, name: "index_macular_tablets_on_macular_cnvm_proforma_id"
remove_index :mail_details, name: "index_mail_details_on_from_user_id"
remove_index :mail_details, name: "index_mail_details_on_to_user_id"
remove_index :mis_register_equipments, name: "index_mis_register_equipments_on_activity_id"
remove_index :mis_register_equipments, name: "index_mis_register_equipments_on_bloodbank_detail_id"
remove_index :mris, name: "index_mris_on_patient_id"
remove_index :duty_rosters, name: "index_name_stationid"
remove_index :neurophthal_proformas, name: "index_neurophthal_proformas_on_patient_id"
remove_index :next_kin_details, name: "index_next_kin_details_on_patient_id"
remove_index :next_kin_details, name: "index_next_kin_details_on_relation_id"
remove_index :nurse_charts, name: "index_nurse_charts_on_patient_id"
remove_index :nurse_prescriptions, name: "index_nurse_prescriptions_on_item_id"
remove_index :nurse_prescriptions, name: "index_nurse_prescriptions_on_prescription_master_id"
remove_index :nurse_tasks, name: "index_nurse_tasks_on_bed_id"
remove_index :obstetric_ultrasounds, name: "index_obstetric_ultrasounds_on_encounter_id"
remove_index :obstetric_ultrasounds, name: "index_obstetric_ultrasounds_on_patient_id"
remove_index :oculoplasty_anolphthal_proformas, name: "index_oculoplasty_anolphthal_proformas_on_patient_id"
remove_index :oculoplasty_ectropion_proformas, name: "index_oculoplasty_ectropion_proformas_on_patient_id"
remove_index :oculoplasty_entropion_proformas, name: "index_oculoplasty_entropion_proformas_on_patient_id"
remove_index :oculoplasty_epiphora_proformas, name: "index_oculoplasty_epiphora_proformas_on_patient_id"
remove_index :oculoplasty_lagophthal_proformas, name: "index_oculoplasty_lagophthal_proformas_on_patient_id"
remove_index :oculoplasty_orbit_proformas, name: "index_oculoplasty_orbit_proformas_on_patient_id"
remove_index :oculoplasty_post_ptosis_proformas, name: "index_oculoplasty_post_ptosis_proformas_on_patient_id"
remove_index :oculoplasty_ptosis_proformas, name: "index_oculoplasty_ptosis_proformas_on_patient_id"
remove_index :oculoplasty_thyroid_proformas, name: "index_oculoplasty_thyroid_proformas_on_patient_id"
remove_index :on_call_doctors, name: "index_on_call_doctors_on_department_id"
remove_index :on_call_doctors, name: "index_on_call_doctors_on_location_id"
remove_index :operative_procedures, name: "index_operative_procedures_on_encounter_id"
remove_index :operative_procedures, name: "index_operative_procedures_on_patient_id"
remove_index :operative_procedures, name: "index_operative_procedures_on_surgery_schedules_id"
remove_index :ophth_photography_requisition_forms, name: "index_ophth_photography_requisition_forms_on_encounter_id"
remove_index :ophth_photography_requisition_forms, name: "index_ophth_photography_requisition_forms_on_patient_id"
remove_index :optometric_evaluations, name: "index_optometric_evaluations_on_patient_id"
remove_index :oral_antibiotics, name: "index_oral_antibiotics_on_endophthalmitis_management_detail_id"
remove_index :order_diets, name: "index_order_diets_on_patient_id"
remove_index :other_expenses, name: "index_other_expenses_on_voucher_type_id"
remove_index :patient_consent_forms, name: "index_patient_consent_forms_on_encounter_id"
remove_index :patient_deposits, name: "index_patient_deposits_on_bill_category_id"
remove_index :patient_deposits, name: "index_patient_deposits_on_corporate_id"
remove_index :patient_documents, name: "index_patient_documents_on_encounter_id"
remove_index :patient_forms, name: "index_patient_forms_on_encounter_id"
remove_index :patient_forms, name: "index_patient_forms_on_patient_form_id"
remove_index :patient_forms, name: "index_patient_forms_on_user_id"
remove_index :pediatric_cataract_examinations, name: "index_pediatric_cataract_examinations_on_patient_id"
remove_index :pediatric_catract_operative_notes, name: "index_pediatric_catract_operative_notes_on_encounter_id"
remove_index :pediatric_catract_operative_notes, name: "index_pediatric_catract_operative_notes_on_patient_id"
remove_index :pelvic_scans, name: "index_pelvic_scans_on_patient_id"
remove_index :duty_rosters, name: "index_personnel_id"
remove_index :pharmacy_mappings, name: "index_pharmacy_mappings_on_cashier_id"
remove_index :pharmacy_mappings, name: "index_pharmacy_mappings_on_pharmacy_id"
remove_index :physical_examinations, name: "index_physical_examinations_on_encounter_id"
remove_index :purchase_indents, name: "index_pi_on_inventory_head_id"
remove_index :purchase_indents, name: "index_pi_on_pi_date"
remove_index :purchase_indent_details, name: "index_pid_on_item_id"
remove_index :purchase_indent_details, name: "index_pid_on_purchase_indent_id"
remove_index :post_operative_courses, name: "index_post_operative_courses_on_patient_id"
remove_index :pregnancy_calculators, name: "index_pregnancy_calculators_on_patient_id"
remove_index :prescription_masters, name: "index_prescription_masters_on_clinician_id"
remove_index :prescription_masters, name: "index_prescription_masters_on_patient_id"
remove_index :prescription_masters, name: "index_prescription_masters_on_visit_id"
remove_index :present_illnesses, name: "index_present_illnesses_on_encounter_id"
remove_index :present_illnesses, name: "index_present_illnesses_on_patient_id"
remove_index :prior_treatments, name: "index_prior_treatments_on_patient_id"
remove_index :prior_treatments, name: "index_prior_treatments_on_uveitis_proforma_id"
remove_index :procedure_details, name: "index_procedure_details_on_package_id"
remove_index :procedure_details, name: "index_procedure_details_on_patient_account_id"
remove_index :procedure_details, name: "index_procedure_details_on_patient_id"
remove_index :procedure_details, name: "index_procedure_details_on_type_id"
remove_index :procedure_preparations, name: "index_procedure_preparations_on_inpatient_detail_id"
remove_index :protocol_samples, name: "index_protocol_samples_on_protocol_detail_id"
remove_index :ptca_stent_reports, name: "index_ptca_stent_reports_on_encounter_id"
remove_index :ptca_stent_reports, name: "index_ptca_stent_reports_on_patient_id"
remove_index :purchase_order_details, name: "index_purchase_order_details_on_item_id"
remove_index :purchase_order_details, name: "index_purchase_order_details_on_item_unit_denomination_id"
remove_index :purchase_order_details, name: "index_purchase_order_details_on_purchase_order_id"
remove_index :purchase_order_details, name: "index_purchase_order_details_on_tax_profile_id"
remove_index :purchase_order_free_items, name: "index_purchase_order_free_items_on_item_id"
remove_index :purchase_order_free_items, name: "index_purchase_order_free_items_on_item_unit_denomination_id"
remove_index :purchase_order_free_items, name: "index_purchase_order_free_items_on_purchase_order_detail_id"
remove_index :purchase_orders, name: "index_purchase_orders_on_inventory_head_id"
remove_index :purchase_orders, name: "index_purchase_orders_on_supplier_id"
remove_index :rate_contract_details, name: "index_rate_contract_details_on_free_item_id"
remove_index :rate_contract_details, name: "index_rate_contract_details_on_free_item_unit_denomination_id"
remove_index :rate_contract_details, name: "index_rate_contract_details_on_item_id"
remove_index :rate_contract_details, name: "index_rate_contract_details_on_item_unit_denomination_id"
remove_index :rate_contract_details, name: "index_rate_contract_details_on_rate_contract_id"
remove_index :rate_contract_details, name: "index_rate_contract_details_on_tax_profile_id"
remove_index :rate_contracts, name: "index_rate_contracts_on_supplier_id"
remove_index :reaction_signs, name: "index_reaction_signs_on_blood_bag_id"
remove_index :reaction_signs, name: "index_reaction_signs_on_recipient_condition_id"
remove_index :reaction_signs, name: "index_reaction_signs_on_recipient_detail_id"
remove_index :reaction_symptoms, name: "index_reaction_symptoms_on_blood_bag_id"
remove_index :reaction_symptoms, name: "index_reaction_symptoms_on_recipient_condition_id"
remove_index :reaction_symptoms, name: "index_reaction_symptoms_on_recipient_detail_id"
remove_index :reagent_quality_controls, name: "index_reagent_quality_controls_on_bloodbank_id"
remove_index :reagent_quality_controls, name: "index_reagent_quality_controls_on_reagent_master_id"
remove_index :recipient_adverse_reactions, name: "index_recipient_adverse_reactions_on_blood_bag_id"
remove_index :recipient_adverse_reactions, name: "index_recipient_adverse_reactions_on_recipient_detail_id"
remove_index :recipient_adverse_reactions, name: "index_recipient_adverse_reactions_on_sign_id_obsolete"
remove_index :recipient_adverse_reactions, name: "index_recipient_adverse_reactions_on_symptom_id_obsolete"
remove_index :recipient_component_details, name: "index_recipient_component_details_on_blood_bank_component_maste"
remove_index :recipient_component_details, name: "index_recipient_component_details_on_recipient_detail_id"
remove_index :recipient_details, name: "index_recipient_details_on_blood_bank_hospital_list_id"
remove_index :recipient_details, name: "index_recipient_details_on_city_id"
remove_index :rejected_bloodbag_details, name: "index_rejected_bloodbag_details_on_blood_bag_id"
remove_index :rejected_bloodbag_details, name: "index_rejected_bloodbag_details_on_protocol_detail_id"
remove_index :repair_services, name: "index_repair_services_on_breakdown_id"
remove_index :repair_services, name: "index_repair_services_on_equipment_id"
remove_index :repair_services, name: "index_repair_services_on_scheduled_service_id"
remove_index :repair_services, name: "index_repair_services_on_supplier_id"
remove_index :repair_services, name: "index_repair_services_on_warranty_amc_id"
remove_index :repair_visits, name: "index_repair_visits_on_repair_service_id"
remove_index :report_op_ip_outstandings, name: "index_report_op_ip_outstandings_on_bill_category_id"
remove_index :report_op_ip_outstandings, name: "index_report_op_ip_outstandings_on_bill_date"
remove_index :report_op_ip_outstandings, name: "index_report_op_ip_outstandings_on_bill_no"
remove_index :report_op_ip_outstandings, name: "index_report_op_ip_outstandings_on_corporate_id"
remove_index :report_op_ip_outstandings, name: "index_report_op_ip_outstandings_on_patient_id"
remove_index :retina_proformas, name: "index_retina_proformas_on_patient_id"
remove_index :review_of_systems, name: "index_review_of_systems_on_encounter_id"
remove_index :rooms, name: "index_rooms_on_floor_id"
remove_index :schedulable_entity_appointments, name: "index_schedulable_entity_appointments_on_appointment_id"
remove_index :schedulable_entity_appointments, name: "index_schedulable_entity_appointments_on_schedulable_entity_id"
remove_index :scheduled_services, name: "index_scheduled_services_on_equipment_id"
remove_index :scheduled_services, name: "index_scheduled_services_on_supplier_id"
remove_index :scleritis_episcleritis_proformas, name: "index_scleritis_episcleritis_proformas_on_encounter_id"
remove_index :scleritis_prior_consultations, name: "index_scleritis_prior_consultations_on_scleritis_episcleritis_p"
remove_index :screened_bags, name: "index_screened_bags_on_blood_bag_id"
remove_index :screened_bags, name: "index_screened_bags_on_protocol_detail_id"
remove_index :serology_alls, name: "index_serology_alls_on_donrec_id"
remove_index :serology_alls, name: "index_serology_alls_on_reci_donor_id"
remove_index :service_rates, name: "index_service_rates_on_corporate_id"
remove_index :service_rates, name: "index_service_rates_on_luxury_type_id"
remove_index :service_rates, name: "index_service_rates_on_ward_id"
remove_index :service_types, name: "index_service_types_on_corporate_id"
remove_index :services_blood_components, name: "index_services_blood_components_on_location_id"
remove_index :shift_definitions, name: "index_shift_definitions_on_shift_timing_id"
remove_index :single_receipt_details, name: "index_single_receipt_details_on_approved_transaction_id"
remove_index :single_receipt_details, name: "index_single_receipt_details_on_patient_account_id"
remove_index :station_units, name: "index_station_units_on_station_id"
remove_index :stock_and_issues, name: "index_stock_and_issues_on_bloodbank_detail_id_obsolete"
remove_index :stock_and_issues, name: "index_stock_and_issues_on_item_id_obsolete"
remove_index :store_entitles, name: "index_store_entitles_on_inventory_head_id"
remove_index :store_entitles, name: "index_store_entitles_on_user_id"
remove_index :sub_procedures, name: "index_sub_procedures_on_procedure_id"
remove_index :suppliers, name: "index_suppliers_on_email_id"
remove_index :suppliers, name: "index_suppliers_on_inventory_head_id"
remove_index :suppliers, name: "index_suppliers_on_supplier_type_id"
remove_index :supportive_treatments, name: "index_supportive_treatments_on_endophthalmitis_management_detai"
remove_index :surgery_pack_details, name: "index_surgical_package_items_on_item_id"
remove_index :surgery_pack_details, name: "index_surgical_package_items_on_surgery_pack_id"
remove_index :surgical_procedures, name: "index_surgical_procedures_on_surgery_type_id"
remove_index :tax_rules, name: "index_tax_rules_on_general_account_id"
remove_index :tax_rules, name: "index_tax_rules_on_tax_profile_id"
remove_index :temperature_records, name: "index_temperature_records_on_equipment_id"
remove_index :temps, name: "index_temps_on_column"
remove_index :temps, name: "index_temps_on_ppp_id"
remove_index :temps, name: "index_temps_on_table"
remove_index :text_datas, name: "index_text_datas_on_diagram_id"
remove_index :track_assets, name: "index_track_assets_on_asset_id"
remove_index :track_assets, name: "index_track_assets_on_inventory_head_id"
remove_index :transadverse_data_preposts, name: "index_transadverse_data_preposts_on_blood_bag_id"
remove_index :transadverse_data_preposts, name: "index_transadverse_data_preposts_on_recipient_detail_id"
remove_index :trauma_proformas, name: "index_trauma_proformas_on_patient_id"
remove_index :uveitis_proformas, name: "index_uveitis_proformas_on_patient_id"
remove_index :vital_signs, name: "index_vital_signs_on_patient_id"
remove_index :vitreoretina_medication_drugs, name: "index_vitreoretina_medication_drugs_on_vitreoretina_proforma_id"
remove_index :vitreoretina_ocular_injections, name: "index_vitreoretina_ocular_injections_on_vitreoretina_proforma_i"
remove_index :vitreoretina_proformas, name: "index_vitreoretina_proformas_on_encounter_id"
remove_index :vitreoretina_proformas, name: "index_vitreoretina_proformas_on_patient_id"
remove_index :vitreous_surgery_reports, name: "index_vitreous_surgery_reports_on_patient_id"
remove_index :warranty_amcs, name: "index_warranty_amcs_on_equipment_id"
remove_index :warranty_amcs, name: "index_warranty_amcs_on_supplier_id"
remove_index :write_off_details, name: "index_write_off_details_on_bill_date"
remove_index :inventory_transactions, name: "inventory_transactions_reference2_from_inventory_head_id_idx"
remove_index :inventory_transactions, name: "inventory_transactions_reference2_to_inventory_head_id_idx"
remove_index :employee_appraisals, name: "kra_employee_id"
remove_index :employee_appraisal_details, name: "kra_list_id"
remove_index :lab_report_remarks, name: "lab_predefined_remark_id"
remove_index :lab_report_remarks, name: "lab_test_request_id"
remove_index :employee_mispunch_details, name: "mispunch_employee_id"
remove_index :employee_mispunch_details, name: "mispunch_shift_timing_id"
remove_index :employee_no_dues, name: "no_dues_employee_separation_id"
remove_index :nurse_tasks, name: "nt_patient_status_bed"
remove_index :on_call_doctors, name: "ocd_employee_depart_date"
remove_index :order_diets, name: "od_pateint_diet_date"
remove_index :order_prescriptions, name: "order_prescriptions_encounter_id_idx"
remove_index :patient_order_set_details, name: "patient_order_set_details_patient_order_set_id_idx"
remove_index :patient_order_sets, name: "patient_order_sets_encounter_id_idx"
remove_index :patient_referal_details, name: "patient_referal_details_encounter_id_idx"
remove_index :payslips, name: "payslip_employee_date"
remove_index :personal_histories, name: "personal_histories_patient_id_idx"
remove_index :prescription_masters, name: "prescription_masters_encounter_id_idx"
remove_index :procedure_details, name: "proce_date_patient"
remove_index :provisional_diagnoses, name: "provisional_diagnoses_patient_id_idx"
remove_index :employee_salary_details, name: "salary_detail_employee_id"
remove_index :salary_calculations, name: "sc_date_employee"
remove_index :service_rates, name: "ser_service_corporate"
remove_index :lab_report_remarks, name: "service_group_id"
remove_index :lab_report_templates, name: "service_id"
remove_index :lab_test_request_details, name: "service_request_detail_id"
remove_index :employee_shift_change_details, name: "shift_change_duty_roster_id"
remove_index :employee_shift_change_details, name: "shift_change_personnel_id"
remove_index :shift_definitions, name: "shift_employee"
remove_index :single_receipt_details, name: "single_date_corpor"
remove_index :single_receipt_details, name: "single_trans_patient"
remove_index :snapshot_content_details, name: "snapshot_content_details_snapshot_content_type_idx"
remove_index :social_histories, name: "social_histories_patient_id_idx"
remove_index :employee_warning_letters, name: "warning_details_employee_id"