--DROP TABLE ParticipationSignature CASCADE; CREATE TABLE ParticipationSignature ( ParticipationSignature_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ParticipationSignature (ParticipationSignature_id, code, codeSystem, displayName) VALUES (1, 'I', '2.16.840.1.113883.5.89', 'intended'); INSERT INTO ParticipationSignature (ParticipationSignature_id, code, codeSystem, displayName) VALUES (2, 'S', '2.16.840.1.113883.5.89', 'signed'); INSERT INTO ParticipationSignature (ParticipationSignature_id, code, codeSystem, displayName) VALUES (3, 'X', '2.16.840.1.113883.5.89', 'required');