--DROP TABLE DocumentEntry.sourcePatientInfo.PID_8 CASCADE; CREATE TABLE DocumentEntry.sourcePatientInfo.PID_8 ( DocumentEntry.sourcePatientInfo.PID_8_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO DocumentEntry.sourcePatientInfo.PID_8 (DocumentEntry.sourcePatientInfo.PID_8_id, code, codeSystem, displayName) VALUES (1, 'female', '2.16.840.1.113883.4.642.1.2', 'Female'); INSERT INTO DocumentEntry.sourcePatientInfo.PID_8 (DocumentEntry.sourcePatientInfo.PID_8_id, code, codeSystem, displayName) VALUES (2, 'male', '2.16.840.1.113883.4.642.1.2', 'Male'); INSERT INTO DocumentEntry.sourcePatientInfo.PID_8 (DocumentEntry.sourcePatientInfo.PID_8_id, code, codeSystem, displayName) VALUES (3, 'other', '2.16.840.1.113883.4.642.1.2', 'Other'); INSERT INTO DocumentEntry.sourcePatientInfo.PID_8 (DocumentEntry.sourcePatientInfo.PID_8_id, code, codeSystem, displayName) VALUES (4, 'unknown', '2.16.840.1.113883.4.642.1.2', 'Unknown');