--DROP TABLE eImpf_ImpfrelevanteErkankungen_VS CASCADE; CREATE TABLE eImpf_ImpfrelevanteErkankungen_VS ( eImpf_ImpfrelevanteErkankungen_VS_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (1, '712986001', '2.16.840.1.113883.6.96', 'Frühsommermeningoencephalitis'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (2, '40468003', '2.16.840.1.113883.6.96', 'Hepatitis A'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (3, '66071002', '2.16.840.1.113883.6.96', 'Hepatitis B'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (4, '14189004', '2.16.840.1.113883.6.96', 'Masern'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (5, '36989005', '2.16.840.1.113883.6.96', 'Mumps'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (6, '36653000', '2.16.840.1.113883.6.96', 'Röteln'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (7, '38907003', '2.16.840.1.113883.6.96', 'Varizellen'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (8, '16541001', '2.16.840.1.113883.6.96', 'Gelbfieber'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (9, '52947006', '2.16.840.1.113883.6.96', 'Japanische Encephalitis'); INSERT INTO eImpf_ImpfrelevanteErkankungen_VS (eImpf_ImpfrelevanteErkankungen_VS_id, code, codeSystem, displayName) VALUES (10, '840539006', '2.16.840.1.113883.6.96', 'SARS-CoV-2');