-- =====================================================
-- SIMPUS Database Schema - Rollback Master Data Migration
-- Version: 000002
-- =====================================================

DROP TABLE IF EXISTS tariffs CASCADE;
DROP TABLE IF EXISTS tariff_categories CASCADE;
DROP TABLE IF EXISTS lab_test_references CASCADE;
DROP TABLE IF EXISTS lab_tests CASCADE;
DROP TABLE IF EXISTS lab_categories CASCADE;
DROP TABLE IF EXISTS medicine_references CASCADE;
DROP TABLE IF EXISTS medicine_frequencies CASCADE;
DROP TABLE IF EXISTS medicine_routes CASCADE;
DROP TABLE IF EXISTS medicine_units CASCADE;
DROP TABLE IF EXISTS medicine_forms CASCADE;
DROP TABLE IF EXISTS medicine_categories CASCADE;
DROP TABLE IF EXISTS icd9cm_codes CASCADE;
DROP TABLE IF EXISTS icd9cm_chapters CASCADE;
DROP TABLE IF EXISTS icd10_codes CASCADE;
DROP TABLE IF EXISTS icd10_blocks CASCADE;
DROP TABLE IF EXISTS icd10_chapters CASCADE;
DROP TABLE IF EXISTS villages CASCADE;
DROP TABLE IF EXISTS districts CASCADE;
DROP TABLE IF EXISTS regencies CASCADE;
DROP TABLE IF EXISTS provinces CASCADE;
