--DROP TABLE eCH0207_Airway CASCADE; CREATE TABLE eCH0207_Airway ( eCH0207_Airway_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO eCH0207_Airway (eCH0207_Airway_id, code, codeSystem, displayName) VALUES (1, '248553004', '2.16.840.1.113883.6.96', 'No obstruction of airway '); INSERT INTO eCH0207_Airway (eCH0207_Airway_id, code, codeSystem, displayName) VALUES (2, '710971000', '2.16.840.1.113883.6.96', 'Maintaining clear airway'); INSERT INTO eCH0207_Airway (eCH0207_Airway_id, code, codeSystem, displayName) VALUES (3, '230040009', '2.16.840.1.113883.6.96', 'Airway suctioning'); INSERT INTO eCH0207_Airway (eCH0207_Airway_id, code, codeSystem, displayName) VALUES (4, '706177004', '2.16.840.1.113883.6.96', 'Inhalation therapy device '); INSERT INTO eCH0207_Airway (eCH0207_Airway_id, code, codeSystem, displayName) VALUES (5, '74964007', '2.16.840.1.113883.6.96', 'Other');