> ## 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. # ej_category table > This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner. ## ej\_category Table (257) This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner. ## Fields | Name | Description | Type | Nullable | | -------------------- | ----------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------- | :------: | | id | The primary key (auto-incremented) | PK | No | | parent\_id | The parent category for this category. -1 if this is a toplevel category. | FK [ej\_category](./ej-category.mdx) | No | | name | The (short) name of this category. E.g. \'support\'. | String(64) | Yes | | category\_master | The user associated with this category. | FK [ejuser](./ejuser.mdx) | Yes | | fullname | The fullname (compiled from parents\' names) for this category. E.g. \'norway/product A/support\'. | String(255) | Yes | | flags | A bitmask representing flags for this category. | Enum [TicketCategoryFlags](./enums/ticketcategoryflags.mdx) | Yes | | delegate\_method | An integer indicating the delegation method for this category. | Enum [TicketCategoryDelegateMethod](./enums/ticketcategorydelegatemethod.mdx) | Yes | | delegate\_counter | A delegate counter, incremented by 1 for every delegation | Int | No | | external\_name | The external name for this category, used for the customer frontend. | String(255) | Yes | | assignment\_lag | Number of minutes we shall override the assignment if a customer sends consecutive messages to this category | Int | Yes | | reply\_template | Reply template to merge with messages posted in this category | FK [reply\_template](./reply-template.mdx) | Yes | | notification\_email | Comma separated list of addresses to notify when requests are redelegated to (unassigned) in this category. | String(2047) | Yes | | closing\_status | Default status for new tickets, if 0 then there is a fallback to a user-dependent value | FK [ticket\_status](./ticket-status.mdx) | Yes | | msg\_closing\_status | Default status for new messages, if 0 then there is a fallback to a user-dependent value | FK [ticket\_status](./ticket-status.mdx) | Yes | ej_category table relationship diagram ## Indexes | Fields | Types | Description | | ---------------- | ----- | ----------- | | parent\_id | FK | Index | | category\_master | FK | Index | | reply\_template | FK | Index | ## Relationships | Table | Description | | --------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [category\_membership](./category-membership) | This table connects users to categories (many-to-many). | | [chat\_topic](./chat-topic) | This table contains chat topics. | | [cust\_category](./cust-category) | This table contains entries for categories exposed through a customer language. | | [ej\_category](./ej-category) | This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner. | | [EjCategoryGroupLink](./ejcategorygrouplink) | User group link table for EjCategory, for mass handling ej\_category members | | [ejuser](./ejuser) | This table contains entries for the users of the system. | | [kb\_group](./kb-group) | This table contains FAQ groups. A group is a cluster of entries (potentially located anywhere in the FAQ hierarchy). A group is located in a certain category. | | [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. | | [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 | | [role\_category](./role-category) | Category membership associated with a role | | [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\_status](./ticket-status) | This table user defined ticket status values. | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [EjCategoryGroupLink table](/en/database/tables/ejcategorygrouplink.md) - [category_membership table](/en/database/tables/category-membership.md) - [role_category table](/en/database/tables/role-category.md) - [cust_category table](/en/database/tables/cust-category.md) - [ejcategory](/en/api/mdo-providers/reference/ejcategory.md) - [What's new in version 10.1.2.686](/release-notes/database/changes-10.1.2.md)