Email Column Has unique=True, but Soft Deletes Create Ambiguity
File: user.py:42
The email column has a hard UNIQUE constraint, but soft-deleted users retain their email. This means:
A user who erases their account permanently blocks that email from re-registration
The composite index ix_users_email_deleted_at exists but the UNIQUE constraint doesn't leverage it
Email Column Has unique=True, but Soft Deletes Create Ambiguity
File: user.py:42
The email column has a hard UNIQUE constraint, but soft-deleted users retain their email. This means:
A user who erases their account permanently blocks that email from re-registration
The composite index ix_users_email_deleted_at exists but the UNIQUE constraint doesn't leverage it