--DROP TABLE epSOSUnknownInformation CASCADE; CREATE TABLE epSOSUnknownInformation ( epSOSUnknownInformation_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO epSOSUnknownInformation (epSOSUnknownInformation_id, code, codeSystem, displayName) VALUES (1, '160245001', '2.16.840.1.113883.6.96', 'No current problems or disability'); INSERT INTO epSOSUnknownInformation (epSOSUnknownInformation_id, code, codeSystem, displayName) VALUES (2, '396782006', '2.16.840.1.113883.6.96', 'Medical history unknown'); INSERT INTO epSOSUnknownInformation (epSOSUnknownInformation_id, code, codeSystem, displayName) VALUES (3, '407559004', '2.16.840.1.113883.6.96', 'Family history unknown'); INSERT INTO epSOSUnknownInformation (epSOSUnknownInformation_id, code, codeSystem, displayName) VALUES (4, '409137002', '2.16.840.1.113883.6.96', 'No known drug allergies'); INSERT INTO epSOSUnknownInformation (epSOSUnknownInformation_id, code, codeSystem, displayName) VALUES (5, '64970000', '2.16.840.1.113883.6.96', 'Substance type unknown'); INSERT INTO epSOSUnknownInformation (epSOSUnknownInformation_id, code, codeSystem, displayName) VALUES (6, '716186003', '2.16.840.1.113883.6.96', 'No known allergy');