ticket_type Table (537)

A ticket (request) type

Fields

NameDescriptionTypeNull
ticket_type_idPrimary keyPK
nameThe list itemString(4000)
rankRank orderUShort●
tooltipTooltip or other descriptionString(4000)●
iconName of the iconString(32)
default_statusDefault ticket status for new ticketsFK ticket_status●
default_priorityDefault ticket priority for new ticketsFK ticket_priority●
reply_templateReply template to use when replying to a ticket of this typeFK reply_template●
is_externalIs this request type visible to external people and they can submit requests of this typeBool●
registeredRegistered whenUtcDateTime
registered_associate_idRegistered by whomFK associate
updatedLast updated whenUtcDateTime
updated_associate_idLast updated by whomFK associate
updatedCountNumber of updates made to this recordUShort
is_defaultIs this Ticket Type marked as defaultBool●
show_in_newEnables this request type to be accessible in +New in top barBool
exclude_signatureDo not insert user signature automaticallyBool
exclude_email_recipientsCreate request without initially having to send outbound e-mailBool
external_as_defaultAbility to set external access level for this request typeBool
visible_for_groupsArray of references to the visible for groupsFKArray●
reply_forward_no_signatureDo not insert user signature when replying or forwarding the messageBool
reply_external_as_defaultSet external access level when replying the messageBool

ticket_type table relationship diagram

Indexes

FieldsTypesDescription
ticket_type_idPKClustered, Unique
nameString(4000)Unique
default_statusFKIndex
default_priorityFKIndex
reply_templateFKIndex
visible_for_groupsFKArrayFull text

Relationships

TableDescription
associateEmployees, resources and other users - except for External persons
mail_in_filterThis table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).
ms_filterThis table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.
reply_templateTemplates for automatic and manual replies to emails/sms organized hierachically
ticketThis table contains the tickets (requests) of the system. Its purpose should be evident.
ticket_priorityThis table contains the ticket priorities.
ticket_statusThis table user defined ticket status values.
ticket_type_priorityLink table defining what Priorities are relevant to a particular Ticket type
ticket_type_statusLink table defining what Statuses are relevant to a particular Ticket type
UserGroupSecondary user groups

Replication Flags

  • None

Security Flags

  • No access control via user’s Role.