voc-1.2.276.0.76.11.41-2024-02-14T094248.sql

    --DROP TABLE transportmethod CASCADE;
    CREATE TABLE transportmethod (
            transportmethod_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO transportmethod (transportmethod_id, code, codeSystem, displayName)
            VALUES (1, '73957001', '2.16.840.1.113883.6.96', 'Air transport ambulance, device (physical object)');
        
    INSERT INTO transportmethod (transportmethod_id, code, codeSystem, displayName)
            VALUES (2, '44613004', '2.16.840.1.113883.6.96', 'Ground transport ambulance (physical object)');
        
    INSERT INTO transportmethod (transportmethod_id, code, codeSystem, displayName)
            VALUES (3, '260413007', '2.16.840.1.113883.6.96', 'None (qualifier value)');
        
    INSERT INTO transportmethod (transportmethod_id, code, codeSystem, displayName)
            VALUES (4, '74964007', '2.16.840.1.113883.6.96', 'Other (qualifier value)');