> ## 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_alert table > This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels. ## ticket\_alert Table (274) This table will contain ticket escalation levels. A ticket will be escalated along a \'chain\' of these levels. ## Fields | Name | Description | Type | Nullable | | --------------------------------- | ------------------------------------------------------------------------------------------------ | -------------------------------------------- | :------: | | id | The primary key (auto-incremented) | PK | No | | priority | The id of the ticket\_priority entry this entry is connected to. | FK [ticket\_priority](./ticket-priority.mdx) | No | | alert\_level | The alert level (strictly ascending number). | Short | Yes | | alert\_timeout | The time (in minutes) before ticket is escalated to next level. | Int | Yes | | action | Bitmap indicating what should be done when escalating *to* this level. | Int | Yes | | delegate\_to | If ticket should be redelegated on escalation, this field contains the id of the target user. | FK [ejuser](./ejuser.mdx) | Yes | | script\_id | Script that can be executed then the ticket alert action occur. | FK [ejscript](./ejscript.mdx) | Yes | | email\_to | If an email should be sent when escalating, this field will contain the recipient email address. | String(255) | Yes | | sms\_to | If an sms should be sent when escalating, this field will contain the recipient email address. | String(255) | Yes | | reply\_template\_id\_customer | Reference to the reply template used in this alert, for mail to customer | FK [reply\_template](./reply-template.mdx) | Yes | | reply\_template\_id\_user | Reference to the reply template used in this alert, for mail to owner of ticket | FK [reply\_template](./reply-template.mdx) | Yes | | reply\_template\_id\_catmast | Reference to the reply template used in this alert, for mail to category master | FK [reply\_template](./reply-template.mdx) | Yes | | reply\_template\_id\_email | Reference to the reply template used in this alert, for mail to custom address | FK [reply\_template](./reply-template.mdx) | Yes | | rti\_customer\_sms | Reference to the reply template used in this alert, for sms to customer | FK [reply\_template](./reply-template.mdx) | Yes | | reply\_template\_id\_user\_sms | Reference to the reply template used in this alert, for sms to owner of ticket | FK [reply\_template](./reply-template.mdx) | Yes | | reply\_template\_id\_catmast\_sms | Reference to the reply template used in this alert, for sms to category master | FK [reply\_template](./reply-template.mdx) | Yes | | reply\_template\_id\_sms | Reference to the reply template used in this alert, for sms to custom address | FK [reply\_template](./reply-template.mdx) | Yes | ticket_alert table relationship diagram ## Indexes | Fields | Types | Description | | --------------------------------- | ----- | ----------- | | priority | FK | Index | | delegate\_to | FK | Index | | script\_id | FK | Index | | reply\_template\_id\_customer | FK | Index | | reply\_template\_id\_user | FK | Index | | reply\_template\_id\_catmast | FK | Index | | reply\_template\_id\_email | FK | Index | | rti\_customer\_sms | FK | Index | | reply\_template\_id\_user\_sms | FK | Index | | reply\_template\_id\_catmast\_sms | FK | Index | | reply\_template\_id\_sms | FK | Index | ## Relationships | Table | Description | | ------------------------------------- | ---------------------------------------------------------------------------------------------------------------------- | | [ejscript](./ejscript) | ejscript | | [ejuser](./ejuser) | This table contains entries for the users of the system. | | [notify](./notify) | This table contains the pop-up messages displayed for users for various events, such as \'new ticket\', etc. | | [reply\_template](./reply-template) | Templates for automatic and manual replies to emails/sms organized hierachically | | [ticket\_priority](./ticket-priority) | This table contains the ticket priorities. | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [NSTicket](/en/automation/crmscript/reference/CRMScript.NetServer.NSTicket.md) - [NSTicketEntity](/en/automation/crmscript/reference/CRMScript.NetServer.NSTicketEntity.md) - [SuperOffice.WebApi.Data.TicketEntity](/en/api/reference/webapi/SuperOffice.WebApi.Data.TicketEntity.md) - [SuperOffice.WebApi.Data.Ticket](/en/api/reference/webapi/SuperOffice.WebApi.Data.Ticket.md) - [ticket table](/en/database/tables/ticket.md) - [Get Ticket](/en/api/reference/restful/agent/ticket_agent/get-ticket.md)