-- Remove redundant transcript fields that can be calculated from hours
ALTER TABLE app.candidate_transcript
    DROP COLUMN IF EXISTS has_theory_hours,
    DROP COLUMN IF EXISTS has_practice_hours,
    DROP COLUMN IF EXISTS ai_has_theory_hours,
    DROP COLUMN IF EXISTS ai_has_practice_hours;