← BackSQL

voc-1.2.276.0.76.3.1.195.11.12-2024-07-22T152032.sql

Download
    --DROP TABLE used_triage_system CASCADE;
    CREATE TABLE used_triage_system (
            used_triage_system_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO used_triage_system (used_triage_system_id, code, codeSystem, displayName)
            VALUES (1, '713009001', '2.16.840.1.113883.6.96', 'Manchester Triage System (assessment scale)');
        
    INSERT INTO used_triage_system (used_triage_system_id, code, codeSystem, displayName)
            VALUES (2, '713010006', '2.16.840.1.113883.6.96', 'Emergency Severity Index (assessment scale)');
        
    INSERT INTO used_triage_system (used_triage_system_id, code, codeSystem, displayName)
            VALUES (3, 'smed', '1.2.276.0.76.3.1.195.5.60', 'SmED');
        
    INSERT INTO used_triage_system (used_triage_system_id, code, codeSystem, displayName)
            VALUES (4, '74964007', '2.16.840.1.113883.6.96', 'Other (qualifier value)');
        
    INSERT INTO used_triage_system (used_triage_system_id, code, codeSystem, displayName)
            VALUES (5, '260413007', '2.16.840.1.113883.6.96', 'None (qualifier value)');