--DROP TABLE adtgekid_grading CASCADE; CREATE TABLE adtgekid_grading ( adtgekid_grading_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (1, '0', '2.16.840.1.113883.6.96', 'primär erworbene Melanose ohne zelluläre Atypien (nur beim malignen Melanom der Konjunktiva)'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (2, '1', '2.16.840.1.113883.6.96', 'gut differenziert'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (3, '2', '2.16.840.1.113883.6.96', 'mäßig differenziert'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (4, '3', '2.16.840.1.113883.6.96', 'schlecht differenziert'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (5, '4', '2.16.840.1.113883.6.96', 'undifferenziert'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (6, '5', '2.16.840.1.113883.6.96', 'nur für C61, TNM8'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (7, 'X', '2.16.840.1.113883.6.96', 'nicht bestimmbar'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (8, 'L', '2.16.840.1.113883.6.96', 'low grade (G1 oder G2)'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (9, 'M', '2.16.840.1.113883.6.96', 'intermediate grade (G2 oder G3)'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (10, 'H', '2.16.840.1.113883.6.96', 'high grade (G3 oder G4)'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (11, 'B', '2.16.840.1.113883.6.96', 'Borderline'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (12, 'U', '2.16.840.1.113883.6.96', 'unbekannt'); INSERT INTO adtgekid_grading (adtgekid_grading_id, code, codeSystem, displayName) VALUES (13, 'T', '2.16.840.1.113883.6.96', 'trifft nicht zu');