--DROP TABLE ELGA_Dokumentenklassen CASCADE; CREATE TABLE ELGA_Dokumentenklassen ( ELGA_Dokumentenklassen_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (1, '18842-5', '2.16.840.1.113883.6.1', 'Discharge summary'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (2, '11490-0', '2.16.840.1.113883.6.1', 'Physician Discharge summary'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (3, '34745-0', '2.16.840.1.113883.6.1', 'Nurse Discharge summary'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (4, '11502-2', '2.16.840.1.113883.6.1', 'Laboratory Report'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (5, '18748-4', '2.16.840.1.113883.6.1', 'Diagnostic imaging study'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (6, '25045-6', '2.16.840.1.113883.6.1', 'Unspecified body region CT'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (7, '25056-3', '2.16.840.1.113883.6.1', 'Unspecified body region MRI'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (8, '25061-3', '2.16.840.1.113883.6.1', 'Unspecified body region US'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (9, '49118-3', '2.16.840.1.113883.6.1', 'Unspecified body region Scan'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (10, '44136-0', '2.16.840.1.113883.6.1', 'Unspecified body region PET'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (11, '18745-0', '2.16.840.1.113883.6.1', 'Cardiac catheterization study'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (12, '42148-7', '2.16.840.1.113883.6.1', 'Heart US'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (13, '18782-3', '2.16.840.1.113883.6.1', 'Radiology Study observation (narrative)'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (14, '18746-8', '2.16.840.1.113883.6.1', 'Colonoscopy study'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (15, '18751-8', '2.16.840.1.113883.6.1', 'Endoscopy study'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (16, '11525-3', '2.16.840.1.113883.6.1', 'US Pelvis and Fetus for pregnancy'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (17, '55113-5', '2.16.840.1.113883.6.1', 'Key images Document Radiology'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (18, '52471-0', '2.16.840.1.113883.6.1', 'Medications'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (19, '57833-6', '2.16.840.1.113883.6.1', 'Prescription for medication'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (20, '60593-1', '2.16.840.1.113883.6.1', 'Medication dispensed.extended Document'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (21, '56445-0', '2.16.840.1.113883.6.1', 'Medication summary Document'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (22, '61356-2', '2.16.840.1.113883.6.1', 'Medication pharmaceutical advice.extended Document');