--DROP TABLE x_DocumentSubject CASCADE; CREATE TABLE x_DocumentSubject ( x_DocumentSubject_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO x_DocumentSubject (x_DocumentSubject_id, code, codeSystem, displayName) VALUES (1, 'PAT', '2.16.840.1.113883.5.110', 'patient'); INSERT INTO x_DocumentSubject (x_DocumentSubject_id, code, codeSystem, displayName) VALUES (2, 'PRS', '2.16.840.1.113883.5.110', 'personal relationship');