--DROP TABLE ELGA_ParticipationFunctionCode CASCADE; CREATE TABLE ELGA_ParticipationFunctionCode ( ELGA_ParticipationFunctionCode_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_ParticipationFunctionCode (ELGA_ParticipationFunctionCode_id, code, codeSystem, displayName) VALUES (1, 'PCP', '2.16.840.1.113883.5.88', 'primary care physician');