cs-1.2.276.0.76.3.1.195.5.99-2023-12-30T000000.sql

        --DROP TABLE snomed_postcoordinations CASCADE;
        CREATE TABLE snomed_postcoordinations (
            snomed_postcoordinations_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 snomed_postcoordinations (snomed_postcoordinations_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (1, 'SCTPOCC-44301001', '1.2.276.0.76.3.1.195.5.99', 'Verdacht auf Suizid', 'draft', '2023-12-30T00:00:00', '', '');
        
            INSERT INTO snomed_postcoordinations (snomed_postcoordinations_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (2, 'SCTPOCC-52684005', '1.2.276.0.76.3.1.195.5.99', 'Verdacht auf Gewaltverbrechen', 'draft', '2023-12-30T00:00:00', '', '');
        
            INSERT INTO snomed_postcoordinations (snomed_postcoordinations_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (3, 'SCTPOCC-49499008', '1.2.276.0.76.3.1.195.5.99', 'MTS-Indikatoren ROT', 'draft', '2023-12-30T00:00:00', '', '');
        
            INSERT INTO snomed_postcoordinations (snomed_postcoordinations_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (4, 'SCTPOCC-25876001', '1.2.276.0.76.3.1.195.5.99', 'MTS-Indikatoren ORANGE', 'draft', '2023-12-30T00:00:00', '', '');
        
            INSERT INTO snomed_postcoordinations (snomed_postcoordinations_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (5, 'SCTPOCC-103391001', '1.2.276.0.76.3.1.195.5.99', 'MTS-Indikatoren GELB', 'draft', '2023-12-30T00:00:00', '', '');
        
            INSERT INTO snomed_postcoordinations (snomed_postcoordinations_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (6, 'SCTPOCC-394848005', '1.2.276.0.76.3.1.195.5.99', 'MTS-Indikatoren GRÜN', 'draft', '2023-12-30T00:00:00', '', '');
        
            INSERT INTO snomed_postcoordinations (snomed_postcoordinations_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (7, 'SCTPOCC-1269489004', '1.2.276.0.76.3.1.195.5.99', 'MTS-Präsentationsdiagramm', 'draft', '2023-12-30T00:00:00', '', '');
        
            INSERT INTO snomed_postcoordinations (snomed_postcoordinations_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (8, 'SCTPOCC-713012003', '1.2.276.0.76.3.1.195.5.99', 'ESI-Triagefaktoren', 'draft', '2023-12-30T00:00:00', '', '');