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

> Comments to entries in the knowledge base, typically made by customers

## kb\_entry\_comment Table (289)

Comments to entries in the knowledge base, typically made by customers

## Fields

| Name                   | Description                                                                   | Type                             | Nullable |
| ---------------------- | ----------------------------------------------------------------------------- | -------------------------------- | :------: |
| id                     | The primary key (auto-incremented)                                            | PK                               |    No    |
| kb\_entry\_id          | The id of the kb\_entry which this comment belongs to.                        | FK [kb\_entry](./kb-entry.mdx)   |    No    |
| time\_posted           | When the comment was posted.                                                  | DateTime                         |    No    |
| publish\_status        | Publish status of comment. 0 is undefined, 1 is not published, 2 is published | publish\_status                  |    No    |
| author                 | The author of the entry                                                       | String(255)                      |    Yes   |
| customer\_id           | The id of the customer that created this comment.                             | FK [person](./person.mdx)        |    No    |
| body                   | The contents of the comment.                                                  | 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    |

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

## Indexes

| Fields                 | Types       | Description |
| ---------------------- | ----------- | ----------- |
| kb\_entry\_id          | FK          | Index       |
| customer\_id           | 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                      |
| ------------------------- | -------------------------------- |
| [dbi\_agent](./dbi-agent) | DBI agent settings               |
| [kb\_entry](./kb-entry)   | This table contains FAQ entries. |
| [person](./person)        | Persons                          |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

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