tickets


Details

Status codes

Status Activity ID Color
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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
actionsteps.ticket fk_actionsteps_ticket N
messages.ticket fk_messages_ticket N
tasks.ticket fk_tasks_ticket N

Ticket ID
ownergroup int4 10 √ null
groups.ID fk_tickets_ownergroup C

Owner group ID (null=PUBLIC)
creator int4 10 √ null
users.ID fk_tickets_creator N

Creator user ID (defaults to authenticated user on creation)
assigneduser int4 10 √ null
users.ID fk_tickets_assigneduser N

Assigned user ID
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
account int4 10 √ null
accounts.ID fk_tickets_account N

Account ID
project int4 10 √ null
projects.ID fk_tickets_project N

Project ID
visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
name text 2147483647 null

Name
ticketnum text 2147483647 ''::text

Ticket number
date int8 19 date_part('epoch'::text, now())

Designated date and time as a Unix time stamp (defaults to current date and time on creation)
duedate int8 19 √ null

Due date and time as a Unix time stamp
status int2 5 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 int2 5 2

Priority (0=LOWEST, 1=LOW, 2=MEDIUM, 3=HIGH, 4=HIGHEST)
description text 2147483647 ''::text

Detailed general description
billingitems json 2147483647 √ null
procurementitems json 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_tickets Primary key Asc ID
fk_tickets_account Performance Asc account
fk_tickets_project Performance Asc project
i_tickets_date_ID Performance Desc/Desc date + ID
i_tickets_noowner Performance Asc ownergroup
i_tickets_owner Performance Asc/Asc ownergroup + assigneduser
s_tickets Performance Asc/Asc name + ticketnum

Relationships

Close relationships within degrees of separation