Space

rails generate migration remove_unused_indexes

And paste

remove_index :item_reorder_levels, name: "item_reorder_levels_item_id_inventory_head_id_idx"
remove_index :item_reorder_levels, name: "index_item_reorder_levels_on_inventory_head_id"
remove_index :item_reorder_levels, name: "index_item_reorder_levels_on_item_unit_denomination_id"
remove_index :icd10_codes, name: "icd10_codes_icd_name_idx"
remove_index :user_clicks, name: "idx_user_clicks_created_at_date"
remove_index :audit_details, name: "index_audit_details_on_audit_id"
remove_index :service_rate_corporates, name: "index_service_rate_corporates_on_service_id"
remove_index :cpt4_codes, name: "cpt4_codes_display_idx"
remove_index :generic_names, name: "generic_names_name_idx"
remove_index :items_suppliers, name: "index_items_suppliers_on_item_id"
remove_index :services, name: "index_services_on_name"
remove_index :scanning_consent_forms, name: "scanning_consent_forms_patient_id_idx"
remove_index :account_services_mappings, name: "index_account_mapping_on_service_id"
remove_index :items_suppliers, name: "index_items_suppliers_on_supplier_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 :service_rate_corporates, name: "service_rate_corporates_location_id_idx"
remove_index :lovs_details, name: "lovs_details_lovs_name_id_idx"
remove_index :address_details, name: "addresable_id"
remove_index :menu_contexts_menu_lists, name: "menu_contexts_menu_lists_valid_patient_parent_id_status_idx"
remove_index :menu_contexts_menu_lists, name: "menu_contexts_menu_lists_menu_context_id_link_type_status_idx"
remove_index :menu_contexts_menu_lists, name: "index_menu_contexts_menu_lists_on_parent_id"
remove_index :risks_alerts, name: "risks_alerts_patient_id_idx"
remove_index :audits, name: "index_audits_on_created_at"
remove_index :snapshots, name: "snapshots_encounter_id_idx"
remove_index :visits, name: "index_visits_on_created_at"
remove_index :items, name: "items_name_idx"
remove_index :menu_contexts_menu_lists, name: "index_menu_contexts_menu_lists_on_position"
remove_index :menu_contexts_menu_lists, name: "index_menu_contexts_menu_lists_on_status"
remove_index :menu_contexts_menu_lists, name: "index_menu_contexts_menu_lists_on_link_type"
remove_index :opd_card_prescription_details, name: "opd_card_prescription_details_opd_card_prescription_id_idx"
remove_index :audits, name: "audits_enity_index"
remove_index :services, name: "services_service_group_id_idx"
remove_index :controller_actions, name: "controller_actions_action_name_idx"
remove_index :visits, name: "index_visits_on_patient_id"
remove_index :visits, name: "index_visits_on_patient_type"
remove_index :visits, name: "index_visits_on_visit_date"
remove_index :account_services_mappings, name: "index_account_mapping_on_general_account_id"
remove_index :visits, name: "index_visits_on_bill_category_id"
remove_index :visits, name: "index_visits_on_location_id"
remove_index :opd_card_prescriptions, name: "opd_card_prescriptions_encounter_id_idx"
remove_index :account_services_mappings, name: "index_account_mapping_on_location_id"
remove_index :audits, name: "index_audits_on_entity_id"
remove_index :address_details, name: "city"
remove_index :address_details, name: "country"
remove_index :address_details, name: "index_address_details_on_addressable_type"
remove_index :visits, name: "index_visits_on_user_id"
remove_index :login_details, name: "login_details_user_id_idx"
remove_index :address_details, name: "state"
remove_index :address_details, name: "index_address_details_on_reference_1"
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_station_id"
remove_index :action_groups_menu_contexts, name: "action_groups_menu_contexts_action_group_id_idx"
remove_index :doctor_weekly_schedules, name: "doctor_weekly_schedules_duty_roster_id_idx"
remove_index :patient_order_set_details, name: "patient_order_set_details_patient_order_set_id_idx"
remove_index :visits, name: "index_visits_on_counter_id"
remove_index :visits, name: "index_visits_on_mrd_status"
remove_index :visits, name: "index_visits_on_referrel_letter_no"
remove_index :patients, name: "patient_extid_date"
remove_index :visits, name: "index_visits_on_employee_id"
remove_index :audits, name: "audit_created_by_index"
remove_index :item_unit_denominations, name: "index_item_unit_denominations_on_item_id"
remove_index :medication_masters, name: "medication_masters_medicine_name_idx"
remove_index :patient_order_sets, name: "patient_order_sets_encounter_id_idx"
remove_index :snapshot_content_details, name: "snapshot_content_details_snapshot_content_type_idx"
remove_index :controller_actions, name: "controller_actions_controller_path_idx"
remove_index :encounters, name: "index_encounters_on_updated_at"
remove_index :patients, name: "patients_extid_idx"
remove_index :encounters, name: "index_encounters_on_visit_id"
remove_index :appointment_details, name: "index_on_appointment_id"
remove_index :schedulable_entities, name: "index_schedulable_entities_on_schedulable_element_id"
remove_index :service_groups_stations, name: "index_service_groups_stations_on_station_id"
remove_index :service_request_details, name: "index_service_request_details_on_service_request_id"
remove_index :items, name: "items_generic_name_id_idx"
remove_index :transaction_details, name: "trans_date_narration"
remove_index :service_groups_stations, name: "index_service_groups_stations_on_service_group_id"
remove_index :encounters, name: "index_encounters_on_patient_id"
remove_index :appointment_details, name: "index_on_scheduable_entity_id"
remove_index :controller_actions, name: "controller_actions_is_browser_page_idx"
remove_index :controller_actions, name: "controller_actions_page_id_idx"
remove_index :controller_actions, name: "controller_actions_page_name_idx"
remove_index :bill_details, name: "index_bill_details_on_amount"
remove_index :bill_details, name: "index_bill_details_on_net_amount"
remove_index :lab_test_reference_values, name: "index_lab_test_reference_values_on_service_unit_id"
remove_index :service_requests, name: "index_service_requests_on_visit_id"
remove_index :bills, name: "pa_narration_date_patient"
remove_index :transaction_details, name: "trans_debit"
remove_index :corporate_service_groups, name: "corporate_service_groups_corporate_id_service_group_id_is_o_idx"
remove_index :items, name: "fki_items_item_subtype_id"
remove_index :general_accounts, name: "general_accounts_location_id_account_type_idx"
remove_index :menu_lists, name: "index_menu_lists_on_action_group_id"
remove_index :service_request_details, name: "index_service_request_details_on_service_id"
remove_index :discharge_intimations, name: "discharge_intimations_visit_id_idx"
remove_index :bill_details, name: "index_bill_details_on_service_request_detail_id"
remove_index :general_accounts, name: "index_general_accounts_on_external_account_id"
remove_index :service_requests, name: "index_service_requests_on_patient_id"
remove_index :transaction_details, name: "trans_visit_extid"
remove_index :coma_scales, name: "coma_scales_patient_id_idx"
remove_index :day_care_assessments, name: "day_care_assessments_patient_id_idx"
remove_index :doctor_timings, name: "doctor_timings_duty_roster_id_idx"
remove_index :bill_details, name: "idx_bill_id"
remove_index :bill_details, name: "index_bill_details_on_corporate_covered_amount"
remove_index :bill_details, name: "index_bill_details_on_discount_amount"
remove_index :station_units, name: "index_station_units_on_station_id"
remove_index :uploaded_documents, name: "ix_file_path"
remove_index :personnels, name: "personnels_is_consultant_first_name_idx"
remove_index :transaction_details, name: "trans_credit"
remove_index :bill_details, name: "bill_details_narration_idx"
remove_index :bills, name: "bills_created_at_idx"
remove_index :comorbidities, name: "comorbidities_encounter_id_idx"
remove_index :personnel_bank_details, name: "employee_salary_type"
remove_index :items, name: "fki_items_dispensing_unit_id"
remove_index :appointments, name: "fki_pat"
remove_index :roles_users, name: "fki_user_role"
remove_index :employees, name: "index_employees_on_personnel_id"
remove_index :extids, name: "index_extids_on_updated_at"
remove_index :item_unit_denominations, name: "index_item_unit_denominations_on_item_unit_id"
remove_index :item_unit_denominations, name: "index_item_unit_denominations_on_quantity"
remove_index :items, name: "index_name_item_staus"
remove_index :schedulable_entities, name: "index_schedulable_entities_on_clinician_id"
remove_index :schedulable_entities, name: "index_schedulable_entities_on_equipment_id"
remove_index :io_chartings, name: "io_chartings_patient_id_idx"
remove_index :bills, name: "pa_corporate_status_visit"
remove_index :patient_assessment_forms, name: "patient_assessment_forms_encounter_id_idx"
remove_index :users, name: "users_name_idx"
remove_index :roles_users, name: "fki_role"
remove_index :bill_details, name: "idx_service_id"
remove_index :appointments, name: "index_app_start_end_date_time"
remove_index :bills, name: "index_bills_on_sevice_request_id"
remove_index :bills, name: "index_bills_on_visit_id"
remove_index :employee_passport_driving_details, name: "index_employee_passport_driving_details_on_employee_id"
remove_index :encounters, name: "index_encounters_on_updated_by"
remove_index :extids, name: "index_extids_on_current_value"
remove_index :inventory_heads, name: "index_inventory_heads_on_name"
remove_index :menu_lists, name: "index_menu_lists_on_notification_name"
remove_index :roles, name: "index_roles_on_name"
remove_index :transaction_details, name: "index_transaction_details_on_created_by"
remove_index :patients, name: "patient_category"
remove_index :patients, name: "relogion_id"
remove_index :appointments, name: "appointment_time"
remove_index :patients, name: "blood_group_id"
remove_index :employees, name: "e_depart_design"
remove_index :employee_leave_balances, name: "elb_employee_leave"
remove_index :eye_part_examinations, name: "eye_part_examinations_status"
remove_index :patients, name: "fki_photograph_id"
remove_index :roles_users, name: "fki_sub_role"
remove_index :bed_allocations, name: "index_bed_allocations_on_station_unit_id"
remove_index :bill_details, name: "index_bill_details_on_bill_detail_date"
remove_index :bill_details, name: "index_bill_details_on_line_item_type"
remove_index :bill_details, name: "index_bill_details_on_reference_1"
remove_index :bill_journals, name: "index_bill_journals_on_bill_id"
remove_index :bills, name: "index_bills_on_patient_id"
remove_index :employees, name: "index_employees_on_designation_id"
remove_index :extids, name: "index_extids_on_current_reset_value"
remove_index :extids, name: "index_extids_on_lock_version"
remove_index :extids, name: "index_extids_on_narration"
remove_index :lab_test_reference_values, name: "index_lab_test_reference_values_on_region_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_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 :patients, name: "index_patients_on_title_id"
remove_index :service_requests, name: "index_service_requests_on_location_id"
remove_index :transaction_details, name: "index_transaction_details_on_location_id"
remove_index :uploaded_documents, name: "ix_created_at"
remove_index :uploaded_documents, name: "ix_document_id"
remove_index :uploaded_documents, name: "ix_updated_at"
remove_index :menu_contexts, name: "menu_contexts_role_id_idx"
remove_index :lab_test_request_details, name: "service_request_detail_id"
remove_index :employee_transfer_details, name: "transfer_employee_id"
remove_index :att_payloadbase, name: "att_payloadbase_break_time_id_022d6fac_like"
remove_index :att_payloadbase, name: "att_payloadbase_overtime_id_0e7be795_like"
remove_index :att_payloadbase, name: "att_payloadbase_uuid_60250467_like"
remove_index :bills, name: "bills_narration_idx"
remove_index :complaints, name: "complaints_encounter_id_idx"
remove_index :employees, name: "e_status"
remove_index :bills, name: "fki_luxurytype_id"
remove_index :cities, name: "fki_state_id"
remove_index :bills, name: "idx_ipsupid"
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 :appointments, name: "index_appointment_criticality"
remove_index :appointments, name: "index_appointments_on_pre_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_inpatient_detail_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_patient_id"
remove_index :bill_details, name: "index_bill_details_on_clinician_id"
remove_index :bill_details, name: "index_bill_details_on_is_cancelled"
remove_index :bill_details, name: "index_bill_details_on_is_original"
remove_index :bill_details, name: "index_bill_details_on_status"
remove_index :bills, name: "index_bills_on_bill_category_id"
remove_index :bills, name: "index_bills_on_clinician_id"
remove_index :bills, name: "index_bills_on_location_id"
remove_index :bills, name: "index_bills_on_package_id"
remove_index :bills, name: "index_bills_on_status"
remove_index :bills, name: "index_bills_on_treatment_id"
remove_index :prescription_masters, name: "index_clinician_id_encounter_id_prescription_time"
remove_index :clinicians, name: "index_clinicians_on_name"
remove_index :clinicians, name: "index_clinicians_on_personnel_id"
remove_index :department_service_groups, name: "index_department_service_groups_on_name"
remove_index :drug_prescription_details, name: "index_drug_prescription_details_on_prescription_master_id"
remove_index :employees, name: "index_employees_on_employee_type_id"
remove_index :employees, name: "index_employees_on_location_id"
remove_index :equipments, name: "index_equipments_on_asset_id"
remove_index :extids, name: "index_extids_on_location_id"
remove_index :inpatient_details, name: "index_inpatient_details_on_admission_time"
remove_index :inpatient_details, name: "index_inpatient_details_on_patient_id"
remove_index :inpatient_details, name: "index_inpatient_details_on_visit_id"
remove_index :inv_tran_details, name: "index_inv_tran_details_on_created_at"
remove_index :inv_tran_details, name: "index_inv_tran_details_on_updated_at"
remove_index :ip_supplementary_bills, name: "index_ip_supplementary_bills_on_inpatient_detail_id"
remove_index :item_subtypes, name: "index_item_subtypes_on_item_type_id"
remove_index :lab_extids, name: "index_lab1_extids_on_current_reset_value"
remove_index :lab_extids, name: "index_lab1_extids_on_updated_at"
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_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 :roles, name: "index_roles_on_created_at"
remove_index :service_groups, name: "index_service_groups_on_name"
remove_index :track_assets, name: "index_track_assets_on_asset_id"
remove_index :nanda_domain_category_codes, name: "n_diagnosis_idx"
remove_index :bills, name: "pa_visit_pack_treat"
remove_index :personnels, name: "personnels_location_id_idx"
remove_index :provisional_diagnoses, name: "provisional_diagnoses_patient_id_idx"
remove_index :lab_test_requests, name: "service_request_id"
remove_index :employee_transfer_details, name: "transfer_department_id"
remove_index :employee_transfer_details, name: "transfer_designation_id"
remove_index :acc_acccombination, name: "acc_acccombination_company_id_700e5a90"
remove_index :acc_accgroups, name: "acc_accgroups_company_id_ac234eff"
remove_index :acc_accprivilege, name: "acc_accprivilege_company_id_8e2fcb81"
remove_index :acc_accprivilege, name: "acc_accprivilege_employee_id_5fc55f95"
remove_index :acc_accprivilege, name: "acc_accprivilege_employee_id_5fc55f95_like"
remove_index :acc_accprivilege, name: "acc_accprivilege_group_id_c5ed7003"
remove_index :acc_acctimezone, name: "acc_acctimezone_company_id_143aa9c1"
remove_index :advance_visits, name: "advance_visits_advance_parent_id_idx"
remove_index :att_attreportsetting, name: "att_attreportsetting_company_id_6be84335"
remove_index :att_attrule, name: "att_attrule_company_id_e4904421"
remove_index :att_attrule, name: "att_attrule_param_name_406bcfb6_like"
remove_index :att_attschedule, name: "att_attschedule_employee_id_caa61686"
remove_index :att_attschedule, name: "att_attschedule_employee_id_caa61686_like"
remove_index :att_attschedule, name: "att_attschedule_shift_id_13d2db9a"
remove_index :att_attshift, name: "att_attshift_company_id_2c0a4f56"
remove_index :att_leavecategory, name: "att_leavecategory_company_id_e8169be2"
remove_index :att_payloadbase, name: "att_payloadbase_emp_id_2c0f6a7b"
remove_index :att_payloadbase, name: "att_payloadbase_emp_id_2c0f6a7b_like"
remove_index :att_payloadbase, name: "att_payloadbase_timetable_id_a389e3d8"
remove_index :att_payloadmulpunchset, name: "att_payloadmulpunchset_emp_id_f47610c8"
remove_index :att_payloadmulpunchset, name: "att_payloadmulpunchset_emp_id_f47610c8_like"
remove_index :att_payloadmulpunchset, name: "att_payloadmulpunchset_timetable_id_9a439a09"
remove_index :att_payloadpunch, name: "att_payloadpunch_emp_id_053da2f0"
remove_index :att_payloadpunch, name: "att_payloadpunch_emp_id_053da2f0_like"
remove_index :att_payloadpunch, name: "att_payloadpunch_orig_id_16b26416"
remove_index :att_payloadpunch, name: "att_payloadpunch_skd_id_17596d82"
remove_index :att_payloadpunch, name: "att_payloadpunch_skd_id_17596d82_like"
remove_index :att_payloadpunch, name: "att_payloadpunch_uuid_91e722f4_like"
remove_index :att_reportparam, name: "att_reportparam_company_id_e1078d08"
remove_index :att_shiftdetail, name: "att_shiftdetail_shift_id_7d694501"
remove_index :att_shiftdetail, name: "att_shiftdetail_time_interval_id_777dde8f"
remove_index :att_timeinterval, name: "att_timeinterval_company_id_9824d651"
remove_index :auth_user, name: "auth_user_id_9fcf16c0_like"
remove_index :auth_user, name: "auth_user_username_6821ab7c_like"
remove_index :authtoken_token, name: "authtoken_token_key_10f0b77e_like"
remove_index :authtoken_token, name: "authtoken_token_user_id_35299eff_like"
remove_index :base_adminlog, name: "base_adminlog_company_id_bc0e756f"
remove_index :base_adminlog, name: "base_adminlog_content_type_id_3e553c30"
remove_index :base_adminlog, name: "base_adminlog_user_id_ecf659f8"
remove_index :base_adminlog, name: "base_adminlog_user_id_ecf659f8_like"
remove_index :base_membership, name: "base_membership_company_id_a76e12ab"
remove_index :base_membership, name: "base_membership_user_id_41d22f2f_like"
remove_index :base_membership, name: "base_membership_vendor_company_id_05daafa1"
remove_index :base_systemsetting, name: "base_systemsetting_company_id_e59b9b82"
remove_index :bed_allocations, name: "bed_allocations_status_idx"
remove_index :bed_categories, name: "bed_categories_name_idx"
remove_index :bed_rate_categories, name: "bed_rate_categories_status_idx"
remove_index :bill_categories, name: "bill_categories_name_idx"
remove_index :clinical_demographics, name: "clinical_demographics_patient_id_encounter_id_idx"
remove_index :corporate_status_details, name: "corporate_transaction"
remove_index :corporates, name: "corporates_name_idx"
remove_index :user_notifications, name: "delete_at_helper_index"
remove_index :django_admin_log, name: "django_admin_log_content_type_id_c4bce8eb"
remove_index :django_admin_log, name: "django_admin_log_user_id_c564eba6"
remove_index :django_admin_log, name: "django_admin_log_user_id_c564eba6_like"
remove_index :duty_rosters, name: "duty_rosters_parent_id_idx"
remove_index :personnel_bank_details, name: "ebd_pf_ot_id"
remove_index :employee_stations, name: "employee_station_employee_id"
remove_index :employee_stations, name: "employee_station_station_id"
remove_index :employee_swipes, name: "eswipe_employee_date"
remove_index :eye_parts, name: "eye_parts_status"
remove_index :family_histories, name: "family_histories_patient_id_idx"
remove_index :vital_signs, name: "fki_inpatient_vital_sign"
remove_index :advance_details, name: "fki_patient"
remove_index :clinicians, name: "fki_type"
remove_index :health_parameters, name: "health_parameters_encounter_id_idx"
remove_index :iclock_biophoto, name: "iclock_biophoto_employee_id_3dba5819"
remove_index :iclock_biophoto, name: "iclock_biophoto_employee_id_3dba5819_like"
remove_index :iclock_deviceconfig, name: "iclock_deviceconfig_company_id_0fec1982"
remove_index :iclock_deviceconfig, name: "iclock_deviceconfig_uuid_d52a3627_like"
remove_index :iclock_terminal, name: "iclock_terminal_area_id_c019c6f0"
remove_index :iclock_terminal, name: "iclock_terminal_company_id_f2ecaaba"
remove_index :iclock_terminal, name: "iclock_terminal_sn_209168b1_like"
remove_index :iclock_terminalcommand, name: "iclock_terminalcommand_terminal_id_transfer_tim_495f0cc3_idx"
remove_index :iclock_transaction, name: "iclock_transaction_company_id_e7aede63"
remove_index :iclock_transaction, name: "iclock_transaction_emp_id_60fa3521"
remove_index :iclock_transaction, name: "iclock_transaction_emp_id_60fa3521_like"
remove_index :iclock_transaction, name: "iclock_transaction_terminal_id_451c81c2"
remove_index :iclock_unregister, name: "iclock_unregister_company_id_e76c1e27"
remove_index :iclock_unregister, name: "iclock_unregister_emp_id_e51e996d"
remove_index :iclock_unregister, name: "iclock_unregister_emp_id_e51e996d_like"
remove_index :iclock_unregister, name: "iclock_unregister_terminal_id_7c0e4a51"
remove_index :ipd_opd_data_entry_forms, name: "idx_pid_vid"
remove_index :inventory_transactions, name: "idx_ref1_ref3_fref3"
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 :account_configurations, name: "index_account_configurations_on_general_account_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 :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_bills, name: "index_advance_visits_bills_on_advance_visit_id"
remove_index :advance_visits_bills, name: "index_advance_visits_bills_on_bill_id"
remove_index :advance_visits_bills, name: "index_advance_visits_bills_on_visit_id"
remove_index :advance_visits, name: "index_advance_visits_on_advance_type"
remove_index :advance_visits, name: "index_advance_visits_on_collection_type"
remove_index :advance_visits, name: "index_advance_visits_on_patient_id"
remove_index :advance_visits, name: "index_advance_visits_on_visit_id"
remove_index :assets, name: "index_assets_on_inventory_transaction_detail_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_station_id"
remove_index :bed_allocations, name: "index_bed_allocations_on_treatment_id"
remove_index :bed_categories, name: "index_bed_categories_on_location_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 :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 :blood_bank_components, name: "index_blood_bank_components_on_location_id"
remove_index :clinical_systems, name: "index_clinical_systems_on_short_name"
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 :corporate_status_details, name: "index_corporate_status_details_on_bill_detail_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 :corporates, name: "index_corporates_on_parent_id"
remove_index :department_service_groups, name: "index_department_service_groups_on_location_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 :diagrams, name: "index_diagrams_on_encounter_id"
remove_index :diagrams, name: "index_diagrams_on_patient_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_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_status"
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 :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_degrees, name: "index_employee_degrees_on_employee_id"
remove_index :employee_dependent_details, name: "index_employee_dependent_details_on_employee_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_experiences, name: "index_employee_experiences_on_employee_id"
remove_index :employee_leave_balances, name: "index_employee_leave_balances_on_leave_type_id"
remove_index :equipments, name: "index_equipments_on_item_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 :inpatient_details, name: "index_inpatient_details_on_discharge_time"
remove_index :inv_tran_details, name: "index_inv_tran_details_on_drug_prescription_detail_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 :inventory_statuses, name: "index_inventory_statuses_on_created_at"
remove_index :inventory_statuses, name: "index_inventory_statuses_on_created_by"
remove_index :inventory_statuses, name: "index_inventory_statuses_on_flag"
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 :inventory_statuses, name: "index_inventory_statuses_on_mg_status"
remove_index :inventory_statuses, name: "index_inventory_statuses_on_quantity"
remove_index :inventory_statuses, name: "index_inventory_statuses_on_status"
remove_index :inventory_statuses, name: "index_inventory_statuses_on_updated_at"
remove_index :inventory_statuses, name: "index_inventory_statuses_on_updated_by"
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_bill_finalized_time"
remove_index :ipd_opd_data_entry_forms, name: "index_ipd_opd_data_entry_forms_on_clinician_id"
remove_index :ipd_opd_data_entry_forms, name: "index_ipd_opd_data_entry_forms_on_patient_age"
remove_index :ipd_opd_data_entry_forms, name: "index_ipd_opd_data_entry_forms_on_patient_type"
remove_index :ipd_opd_data_entry_forms, name: "index_ipd_opd_data_entry_forms_on_visit_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_with_details, name: "index_item_with_details_on_actual_cost_price"
remove_index :item_with_details, name: "index_item_with_details_on_batch_number"
remove_index :item_with_details, name: "index_item_with_details_on_cost_price"
remove_index :item_with_details, name: "index_item_with_details_on_created_at"
remove_index :item_with_details, name: "index_item_with_details_on_created_by"
remove_index :item_with_details, name: "index_item_with_details_on_dc_date"
remove_index :item_with_details, name: "index_item_with_details_on_dc_no"
remove_index :item_with_details, name: "index_item_with_details_on_difference_amount"
remove_index :item_with_details, name: "index_item_with_details_on_discount_percentage"
remove_index :item_with_details, name: "index_item_with_details_on_effective_cost_price"
remove_index :item_with_details, name: "index_item_with_details_on_expiry_date"
remove_index :item_with_details, name: "index_item_with_details_on_fare_market_value"
remove_index :item_with_details, name: "index_item_with_details_on_general_account_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_manufacture_date"
remove_index :item_with_details, name: "index_item_with_details_on_manufacturer_id"
remove_index :item_with_details, name: "index_item_with_details_on_mg_status"
remove_index :item_with_details, name: "index_item_with_details_on_mrp"
remove_index :item_with_details, name: "index_item_with_details_on_output_tax_profile_id"
remove_index :item_with_details, name: "index_item_with_details_on_purchase_expense_amount"
remove_index :item_with_details, name: "index_item_with_details_on_reference1"
remove_index :item_with_details, name: "index_item_with_details_on_selling_price"
remove_index :item_with_details, name: "index_item_with_details_on_status"
remove_index :item_with_details, name: "index_item_with_details_on_supplier_id"
remove_index :item_with_details, name: "index_item_with_details_on_tax_amount"
remove_index :item_with_details, name: "index_item_with_details_on_tax_on_flag"
remove_index :item_with_details, name: "index_item_with_details_on_tax_profile_id"
remove_index :item_with_details, name: "index_item_with_details_on_updated_at"
remove_index :item_with_details, name: "index_item_with_details_on_updated_by"
remove_index :lab_extids, name: "index_lab1_extids_on_current_value"
remove_index :lab_extids, name: "index_lab1_extids_on_location_id"
remove_index :lab_extids, name: "index_lab1_extids_on_lock_version"
remove_index :lab_extids, name: "index_lab1_extids_on_narration"
remove_index :lab_test_specimens, name: "index_lab_test_specimens_on_specimen_extid"
remove_index :lab_test_specimens, name: "index_lab_test_specimens_on_specimen_number"
remove_index :lab_test_specimens, name: "index_lab_test_specimens_on_specimen_prefix"
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 :leave_availd_details, name: "index_leave_availd_details_on_leave_type_id"
remove_index :leave_profile_details, name: "index_leave_profile_details_on_leave_type_id"
remove_index :holiday_masters, name: "index_name"
remove_index :nurse_tasks, name: "index_nurse_tasks_on_bed_id"
remove_index :optometric_evaluations, name: "index_optometric_evaluations_on_patient_id"
remove_index :drug_prescription_details, name: "index_order_control_is_future_order"
remove_index :patient_referal_details, name: "index_patient_referal_details_on_patient_id"
remove_index :people, name: "index_people_on_dependent_code"
remove_index :people, name: "index_people_on_member_id"
remove_index :people, name: "index_people_on_memberno"
remove_index :duty_rosters, name: "index_personnel_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 :prescription_masters, name: "index_prescription_category"
remove_index :prescription_masters, name: "index_prescription_date_prescription_type"
remove_index :prescription_masters, name: "index_prescription_masters_on_patient_id"
remove_index :prescription_masters, name: "index_prescription_masters_on_visit_id"
remove_index :prescription_masters, name: "index_prescription_type"
remove_index :present_illnesses, name: "index_present_illnesses_on_encounter_id"
remove_index :present_illnesses, name: "index_present_illnesses_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_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 :review_of_systems, name: "index_review_of_systems_on_encounter_id"
remove_index :roles, name: "index_roles_on_location_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 :service_types, name: "index_service_types_on_corporate_id"
remove_index :services_blood_components, name: "index_services_blood_components_on_location_id"
remove_index :states, name: "index_states_on_country_id"
remove_index :clinicians, name: "index_status"
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 :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 :tax_rules, name: "index_tax_rules_on_general_account_id"
remove_index :tax_rules, name: "index_tax_rules_on_tax_profile_id"
remove_index :titles, name: "index_titles_on_sex_id"
remove_index :track_assets, name: "index_track_assets_on_inventory_head_id"
remove_index :users_approvals, name: "index_users_approvals_on_user_id"
remove_index :vital_signs, name: "index_vital_signs_on_patient_id"
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 :uploaded_documents, name: "ix_description"
remove_index :lab_report_remarks, name: "lab_predefined_remark_id"
remove_index :lab_report_remarks, name: "lab_test_request_id"
remove_index :leave_availd_details, name: "lad_employee_date_status"
remove_index :localities, name: "localities_id_name_status_created_at_created_by_location_id_idx"
remove_index :user_notifications, name: "main_menu_fetch_index"
remove_index :nanda_domain_category_codes, name: "n_diagnosis_code_idx"
remove_index :allowance_deductions, name: "name"
remove_index :employee_no_dues, name: "no_dues_employee_separation_id"
remove_index :nurse_tasks, name: "nt_patient_status_bed"
remove_index :payroll_emppayrollprofile, name: "payroll_emppayrollprofile_employee_id_6c97078c_like"
remove_index :personnel_area, name: "personnel_area_company_id_59750eb5"
remove_index :personnel_area, name: "personnel_area_parent_area_id_39028fda"
remove_index :personnel_company, name: "personnel_company_name_7fd322ef_like"
remove_index :personnel_department, name: "personnel_department_company_id_00867fd8"
remove_index :personnel_department, name: "personnel_department_parent_dept_id_d0b44024"
remove_index :personnel_employee_area, name: "personnel_employee_area_area_id_64c21925"
remove_index :personnel_employee_area, name: "personnel_employee_area_employee_id_8e5cec21_like"
remove_index :personnel_employee, name: "personnel_employee_company_id_department_id_2c555933_idx"
remove_index :personnel_employee, name: "personnel_employee_department_id_068bbd08"
remove_index :personnel_employee, name: "personnel_employee_id_7ea5640e_like"
remove_index :personnel_employee, name: "personnel_employee_location_id_494a1f8d"
remove_index :personnel_employee, name: "personnel_employee_position_id_c9321343"
remove_index :personnel_location, name: "personnel_location_company_id_46ad1d50"
remove_index :personnel_location, name: "personnel_location_parent_location_id_667cb9ac"
remove_index :personnel_position, name: "personnel_position_company_id_f06c5d2a"
remove_index :personnel_position, name: "personnel_position_parent_position_id_a496a36b"
remove_index :prescription_masters, name: "prescription_masters_encounter_id_idx"
remove_index :employee_separation_details, name: "separation_employee_id"
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__status"
remove_index :social_histories, name: "social_histories_patient_id_idx"
remove_index :workflow_workflowrole, name: "workflow_workflowrole_company_id_bbb75590"
remove_index :acc_accholiday, name: "acc_accholiday_company_id_e4214e28"
remove_index :acc_accholiday, name: "acc_accholiday_holiday_id_a9efe924"
remove_index :acc_accholiday, name: "acc_accholiday_timezone_id_450d2d1e"
remove_index :acc_accterminal, name: "acc_accterminal_company_id_4bc45d50"
remove_index :acc_accterminal, name: "acc_accterminal_terminal_id_fc92cce2"
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 :att_breaktime, name: "att_breaktime_company_id_fbb9a2b7"
remove_index :att_changeschedule, name: "att_changeschedule_employee_id_7871a2b6"
remove_index :att_changeschedule, name: "att_changeschedule_employee_id_7871a2b6_like"
remove_index :att_changeschedule, name: "att_changeschedule_timeinterval_id_d41ac077"
remove_index :att_clientdetails, name: "att_clientdetails_company_id_11b1619a"
remove_index :att_departmentschedule, name: "att_departmentschedule_department_id_c68fca3d"
remove_index :att_departmentschedule, name: "att_departmentschedule_shift_id_c37d5ade"
remove_index :att_deptattrule, name: "att_deptattrule_company_id_420199ab"
remove_index :att_deptattrule, name: "att_deptattrule_department_id_f333c8f0"
remove_index :att_holiday, name: "att_holiday_company_id_4c395f52"
remove_index :att_holiday, name: "att_holiday_department_id_fbbbd185"
remove_index :att_holiday, name: "att_holiday_location_id_7bd552a5"
remove_index :att_leave, name: "att_leave_category_id_bbba39ba"
remove_index :att_leave, name: "att_leave_employee_id_bb231627"
remove_index :att_leave, name: "att_leave_employee_id_bb231627_like"
remove_index :att_leaveschedule, name: "att_leaveschedule_company_id_e9e8f83c"
remove_index :att_leaveschedule, name: "att_leaveschedule_employee_id_d0b947bc"
remove_index :att_leaveschedule, name: "att_leaveschedule_employee_id_d0b947bc_like"
remove_index :att_leavesettings, name: "att_leavesettings_company_id_22b94e3e"
remove_index :att_leavesettings, name: "att_leavesettings_employee_id_499b08f8"
remove_index :att_leavesettings, name: "att_leavesettings_employee_id_499b08f8_like"
remove_index :att_manuallog, name: "att_manuallog_employee_id_dc8cc2ad"
remove_index :att_manuallog, name: "att_manuallog_employee_id_dc8cc2ad_like"
remove_index :att_outdooremployeeschedule, name: "att_outdooremployeeschedule_company_id_3d89bc1d"
remove_index :att_outdooremployeeschedule, name: "att_outdooremployeeschedule_employee_id_d1d04c44"
remove_index :att_outdooremployeeschedule, name: "att_outdooremployeeschedule_employee_id_d1d04c44_like"
remove_index :att_outdooremployeeschedule, name: "att_outdooremployeeschedule_schedule_planner_id_7f6c2124"
remove_index :att_outdoorscheduleplanner, name: "att_outdoorscheduleplanner_company_id_d3e68ba0"
remove_index :att_outdoortrack, name: "att_outdoortrack_client_id_685e3c3b"
remove_index :att_outdoortrack, name: "att_outdoortrack_company_id_0f25e1bc"
remove_index :att_outdoortrack, name: "att_outdoortrack_employee_id_93263c5c"
remove_index :att_outdoortrack, name: "att_outdoortrack_employee_id_93263c5c_like"
remove_index :att_outdoortrack, name: "att_outdoortrack_schedule_id_a9af11fb"
remove_index :att_overtime, name: "att_overtime_employee_id_0c0d39dc"
remove_index :att_overtime, name: "att_overtime_employee_id_0c0d39dc_like"
remove_index :att_payloadbreak, name: "att_payloadbreak_uuid_533ea5e2_like"
remove_index :att_payloadexception, name: "att_payloadexception_item_id_a08bfe48"
remove_index :att_payloadexception, name: "att_payloadexception_skd_id_b2e9ecaa"
remove_index :att_payloadexception, name: "att_payloadexception_skd_id_b2e9ecaa_like"
remove_index :att_payloadexception, name: "att_payloadexception_uuid_517a81e8_like"
remove_index :att_payloadovertime, name: "att_payloadovertime_uuid_15d7782f_like"
remove_index :att_tempschedule, name: "att_tempschedule_employee_id_b89c7e54"
remove_index :att_tempschedule, name: "att_tempschedule_employee_id_b89c7e54_like"
remove_index :att_tempschedule, name: "att_tempschedule_time_interval_id_08dd8eb3"
remove_index :att_timeinterval_break_time, name: "att_timeinterval_break_time_breaktime_id_08462308"
remove_index :att_training, name: "att_training_category_id_fb38e891"
remove_index :att_training, name: "att_training_employee_id_44af8319"
remove_index :att_training, name: "att_training_employee_id_44af8319_like"
remove_index :att_trainingcategory, name: "att_trainingcategory_company_id_b2cdea87"
remove_index :auth_group, name: "auth_group_name_a6ea08ec_like"
remove_index :auth_group_permissions, name: "auth_group_permissions_permission_id_84c5c92e"
remove_index :auth_group_profile, name: "auth_group_profile_company_id_5b832dad"
remove_index :auth_group_profile_group_user, name: "auth_group_profile_group_user_myuser_id_43d03228"
remove_index :auth_group_profile_group_user, name: "auth_group_profile_group_user_myuser_id_43d03228_like"
remove_index :auth_user_groups, name: "auth_user_groups_group_id_97559544"
remove_index :auth_user_groups, name: "auth_user_groups_myuser_id_d03e8dcc_like"
remove_index :auth_user_user_permissions, name: "auth_user_user_permissions_myuser_id_679b1527_like"
remove_index :auth_user_user_permissions, name: "auth_user_user_permissions_permission_id_1fbb5f2c"
remove_index :base_autoexporttask, name: "base_autoexporttask_company_id_efb12456"
remove_index :base_bookmark, name: "base_bookmark_company_id_67ca1aa0"
remove_index :base_bookmark, name: "base_bookmark_content_type_id_b6a0e799"
remove_index :base_bookmark, name: "base_bookmark_user_id_5f2d5ca2"
remove_index :base_bookmark, name: "base_bookmark_user_id_5f2d5ca2_like"
remove_index :base_dbbackuplog, name: "base_dbbackuplog_company_id_8f93ee2e"
remove_index :base_dbmigrate, name: "base_dbmigrate_company_id_e1709280"
remove_index :base_membership_auth_area, name: "base_membership_auth_area_area_id_e58abb05"
remove_index :base_membership_auth_dept, name: "base_membership_auth_dept_department_id_c1d95e5b"
remove_index :base_membership_auth_pos, name: "base_membership_auth_pos_position_id_ae22a7d3"
remove_index :base_sftpsetting, name: "base_sftpsetting_company_id_f270bcdb"
remove_index :base_sysparamdept, name: "base_sysparamdept_rule_name_bb46d5af_like"
remove_index :celery_taskmeta, name: "celery_taskmeta_hidden_23fd02dc"
remove_index :celery_taskmeta, name: "celery_taskmeta_task_id_9558b198_like"
remove_index :celery_tasksetmeta, name: "celery_tasksetmeta_hidden_593cfc24"
remove_index :celery_tasksetmeta, name: "celery_tasksetmeta_taskset_id_a5a1d4ae_like"
remove_index :employee_check_lists, name: "check_check_list_id"
remove_index :employee_check_lists, name: "check_personnel_id"
remove_index :cloud_discount, name: "cloud_discount_create_user_id_0506f480"
remove_index :cloud_discount, name: "cloud_discount_create_user_id_0506f480_like"
remove_index :cloud_order, name: "cloud_order_company_id_a339bfc4"
remove_index :cloud_order, name: "cloud_order_create_user_id_1c5f3fc4"
remove_index :cloud_order, name: "cloud_order_create_user_id_1c5f3fc4_like"
remove_index :cloud_order_feature, name: "cloud_order_feature_feature_id_dd677eee"
remove_index :cloud_order, name: "cloud_order_price_strategy_id_237d5d03"
remove_index :cloud_paymentrecord, name: "cloud_paymentrecord_order_id_296426c6"
remove_index :cloud_pricestrategy, name: "cloud_pricestrategy_create_user_id_e5b9e9d1"
remove_index :cloud_pricestrategy, name: "cloud_pricestrategy_create_user_id_e5b9e9d1_like"
remove_index :cloud_pricestrategy, name: "cloud_pricestrategy_discount_id_fbf0d75e"
remove_index :cloud_pricestrategy_feature, name: "cloud_pricestrategy_feature_feature_id_574f3192"
remove_index :cloud_pricestrategy, name: "cloud_pricestrategy_vendor_id_427cf2a3"
remove_index :delayed_jobs, name: "delayed_jobs_priority"
remove_index :django_session, name: "django_session_expire_date_a5c62663"
remove_index :django_session, name: "django_session_session_key_c0390e0f_like"
remove_index :djcelery_periodictask, name: "djcelery_periodictask_crontab_id_75609bab"
remove_index :djcelery_periodictask, name: "djcelery_periodictask_interval_id_b426ab02"
remove_index :djcelery_periodictask, name: "djcelery_periodictask_name_cb62cda9_like"
remove_index :djcelery_taskstate, name: "djcelery_taskstate_hidden_c3905e57"
remove_index :djcelery_taskstate, name: "djcelery_taskstate_name_8af9eded"
remove_index :djcelery_taskstate, name: "djcelery_taskstate_name_8af9eded_like"
remove_index :djcelery_taskstate, name: "djcelery_taskstate_state_53543be4"
remove_index :djcelery_taskstate, name: "djcelery_taskstate_state_53543be4_like"
remove_index :djcelery_taskstate, name: "djcelery_taskstate_task_id_9d2efdb5_like"
remove_index :djcelery_taskstate, name: "djcelery_taskstate_tstamp_4c3f93a1"
remove_index :djcelery_taskstate, name: "djcelery_taskstate_worker_id_f7f57a05"
remove_index :djcelery_workerstate, name: "djcelery_workerstate_hostname_b31c7fab_like"
remove_index :djcelery_workerstate, name: "djcelery_workerstate_last_heartbeat_4539b544"
remove_index :employee_advance_accounts, name: "eaa_employee_date"
remove_index :employee_advance_account_details, name: "eaad_employee_date"
remove_index :employee_leave_encashments, name: "ele_employee_date"
remove_index :emergency_forms, name: "emergency_forms_encounter_id_patient_id_idx"
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_payslip_details, name: "epd_payslip_comp_type"
remove_index :employee_personal_informations, name: "epi_employee_name"
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 :clinicianreferals, name: "fki_clinician_id"
remove_index :patient_forms, name: "fki_frommaster_key"
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 :guardian_groupobjectpermission, name: "guardian_groupobjectpermission_content_type_id_7ade36b8"
remove_index :guardian_groupobjectpermission, name: "guardian_groupobjectpermission_permission_id_36572738"
remove_index :guardian_userobjectpermission, name: "guardian_userobjectpermission_content_type_id_2e892405"
remove_index :guardian_userobjectpermission, name: "guardian_userobjectpermission_permission_id_71807bfc"
remove_index :guardian_userobjectpermission, name: "guardian_userobjectpermission_user_id_d5c1e964_like"
remove_index :iclock_biodata, name: "iclock_biodata_employee_id_ff748ea7_like"
remove_index :iclock_errorcommandlog, name: "iclock_errorcommandlog_terminal_id_3b2d7cbd"
remove_index :iclock_events, name: "iclock_events_company_id_98a3c764"
remove_index :iclock_privatemessage, name: "iclock_privatemessage_employee_id_e84a34c0"
remove_index :iclock_privatemessage, name: "iclock_privatemessage_employee_id_e84a34c0_like"
remove_index :iclock_publicmessage, name: "iclock_publicmessage_terminal_id_c3b5e4cf"
remove_index :iclock_terminallog, name: "iclock_terminallog_terminal_id_667b3ea7"
remove_index :iclock_terminaluploadlog, name: "iclock_terminaluploadlog_terminal_id_9c9a7664"
remove_index :iclock_terminalworkcode, name: "iclock_terminalworkcode_company_id_77625f26"
remove_index :iclock_transactionproofcmd, name: "iclock_transactionproofcmd_terminal_id_08b81e1e"
remove_index :histho_blocks, name: "idx_histho_blocks_lab_test_request_detail_id"
remove_index :histho_blocks, name: "idx_histho_blocks_patient_id"
remove_index :histho_slides, name: "idx_histho_slides_lab_test_request_detail_id"
remove_index :histho_slides, name: "idx_histho_slides_patient_id"
remove_index :histho_specimens, name: "idx_histho_specimens_lab_test_request_detail_id"
remove_index :histho_specimens, name: "idx_histho_specimens_patient_id"
remove_index :mrd_details, name: "idx_iodefi"
remove_index :abdomino_pelvic_ultrasounds, name: "index_abdomino_pelvic_ultrasounds_on_patient_id"
remove_index :account_closures, name: "index_account_closures_on_closing_date"
remove_index :account_closures, name: "index_account_closures_on_closure_type"
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 :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_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 :blocked_items, name: "index_blocked_items_on_inventory_head_id"
remove_index :blocked_items, name: "index_blocked_items_on_is_blocked_now"
remove_index :blocked_items, name: "index_blocked_items_on_item_id"
remove_index :blocked_items, name: "index_blocked_items_on_item_with_detail_id"
remove_index :blocked_items, name: "index_blocked_items_on_quantity"
remove_index :blood_bags, name: "index_blood_bags_on_donor_detail_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 :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 :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 :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_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 :drugs_interactions, name: "index_drugs_interactions_on_drug1_id"
remove_index :drugs_interactions, name: "index_drugs_interactions_on_drug2_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_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 :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 :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 :invoice_summaries, name: "index_invoice_summaries_on_invoice_id"
remove_index :invoice_summaries, name: "index_invoice_summaries_on_visit_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_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 :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 :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 :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 :mrd_details, name: "index_mrd_code"
remove_index :mrd_details, name: "index_mrd_detail"
remove_index :mrd_details, name: "index_mrd_details_on_category"
remove_index :mris, name: "index_mris_on_patient_id"
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 :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 :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 :package_rates, name: "index_package_rates_on_corporate_id"
remove_index :package_rates, name: "index_package_rates_on_luxury_type_id"
remove_index :package_rates, name: "index_package_rates_on_package_id"
remove_index :packages, name: "index_packages_on_treatment_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_deposits, name: "index_patient_deposits_on_patient_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 :person_insurance_details, name: "index_person_insurance_details_on_person_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 :pharmacy_markup_percentages, name: "index_pharmacy_markup_percentages_on_corporate_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 :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_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 :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 :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 :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 :statewise_tax_profiles, name: "index_statewise_tax_profiles_on_item_id"
remove_index :statewise_tax_profiles, name: "index_statewise_tax_profiles_on_state_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 :supportive_treatments, name: "index_supportive_treatments_on_endophthalmitis_management_detai"
remove_index :surgical_procedures, name: "index_surgical_procedures_on_surgery_type_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 :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 :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 :employee_appraisals, name: "kra_employee_id"
remove_index :employee_appraisal_details, name: "kra_list_id"
remove_index :employee_mispunch_details, name: "mispunch_employee_id"
remove_index :employee_mispunch_details, name: "mispunch_shift_timing_id"
remove_index :mobile_announcement, name: "mobile_announcement_company_id_46c8203d"
remove_index :mobile_announcement, name: "mobile_announcement_receiver_id_ddf2a860"
remove_index :mobile_announcement, name: "mobile_announcement_receiver_id_ddf2a860_like"
remove_index :mobile_applist, name: "mobile_applist_company_id_5a52be94"
remove_index :mobile_appnotification, name: "mobile_appnotification_receiver_id_90c4a355"
remove_index :mobile_appnotification, name: "mobile_appnotification_receiver_id_90c4a355_like"
remove_index :mobile_gpsfordepartment, name: "mobile_gpsfordepartment_department_id_988ccf22"
remove_index :mobile_gpsforemployee, name: "mobile_gpsforemployee_employee_id_982b7cef"
remove_index :mobile_gpsforemployee, name: "mobile_gpsforemployee_employee_id_982b7cef_like"
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 :payer_details, name: "payer_details_patient_id_default_payer_idx"
remove_index :payroll_allowancetype, name: "payroll_allowancetype_company_id_4eb737ec"
remove_index :payroll_deductionformula, name: "payroll_deductionformula_company_id_0a591c19"
remove_index :payroll_emploan, name: "payroll_emploan_employee_id_97a251ef"
remove_index :payroll_emploan, name: "payroll_emploan_employee_id_97a251ef_like"
remove_index :payroll_exceptionformula, name: "payroll_exceptionformula_company_id_0541a53f"
remove_index :payroll_extradeduction, name: "payroll_extradeduction_employee_id_53072441"
remove_index :payroll_extradeduction, name: "payroll_extradeduction_employee_id_53072441_like"
remove_index :payroll_extraincrease, name: "payroll_extraincrease_employee_id_f902e6bb"
remove_index :payroll_extraincrease, name: "payroll_extraincrease_employee_id_f902e6bb_like"
remove_index :payroll_increasementformula, name: "payroll_increasementformula_company_id_2fdef254"
remove_index :payroll_leaveformula, name: "payroll_leaveformula_category_id_945b2054"
remove_index :payroll_leaveformula, name: "payroll_leaveformula_company_id_a4d269d1"
remove_index :payroll_monthlysalary, name: "payroll_monthlysalary_employee_id_97fdc6a9"
remove_index :payroll_monthlysalary, name: "payroll_monthlysalary_employee_id_97fdc6a9_like"
remove_index :payroll_overtimeformula, name: "payroll_overtimeformula_company_id_f55f42e4"
remove_index :payroll_purposetype, name: "payroll_purposetype_company_id_12048ee6"
remove_index :payroll_reimbursement, name: "payroll_reimbursement_allowance_type_id_e5d0c005"
remove_index :payroll_reimbursement, name: "payroll_reimbursement_company_id_55bbbb1b"
remove_index :payroll_reimbursement, name: "payroll_reimbursement_employee_id_c4bbde36"
remove_index :payroll_reimbursement, name: "payroll_reimbursement_employee_id_c4bbde36_like"
remove_index :payroll_reimbursement, name: "payroll_reimbursement_purpose_type_id_b32cc304"
remove_index :payroll_reimbursement, name: "payroll_reimbursement_workflow_abstractException_id_1c15b3c1"
remove_index :payroll_salaryadvance, name: "payroll_salaryadvance_employee_id_2abd43e5"
remove_index :payroll_salaryadvance, name: "payroll_salaryadvance_employee_id_2abd43e5_like"
remove_index :payroll_salarystructure_deductionformula, name: "payroll_salarystructure_de_deductionformula_id_b174d5b6"
remove_index :payroll_salarystructure, name: "payroll_salarystructure_employee_id_98996e15"
remove_index :payroll_salarystructure, name: "payroll_salarystructure_employee_id_98996e15_like"
remove_index :payroll_salarystructure_exceptionformula, name: "payroll_salarystructure_ex_exceptionformula_id_8f6dadb3"
remove_index :payroll_salarystructure_increasementformula, name: "payroll_salarystructure_in_increasementformula_id_3cd77082"
remove_index :payroll_salarystructure_leaveformula, name: "payroll_salarystructure_leaveformula_leaveformula_id_049f9024"
remove_index :payroll_salarystructure_overtimeformula, name: "payroll_salarystructure_ov_overtimeformula_id_40ad89ef"
remove_index :payslips, name: "payslip_employee_date"
remove_index :personal_histories, name: "personal_histories_patient_id_idx"
remove_index :personnel_certification, name: "personnel_certification_company_id_c1b1bd00"
remove_index :personnel_company_feature, name: "personnel_company_feature_feature_id_67123392"
remove_index :personnel_employee_flow_role, name: "personnel_employee_flow_role_employee_id_c27f8a56_like"
remove_index :personnel_employee_flow_role, name: "personnel_employee_flow_role_workflowrole_id_4704db32"
remove_index :personnel_employeecertification, name: "personnel_employeecertification_certification_id_faabed40"
remove_index :personnel_employeecertification, name: "personnel_employeecertification_employee_id_b7bd3867_like"
remove_index :personnel_employeeprofile, name: "personnel_employeeprofile_emp_id_3a69c313_like"
remove_index :personnel_resign, name: "personnel_resign_employee_id_dd9b7e08_like"
remove_index :pmo_sanction_details, name: "pmo_sanction"
remove_index :procedure_details, name: "proce_date_patient"
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 :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 :staff_stafftoken, name: "staff_stafftoken_key_af7789a4_like"
remove_index :staff_stafftoken, name: "staff_stafftoken_user_id_39c937fa_like"
remove_index :upload_files, name: "upload_employee_hr_name"
remove_index :employee_warning_letters, name: "warning_details_employee_id"
remove_index :workflow_abstractexception, name: "workflow_abstractexception_company_id_0bf5003a"
remove_index :workflow_nodeinstance, name: "workflow_nodeinstance_approver_admin_id_dff58806"
remove_index :workflow_nodeinstance, name: "workflow_nodeinstance_approver_admin_id_dff58806_like"
remove_index :workflow_nodeinstance, name: "workflow_nodeinstance_approver_employee_id_d36cd45d"
remove_index :workflow_nodeinstance, name: "workflow_nodeinstance_approver_employee_id_d36cd45d_like"
remove_index :workflow_nodeinstance, name: "workflow_nodeinstance_departments_id_b0dc2bdb"
remove_index :workflow_nodeinstance, name: "workflow_nodeinstance_node_engine_id_4533f12d"
remove_index :workflow_nodeinstance, name: "workflow_nodeinstance_workflow_instance_id_afe84fe4"
remove_index :workflow_workflowengine, name: "workflow_workflowengine_applicant_position_id_8a65e03a"
remove_index :workflow_workflowengine, name: "workflow_workflowengine_company_id_c42adcb0"
remove_index :workflow_workflowengine, name: "workflow_workflowengine_content_type_id_f7345c20"
remove_index :workflow_workflowengine, name: "workflow_workflowengine_departments_id_0f06d4c7"
remove_index :workflow_workflowengine_employee, name: "workflow_workflowengine_employee_employee_id_803a409e"
remove_index :workflow_workflowengine_employee, name: "workflow_workflowengine_employee_employee_id_803a409e_like"
remove_index :workflow_workflowinstance, name: "workflow_workflowinstance_employee_id_c7cff08e"
remove_index :workflow_workflowinstance, name: "workflow_workflowinstance_employee_id_c7cff08e_like"
remove_index :workflow_workflowinstance, name: "workflow_workflowinstance_workflow_engine_id_1e6ac40f"
remove_index :workflow_workflownode_approver, name: "workflow_workflownode_approver_workflowrole_id_c8e00d42"
remove_index :workflow_workflownode, name: "workflow_workflownode_company_id_44989997"
remove_index :workflow_workflownode_notifier, name: "workflow_workflownode_notifier_workflowrole_id_73de7fc2"