In one of our APS applications, we have two services that have an email address field. They are defined as type=“email”, class=“email-on-application-domain”, and both have the same uuid. PA ensures uniqueness, but only in a case-sensitive manner. Obviously, when it comes to email addresses, case is irrelevant.
Is there a way to define a case-insensitive unique constraint? If not, are there any plans to create such a constraint type? I would have to imagine there would be many cases (no pun intended) where such a constraint would be needed.