--ABS-169186
ALTER TABLE ERP_I_WEARER
  DROP CONSTRAINT CHK_ERP_I_WEARER_SEX;
ALTER TABLE ERP_I_WEARER
  ADD CONSTRAINT CHK_ERP_I_WEARER_SEX
  CHECK (SEX IN ('F','M','X','T','I','S','U','N'));

COMMENT ON COLUMN ERP_I_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';
