SQL
Soft delete with a partial unique index
Keep deleted rows but still enforce unique emails among active rows using a partial unique index.
#Schema Design
Loading snippets…
Loading snippets…
1 snippet
Keep deleted rows but still enforce unique emails among active rows using a partial unique index.