--DROP TABLE ELGA_FormatCode CASCADE; CREATE TABLE ELGA_FormatCode ( ELGA_FormatCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (1, 'urn:elga:2014:EIS_Basic', '1.2.40.0.34.5.37', 'ELGA Dokument'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (2, 'urn:elga:2013:EIS_Basic', '1.2.40.0.34.5.37', 'ELGA Dokument'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (3, 'urn:elga:dissum:2014:EIS_Basic', '1.2.40.0.34.5.37', 'ELGA Entlassungsbrief'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (4, 'urn:elga:dissum:2014:EIS_Enhanced', '1.2.40.0.34.5.37', 'ELGA Entlassungsbrief'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (5, 'urn:elga:dissum:2014:EIS_FullSupport', '1.2.40.0.34.5.37', 'ELGA Entlassungsbrief'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (6, 'urn:elga:dissum:2013:EIS_Basic', '1.2.40.0.34.5.37', 'ELGA Entlassungsbrief'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (7, 'urn:elga:dissum:2013:EIS_Enhanced', '1.2.40.0.34.5.37', 'ELGA Entlassungsbrief'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (8, 'urn:elga:dissum:2013:EIS_FullSupport', '1.2.40.0.34.5.37', 'ELGA Entlassungsbrief'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (9, 'urn:elga:lab:2014:EIS_Basic', '1.2.40.0.34.5.37', 'ELGA Befundbericht Labor'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (10, 'urn:elga:lab:2014:EIS_Enhanced', '1.2.40.0.34.5.37', 'ELGA Befundbericht Labor'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (11, 'urn:elga:lab:2014:EIS_FullSupport', '1.2.40.0.34.5.37', 'ELGA Befundbericht Labor'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (12, 'urn:elga:radio:2013:EIS_Basic', '1.2.40.0.34.5.37', 'ELGA Befundbericht Radiologie'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (13, 'urn:elga:radio:2013:EIS_Enhanced', '1.2.40.0.34.5.37', 'ELGA Befundbericht Radiologie'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (14, 'urn:elga:radio:2013:EIS_FullSupport', '1.2.40.0.34.5.37', 'ELGA Befundbericht Radiologie'); INSERT INTO ELGA_FormatCode (ELGA_FormatCode_id, code, codeSystem, displayName) VALUES (15, 'urn:elga:emedat:2014:EIS_FullSupport', '1.2.40.0.34.5.37', 'ELGA e-Medikation');