--DROP TABLE SwissVaccinationPlanImmunizations CASCADE; CREATE TABLE SwissVaccinationPlanImmunizations ( SwissVaccinationPlanImmunizations_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (1, '42284007', '2.16.840.1.113883.6.96', 'BCG vaccination'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (2, '76668005', '2.16.840.1.113883.6.96', 'Diphtheria vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (3, '127787002', '2.16.840.1.113883.6.96', 'Haemophilus influenzae type b vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (4, '243789007', '2.16.840.1.113883.6.96', 'Hepatitis A immunization (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (5, '16584000', '2.16.840.1.113883.6.96', 'Hepatitis B vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (6, '86198006', '2.16.840.1.113883.6.96', 'Influenza vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (7, '314759000', '2.16.840.1.113883.6.96', 'Japanese encephalitis vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (8, '47435007', '2.16.840.1.113883.6.96', 'Measles vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (9, '41088001', '2.16.840.1.113883.6.96', 'Meningococcus vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (10, '50583002', '2.16.840.1.113883.6.96', 'Mumps vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (11, '428570002', '2.16.840.1.113883.6.96', 'Vaccination for human papillomavirus (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (12, '39343008', '2.16.840.1.113883.6.96', 'Pertussis vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (13, '12866006', '2.16.840.1.113883.6.96', 'Pneumococcal vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (14, '72093006', '2.16.840.1.113883.6.96', 'Poliomyelitis vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (15, '34631000', '2.16.840.1.113883.6.96', 'Rabies vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (16, '82314000', '2.16.840.1.113883.6.96', 'Rubella vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (17, '127786006', '2.16.840.1.113883.6.96', 'Tetanus vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (18, '281658005', '2.16.840.1.113883.6.96', 'Tick-borne encephalitis vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (19, '15483003', '2.16.840.1.113883.6.96', 'Typhoid vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (20, '68525005', '2.16.840.1.113883.6.96', 'Varicella vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (21, '67308009', '2.16.840.1.113883.6.96', 'Yellow fever vaccination (procedure)'); --DROP TABLE SwissVaccinationPlanImmunizations CASCADE; CREATE TABLE SwissVaccinationPlanImmunizations ( SwissVaccinationPlanImmunizations_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (1, '42284007', '2.16.840.1.113883.6.96', 'BCG vaccination'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (2, '76668005', '2.16.840.1.113883.6.96', 'Diphtheria vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (3, '127787002', '2.16.840.1.113883.6.96', 'Haemophilus influenzae type b vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (4, '243789007', '2.16.840.1.113883.6.96', 'Hepatitis A immunization (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (5, '16584000', '2.16.840.1.113883.6.96', 'Hepatitis B vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (6, '86198006', '2.16.840.1.113883.6.96', 'Influenza vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (7, '314759000', '2.16.840.1.113883.6.96', 'Japanese encephalitis vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (8, '47435007', '2.16.840.1.113883.6.96', 'Measles vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (9, '41088001', '2.16.840.1.113883.6.96', 'Meningococcus vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (10, '50583002', '2.16.840.1.113883.6.96', 'Mumps vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (11, '428570002', '2.16.840.1.113883.6.96', 'Vaccination for human papillomavirus (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (12, '39343008', '2.16.840.1.113883.6.96', 'Pertussis vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (13, '12866006', '2.16.840.1.113883.6.96', 'Pneumococcal vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (14, '72093006', '2.16.840.1.113883.6.96', 'Poliomyelitis vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (15, '34631000', '2.16.840.1.113883.6.96', 'Rabies vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (16, '82314000', '2.16.840.1.113883.6.96', 'Rubella vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (17, '127786006', '2.16.840.1.113883.6.96', 'Tetanus vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (18, '281658005', '2.16.840.1.113883.6.96', 'Tick-borne encephalitis vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (19, '30338008', '2.16.840.1.113883.6.96', 'Typhus vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (20, '68525005', '2.16.840.1.113883.6.96', 'Varicella vaccination (procedure)'); INSERT INTO SwissVaccinationPlanImmunizations (SwissVaccinationPlanImmunizations_id, code, codeSystem, displayName) VALUES (21, '67308009', '2.16.840.1.113883.6.96', 'Yellow fever vaccination (procedure)');