tickets
Support tickets with status, priority, and billing items.
Status codes
| Status | ACTIVITY | Color | ID |
|---|---|---|---|
| Not started | DRAFT | 0 | orange |
| Awaiting acceptance | DRAFT | 1 | orange |
| Accepted | OPEN | 2 | green |
| Rejected | CANCELLED | 3 | red |
| Active | OPEN | 4 | green |
| Inactive | OPEN | 5 | orange |
| Feedback required | OPEN | 6 | orange |
| Testing | OPEN | 7 | green |
| Cancelled | CANCELLED | 8 | red |
| Completed | CLOSED | 9 | black |
| Failed | CLOSED | 10 | black |
| Booked | CLOSED | 11 | black |
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Ticket ID | ||
fork forks.ID | integer | Fork ID (`null` for base module) | ||
ownergroup groups.ID | integer | Owner group ID (`null`=PUBLIC) | ||
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) | |
account accounts.ID | integer | Account ID; is mutually exclusive to `project` | ||
project projects.ID | integer | Project ID; is mutually exclusive to `account` | ||
visibility | smallint | 0 | Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED) | |
name | text | Name | ||
ticketnum | text | '' | Ticket number | |
date | bigint | date_part('epoch', now()) | Designated date and time as a Unix timestamp (defaults to current date and time on creation) | |
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) | |
description | text | '' | Detailed general description | |
billingitems | json | JSON-encoded items (array) | ||
procurementitems | json | JSON-encoded items (array) |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_tickets_account | btree | account | ||||
| fk_tickets_assigneduser | gin | assigneduser | ||||
| fk_tickets_fork | gin | fork | ||||
| fk_tickets_ownergroup | gin | ownergroup | ||||
| fk_tickets_project | gin | project | ||||
| i_tickets_date | btree | date | ||||
| i_tickets_nofork | gin | fork | ||||
| i_tickets_noowner | gin | ownergroup | ||||
| pk_tickets | btree | ID | ||||
| s_tickets_name | gin | name | ||||
| s_tickets_ticketnum | gin | ticketnum |
| Name | Type |
|---|---|
| c_tickets_association | check |
| dc_tickets_billingitems | check |
| dc_tickets_description | check |
| dc_tickets_name | check |
| dc_tickets_priority | check |
| dc_tickets_procurementitems | check |
| dc_tickets_status | check |
| dc_tickets_ticketnum | check |
| dc_tickets_visibility | check |
| fk_tickets_account | foreign_key |
| fk_tickets_assigneduser | foreign_key |
| fk_tickets_fork | foreign_key |
| fk_tickets_ownergroup | foreign_key |
| fk_tickets_project | foreign_key |
| pk_tickets | primary_key |
Loading...