34 lines
1.2 KiB
SQL
34 lines
1.2 KiB
SQL
-- Add transcript summary fields to candidate table
|
|
ALTER TABLE app.candidate_transcript
|
|
ADD COLUMN ai_is_nursing_focus BOOLEAN,
|
|
ADD COLUMN ai_has_theory_hours BOOLEAN,
|
|
ADD COLUMN ai_has_practice_hours BOOLEAN,
|
|
ADD COLUMN is_nursing_focus BOOLEAN,
|
|
ADD COLUMN has_theory_hours BOOLEAN,
|
|
ADD COLUMN has_practice_hours BOOLEAN;
|
|
|
|
CREATE TYPE app.nurse_recognition_home_country AS ENUM (
|
|
'nurse',
|
|
'assistant_nurse',
|
|
'nursing_helper',
|
|
'none'
|
|
);
|
|
|
|
ALTER TYPE app.nurse_recognition RENAME TO nurse_recognition_germany;
|
|
|
|
-- Change qualification_status_home_country to use the new enum type
|
|
ALTER TABLE app.candidate
|
|
ALTER COLUMN qualification_status_home_country TYPE app.nurse_recognition_home_country
|
|
USING qualification_status_home_country::text::app.nurse_recognition_home_country;
|
|
|
|
DROP TABLE app.candidate_transcript_course;
|
|
|
|
-- Add transcript summary fields to candidate table
|
|
ALTER TABLE app.candidate
|
|
DROP COLUMN transcripts_total_hours,
|
|
DROP COLUMN transcripts_total_theory_hours,
|
|
DROP COLUMN transcripts_total_practice_hours,
|
|
DROP COLUMN transcripts_theory_and_practice,
|
|
DROP COLUMN transcripts_structured_training,
|
|
ADD COLUMN transcripts_has_duration BOOLEAN;
|