- Unique constraints. A deleted user still "uses" their username. Use a partial unique index (`where deleted_at is null`).
- Every query must filter deleted rows. Miss one, and deleted data shows up in a report or API response.
- Foreign keys. What happens to orders that belong to a soft-deleted customer?
- Real deletion. Privacy laws may require you to actually erase data, so soft delete can't be the only option.
- Restoring. What if the username was taken again while the old account was deleted?
Do you use soft delete, or did you move to archive tables instead?