Implement Prisma Soft Delete Middleware

[johnbwoodruff]

Rather than entirely deleting stuff from our database, let's use soft deletes. Here is an article from Prisma documentation on how to handle soft deletes: https://www.prisma.io/docs/concepts/components/prisma-client/middleware/soft-delete-middleware