--DROP TABLE DocumentEntry.author.authorRole CASCADE; CREATE TABLE DocumentEntry.author.authorRole ( DocumentEntry.author.authorRole_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO DocumentEntry.author.authorRole (DocumentEntry.author.authorRole_id, code, codeSystem, displayName) VALUES (1, 'PAT', '2.16.756.5.30.1.127.3.10.6', 'Patient'); INSERT INTO DocumentEntry.author.authorRole (DocumentEntry.author.authorRole_id, code, codeSystem, displayName) VALUES (2, 'HCP', '2.16.756.5.30.1.127.3.10.6', 'Healthcare professional'); INSERT INTO DocumentEntry.author.authorRole (DocumentEntry.author.authorRole_id, code, codeSystem, displayName) VALUES (3, 'ASS', '2.16.756.5.30.1.127.3.10.6', 'Assistant'); INSERT INTO DocumentEntry.author.authorRole (DocumentEntry.author.authorRole_id, code, codeSystem, displayName) VALUES (4, 'REP', '2.16.756.5.30.1.127.3.10.6', 'Representative'); INSERT INTO DocumentEntry.author.authorRole (DocumentEntry.author.authorRole_id, code, codeSystem, displayName) VALUES (5, 'TCU', '2.16.756.5.30.1.127.3.10.6', 'Technical user');