> ## 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_entry table

> This table contains FAQ entries.

## kb\_entry Table (282)

This table contains FAQ entries.

## Fields

| Name                   | Description                                                                 | Type                                 | Nullable |
| ---------------------- | --------------------------------------------------------------------------- | ------------------------------------ | :------: |
| id                     | The primary key (auto-incremented)                                          | PK                                   |    No    |
| category\_id           | The id of the category in which this entry is located.                      | FK [kb\_category](./kb-category.mdx) |    No    |
| title                  | The title of this entry.                                                    | String(255)                          |    Yes   |
| question               | The question for this entry.                                                | Clob                                 |    Yes   |
| answer                 | The answer for this entry.                                                  | Clob                                 |    Yes   |
| keywords               | The keywords for this entry                                                 | String(255)                          |    Yes   |
| access\_level          | The access level for this entry (enum).                                     | access\_level                        |    Yes   |
| created\_by            | The id of the user who owns this entry.                                     | FK [ejuser](./ejuser.mdx)            |    Yes   |
| sort\_order            | A scrictly ascending number indicating the sort-order when listing entries. | Int                                  |    No    |
| last\_changed          | When the entry was last changed.                                            | DateTime                             |    Yes   |
| read\_count            | The number of times someone has read this entry from the customer frontend. | Int                                  |    No    |
| score                  | The accumulated score (0..100) for this entry.                              | Int                                  |    Yes   |
| score\_weight          | The number of votes behind the accumulated score.                           | Int                                  |    Yes   |
| flags                  | A bitmap field.                                                             | UInt                                 |    Yes   |
| status                 | The status for this entry (enum).                                           | status                               |    Yes   |
| expire\_date           | The date until which this entry is valid.                                   | DateTime                             |    Yes   |
| workflow\_phase        | The workflow phase this entry is in                                         | FK [kb\_workflow](./kb-workflow.mdx) |    No    |
| 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    |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/kb_entry.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=56dee767c87a92109a8a9d2c6e9e5d69" alt="kb_entry table relationship diagram" width="1021" height="860" data-path="media/loc/en/database/tables/kb_entry.png" />

## Indexes

| Fields                            | Types                                | Description |
| --------------------------------- | ------------------------------------ | ----------- |
| category\_id                      | FK                                   | Index       |
| created\_by                       | FK                                   | Index       |
| sort\_order                       | Int                                  | Index       |
| workflow\_phase                   | FK                                   | Index       |
| dbi\_agent\_id                    | FK                                   | Index       |
| dbi\_key                          | String(255)                          | Index       |
| dbi\_last\_syncronized            | DateTime                             | Index       |
| dbi\_last\_modified               | DateTime                             | Index       |
| title, question, answer, keywords | String(255), Clob, Clob, String(255) | Full text   |

## Relationships

| Table                                                     | Description                                                                                                  |
| --------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------ |
| [dbi\_agent](./dbi-agent)                                 | DBI agent settings                                                                                           |
| [ejuser](./ejuser)                                        | This table contains entries for the users of the system.                                                     |
| [kb\_attachment](./kb-attachment)                         | This table connects FAQ entries to attachments.                                                              |
| [kb\_category](./kb-category)                             | Knowledge base folder hierarchy                                                                              |
| [kb\_entry\_comment](./kb-entry-comment)                  | Comments to entries in the knowledge base, typically made by customers                                       |
| [kb\_entry\_keyword](./kb-entry-keyword)                  | This table contains all keywords for the faq entries                                                         |
| [kb\_entry\_log](./kb-entry-log)                          | Who and when, if somebody edits a knowledge base entry                                                       |
| [kb\_group\_entry](./kb-group-entry)                      | This table contains group entries for FAQ groups.                                                            |
| [kb\_http\_link](./kb-http-link)                          | This table contains URL\&apos;s associated with a single FAQ entry.                                          |
| [kb\_solution\_finder\_entry](./kb-solution-finder-entry) | Knowledge base problem solving wizard, items in a category linking to a knowledge base entry                 |
| [kb\_workflow](./kb-workflow)                             | Knowledge base workflow steps                                                                                |
| [word\_relations](./word-relations)                       | This table shows which word are used in which FAQ entry, and how many times            they are used in each |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [kb_entry_keyword table](/en/database/tables/kb-entry-keyword.md)
- [kb_entry_log table](/en/database/tables/kb-entry-log.md)
- [kb_entry_comment table](/en/database/tables/kb-entry-comment.md)
- [kb_entry_words table](/en/database/tables/kb-entry-words.md)
- [kb_group_entry table](/en/database/tables/kb-group-entry.md)
- [kb_solution_finder_entry table](/en/database/tables/kb-solution-finder-entry.md)