> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ticket_priority table

> This table contains the ticket priorities.

## ticket\_priority Table (275)

This table contains the ticket priorities.

## Fields

| Name                      | Description                                                                                              | Type                                                                        | Nullable |
| ------------------------- | -------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------- | :------: |
| id                        | The primary key (auto-incremented)                                                                       | PK                                                                          |    No    |
| name                      | The name of the priority.                                                                                | String(64)                                                                  |    Yes   |
| status                    | The status (normal/deleted) of the priority.                                                             | Enum [TicketPriorityStatus](./enums/ticketprioritystatus.mdx)               |    Yes   |
| flags                     | A bitmask of flags.                                                                                      | Enum [TicketPriorityFlags](./enums/ticketpriorityflags.mdx)                 |    Yes   |
| mon\_start                | The work hour start for Mondays. Note that only the time part of the DateTime is used                    | DateTime                                                                    |    Yes   |
| mon\_stop                 | The work hour start for Mondays. Note that only the time part of the DateTime is used                    | DateTime                                                                    |    Yes   |
| tue\_start                | The work hour start for Tuesdays. Note that only the time part of the DateTime is used                   | DateTime                                                                    |    Yes   |
| tue\_stop                 | The work hour stop for Tuesdays. Note that only the time part of the DateTime is used                    | DateTime                                                                    |    Yes   |
| wed\_start                | The work hour start for Wednesdays. Note that only the time part of the DateTime is used                 | DateTime                                                                    |    Yes   |
| wed\_stop                 | The work hour stop for Wednesdays. Note that only the time part of the DateTime is used                  | DateTime                                                                    |    Yes   |
| thu\_start                | The work hour start for Thursdays. Note that only the time part of the DateTime is used                  | DateTime                                                                    |    Yes   |
| thu\_stop                 | The work hour stop for Thursdays. Note that only the time part of the DateTime is used                   | DateTime                                                                    |    Yes   |
| fri\_start                | The work hour start for Fridays. Note that only the time part of the DateTime is used                    | DateTime                                                                    |    Yes   |
| fri\_stop                 | The work hour stop for Fridays. Note that only the time part of the DateTime is used                     | DateTime                                                                    |    Yes   |
| sat\_start                | The work hour start for Saturdays. Note that only the time part of the DateTime is used                  | DateTime                                                                    |    Yes   |
| sat\_stop                 | The work hour stop for Saturdays. Note that only the time part of the DateTime is used                   | DateTime                                                                    |    Yes   |
| sun\_start                | The work hour start for Sundays. Note that only the time part of the DateTime is used                    | DateTime                                                                    |    Yes   |
| sun\_stop                 | The work hour stop for Sundays. Note that only the time part of the DateTime is used                     | DateTime                                                                    |    Yes   |
| non\_dates                | A comma separated list of dates (dd/mm) which should be excluded from the timeframe.                     | String(255)                                                                 |    Yes   |
| deadline                  | Deadline to add if escalated (minutes)                                                                   | Int                                                                         |    Yes   |
| sort\_order               | Indicates the sort order for this priority. 1 is first, 100 is last                                      | Int                                                                         |    Yes   |
| ticket\_read              | This field indicates what to do with the escalation chain when the request is read                       | Enum [TicketPriorityEscalateEvent](./enums/ticketpriorityescalateevent.mdx) |    Yes   |
| changed\_owner            | This field indicates what to do with the escalation chain when the request changes owner (manually)      | Enum [TicketPriorityEscalateEvent](./enums/ticketpriorityescalateevent.mdx) |    Yes   |
| ticket\_newinfo           | This field indicates what to do with the escalation chain when the request gets new info                 | Enum [TicketPriorityEscalateEvent](./enums/ticketpriorityescalateevent.mdx) |    Yes   |
| ticket\_closed            | This field indicates what to do with the escalation chain when the request is closed                     | Enum [TicketPriorityEscalateEvent](./enums/ticketpriorityescalateevent.mdx) |    Yes   |
| ticket\_changed\_priority | This field indicates what to do with the escalation chain when the request is changed into this priority | Enum [TicketPriorityEscalateEvent](./enums/ticketpriorityescalateevent.mdx) |    Yes   |
| ticket\_new               | This field indicates what to do with the escalation chain when a new request is registered               | Enum [TicketPriorityEscalateEvent](./enums/ticketpriorityescalateevent.mdx) |    No    |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/ticket_priority.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=19093d5eb98408cf8fa0da5cf5a666ad" alt="ticket_priority table relationship diagram" width="831" height="743" data-path="media/loc/en/database/tables/ticket_priority.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table                                            | Description                                                                                                               |
| ------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------- |
| [chat\_topic](./chat-topic)                      | This table contains chat topics.                                                                                          |
| [contact](./contact)                             | Companies and Organizations.                                                                                              |
| [mail\_in\_filter](./mail-in-filter)             | This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).                   |
| [ms\_filter](./ms-filter)                        | This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails.         |
| [person](./person)                               | Persons                                                                                                                   |
| [s\_link](./s-link)                              | Links in messages to measure success rate of a campaign.                                                                  |
| [ticket](./ticket)                               | This table contains the tickets (requests) of the system. Its purpose should be evident.                                  |
| [ticket\_alert](./ticket-alert)                  | This table will contain ticket escalation levels. A ticket will be escalated along a \&apos;chain\&apos; of these levels. |
| [ticket\_type](./ticket-type)                    | A ticket (request) type                                                                                                   |
| [ticket\_type\_priority](./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.


## Related topics

- [NSTicket](/en/automation/crmscript/reference/CRMScript.NetServer.NSTicket.md)
- [ticket table](/en/database/tables/ticket.md)
- [SuperOffice.WebApi.Data.Ticket](/en/api/reference/webapi/SuperOffice.WebApi.Data.Ticket.md)
- [Enum values for TicketPriorityEscalateEvent](/en/database/tables/enums/ticketpriorityescalateevent.md)
- [ticket_type_priority table](/en/database/tables/ticket-type-priority.md)
- [Enum values for TicketPriorityFlags](/en/database/tables/enums/ticketpriorityflags.md)
