Database TestingDatabaseIntermediate
Soft delete behavior
Scenario
A project management app soft-deletes projects by setting deletedAt and deletedBy instead of removing rows. Deleted projects should disappear from normal lists, remain visible in admin recovery views, and be restorable for 30 days.
List checks, risks, edge cases, data conditions, and user experience concerns you would cover.