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


Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"tickets_ID_seq"'::regclass)
actionsteps.ticket FK_actionsteps_ticket N
messages.ticket FK_messages_ticket N
tasks.ticket FK_tasks_ticket N
ownergroup int4 10 null
groups.ID FK_tickets_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_tickets_creator N

The object creator

assigneduser int4 10 null
users.ID FK_tickets_assigneduser N

The assigned user

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

account int4 10 null
accounts.ID FK_tickets_account N

Reference to the associated account

project int4 10 null
projects.ID FK_tickets_project N
visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

name text 2147483647 null
ticketnum text 2147483647 ''::text
date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

duedate int8 19 null

Unix timestamp in seconds

status int2 5 0

0: Not started, 1: Awaiting acceptance, 2: Accepted, 3: Rejected, 4: Active, 5: Inactive, 6: Feedback required, 7: Testing, 8: Cancelled, 9: Completed, 10: Failed, 11: Booked

priority int2 5 2

priority status (0: Lowest, 1: Low, 2: Medium, 3: High, 4: Highest)

description text 2147483647 ''::text

The general description field

items json 2147483647 null

Table contained 0 rows


Constraint Name Type Sort Column(s)
PK_tickets_ID Primary key Asc ID