[BE] Trigger for activities

[mczujowski]

Background:

The "Activity" section within the "My space" feature displays a log of actions related to the user's account, such as project submissions, goal completions, or skill updates. This section should dynamically update when new user-related actions are performed.

This task aims to develop a reusable backend trigger that will automatically update the activity table whenever relevant user actions occur. This implementation will serve as the foundational step for a scalable solution, ensuring that future functions related to user activities can be easily integrated.

Requirements:

• Implement a reusable backend trigger that automatically updates the user's activity log when a user performs specific actions (e.g., submitting a project, completing a goal, or updating skills).
• Design the trigger to handle various types of user actions. While these actions are not yet fully implemented, the solution should be flexible enough to accommodate future functions.
• Ensure that the trigger correctly associates activities with the corresponding user, ensuring accurate logging in the activity section.
• The activity table should update automatically, reflecting new actions without requiring manual refreshes or user intervention.
• Ensure the solution is built with scalability in mind, allowing for future extensions and easy integration of new activity types.
• Modify the database schema if needed to log and track various user activities efficiently.