One issue with soft delete, it's not compatible with unique constraints.
4 min read
5 min read
3 min read