# Task & Project Entities {#task--project-entities}


Entities for tasks, projects, sprints, daily plans, and related configuration (statuses, priorities, sizes, issue types).


## Task {#task}


| Column        | Type     | Description                   |
| ------------- | -------- | ----------------------------- |
| `title`       | string   | Task title                    |
| `number`      | number   | Auto-increment per project    |
| `prefix`      | string   | Project prefix (e.g., `PROJ`) |
| `description` | string?  | Rich text description         |
| `status`      | string?  | Current status name           |
| `priority`    | string?  | Priority level name           |
| `size`        | string?  | Size/complexity name          |
| `issueType`   | string?  | Issue type name               |
| `estimate`    | number?  | Estimated seconds             |
| `dueDate`     | Date?    | Deadline                      |
| `startDate`   | Date?    | Start date                    |
| `resolvedAt`  | Date?    | Resolution timestamp          |
| `version`     | string?  | Version/milestone             |
| `isDraft`     | boolean? | Draft status                  |
| `projectId`   | UUID?    | FK to organization_project    |
| `creatorId`   | UUID     | FK to user who created        |
| `parentId`    | UUID?    | FK to parent task (sub-tasks) |

**Key Relations:**

| Relation       | Type       | Target                  |
| -------------- | ---------- | ----------------------- |
| `project`      | ManyToOne  | OrganizationProject     |
| `creator`      | ManyToOne  | User                    |
| `parent`       | ManyToOne  | Task (self-referencing) |
| `children`     | OneToMany  | Task (sub-tasks)        |
| `members`      | ManyToMany | Employee                |
| `teams`        | ManyToMany | OrganizationTeam        |
| `tags`         | ManyToMany | Tag                     |
| `linkedIssues` | OneToMany  | TaskLinkedIssue         |
| `comments`     | OneToMany  | Comment                 |
| `timeLogs`     | OneToMany  | TimeLog                 |
| `dailyPlans`   | ManyToMany | DailyPlan               |


## OrganizationProject {#organizationproject}


| Column                  | Type     | Description                                                |
| ----------------------- | -------- | ---------------------------------------------------------- |
| `name`                  | string   | Project name                                               |
| `startDate`             | Date?    | Start date                                                 |
| `endDate`               | Date?    | End date                                                   |
| `billing`               | enum?    | `RATE_PER_TASK`, `RATE_PER_HOUR`, `FLAT_FEE`, `MILESTONES` |
| `currency`              | string?  | Project currency                                           |
| `public`                | boolean  | Public visibility                                          |
| `taskListType`          | enum     | Default task view type                                     |
| `code`                  | string?  | Short code                                                 |
| `description`           | string?  | Project description                                        |
| `color`                 | string?  | UI color                                                   |
| `billable`              | boolean? | Is billable                                                |
| `billingFlat`           | boolean? | Flat billing                                               |
| `budget`                | number?  | Budget amount                                              |
| `budgetType`            | enum?    | Budget tracking type                                       |
| `imageUrl`              | string?  | Project image                                              |
| `organizationContactId` | UUID?    | FK to client/contact                                       |


## OrganizationSprint {#organizationsprint}


| Column      | Type    | Description                   |
| ----------- | ------- | ----------------------------- |
| `name`      | string  | Sprint name                   |
| `goal`      | string? | Sprint goal                   |
| `length`    | number  | Sprint length (days)          |
| `startDate` | Date?   | Start date                    |
| `endDate`   | Date?   | End date                      |
| `dayStart`  | number? | Week start day                |
| `status`    | enum?   | `TODO`, `IN_PROGRESS`, `DONE` |
| `projectId` | UUID    | FK to project                 |


## DailyPlan {#dailyplan}


| Column       | Type   | Description         |
| ------------ | ------ | ------------------- |
| `date`       | Date   | Plan date           |
| `status`     | enum   | Plan status         |
| `employeeId` | UUID   | FK to employee      |
| `tasks`      | Task[] | Planned tasks (M2M) |


## Status / Priority / Size / IssueType {#status--priority--size--issuetype}


Each is a lookup entity with customizable values per project:

| Column        | Type    | Description             |
| ------------- | ------- | ----------------------- |
| `name`        | string  | Display name            |
| `value`       | string  | Unique value identifier |
| `description` | string? | Description             |
| `icon`        | string? | Icon identifier         |
| `color`       | string? | Color hex               |
| `isSystem`    | boolean | System-defined          |
| `projectId`   | UUID?   | Scoped to project       |


## TaskLinkedIssue {#tasklinkedissue}


| Column       | Type | Description       |
| ------------ | ---- | ----------------- |
| `action`     | enum | Relationship type |
| `taskFromId` | UUID | Source task       |
| `taskToId`   | UUID | Target task       |

**Action types:** `IS_BLOCKED_BY`, `BLOCKS`, `IS_CLONED_BY`, `CLONES`, `IS_DUPLICATED_BY`, `DUPLICATES`, `RELATES_TO`


## Related Pages {#related-pages}


- [Task Endpoints](https://sourcey-gauzy.pages.dev/api/task-endpoints/index.md) — API reference
- [Sprint Endpoints](https://sourcey-gauzy.pages.dev/api/sprint-endpoints/index.md) — sprint API
- [Daily Plan Endpoints](https://sourcey-gauzy.pages.dev/api/daily-plan-endpoints/index.md) — daily plan API
- [Task Management](https://sourcey-gauzy.pages.dev/features/task-management/index.md) — feature guide