ticket_priority Table (275)

•
Environment: onsite, online
• 5 minutes to read
 • 5 minutes to read

This table contains the ticket priorities.

Fields

Name Description Type Null
id The primary key (auto-incremented) PK
name The name of the priority. String(64) ●
status The status (normal/deleted) of the priority. Enum TicketPriorityStatus ●
flags A bitmask of flags. Enum TicketPriorityFlags ●
mon_start The work hour start for Mondays. Note that only the time part of the DateTime is used DateTime ●
mon_stop The work hour start for Mondays. Note that only the time part of the DateTime is used DateTime ●
tue_start The work hour start for Tuesdays. Note that only the time part of the DateTime is used DateTime ●
tue_stop The work hour stop for Tuesdays. Note that only the time part of the DateTime is used DateTime ●
wed_start The work hour start for Wednesdays. Note that only the time part of the DateTime is used DateTime ●
wed_stop The work hour stop for Wednesdays. Note that only the time part of the DateTime is used DateTime ●
thu_start The work hour start for Thursdays. Note that only the time part of the DateTime is used DateTime ●
thu_stop The work hour stop for Thursdays. Note that only the time part of the DateTime is used DateTime ●
fri_start The work hour start for Fridays. Note that only the time part of the DateTime is used DateTime ●
fri_stop The work hour stop for Fridays. Note that only the time part of the DateTime is used DateTime ●
sat_start The work hour start for Saturdays. Note that only the time part of the DateTime is used DateTime ●
sat_stop The work hour stop for Saturdays. Note that only the time part of the DateTime is used DateTime ●
sun_start The work hour start for Sundays. Note that only the time part of the DateTime is used DateTime ●
sun_stop The work hour stop for Sundays. Note that only the time part of the DateTime is used DateTime ●
non_dates A comma separated list of dates (dd/mm) which should be excluded from the timeframe. String(255) ●
deadline Deadline to add if escalated (minutes) Int ●
sort_order Indicates the sort order for this priority. 1 is first, 100 is last Int ●
ticket_read This field indicates what to do with the escalation chain when the request is read Enum TicketPriorityEscalateEvent ●
changed_owner This field indicates what to do with the escalation chain when the request changes owner (manually) Enum TicketPriorityEscalateEvent ●
ticket_newinfo This field indicates what to do with the escalation chain when the request gets new info Enum TicketPriorityEscalateEvent ●
ticket_closed This field indicates what to do with the escalation chain when the request is closed Enum TicketPriorityEscalateEvent ●
ticket_changed_priority This field indicates what to do with the escalation chain when the request is changed into this priority Enum TicketPriorityEscalateEvent ●
ticket_new This field indicates what to do with the escalation chain when a new request is registered Enum TicketPriorityEscalateEvent

ticket_priority table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique

Relationships

Table Description
chat_topic This table contains chat topics.
contact Companies and Organizations.
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.
person Persons
s_link Links in messages to measure success rate of a campaign.
ticket This table contains the tickets (requests) of the system. Its purpose should be evident.
ticket_alert This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels.
ticket_type A ticket (request) type
ticket_type_priority Link table defining what Priorities are relevant to a particular Ticket type

Replication Flags

  • None

Security Flags

  • No access control via user's Role.