--DROP TABLE ActStatusAbortedCancelledCompleted CASCADE; CREATE TABLE ActStatusAbortedCancelledCompleted ( ActStatusAbortedCancelledCompleted_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActStatusAbortedCancelledCompleted (ActStatusAbortedCancelledCompleted_id, code, codeSystem, displayName) VALUES (1, 'aborted', '2.16.840.1.113883.5.14', 'aborted'); INSERT INTO ActStatusAbortedCancelledCompleted (ActStatusAbortedCancelledCompleted_id, code, codeSystem, displayName) VALUES (2, 'cancelled', '2.16.840.1.113883.5.14', 'cancelled'); INSERT INTO ActStatusAbortedCancelledCompleted (ActStatusAbortedCancelledCompleted_id, code, codeSystem, displayName) VALUES (3, 'completed', '2.16.840.1.113883.5.14', 'completed'); --DROP TABLE ActStatusAbortedCancelledCompleted CASCADE; CREATE TABLE ActStatusAbortedCancelledCompleted ( ActStatusAbortedCancelledCompleted_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ActStatusAbortedCancelledCompleted (ActStatusAbortedCancelledCompleted_id, code, codeSystem, displayName) VALUES (1, 'aborted', '2.16.840.1.113883.5.14', 'aborted'); INSERT INTO ActStatusAbortedCancelledCompleted (ActStatusAbortedCancelledCompleted_id, code, codeSystem, displayName) VALUES (2, 'cancelled', '2.16.840.1.113883.5.14', 'cancelled'); INSERT INTO ActStatusAbortedCancelledCompleted (ActStatusAbortedCancelledCompleted_id, code, codeSystem, displayName) VALUES (3, 'completed', '2.16.840.1.113883.5.14', 'completed');