--DROP TABLE IVR_VS_symptom CASCADE; CREATE TABLE IVR_VS_symptom ( IVR_VS_symptom_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_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (1, '1000055', '2.16.756.5.30.1.143.5.1', 'not asked'); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (2, '1000058', '2.16.756.5.30.1.143.5.1', 'no information'); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (3, '1000057', '2.16.756.5.30.1.143.5.1', 'see attachment'); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (4, '24199005', '2.16.840.1.113883.6.96', 'Agitation'); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (5, '267036007', '2.16.840.1.113883.6.96', 'Dyspnea '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (6, '418107008', '2.16.840.1.113883.6.96', ' Unconsciousness '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (7, '131148009', '2.16.840.1.113883.6.96', 'Bleeding '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (8, '62315008', '2.16.840.1.113883.6.96', 'Diarrhea '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (9, '422400008', '2.16.840.1.113883.6.96', 'Vomiting '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (10, '386661006', '2.16.840.1.113883.6.96', 'Fever '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (11, '3424008', '2.16.840.1.113883.6.96', 'Tachycardia'); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (12, '418363000', '2.16.840.1.113883.6.96', 'Pruritus'); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (13, '91175000', '2.16.840.1.113883.6.96', 'Seizure '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (14, '44695005', '2.16.840.1.113883.6.96', 'Paralysis '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (15, '80313002', '2.16.840.1.113883.6.96', 'Palpitations '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (16, '21522001', '2.16.840.1.113883.6.96', 'Abdominal pain '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (17, '29857009', '2.16.840.1.113883.6.96', 'Chest pain '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (18, '162397003', '2.16.840.1.113883.6.96', 'Pain in throat '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (19, '25064002', '2.16.840.1.113883.6.96', 'Headache '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (20, '16001004', '2.16.840.1.113883.6.96', 'Otalgia '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (21, '161891005', '2.16.840.1.113883.6.96', 'Backache '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (22, '27355003', '2.16.840.1.113883.6.96', 'Toothache '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (23, '399153001', '2.16.840.1.113883.6.96', 'Vertigo '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (24, '271594007', '2.16.840.1.113883.6.96', 'Syncope'); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (25, '247412007', '2.16.840.1.113883.6.96', 'Childbirth pain'); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (26, '422587007', '2.16.840.1.113883.6.96', ' Nausea '); INSERT INTO IVR_VS_symptom (IVR_VS_symptom_id, code, codeSystem, displayName) VALUES (27, '22253000', '2.16.840.1.113883.6.96', 'Pain ');