--DROP TABLE smoking_status CASCADE; CREATE TABLE smoking_status ( smoking_status_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO smoking_status (smoking_status_id, code, codeSystem, displayName) VALUES (1, 'LA18976-3', '2.16.840.1.113883.6.1', 'Current every day smoker'); INSERT INTO smoking_status (smoking_status_id, code, codeSystem, displayName) VALUES (2, 'LA18978-9', '2.16.840.1.113883.6.1', 'Never smoker'); INSERT INTO smoking_status (smoking_status_id, code, codeSystem, displayName) VALUES (3, 'LA18980-5', '2.16.840.1.113883.6.1', 'Unknown if ever smoked'); INSERT INTO smoking_status (smoking_status_id, code, codeSystem, displayName) VALUES (4, 'LA15920-4', '2.16.840.1.113883.6.1', 'Former smoker');