--DROP TABLE IVR_VS_missionTimeRole CASCADE; CREATE TABLE IVR_VS_missionTimeRole ( IVR_VS_missionTimeRole_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (1, '1000033', '2.16.756.5.30.1.143.5.1', 'alarm'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (2, '1000034', '2.16.756.5.30.1.143.5.1', 'disposition'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (3, '1000035', '2.16.756.5.30.1.143.5.1', 'rollout'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (4, '1000036', '2.16.756.5.30.1.143.5.1', 'arrival on scene'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (5, '1000037', '2.16.756.5.30.1.143.5.1', 'arrival patient'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (6, '1000038', '2.16.756.5.30.1.143.5.1', 'departure from scene'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (7, '1000039', '2.16.756.5.30.1.143.5.1', 'arrival at target'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (8, '1000040', '2.16.756.5.30.1.143.5.1', 'handover patient'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (9, '1000041', '2.16.756.5.30.1.143.5.1', 'departure from target'); INSERT INTO IVR_VS_missionTimeRole (IVR_VS_missionTimeRole_id, code, codeSystem, displayName) VALUES (10, '1000042', '2.16.756.5.30.1.143.5.1', 'operational readiness');