--DROP TABLE SpecialCaseMedication CASCADE; CREATE TABLE SpecialCaseMedication ( SpecialCaseMedication_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO SpecialCaseMedication (SpecialCaseMedication_id, code, codeSystem, displayName) VALUES (1, '182904002', '2.16.840.1.113883.6.96', 'Drug Treatment Unknown'); INSERT INTO SpecialCaseMedication (SpecialCaseMedication_id, code, codeSystem, displayName) VALUES (2, '182849000', '2.16.840.1.113883.6.96', 'No Drug Therapy Prescribed'); INSERT INTO SpecialCaseMedication (SpecialCaseMedication_id, code, codeSystem, displayName) VALUES (3, '408350003', '2.16.840.1.113883.6.96', 'Patient Not On Self-Medications'); INSERT INTO SpecialCaseMedication (SpecialCaseMedication_id, code, codeSystem, displayName) VALUES (4, '406149000', '2.16.840.1.113883.6.96', 'Medication refused, Patient Objective');