--DROP TABLE Laborbefundgruppe CASCADE; CREATE TABLE Laborbefundgruppe ( Laborbefundgruppe_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (1, '18717-9', '2.16.840.1.113883.6.1', 'Blood bank studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (2, '18719-5', '2.16.840.1.113883.6.1', 'Chemistry studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (3, '18720-3', '2.16.840.1.113883.6.1', 'Coagulation studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (4, '18723-7', '2.16.840.1.113883.6.1', 'Hematology studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (5, '18724-5', '2.16.840.1.113883.6.1', 'HLA studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (6, '18725-2', '2.16.840.1.113883.6.1', 'Microbiology studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (7, '18727-8', '2.16.840.1.113883.6.1', 'Serology studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (8, '18729-4', '2.16.840.1.113883.6.1', 'Urinalysis studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (9, '18767-4', '2.16.840.1.113883.6.1', 'Blood gas studies'); INSERT INTO Laborbefundgruppe (Laborbefundgruppe_id, code, codeSystem, displayName) VALUES (10, '18768-2', '2.16.840.1.113883.6.1', 'Cell counts+Differential studies');