ticket_type Table (537)

•

Environment: onsite, online

• 3 minutes to read

A ticket (request) type

Fields

Name	Description	Type	Null
ticket_type_id	Primary key	PK
name	The list item	String(4000)
rank	Rank order	UShort	●
tooltip	Tooltip or other description	String(4000)	●
icon	Name of the icon	String(32)
default_status	Default ticket status for new tickets	FK ticket_status	●
default_priority	Default ticket priority for new tickets	FK ticket_priority	●
reply_template	Reply template to use when replying to a ticket of this type	FK reply_template	●
is_external	Is this request type visible to external people and they can submit requests of this type	Bool	●
registered	Registered when	UtcDateTime
registered_associate_id	Registered by whom	FK associate
updated	Last updated when	UtcDateTime
updated_associate_id	Last updated by whom	FK associate
updatedCount	Number of updates made to this record	UShort
is_default	Is this Ticket Type marked as default	Bool	●
show_in_new	Enables this request type to be accessible in +New in top bar	Bool
exclude_signature	Do not insert user signature automatically	Bool
exclude_email_recipients	Create request without initially having to send outbound e-mail	Bool
external_as_default	Ability to set external access level for this request type	Bool
visible_for_groups	Array of references to the visible for groups	FKArray	●
reply_forward_no_signature	Do not insert user signature when replying or forwarding the message	Bool
reply_external_as_default	Set external access level when replying the message	Bool

ticket_type table relationship diagram

Table	Description
associate	Employees, resources and other users - except for External persons
mail_in_filter	This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).
ms_filter	This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.
reply_template	Templates for automatic and manual replies to emails/sms organized hierachically
ticket	This table contains the tickets (requests) of the system. Its purpose should be evident.
ticket_priority	This table contains the ticket priorities.
ticket_status	This table user defined ticket status values.
ticket_type_priority	Link table defining what Priorities are relevant to a particular Ticket type
ticket_type_status	Link table defining what Statuses are relevant to a particular Ticket type
UserGroup	Secondary user groups