--DROP TABLE Referralactions CASCADE; CREATE TABLE Referralactions ( Referralactions_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Referralactions (Referralactions_id, code, codeSystem, displayName) VALUES (1, '1', '2.16.840.1.113883.2.6.60.3.5.53', 'intern: OP / Intervention (z.B. Herzkatheter, Endoskopie, ...)'); INSERT INTO Referralactions (Referralactions_id, code, codeSystem, displayName) VALUES (2, '2', '2.16.840.1.113883.2.6.60.3.5.53', 'extern: OP / Intervention (z.B. Herzkatheter, Endoskopie, ...)'); INSERT INTO Referralactions (Referralactions_id, code, codeSystem, displayName) VALUES (3, '3', '2.16.840.1.113883.2.6.60.3.5.53', 'intern: Überwachung (ICU / IMC / Chest-Pain-Unit / Stroke)'); INSERT INTO Referralactions (Referralactions_id, code, codeSystem, displayName) VALUES (4, '4', '2.16.840.1.113883.2.6.60.3.5.53', 'extern: Überwachung (ICU / IMC / Chest-Pain-Unit / Stroke)'); INSERT INTO Referralactions (Referralactions_id, code, codeSystem, displayName) VALUES (5, '5', '2.16.840.1.113883.2.6.60.3.5.53', 'intern: Normalstation'); INSERT INTO Referralactions (Referralactions_id, code, codeSystem, displayName) VALUES (6, '6', '2.16.840.1.113883.2.6.60.3.5.53', 'extern: Normalstation');