kb_entry Table (282)
•
Environment: onsite, online
Some tooltip text!
• 3 minutes to read
• 3 minutes to read
This table contains FAQ entries.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| category_id | The id of the category in which this entry is located. | FK kb_category | |
| title | The title of this entry. | String(255) | ● |
| question | The question for this entry. | Clob | ● |
| answer | The answer for this entry. | Clob | ● |
| keywords | The keywords for this entry | String(255) | ● |
| access_level | The access level for this entry (enum). | access_level | ● |
| created_by | The id of the user who owns this entry. | FK ejuser | ● |
| sort_order | A scrictly ascending number indicating the sort-order when listing entries. | Int | |
| last_changed | When the entry was last changed. | DateTime | ● |
| read_count | The number of times someone has read this entry from the customer frontend. | Int | |
| score | The accumulated score (0..100) for this entry. | Int | ● |
| score_weight | The number of votes behind the accumulated score. | Int | ● |
| flags | A bitmap field. | UInt | ● |
| status | The status for this entry (enum). | status | ● |
| expire_date | The date until which this entry is valid. | DateTime | ● |
| workflow_phase | The workflow phase this entry is in | FK kb_workflow | |
| 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 |
| 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 settings |
| ejuser | This table contains entries for the users of the system. |
| kb_attachment | This table connects FAQ entries to attachments. |
| kb_category | Knowledge base folder hierarchy |
| kb_entry_comment | Comments to entries in the knowledge base, typically made by customers |
| kb_entry_keyword | This table contains all keywords for the faq entries |
| kb_entry_log | Who and when, if somebody edits a knowledge base entry |
| kb_group_entry | This table contains group entries for FAQ groups. |
| kb_http_link | This table contains URL's associated with a single FAQ entry. |
| kb_solution_finder_entry | Knowledge base problem solving wizard, items in a category linking to a knowledge base entry |
| kb_workflow | Knowledge base workflow steps |
| 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.