✅ tasks

The Task model represents an individual unit of work within a project. Each task includes metadata such as its title, description, status, deadlines, and completion percentage.

✅ Task Model

📄 Attributes:

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

  • 📁 project_id (ForeignKey): Reference to the project this task belongs to.

  • 📝 task_title (String): The title or short name of the task.

  • 📄 task_description (Text): A detailed explanation of the task’s purpose or content.

  • 📊 percentage_complete (Float): The percentage of task progress calculated by microtasks completed (e.g., 0.0 to 100.0).

  • 🕒 date_created (DateTime): Date and time when the task was created.

  • 📅 due_date (DateTime): Deadline for completing the task.

  • 🚦 status (enum type): Current status of the task ("assigned" , "in_progress" , "under_review", "completed")

🔗 Relationships:

  • 📁 project: Belongs to a Project.


📎 TasksFile Model

The TasksFile model links files to specific tasks, enabling users to attach documents or media to a task.

📄 Attributes:

  • 🆔 id (Integer): Unique identifier for the task-file relationship.

  • tasks_id (ForeignKey): The task to which the file is attached.

  • 📂 files_id (ForeignKey): The file being linked.

🔗 Relationships:

  • 📂 files: The File attached.

  • tasks: The Task to which the file is attached.


💬 TaskComment Model

The TaskComment model stores user-generated comments on individual tasks, allowing for collaboration and communication.

📄 Attributes:

  • 🆔 id (Integer): Unique identifier for the comment.

  • 👤 user_id (ForeignKey): The user who wrote the comment.

  • task_id (ForeignKey): The task this comment refers to.

  • 🕒 time_posted (DateTime): Timestamp of when the comment was made.

  • ✏️ content (Text): The actual text content of the comment.

🔗 Relationships:

  • 👤 user: The User who made the comment.

  • task: The Task that the comment belongs to.


📎💬 TaskCommentsFile Model

The TaskCommentsFile model links files to specific comments within tasks, allowing users to support their feedback with attachments.

📄 Attributes:

  • 🆔 id (Integer): Unique identifier for the comment-file relationship.

  • 💬 task_comments_id (ForeignKey): The comment to which the file is attached.

  • 📂 files_id (ForeignKey): The file being linked.

🔗 Relationships:

  • 📂 files: The File attached.

  • 💬 task_comments: The TaskComment that this file belongs to.

Last updated