Delete copy tables from production database

[petmongrels]

Some of these tables may accidentally go another customer when we export, so it is better we remove these tables.

checklist_item_temp, checklist_temp, hd_waste_type, hiren_test_virtual_catchment_address_mapping_table, individual_copy_ck, individual_copy_ihmp, individual_copy, individual_copy_ck, individual_copy_ihmp, program_encounter_copy, program_enrolment_ck, program_enrolment_copy, program_enrolment_ihmp, temp_birth_weight_migration_fix

check and delete whether they are used in reports still

jsscp_month_years, sr_enrolment_year, sr_observations,

Look for additional tables if they have been created since the last time this was checked.

[petmongrels]

pls take through code review process

[petmongrels]

DROP TABLE sr_observations; will not work as it depends on other things. I tried this on local db of one org.

[2024-04-19 14:20:13] [2BP01] ERROR: cannot drop table sr_observations because other objects depend on it
[2024-04-19 14:20:13] Detail: view addiction_details depends on table sr_observations
[2024-04-19 14:20:13] view anemia_status depends on table sr_observations
[2024-04-19 14:20:13] view chronic_sickness depends on table sr_observations
[2024-04-19 14:20:13] view menstrual_disorders depends on table sr_observations
[2024-04-19 14:20:13] view school_going depends on table sr_observations
[2024-04-19 14:20:13] view sickling_result depends on table sr_observations
[2024-04-19 14:20:13] Hint: Use DROP ... CASCADE to drop the dependent objects too.

[1t5j0y]

Executed on prod