ticket_priority Table (275)

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.