--DROP TABLE eCH0207_bedding CASCADE; CREATE TABLE eCH0207_bedding ( eCH0207_bedding_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (1, '1000101', '2.16.756.5.30.1.143.5.1', 'seated'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (2, '1000102', '2.16.756.5.30.1.143.5.1', 'partly lying'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (3, '1000103', '2.16.756.5.30.1.143.5.1', 'laying'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (4, '1000104', '2.16.756.5.30.1.143.5.1', 'legs up'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (5, '1000105', '2.16.756.5.30.1.143.5.1', 'legs down'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (6, '1000106', '2.16.756.5.30.1.143.5.1', 'knee kick'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (7, '1000107', '2.16.756.5.30.1.143.5.1', 'abdominal position'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (8, '1000108', '2.16.756.5.30.1.143.5.1', 'side position left'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (9, '1000109', '2.16.756.5.30.1.143.5.1', 'side position right'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (10, '423212001', '2.16.840.1.113883.6.96', 'Trendelenburg positioning'); INSERT INTO eCH0207_bedding (eCH0207_bedding_id, code, codeSystem, displayName) VALUES (11, '74964007', '2.16.840.1.113883.6.96', 'Other');