--ABS-146625

--GDTRANSACTION TABLE
COMMENT ON COLUMN GDTRANSACTION.SEX IS 'M = Male F = Female X = Non-binary T = Transgender I = Intersex S = Let me specify U = I prefer not to say N = Not known';

--WEARER TABLE
ALTER TABLE WEARER MODIFY SEX DEFAULT 'N';
COMMENT ON COLUMN WEARER.SEX IS 'M = Male F = Female X = Non-binary T = Transgender I = Intersex S = Let me specify U = I prefer not to say N = Not known';

ALTER TABLE WEARER DROP CONSTRAINT CHK_WEARER_SEX;
                                
ALTER TABLE WEARER
  ADD CONSTRAINT CHK_WEARER_SEX
  CHECK (SEX IN ('F','M','X','T','I','S','U','N'));
