← BackSQL

cs-1.2.276.0.76.3.1.195.5.105-2025-05-26T155050.sql

Download
        --DROP TABLE ConditionCategory CASCADE;
        CREATE TABLE ConditionCategory (
            ConditionCategory_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 ConditionCategory (ConditionCategory_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (1, 'presenting-complaint', '1.2.276.0.76.3.1.195.5.105', 'Presenting Complaint', 'draft', '', '', '');