Explore strategies for soft deletion of database records
Consider if there are ways we could add some kind of "Universal" soft delete feature that would pick up and save deletes automatically across the entire database.
We will evaluate if a general single solution to soft-deletes is possible for the entire database.
If a single solution is possible, we will develop a POC for it.
If, while architecting a single solution or during the POC, we decide that a single soft-delete solution is impossible, we will instead develop a pattern for teams
to implement their own soft-deletes for each feature.
### Deliverables
- [ ] Gather requirements for soft-deletes -- what restoration timelines do we need to support? How automatic does the restoration need to be?
- [ ] Build a POC for universal soft deletes (or decide that it is impossible)
- [ ] Either commit to the POC or write documentation for team-level soft-deletes.
epic