ALTER TABLE diseases
    DROP COLUMN IF EXISTS expert_confirmed_by,
    DROP COLUMN IF EXISTS source_date,
    DROP COLUMN IF EXISTS source,
    DROP COLUMN IF EXISTS status;

ALTER TABLE knowledge_articles
    DROP COLUMN IF EXISTS expert_confirmed_by,
    DROP COLUMN IF EXISTS source_date,
    DROP COLUMN IF EXISTS source,
    DROP COLUMN IF EXISTS status;

ALTER TABLE consultations
    DROP COLUMN IF EXISTS last_sla_event_at,
    DROP COLUMN IF EXISTS overdue_at,
    DROP COLUMN IF EXISTS sla_deadline,
    DROP COLUMN IF EXISTS needs_info_at,
    DROP COLUMN IF EXISTS accepted_at,
    DROP COLUMN IF EXISTS assigned_at,
    DROP COLUMN IF EXISTS assignee_id;

DROP TABLE IF EXISTS knowledge_reviews CASCADE;
DROP TABLE IF EXISTS rule_engine_results CASCADE;
DROP TABLE IF EXISTS consultation_opinion_versions CASCADE;
