--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 summarization note'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (2, '11490-0', '2.16.840.1.113883.6.1', 'Discharge summarization note (physician)'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (3, '34745-0', '2.16.840.1.113883.6.1', 'Discharge summarization note (nursing)'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (4, '11502-2', '2.16.840.1.113883.6.1', 'LABORATORY REPORT.TOTAL'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (5, '18748-4', '2.16.840.1.113883.6.1', 'Diagnostic Imaging Report'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (6, '18747-6', '2.16.840.1.113883.6.1', 'CT Unspecified system Study'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (7, '18755-9', '2.16.840.1.113883.6.1', 'MRI Unspecified site study'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (8, '18760-9', '2.16.840.1.113883.6.1', 'US Unspecified system Study'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (9, '18757-5', '2.16.840.1.113883.6.1', 'Nuclear medicine study'); INSERT INTO ELGA_Dokumentenklassen (ELGA_Dokumentenklassen_id, code, codeSystem, displayName) VALUES (10, '18758-3', '2.16.840.1.113883.6.1', 'PET scan Unspecified system Study'); 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, '11522-0', '2.16.840.1.113883.6.1', 'Cardiac echo study'); 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', 'Obstetrical ultrasound study'); 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');