--DROP TABLE diabetes_diseases_surrogate CASCADE; CREATE TABLE diabetes_diseases_surrogate ( diabetes_diseases_surrogate_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO diabetes_diseases_surrogate (diabetes_diseases_surrogate_id, code, codeSystem, displayName) VALUES (1, 'E11.9', '1.2.276.0.76.5.409', 'Diabetes mellitus, Typ 2 : Ohne Komplikationen'); INSERT INTO diabetes_diseases_surrogate (diabetes_diseases_surrogate_id, code, codeSystem, displayName) VALUES (2, 'E10.9', '1.2.276.0.76.5.409', 'Diabetes mellitus, Typ 1 : Ohne Komplikationen'); INSERT INTO diabetes_diseases_surrogate (diabetes_diseases_surrogate_id, code, codeSystem, displayName) VALUES (3, 'E13.9', '1.2.276.0.76.5.409', 'Sonstiger näher bezeichneter Diabetes mellitus : Ohne Komplikationen');