--DROP TABLE ELGA_MedikationAbgabeArt CASCADE; CREATE TABLE ELGA_MedikationAbgabeArt ( ELGA_MedikationAbgabeArt_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_MedikationAbgabeArt (ELGA_MedikationAbgabeArt_id, code, codeSystem, displayName) VALUES (1, 'FFC', '2.16.840.1.113883.5.4', 'First Fill - Complete'); INSERT INTO ELGA_MedikationAbgabeArt (ELGA_MedikationAbgabeArt_id, code, codeSystem, displayName) VALUES (2, 'FFP', '2.16.840.1.113883.5.4', 'First Fill - Part Fill'); INSERT INTO ELGA_MedikationAbgabeArt (ELGA_MedikationAbgabeArt_id, code, codeSystem, displayName) VALUES (3, 'RFC', '2.16.840.1.113883.5.4', 'Refill - Complete'); INSERT INTO ELGA_MedikationAbgabeArt (ELGA_MedikationAbgabeArt_id, code, codeSystem, displayName) VALUES (4, 'RFP', '2.16.840.1.113883.5.4', 'Refill - Part Fill');