Files
heygermany-e2e-mrg4m7dd/db/postgres/0023-analysis-model-refactor.sql
e2e 6c231d1d36
Some checks failed
Main / Setup and Test (push) Has been cancelled
Main / Build Website (push) Has been cancelled
chore: heygermany customer project
2026-07-11 10:52:27 +02:00

10 lines
464 B
SQL

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;