kb_entry_comment Table (289)
Some tooltip text!
• 1 minute to read
• 1 minute to read
Comments to entries in the knowledge base, typically made by customers
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| kb_entry_id | The id of the kb_entry which this comment belongs to. | FK kb_entry | |
| time_posted | When the comment was posted. | DateTime | |
| publish_status | Publish status of comment. 0 is undefined, 1 is not published, 2 is published | publish_status | |
| author | The author of the entry | String(255) | ● |
| customer_id | The id of the customer that created this comment. | FK person | |
| body | The contents of the comment. | Clob | ● |
| dbi_agent_id | Integration agent (eJournal) | FK dbi_agent | |
| dbi_key | The primary key for the integrated entry in the external datasource. | String(255) | |
| dbi_last_syncronized | Last external syncronization. | DateTime | |
| dbi_last_modified | When the entry was last modified. | DateTime |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| 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 settings |
| kb_entry | This table contains FAQ entries. |
| person | Persons in a company or an organizations. All associates have a corresponding person record |
Replication Flags
- None
Security Flags
- No access control via user's Role.