ALTER TABLE app.candidate_education
    ADD COLUMN IF NOT EXISTS has_theory BOOLEAN,
    ADD COLUMN IF NOT EXISTS has_practice BOOLEAN,
    ADD COLUMN IF NOT EXISTS duration_hours INTEGER,
    ADD COLUMN IF NOT EXISTS is_nursing_focus BOOLEAN,
    ADD COLUMN IF NOT EXISTS ai_has_theory BOOLEAN,
    ADD COLUMN IF NOT EXISTS ai_has_practice BOOLEAN,
    ADD COLUMN IF NOT EXISTS ai_duration_hours INTEGER,
    ADD COLUMN IF NOT EXISTS ai_is_nursing_focus BOOLEAN;