--DROP TABLE ProblemTypeCode CASCADE; CREATE TABLE ProblemTypeCode ( ProblemTypeCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ProblemTypeCode (ProblemTypeCode_id, code, codeSystem, displayName) VALUES (1, '64572001', '2.16.840.1.113883.6.96', 'Condition'); INSERT INTO ProblemTypeCode (ProblemTypeCode_id, code, codeSystem, displayName) VALUES (2, '418799008', '2.16.840.1.113883.6.96', 'Symptom'); INSERT INTO ProblemTypeCode (ProblemTypeCode_id, code, codeSystem, displayName) VALUES (3, '404684003', '2.16.840.1.113883.6.96', 'Finding'); INSERT INTO ProblemTypeCode (ProblemTypeCode_id, code, codeSystem, displayName) VALUES (4, '409586006', '2.16.840.1.113883.6.96', 'Complaint'); INSERT INTO ProblemTypeCode (ProblemTypeCode_id, code, codeSystem, displayName) VALUES (5, '248536006', '2.16.840.1.113883.6.96', 'Functional limitation'); INSERT INTO ProblemTypeCode (ProblemTypeCode_id, code, codeSystem, displayName) VALUES (6, '55607006', '2.16.840.1.113883.6.96', 'Problem'); INSERT INTO ProblemTypeCode (ProblemTypeCode_id, code, codeSystem, displayName) VALUES (7, '282291009', '2.16.840.1.113883.6.96', 'Diagnosis');