--DROP TABLE IVR_VS_respirationObservation CASCADE; CREATE TABLE IVR_VS_respirationObservation ( IVR_VS_respirationObservation_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_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (1, '1023001', '2.16.840.1.113883.6.96', 'Apnea'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (2, '267036007', '2.16.840.1.113883.6.96', 'Dyspnea'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (3, '86684002', '2.16.840.1.113883.6.96', 'Bradypnea'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (4, '271823003', '2.16.840.1.113883.6.96', 'Tachypnea'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (5, '23141003', '2.16.840.1.113883.6.96', 'Gasping respiration'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (6, '3415004', '2.16.840.1.113883.6.96', 'Cyanosis'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (7, '221360009', '2.16.840.1.113883.6.96', 'Spasticity'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (8, '1000075', '2.16.756.5.30.1.143.5.1', 'Stridor links'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (9, '100076', '2.16.756.5.30.1.143.5.1', 'Stridor rechts'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (10, '44416002', '2.16.840.1.113883.6.96', 'Airway constriction'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (11, '58840004', '2.16.840.1.113883.6.96', 'Decreased breath sounds'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (12, '65949001', '2.16.840.1.113883.6.96', 'Increased breath sounds'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (13, '1000077', '2.16.756.5.30.1.143.5.1', 'Respiratory crackles left'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (14, '1000078', '2.16.756.5.30.1.143.5.1', 'Respiratory crackles right'); INSERT INTO IVR_VS_respirationObservation (IVR_VS_respirationObservation_id, code, codeSystem, displayName) VALUES (15, '371820004', '2.16.840.1.113883.6.96', 'Patient ventilated');