Soft deletion: Consistency and migration
Introduces soft-delete flags/filters with backfill and unique-index adjustments so deleted rows stop colliding with live uniqueness.
Requires destructive confirmations to identify the target and consequence, follow accessible modal keyboard behavior, and use stronger confirmation profiles only when risk warrants them.