kb_entry table

kb_entry Table (282)

This table contains FAQ entries.

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	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	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	No
dbi_agent_id	Integration agent (eJournal)	FK dbi_agent	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

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

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