--DROP TABLE ELGA_Diagnosesicherheit CASCADE; CREATE TABLE ELGA_Diagnosesicherheit ( ELGA_Diagnosesicherheit_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_Diagnosesicherheit (ELGA_Diagnosesicherheit_id, code, codeSystem, displayName) VALUES (1, 'G', '2.16.840.1.113883.3.7.1.8', 'Gesichert'); INSERT INTO ELGA_Diagnosesicherheit (ELGA_Diagnosesicherheit_id, code, codeSystem, displayName) VALUES (2, 'V', '2.16.840.1.113883.3.7.1.8', 'Verdacht auf');