← BackSQL

voc-1.2.276.0.76.3.1.195.11.3-2024-02-14T115917.sql

Download
    --DROP TABLE complaint_dynamics CASCADE;
    CREATE TABLE complaint_dynamics (
            complaint_dynamics_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO complaint_dynamics (complaint_dynamics_id, code, codeSystem, displayName)
            VALUES (1, '263730007', '2.16.840.1.113883.6.96', 'Continual (qualifier value)');
        
    INSERT INTO complaint_dynamics (complaint_dynamics_id, code, codeSystem, displayName)
            VALUES (2, '255314001', '2.16.840.1.113883.6.96', 'Progressive (qualifier value)');
        
    INSERT INTO complaint_dynamics (complaint_dynamics_id, code, codeSystem, displayName)
            VALUES (3, '37865006', '2.16.840.1.113883.6.96', 'Regressive (qualifier value)');
        
    INSERT INTO complaint_dynamics (complaint_dynamics_id, code, codeSystem, displayName)
            VALUES (4, '103338009', '2.16.840.1.113883.6.96', 'In full remission (qualifier value)');
        
    INSERT INTO complaint_dynamics (complaint_dynamics_id, code, codeSystem, displayName)
            VALUES (5, '255341006', '2.16.840.1.113883.6.96', 'Fluctuating (qualifier value)');
        
    INSERT INTO complaint_dynamics (complaint_dynamics_id, code, codeSystem, displayName)
            VALUES (6, '7087005', '2.16.840.1.113883.6.96', 'Intermittent (qualifier value)');