← BackSQL

cs-1.2.276.0.76.3.1.195.5.60-2019-08-15T000000.sql

Download
        --DROP TABLE other_triage_systems CASCADE;
        CREATE TABLE other_triage_systems (
            other_triage_systems_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL,
            statusCode varchar(255),
            effectiveDate varchar(255),
            expirationDate varchar(255),
            officialReleaseDate varchar(255),
        );
        
            INSERT INTO other_triage_systems (other_triage_systems_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (1, 'smed', '1.2.276.0.76.3.1.195.5.60', 'SmED', 'active', '2019-08-15T00:00:00', '', '');