🧑‍💻users

Documentation for the 'users' table

The User model represents individuals who can access and interact with the system. Each user has identifying information, permissions, and associations with other entities in the platform.

📄 Attributes:

• 🆔 id (Integer): Unique identifier for the user (Primary Key).

• 🧑‍💻 username (String): A unique name used for user identification and login.

• 🧾 first_name (String): The user’s given name.

• 🧾 last_name (String): The user’s surname or family name.

• 📧 email (String): Email address used for communication and login.

• 🔐 password (String): Hashed password used for secure authentication.

• 🛡️ permission (Enum type): Role of the user — either "admin" "pm",or "user". Defines access to admin-level functionalities and pm allows users to create new projects.

🔗 Relationships:

• 💬 task_comments: Comments made by the user on tasks (TaskComment).

• 💬 microtask_comments: Comments made by the user on microtasks (MicrotaskComment).

• 🧩 templates: Templates created or owned by the user (Template).

• 🔔 notifications: Notifications sent to or generated for the user (Notification).

• 📚 activity_logs: Logs of actions performed by the user (ActivityLog, via user_id).

• 👀 object_activity_logs: Logs where the user is the subject of the activity (ActivityLog, via object_user_id).

• 🧑‍🤝‍🧑 projects_users: Many-to-many relationship linking the user with projects via the ProjectsUser association.