tasks
Task records with priority, effort, and project linking.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Task ID | ||
fork forks.ID | integer | Fork ID (`null` for base module) | ||
owneruser users.ID | integer | Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
ownergroup groups.ID | integer | Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
assigneduser users.ID | integer | Assigned user ID | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | date_part('epoch', now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
davserver davservers.ID | integer | DAV server ID | ||
ticket tickets.ID | integer | Ticket ID; is mutually exclusive to `project` | ||
project projects.ID | integer | Project ID; is mutually exclusive to `ticket` | ||
visibility | smallint | 0 | Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED) | |
name | text | Name | ||
tasknum | text | '' | Task number | |
datefrom | bigint | Start date and time as a Unix timestamp | ||
duedate | bigint | Due date and time as a Unix timestamp | ||
status | smallint | 0 | Status (`0`=NOTSTARTED, `1`=AWAITINGACCEPTANCE, `2`=ACCEPTED, `3`=REJECTED, `4`=ACTIVE, `5`=INACTIVE, `6`=FEEDBACKREQUIRED, `7`=TESTING, `8`=CANCELLED, `9`=COMPLETED, `10`=FAILED, `11`=BOOKED) | |
priority | smallint | 2 | Priority (`0`=LOWEST, `1`=LOW, `2`=MEDIUM, `3`=HIGH, `4`=HIGHEST) | |
projectedeffort | integer | 0 | Projected effort in minutes | |
description | text | '' | Detailed general description |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_tasks_assigneduser | gin | assigneduser | ||||
| fk_tasks_davserver | gin | davserver | ||||
| fk_tasks_fork | gin | fork | ||||
| fk_tasks_ownergroup | gin | ownergroup | ||||
| fk_tasks_owneruser | gin | owneruser | ||||
| fk_tasks_project | gin | project | ||||
| fk_tasks_ticket | btree | ticket | ||||
| i_tasks_nofork | gin | fork | ||||
| i_tasks_noowner | gin | ownergroup | ||||
| pk_tasks | btree | ID | ||||
| s_tasks_name | gin | name | ||||
| s_tasks_tasknum | gin | tasknum |
| Name | Type |
|---|---|
| c_tasks_association | check |
| c_tasks_owner | check |
| dc_tasks_description | check |
| dc_tasks_name | check |
| dc_tasks_priority | check |
| dc_tasks_projectedeffort | check |
| dc_tasks_status | check |
| dc_tasks_tasknum | check |
| dc_tasks_visibility | check |
| fk_tasks_assigneduser | foreign_key |
| fk_tasks_davserver | foreign_key |
| fk_tasks_fork | foreign_key |
| fk_tasks_ownergroup | foreign_key |
| fk_tasks_owneruser | foreign_key |
| fk_tasks_project | foreign_key |
| fk_tasks_ticket | foreign_key |
| pk_tasks | primary_key |
Loading...