cs-1.2.276.0.76.3.1.195.5.101-2019-08-16T000000.sql

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