--DROP TABLE elga_entitynamepartqualifier CASCADE; CREATE TABLE elga_entitynamepartqualifier ( elga_entitynamepartqualifier_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (1, 'VV', '2.16.840.1.113883.5.43', 'voorvoegsel'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (2, 'TITLE', '2.16.840.1.113883.5.43', 'title'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (3, 'SP', '2.16.840.1.113883.5.43', 'spouse'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (4, 'PR', '2.16.840.1.113883.5.43', 'professional'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (5, 'NB', '2.16.840.1.113883.5.43', 'nobility'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (6, 'LS', '2.16.840.1.113883.5.43', 'Legal status'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (7, 'IN', '2.16.840.1.113883.5.43', 'initial'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (8, 'CL', '2.16.840.1.113883.5.43', 'callme'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (9, 'BR', '2.16.840.1.113883.5.43', 'birth'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (10, 'AD', '2.16.840.1.113883.5.43', 'adopted'); INSERT INTO elga_entitynamepartqualifier (elga_entitynamepartqualifier_id, code, codeSystem, displayName) VALUES (11, 'AC', '2.16.840.1.113883.5.43', 'academic');