--DROP TABLE allergyOrIntollerance_VS CASCADE; CREATE TABLE allergyOrIntollerance_VS ( allergyOrIntollerance_VS_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO allergyOrIntollerance_VS (allergyOrIntollerance_VS_id, code, codeSystem, displayName) VALUES (1, 'OINT', '2.16.840.1.113883.5.4', 'Allergy or Intolerance'); INSERT INTO allergyOrIntollerance_VS (allergyOrIntollerance_VS_id, code, codeSystem, displayName) VALUES (2, 'allergy', '2.16.840.1.113883.4.642.1.122', 'Allergy'); INSERT INTO allergyOrIntollerance_VS (allergyOrIntollerance_VS_id, code, codeSystem, displayName) VALUES (3, 'intolerance', '2.16.840.1.113883.4.642.1.122', 'Intolerance');