--DROP TABLE ELGA_Rollen CASCADE; CREATE TABLE ELGA_Rollen ( ELGA_Rollen_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (1, '700', '1.2.40.0.34.5.3', 'Arzt'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (2, '701', '1.2.40.0.34.5.3', 'Zahnarzt'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (3, '702', '1.2.40.0.34.5.3', 'Krankenanstalt'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (4, '703', '1.2.40.0.34.5.3', 'Einrichtung der Pflege'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (5, '704', '1.2.40.0.34.5.3', 'Apotheke'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (6, '705', '1.2.40.0.34.5.3', 'ELGA-Beratung'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (7, '706', '1.2.40.0.34.5.3', 'ELGA-Ombudsstelle'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (8, '707', '1.2.40.0.34.5.3', 'ELGA-Widerspruchsstelle'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (9, '708', '1.2.40.0.34.5.3', 'ELGA-Regelwerkadministrator'); INSERT INTO ELGA_Rollen (ELGA_Rollen_id, code, codeSystem, displayName) VALUES (10, '709', '1.2.40.0.34.5.3', 'ELGA-Sicherheitsadministrator');