https://www.projects.openhealthtools.org/integration/viewvc/viewvc.cgi/trunk/OpenPIXPDQ/conf/create_database_schema.sql?root=openpixpdq&system=exsy1002&view=markup

gender.sql

CREATE TABLE gender (
	    gender_cd integer NOT NULL,
	    gender_name varchar(64) NOT NULL,
	    gender_description varchar(255),
	    gender_code varchar(64) NOT NULL
) WITHOUT OIDS;

insert into gender (gender_cd, gender_name, gender_description, gender_code) values (1, 'Female', 'Female', 'F');
insert into gender (gender_cd, gender_name, gender_description, gender_code) values (2, 'Male', 'Male', 'M');
insert into gender (gender_cd, gender_name, gender_description, gender_code) values (3, 'Other', 'Other', 'O');
insert into gender (gender_cd, gender_name, gender_description, gender_code) values (4, 'Unknown', 'Unknown', 'U');