--DROP TABLE SpecialCaseAllergiesIntolerances CASCADE; CREATE TABLE SpecialCaseAllergiesIntolerances ( SpecialCaseAllergiesIntolerances_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO SpecialCaseAllergiesIntolerances (SpecialCaseAllergiesIntolerances_id, code, codeSystem, displayName) VALUES (1, '64970000', '2.16.840.1.113883.6.96', 'Substance Type Unknown'); INSERT INTO SpecialCaseAllergiesIntolerances (SpecialCaseAllergiesIntolerances_id, code, codeSystem, displayName) VALUES (2, '160244002', '2.16.840.1.113883.6.96', 'No Known Allergies'); INSERT INTO SpecialCaseAllergiesIntolerances (SpecialCaseAllergiesIntolerances_id, code, codeSystem, displayName) VALUES (3, '409137002', '2.16.840.1.113883.6.96', 'No Known Drug Allergies');