Implement Activity Logging System

[Christiantyemele]

Description

Create an activity logging system that tracks all important actions in the application (create, update, delete) for auditing and notification purposes.

Tasks

• Create activity logs API route (/api/activity-logs)
• Implement automatic logging on project CRUD operations
• Implement automatic logging on task CRUD operations
• Implement automatic logging on comment CRUD operations
• Create activity feed component for dashboard
• Add activity log filtering by entity type and user
• Implement activity log metadata storage (JSON)
• Add activity timestamps and user attribution

Database Schema

The activity_logs table already exists with:

• action - The type of action performed
• entity_type - The type of entity affected
• entity_id - The ID of the entity affected
• metadata - JSON field for additional context
• user_id, project_id, task_id - Associations

Acceptance Criteria

• All CRUD operations automatically create activity log entries
• Activity logs are viewable in the dashboard
• Logs include proper metadata about what changed
• Users can filter activity logs by entity and date range
• Activity logs are properly secured with RLS