voc-1.2.276.0.76.3.1.195.11.2-2024-02-14T112351.sql

    --DROP TABLE patient_escort CASCADE;
    CREATE TABLE patient_escort (
            patient_escort_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO patient_escort (patient_escort_id, code, codeSystem, displayName)
            VALUES (1, '715933006', '2.16.840.1.113883.6.96', 'Provision of medical patient escort (procedure)');
        
    INSERT INTO patient_escort (patient_escort_id, code, codeSystem, displayName)
            VALUES (2, '1156336002', '2.16.840.1.113883.6.96', 'Escorting subject of care (procedure)');