voc-1.2.276.0.76.3.1.195.11.6-2024-02-14T131928.sql

    --DROP TABLE accident_reason_snomed CASCADE;
    CREATE TABLE accident_reason_snomed (
            accident_reason_snomed_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO accident_reason_snomed (accident_reason_snomed_id, code, codeSystem, displayName)
            VALUES (1, '418019003', '2.16.840.1.113883.6.96', 'Accidental event (event)');
        
    INSERT INTO accident_reason_snomed (accident_reason_snomed_id, code, codeSystem, displayName)
            VALUES (2, '68023007', '2.16.840.1.113883.6.96', 'Undetermined manner of death, suicide suspected (event)');
        
    INSERT INTO accident_reason_snomed (accident_reason_snomed_id, code, codeSystem, displayName)
            VALUES (3, 'SCTPOCC-52684005', '1.2.276.0.76.3.1.195.5.99', 'Verdacht auf Gewaltverbrechen');