ACUITY DB tables to delete

These tables are not used at all, or are updated, but never read, or even are used in some requests, but are not required there in fact. We can't just remove them all at once and be sure that nothing is broken as a result, but gradually we will remove them — or move to some of other pages, so finally this page should be removed too.

Schemas

• maintenance_tasks - an empty schema, probably unused; if so, it will be deleted soon

Tables

Result tables to remove

Most part of these tables data are calculated and written into DB during ETL, but never requested and presented by VAHub, so it looks like if they are calculated in vain and all the corresponding functionality should be removed. Other are not updated nor requested. But anyway, it takes MUCH attention to break nothing during this removing! Some tables may still be required in fact!

• result_consent
• result_conmed_procedure
• result_ecg - legacy ECG format; delete?
• result_fm_gene
• result_liverss
• result_lab_group - pay attention: FK'ed by result_laboratory (FK is always null in current test data).
• result_country - country patient is from or what? not used! possibly replaced with corresponding field in result_patient table.
• result_overdose_report - may be just lost
• result_pregnancy_test - maybe SSV
• result_primary_tumour_location - may be required not for visualization (for AdminUI) - also mb SSV
• result_performance_status - performance monitoring?
• result_pathology - seems to be unpresented, despite there is even a service in VAHub. is it? - smth about oncology and/or SSV
• result_radiotherapy - is it used? there is backend part, but... on frontend there is TumourTherapy containing it, but it looks unused too. - SSV, maybe more Tables for data about eDiaries; for now, seem to be unused (never presented or mentioned in VAHub). Remove it? Probably Spotfire only.
• result_ediary
• result_ediary_medication_usage
• result_ediary_observations

Mapping tables to remove

• map_subject_group_annotation, map_subject_group_dosing, map_subject_group_dosing_sched - required for (already removed) dashboards only? map_subject_group_annotation - table with additional settings for groups (preferred name etc). Relevant for selected groupings only (msga_grouping_id FK refers to a map_subject_grouping table entry). map_subject_group_dosing, map_subject_group_dosing_sched - tables with alternative drug dosings and scheduling.
• map_dashboard_col_options, map_dashboard_row_options - likely part of dashboards and should be removed