tickets

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Ticket ID
fork	integer	plain		forks.ID	Fork ID (`null` for base module)
ownergroup	integer	plain		groups.ID	Owner group ID (`null`=PUBLIC)
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)
account	integer	plain		accounts.ID	Account ID; is mutually exclusive to `project`
project	integer	plain		projects.ID	Project ID; is mutually exclusive to `account`
visibility	smallint	plain			Default: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text	main			Name
ticketnum	text	main			Default: ''Ticket number
date	bigint	plain			Default: date_part('epoch', now())Designated date and time as a Unix timestamp (defaults to current date and time on creation)
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)
description	text	extended			Default: ''Detailed general description
billingitems	json	extended			JSON-encoded items (array)
procurementitems	json	extended			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_creator	foreign_key
fk_tickets_fork	foreign_key
fk_tickets_ownergroup	foreign_key
fk_tickets_project	foreign_key
pk_tickets	primary_key

Loading...