--DROP TABLE AdministrativeGender CASCADE; CREATE TABLE AdministrativeGender ( AdministrativeGender_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO AdministrativeGender (AdministrativeGender_id, code, codeSystem, displayName) VALUES (1, 'F', '2.16.840.1.113883.5.1', 'Female'); INSERT INTO AdministrativeGender (AdministrativeGender_id, code, codeSystem, displayName) VALUES (2, 'M', '2.16.840.1.113883.5.1', 'Male'); INSERT INTO AdministrativeGender (AdministrativeGender_id, code, codeSystem, displayName) VALUES (3, 'UN', '2.16.840.1.113883.5.1', 'Undifferentiated'); --DROP TABLE AdministrativeGender CASCADE; CREATE TABLE AdministrativeGender ( AdministrativeGender_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO AdministrativeGender (AdministrativeGender_id, code, codeSystem, displayName) VALUES (1, 'F', '2.16.840.1.113883.5.1', 'Female'); INSERT INTO AdministrativeGender (AdministrativeGender_id, code, codeSystem, displayName) VALUES (2, 'M', '2.16.840.1.113883.5.1', 'Male'); INSERT INTO AdministrativeGender (AdministrativeGender_id, code, codeSystem, displayName) VALUES (3, 'UN', '2.16.840.1.113883.5.1', 'Undifferentiated');