> ## 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. # notify table > This table contains the pop-up messages displayed for users for various events, such as 'new ticket', etc. ## notify Table (301) This table contains the pop-up messages displayed for users for various events, such as \'new ticket\', etc. ## Fields | Name | Description | Type | Nullable | | ------------------------- | ------------------------------------------------------------------ | -------------------------------------- | :------: | | id | The primary key (auto-incremented) | PK | No | | type | A number (enum) indicating the type of the notification. | Int | Yes | | expires | When the notification expires, if it has not yet been displayed. | DateTime | Yes | | user\_id | The id of the user who should be notified. | FK [ejuser](./ejuser.mdx) | No | | owner\_id | The id of the user who is the original owner of this notification. | FK [ejuser](./ejuser.mdx) | No | | ticket\_id | The id of the ticket this notification message affects. | FK [ticket](./ticket.mdx) | No | | user2\_id | A second user involved in this notification | FK [ejuser](./ejuser.mdx) | Yes | | category\_id | The category involed in this notification | FK [ej\_category](./ej-category.mdx) | Yes | | chat\_topic\_id | Chat topic involed in this notification | FK [chat\_topic](./chat-topic.mdx) | Yes | | chat\_nick\_name | Chat customer nick name in this notification | String(255) | Yes | | ticket\_alert\_id | Ticket alert used when tickets are escalated | FK [ticket\_alert](./ticket-alert.mdx) | Yes | | custom\_message | Text for custom notify messages | String(255) | Yes | | contact\_id | Id of the assigned contact | FK [contact](./contact.mdx) | Yes | | person\_id | Id of the assigned person | FK [person](./person.mdx) | Yes | | custom\_url | An URL which can be set with custom notification messages | String(2048) | Yes | | registered | Registered when | UtcDateTime | Yes | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | Yes | notify table relationship diagram ## Indexes | Fields | Types | Description | | ----------------- | ----- | ----------- | | user\_id | FK | Index | | owner\_id | FK | Index | | ticket\_id | FK | Index | | user2\_id | FK | Index | | category\_id | FK | Index | | chat\_topic\_id | FK | Index | | ticket\_alert\_id | FK | Index | | contact\_id | FK | Index | | person\_id | FK | Index | ## Relationships | Table | Description | | ------------------------------- | ------------------------------------------------------------------------------------------------------------------------- | | [associate](./associate) | Employees, resources and other users - except for External persons | | [chat\_topic](./chat-topic) | This table contains chat topics. | | [contact](./contact) | Companies and Organizations. | | [ej\_category](./ej-category) | This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner. | | [ejuser](./ejuser) | This table contains entries for the users of the system. | | [person](./person) | Persons | | [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 \'chain\' of these levels. | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [Webhook_notify table](/en/database/tables/webhook-notify.md) - [What's new in version 12.0.342.0](/release-notes/database/changes-12.0.342.md) - [What's new in version 12.1.1412.0](/release-notes/database/changes-12.1.1412.md) - [What's new in version 12.2.2072.0](/release-notes/database/changes-12.2.2072.md) - [What's new in version 12.3.2195.0](/release-notes/database/changelog.md) - [Notify](/en/automation/crmscript/reference/CRMScript.Native.Notify.md)