| PKID | integer | plain | | | Task ID |
| fork | integer | plain | | forks.ID | Fork ID (`null` for base module) |
| owneruser | integer | plain | | users.ID | Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) |
| ownergroup | integer | plain | | groups.ID | Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) |
| creator | integer | plain | | users.ID | Creator user ID (defaults to authenticated user on creation) |
| assigneduser | integer | plain | | users.ID | Assigned user ID |
| creationdate | bigint | plain | | | Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation) |
| lastmodified | bigint | plain | | | Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification) |
| davserver | integer | plain | | davservers.ID | DAV server ID |
| ticket | integer | plain | | tickets.ID | Ticket ID; is mutually exclusive to `project` |
| project | integer | plain | | projects.ID | Project ID; is mutually exclusive to `ticket` |
| visibility | smallint | plain | | | Default: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED) |
| name | text | main | | | Name |
| tasknum | text | main | | | Default: ''Task number |
| datefrom | bigint | plain | | | Start date and time as a Unix timestamp |
| duedate | bigint | plain | | | Due date and time as a Unix timestamp |
| status | smallint | plain | | | Default: 0Status (`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 | plain | | | Default: 2Priority (`0`=LOWEST, `1`=LOW, `2`=MEDIUM, `3`=HIGH, `4`=HIGHEST) |
| projectedeffort | integer | plain | | | Default: 0Projected effort in minutes |
| description | text | extended | | | Default: ''Detailed general description |