--DROP TABLE eHDSIActStatusActiveAbortedSuspendedCompleted CASCADE; CREATE TABLE eHDSIActStatusActiveAbortedSuspendedCompleted ( eHDSIActStatusActiveAbortedSuspendedCompleted_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO eHDSIActStatusActiveAbortedSuspendedCompleted (eHDSIActStatusActiveAbortedSuspendedCompleted_id, code, codeSystem, displayName) VALUES (1, 'aborted', '2.16.840.1.113883.5.14', 'aborted'); INSERT INTO eHDSIActStatusActiveAbortedSuspendedCompleted (eHDSIActStatusActiveAbortedSuspendedCompleted_id, code, codeSystem, displayName) VALUES (2, 'completed', '2.16.840.1.113883.5.14', 'completed'); INSERT INTO eHDSIActStatusActiveAbortedSuspendedCompleted (eHDSIActStatusActiveAbortedSuspendedCompleted_id, code, codeSystem, displayName) VALUES (3, 'active', '2.16.840.1.113883.5.14', 'active'); INSERT INTO eHDSIActStatusActiveAbortedSuspendedCompleted (eHDSIActStatusActiveAbortedSuspendedCompleted_id, code, codeSystem, displayName) VALUES (4, 'suspended', '2.16.840.1.113883.5.14', 'suspended');