--DROP TABLE ELGA_ActCode_PatInfo CASCADE; CREATE TABLE ELGA_ActCode_PatInfo ( ELGA_ActCode_PatInfo_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_ActCode_PatInfo (ELGA_ActCode_PatInfo_id, code, codeSystem, displayName) VALUES (1, 'ZINFO', '1.2.40.0.34.5.103', 'Zusatzinformationen für den Patienten'); INSERT INTO ELGA_ActCode_PatInfo (ELGA_ActCode_PatInfo_id, code, codeSystem, displayName) VALUES (2, 'ALTEIN', '1.2.40.0.34.5.103', 'Informationen zur alternativen Einnahme'); INSERT INTO ELGA_ActCode_PatInfo (ELGA_ActCode_PatInfo_id, code, codeSystem, displayName) VALUES (3, 'ARZNEIINFO', '1.2.40.0.34.5.103', 'Informationen zur Arznei');