--DROP TABLE ELGA_InformationRecipientType CASCADE; CREATE TABLE ELGA_InformationRecipientType ( ELGA_InformationRecipientType_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_InformationRecipientType (ELGA_InformationRecipientType_id, code, codeSystem, displayName) VALUES (1, 'PRCP', '2.16.840.1.113883.5.90', 'primary information recipient'); INSERT INTO ELGA_InformationRecipientType (ELGA_InformationRecipientType_id, code, codeSystem, displayName) VALUES (2, 'TRC', '2.16.840.1.113883.5.90', 'tracker');