--DROP TABLE ELGA_MedikationFrequenz CASCADE; CREATE TABLE ELGA_MedikationFrequenz ( ELGA_MedikationFrequenz_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_MedikationFrequenz (ELGA_MedikationFrequenz_id, code, codeSystem, displayName) VALUES (1, 'd', '2.16.840.1.113883.6.8', 'Tag'); INSERT INTO ELGA_MedikationFrequenz (ELGA_MedikationFrequenz_id, code, codeSystem, displayName) VALUES (2, 'wk', '2.16.840.1.113883.6.8', 'Woche'); INSERT INTO ELGA_MedikationFrequenz (ELGA_MedikationFrequenz_id, code, codeSystem, displayName) VALUES (3, 'mo', '2.16.840.1.113883.6.8', 'Monat');