make sure uniqueness take into account soft-deleted items

[migmartri]

We have a DB contraint in workflow and contracts that makes the name of those unique. Some of those entities have soft-deletion. We need to make sure soft-deletion doesn't get on the way of adding new items.