Implement data retention policies for inactive chatrooms #39
Description
Which feature are you enhancing?
Chatroom data retention and lifecycle management
Why is this required?
As the application scales, inactive chatrooms will accumulate and consume database resources unnecessarily. Implementing data retention policies will help maintain system performance, reduce storage costs, and ensure compliance with data minimization principles.
Any additional context?
This feature requires adding a new lastActivityAt field to the Chatroom model and creating a scheduled job to process inactive rooms. Consider implementing a notification system to alert room owners before deletion or archiving occurs. The retention period and action type (archive, anonymize, delete) should be configurable through admin settings.