ticket-priority.md

uid	title	description	so.generated	keywords	so.date	so.topic	so.envir
table-ticket_priority	ticket_priority table	This table contains the ticket priorities.	true	database ticket_priority	11.04.2021	reference	onsite online

ticket_priority Table (275)

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	When the timeframe starts on monday.	DateTime	●
mon_stop	When the timeframe ends on monday.	DateTime	●
tue_start		DateTime	●
tue_stop		DateTime	●
wed_start		DateTime	●
wed_stop		DateTime	●
thu_start		DateTime	●
thu_stop		DateTime	●
fri_start		DateTime	●
fri_stop		DateTime	●
sat_start		DateTime	●
sat_stop		DateTime	●
sun_start		DateTime	●
sun_stop		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

[!includedetails]

Indexes

Fields	Types	Description
id	PK	Clustered, Unique

Replication Flags

• None

Security Flags

• No access control via user's Role.