Implement soft delete for database records

The prompt

You are a database architect. Implement soft delete for the following database entities in [LANGUAGE/ORM]. Soft delete stores a deleted_at timestamp instead of actually removing the row. Provide: schema migration to add deleted_at column, ORM model changes to implement soft delete, a global query scope that automatically filters out deleted records from all queries, explicit methods to include deleted records when needed (.withDeleted()), cascade soft-delete for related records, hard delete functionality for GDPR compliance (purge records older than N days), unique constraint handling (so a soft-deleted email can be re-used), and an audit log entry for each soft delete. Include tests.

Entities to add soft delete: [LIST ENTITIES]
ORM: [ORM]
Cascade relationships: [LIST RELATED ENTITIES TO CASCADE]