--DROP TABLE ELGA_TimingEvent CASCADE; CREATE TABLE ELGA_TimingEvent ( ELGA_TimingEvent_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (1, 'AC', '2.16.840.1.113883.5.139', 'AC'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (2, 'ACD', '2.16.840.1.113883.5.139', 'ACD'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (3, 'ACM', '2.16.840.1.113883.5.139', 'ACM'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (4, 'ACV', '2.16.840.1.113883.5.139', 'ACV'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (5, 'HS', '2.16.840.1.113883.5.139', 'HS'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (6, 'IC', '2.16.840.1.113883.5.139', 'IC'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (7, 'ICD', '2.16.840.1.113883.5.139', 'ICD'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (8, 'ICM', '2.16.840.1.113883.5.139', 'ICM'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (9, 'ICV', '2.16.840.1.113883.5.139', 'ICV'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (10, 'PC', '2.16.840.1.113883.5.139', 'PC'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (11, 'PCD', '2.16.840.1.113883.5.139', 'PCD'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (12, 'PCM', '2.16.840.1.113883.5.139', 'PCM'); INSERT INTO ELGA_TimingEvent (ELGA_TimingEvent_id, code, codeSystem, displayName) VALUES (13, 'PCV', '2.16.840.1.113883.5.139', 'PCV');