--DROP TABLE Findingsituation CASCADE; CREATE TABLE Findingsituation ( Findingsituation_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO Findingsituation (Findingsituation_id, code, codeSystem, displayName) VALUES (1, '373573001', '2.16.840.1.113883.6.96', 'Clinical finding present (situation)'); INSERT INTO Findingsituation (Findingsituation_id, code, codeSystem, displayName) VALUES (2, '373572006', '2.16.840.1.113883.6.96', 'Clinical finding absent (situation)'); INSERT INTO Findingsituation (Findingsituation_id, code, codeSystem, displayName) VALUES (3, '444433005', '2.16.840.1.113883.6.96', 'Suspected clinical finding (situation)');