--DROP TABLE IVR_VS_ambulanceType CASCADE; CREATE TABLE IVR_VS_ambulanceType ( IVR_VS_ambulanceType_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_ambulanceType (IVR_VS_ambulanceType_id, code, codeSystem, displayName) VALUES (1, '83887000', '2.16.840.1.113883.6.96', 'Rescue vehicle'); INSERT INTO IVR_VS_ambulanceType (IVR_VS_ambulanceType_id, code, codeSystem, displayName) VALUES (2, '465341007', '2.16.840.1.113883.6.96', 'Automobile ambulance'); INSERT INTO IVR_VS_ambulanceType (IVR_VS_ambulanceType_id, code, codeSystem, displayName) VALUES (3, '55121009', '2.16.840.1.113883.6.96', 'Light land transport vehicle'); INSERT INTO IVR_VS_ambulanceType (IVR_VS_ambulanceType_id, code, codeSystem, displayName) VALUES (4, '469233002', '2.16.840.1.113883.6.96', 'Helicopter ambulance'); INSERT INTO IVR_VS_ambulanceType (IVR_VS_ambulanceType_id, code, codeSystem, displayName) VALUES (5, '73957001', '2.16.840.1.113883.6.96', ' Air transport ambulance');