← BackSQL

voc-1.2.276.0.76.3.1.195.11.11-2024-07-22T145250.sql

Download
    --DROP TABLE generic_5level_triage_system CASCADE;
    CREATE TABLE generic_5level_triage_system (
            generic_5level_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 generic_5level_triage_system (generic_5level_triage_system_id, code, codeSystem, displayName)
            VALUES (1, 'LA21538-6', '2.16.840.1.113883.6.1', 'Resuscitation');
        
    INSERT INTO generic_5level_triage_system (generic_5level_triage_system_id, code, codeSystem, displayName)
            VALUES (2, 'LA19759-2', '2.16.840.1.113883.6.1', 'Emergent');
        
    INSERT INTO generic_5level_triage_system (generic_5level_triage_system_id, code, codeSystem, displayName)
            VALUES (3, 'LA21544-4', '2.16.840.1.113883.6.1', 'Urgent');
        
    INSERT INTO generic_5level_triage_system (generic_5level_triage_system_id, code, codeSystem, displayName)
            VALUES (4, 'LA21587-3', '2.16.840.1.113883.6.1', 'Less urgent');
        
    INSERT INTO generic_5level_triage_system (generic_5level_triage_system_id, code, codeSystem, displayName)
            VALUES (5, 'LA21545-1', '2.16.840.1.113883.6.1', 'Nonurgent');