ticket

All tickets and workflow instances.

Column name	Description	Data type
company	Reference to `company`.	integer
ticket	Primary key.	integer
number	Ticket's public unique identity. Used as the key in SOAP requests.	text
ticket_type	Reference to `ticket_type`.	integer
ticket_priority	Reference to `ticket_priority`.	integer
ticket_status	Reference to `ticket_status`.	integer
ticket_group	Reference to `ticket_group`.	integer
account	The account this ticket pertains or belongs to, if any. Typically tickets from customers will be allocated under their account. Reference to `account`.	integer *
target_subscription	The subscription the ticket pertains or belongs to, if specified. Reference to `subscription`.	integer *
target_tx	The transaction affected by the ticket. Reference to `tx`.	integer *
submitting_subscription	The user that submitted the ticket. Reference to `subscription`.	integer *
assigned_operator	The operator assigned to dealing with the ticket. Reference to `operator`.	integer *
creation_time		timestamp with time zone
closed_time	Timestamp the ticket was closed, null if the ticket is open.	timestamp with time zone *
held_until	Timestamp when the ticket is held until. When null the ticket is not held.	timestamp with time zone *
seconds	Time since the ticket was opened in seconds.	integer
summary	A subject or short summary of the ticket. Normally filled in by an operator.	text *
status_text	Extra status text, normally filled in by an operator.	text *
unread	If the ticket has been flagged as unread for the `assigned_operator`.	boolean
description	A textual description of the ticket.	text *