voc-1.2.276.0.76.3.1.195.11.4-2024-02-14T122629.sql

    --DROP TABLE accident_mechanism CASCADE;
    CREATE TABLE accident_mechanism (
            accident_mechanism_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO accident_mechanism (accident_mechanism_id, code, codeSystem, displayName)
            VALUES (1, '425359009', '2.16.840.1.113883.6.96', 'Blunt injury (disorder)');
        
    INSERT INTO accident_mechanism (accident_mechanism_id, code, codeSystem, displayName)
            VALUES (2, '262560006', '2.16.840.1.113883.6.96', 'Penetrating wound (disorder)');