Good day! I suggest that you would add compound unique constraint on a schema.
Thanks in advance!
Hello,
You can already mark more than one column in a table as unique. If this is not what you had in mind, please elaborate your idea.
Mark
What I mean is to treat compound columns as one unique key. For example, there’s a school in different cities with the same name. So it will treat school name and city as one unique constraint instead of two seperate unique constraint.
I see, thanks for clarifying. This is something that you could enforce through custom business logic (in the beforeCreate and beforeUpdate events).
Ok, will try it later. Thanks! 