Files
heygermany-e2e-mrg1d1zl/db/postgres/0023-analysis-model-refactor.sql
e2e 59b4a7a404
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 09:21:21 +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;