--DROP TABLE EprAuthorRole CASCADE; CREATE TABLE EprAuthorRole ( EprAuthorRole_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (1, '46255001', '2.16.840.1.113883.6.96', 'Pharmacist (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (2, '309343006', '2.16.840.1.113883.6.96', 'Physician (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (3, '3842006', '2.16.840.1.113883.6.96', 'Chiropractor (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (4, '159033005', '2.16.840.1.113883.6.96', 'Dietitian (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (5, '309453006', '2.16.840.1.113883.6.96', 'Registered midwife (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (6, '224609002', '2.16.840.1.113883.6.96', 'Complementary health worker (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (7, '116154003', '2.16.840.1.113883.6.96', 'Patient (person)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (8, '106292003', '2.16.840.1.113883.6.96', 'Professional nurse (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (9, '59944000', '2.16.840.1.113883.6.96', 'Psychologist (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (10, '158933003', '2.16.840.1.113883.6.96', 'Social caseworker (general) (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (11, '159026005', '2.16.840.1.113883.6.96', 'Speech/language therapist (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (12, '36682004', '2.16.840.1.113883.6.96', 'Physiotherapist (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (13, '80546007', '2.16.840.1.113883.6.96', 'Occupational therapist (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (14, '225726006', '2.16.840.1.113883.6.96', 'Lactation consultant (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (15, '106289002', '2.16.840.1.113883.6.96', 'Dentist (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (16, '66862007', '2.16.840.1.113883.6.96', 'Radiologist (occupation)'); INSERT INTO EprAuthorRole (EprAuthorRole_id, code, codeSystem, displayName) VALUES (17, '223366009', '2.16.840.1.113883.6.96', 'Healthcare professional (occupation)');