> ## 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. # kb_category table > Knowledge base folder hierarchy ## kb\_category Table (283) Knowledge base folder hierarchy ## Fields | Name | Description | Type | Nullable | | ------------------------ | -------------------------------------------------------------------------------------------------- | ------------------------------------ | :------: | | id | The primary key (auto-incremented) | PK | No | | parent\_id | This entry contains a reference to the parent category. NULL or -1 if this is a toplevel category. | FK [kb\_category](./kb-category.mdx) | No | | name | The name of this category. | String(64) | Yes | | fullname | The full name of this category, i.e. Foo/bar/test. | Clob | Yes | | description | The description of this category. | Clob | Yes | | sort\_order | A strictly ascending number used for sorting categories when they are listed. | Int | No | | access\_level | The access level for this category (enum). | access\_level | Yes | | inherited\_access\_level | The lowest access level for this category or any parent | inherited\_access\_level | Yes | | created\_by | The id of the user who created this category. | FK [ejuser](./ejuser.mdx) | Yes | | access\_check | Contains a Parser-script used for evaluating customer access to this category. | Clob | Yes | | dbi\_agent\_id | Integration agent (eJournal) | FK [dbi\_agent](./dbi-agent.mdx) | No | | dbi\_key | The primary key for the integrated entry in the external datasource. | String(255) | No | | dbi\_last\_syncronized | Last external syncronization. | DateTime | No | | dbi\_last\_modified | When the entry was last modified. | DateTime | No | kb_category table relationship diagram ## Indexes | Fields | Types | Description | | ---------------------- | ----------- | ----------- | | parent\_id | FK | Index | | sort\_order | Int | Index | | created\_by | FK | Index | | dbi\_agent\_id | FK | Index | | dbi\_key | String(255) | Index | | dbi\_last\_syncronized | DateTime | Index | | dbi\_last\_modified | DateTime | Index | ## Relationships | Table | Description | | -------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [chat\_topic](./chat-topic) | This table contains chat topics. | | [cust\_lang](./cust-lang) | This table contains entries for customer languages. | | [dbi\_agent](./dbi-agent) | DBI agent settings | | [ejuser](./ejuser) | This table contains entries for the users of the system. | | [kb\_category](./kb-category) | Knowledge base folder hierarchy | | [kb\_category\_log](./kb-category-log) | Who and when, if somebody edits a knowledge base folder | | [kb\_entry](./kb-entry) | This table contains FAQ entries. | | [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). | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [kb_category_log table](/en/database/tables/kb-category-log.md) - [kb_group table](/en/database/tables/kb-group.md) - [kb_attachment table](/en/database/tables/kb-attachment.md) - [SuperOffice.WebApi.Data.KbCategory](/en/api/reference/webapi/SuperOffice.WebApi.Data.KbCategory.md) - [kb_entry table](/en/database/tables/kb-entry.md) - [kb_solution_finder table](/en/database/tables/kb-solution-finder.md)