Unique element for multiple schemas
<p>I have same table (User) in another schemas.
One schema - for one tenant.
User has unique email.
How to set email field like unique for all schemas?</p>

<p>And if this is impossible, can I get all users from another schemas per one hql query?</p>