--DROP TABLE x_ActMoodDocumentObservation CASCADE; CREATE TABLE x_ActMoodDocumentObservation ( x_ActMoodDocumentObservation_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO x_ActMoodDocumentObservation (x_ActMoodDocumentObservation_id, code, codeSystem, displayName) VALUES (1, 'DEF', '2.16.840.1.113883.5.1001', 'definition'); INSERT INTO x_ActMoodDocumentObservation (x_ActMoodDocumentObservation_id, code, codeSystem, displayName) VALUES (2, 'EVN', '2.16.840.1.113883.5.1001', 'event (occurrence)'); INSERT INTO x_ActMoodDocumentObservation (x_ActMoodDocumentObservation_id, code, codeSystem, displayName) VALUES (3, 'GOL', '2.16.840.1.113883.5.1001', 'Goal'); INSERT INTO x_ActMoodDocumentObservation (x_ActMoodDocumentObservation_id, code, codeSystem, displayName) VALUES (4, 'INT', '2.16.840.1.113883.5.1001', 'intent'); INSERT INTO x_ActMoodDocumentObservation (x_ActMoodDocumentObservation_id, code, codeSystem, displayName) VALUES (5, 'PRMS', '2.16.840.1.113883.5.1001', 'promise'); INSERT INTO x_ActMoodDocumentObservation (x_ActMoodDocumentObservation_id, code, codeSystem, displayName) VALUES (6, 'PRP', '2.16.840.1.113883.5.1001', 'proposal'); INSERT INTO x_ActMoodDocumentObservation (x_ActMoodDocumentObservation_id, code, codeSystem, displayName) VALUES (7, 'RQO', '2.16.840.1.113883.5.1001', 'request');