kb_category table

kb_category Table (283)

Knowledge base folder hierarchy

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
parent_id	This entry contains a reference to the parent category. NULL or -1 if this is a toplevel category.	FK kb_category	No
name	The name of this category.	String(64)	Yes
fullname	The full name of this category, i.e. Foo/bar/test.	Clob	Yes
description	The description of this category.	Clob	Yes
sort_order	A strictly ascending number used for sorting categories when they are listed.	Int	No
access_level	The access level for this category (enum).	access_level	Yes
inherited_access_level	The lowest access level for this category or any parent	inherited_access_level	Yes
created_by	The id of the user who created this category.	FK ejuser	Yes
access_check	Contains a Parser-script used for evaluating customer access to this category.	Clob	Yes
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

Table	Description
chat_topic	This table contains chat topics.
cust_lang	This table contains entries for customer languages.
dbi_agent	DBI agent settings
ejuser	This table contains entries for the users of the system.
kb_category	Knowledge base folder hierarchy
kb_category_log	Who and when, if somebody edits a knowledge base folder
kb_entry	This table contains FAQ entries.
kb_group	This table contains FAQ groups. A group is a cluster of entries (potentially located anywhere in the FAQ hierarchy). A group is located in a certain category.
mail_in_filter	This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP).