Soft Delete Implementation Pattern

Implement soft delete for:

Database: [PostgreSQL/MySQL/MongoDB]
ORM: [Prisma/TypeORM/Sequelize/etc.]
Tables/Collections: [LIST ENTITIES]

Requirements:
- Recovery period: [DAYS BEFORE PERMANENT DELETE]
- Cascade behavior: [HOW TO HANDLE RELATED DATA]
- Query transparency: [AUTOMATIC FILTERING]

Please provide:
1. Schema changes for soft delete
2. ORM/query middleware for automatic filtering
3. Soft delete trigger/function
4. Recovery procedures
5. Permanent deletion job (cleanup)
6. Audit trail integration