--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', '', '', '');