voc-1.2.276.0.76.3.1.195.11.10-2024-02-11T212338.sql

    --DROP TABLE mts_presenting_diagram CASCADE;
    CREATE TABLE mts_presenting_diagram (
            mts_presenting_diagram_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (1, '1', '1.2.276.0.76.3.1.195.5.101', 'Abdominelle Schmerzen bei Erwachsenen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (2, '2', '1.2.276.0.76.3.1.195.5.101', 'Abdominelle Schmerzen bei Kindern');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (3, '3', '1.2.276.0.76.3.1.195.5.101', 'Abszesse und lokale Infektionen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (4, '4', '1.2.276.0.76.3.1.195.5.101', 'Allergie');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (5, '5', '1.2.276.0.76.3.1.195.5.101', 'Angriff (Zustand nach)');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (6, '6', '1.2.276.0.76.3.1.195.5.101', 'Asthma');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (7, '7', '1.2.276.0.76.3.1.195.5.101', 'Atemproblem bei Erwachsenen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (8, '8', '1.2.276.0.76.3.1.195.5.101', 'Atemproblem bei Kindern');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (9, '9', '1.2.276.0.76.3.1.195.5.101', 'Auffälliges Verhalten');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (10, '10', '1.2.276.0.76.3.1.195.5.101', 'Augenprobleme');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (11, '11', '1.2.276.0.76.3.1.195.5.101', 'Besorgte Eltern');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (12, '12', '1.2.276.0.76.3.1.195.5.101', 'Betrunkener Eindruck');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (13, '13', '1.2.276.0.76.3.1.195.5.101', 'Bisse und Stiche');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (14, '14', '1.2.276.0.76.3.1.195.5.101', 'Chemikalienkontakt');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (15, '15', '1.2.276.0.76.3.1.195.5.101', 'Diabetes');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (16, '16', '1.2.276.0.76.3.1.195.5.101', 'Durchfälle und Erbrechen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (17, '17', '1.2.276.0.76.3.1.195.5.101', 'Extremitätenprobleme');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (18, '18', '1.2.276.0.76.3.1.195.5.101', 'Fremdkörper');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (19, '19', '1.2.276.0.76.3.1.195.5.101', 'Gastrointestinale Blutung');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (20, '20', '1.2.276.0.76.3.1.195.5.101', 'Gesichtsprobleme');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (21, '21', '1.2.276.0.76.3.1.195.5.101', 'Halsschmerz');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (22, '22', '1.2.276.0.76.3.1.195.5.101', 'Hautausschläge');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (23, '23', '1.2.276.0.76.3.1.195.5.101', 'Herzklopfen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (24, '24', '1.2.276.0.76.3.1.195.5.101', 'Hinkendes Kind');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (25, '25', '1.2.276.0.76.3.1.195.5.101', 'Hodenschmerz');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (26, '26', '1.2.276.0.76.3.1.195.5.101', 'Irritables (erregbares/reizbares) Kind ');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (27, '27', '1.2.276.0.76.3.1.195.5.101', 'Körperstammverletzung');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (28, '28', '1.2.276.0.76.3.1.195.5.101', 'Kollaps');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (29, '29', '1.2.276.0.76.3.1.195.5.101', 'Kopfschmerz');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (30, '30', '1.2.276.0.76.3.1.195.5.101', 'Kopfverletzung');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (31, '31', '1.2.276.0.76.3.1.195.5.101', 'Krampfanfall');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (32, '32', '1.2.276.0.76.3.1.195.5.101', 'Nackenschmerz');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (33, '33', '1.2.276.0.76.3.1.195.5.101', 'Ohrenprobleme');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (34, '34', '1.2.276.0.76.3.1.195.5.101', 'Psychiatrische Erkrankung');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (35, '35', '1.2.276.0.76.3.1.195.5.101', 'Rückenschmerz');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (36, '36', '1.2.276.0.76.3.1.195.5.101', 'Schreiendes Baby');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (37, '37', '1.2.276.0.76.3.1.195.5.101', 'Schwangerschaftsproblem');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (38, '38', '1.2.276.0.76.3.1.195.5.101', 'Schweres Trauma');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (39, '39', '1.2.276.0.76.3.1.195.5.101', 'Selbstverletzung');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (40, '40', '1.2.276.0.76.3.1.195.5.101', 'Sexualinfektion');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (41, '41', '1.2.276.0.76.3.1.195.5.101', 'Stürze');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (42, '42', '1.2.276.0.76.3.1.195.5.101', 'Thoraxschmerz');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (43, '43', '1.2.276.0.76.3.1.195.5.101', 'Überdosierung und Vergiftung');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (44, '44', '1.2.276.0.76.3.1.195.5.101', 'Unwohlsein bei Erwachsenen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (45, '45', '1.2.276.0.76.3.1.195.5.101', 'Unwohlsein bei Kindern');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (46, '46', '1.2.276.0.76.3.1.195.5.101', 'Unwohlsein bei Neugeborenen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (47, '47', '1.2.276.0.76.3.1.195.5.101', 'Unwohlsein bei Säuglingen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (48, '48', '1.2.276.0.76.3.1.195.5.101', 'Urologische Probleme');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (49, '49', '1.2.276.0.76.3.1.195.5.101', 'Vaginale Blutung');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (50, '50', '1.2.276.0.76.3.1.195.5.101', 'Verbrennungen und Verbrühungen');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (51, '51', '1.2.276.0.76.3.1.195.5.101', 'Wunden');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (52, '52', '1.2.276.0.76.3.1.195.5.101', 'Zahnprobleme');
        
    INSERT INTO mts_presenting_diagram (mts_presenting_diagram_id, code, codeSystem, displayName)
            VALUES (53, '53', '1.2.276.0.76.3.1.195.5.101', 'Generelle Indikatoren');