Test multi-key uniqueness validations in database

Before this commit, testing that the compound key [name, email] was
unique would pass even if name and email were each globally unique.

[#54079455]
Remove the redundant tests for uniqueness at api level

[#54079455]