--DROP TABLE x_InformationRecipientRole CASCADE; CREATE TABLE x_InformationRecipientRole ( x_InformationRecipientRole_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO x_InformationRecipientRole (x_InformationRecipientRole_id, code, codeSystem, displayName) VALUES (1, 'ASSIGNED', '2.16.840.1.113883.5.110', 'assigned entity'); INSERT INTO x_InformationRecipientRole (x_InformationRecipientRole_id, code, codeSystem, displayName) VALUES (2, 'CAREGIVER', '2.16.840.1.113883.5.110', 'caregiver'); INSERT INTO x_InformationRecipientRole (x_InformationRecipientRole_id, code, codeSystem, displayName) VALUES (3, 'GUAR', '2.16.840.1.113883.5.110', 'guarantor GuarantorRole'); INSERT INTO x_InformationRecipientRole (x_InformationRecipientRole_id, code, codeSystem, displayName) VALUES (4, 'PROV', '2.16.840.1.113883.5.110', 'healthcare provider'); INSERT INTO x_InformationRecipientRole (x_InformationRecipientRole_id, code, codeSystem, displayName) VALUES (5, 'PRS', '2.16.840.1.113883.5.110', 'personal relationship');