kb_category Table (283)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
Knowledge base folder hierarchy
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| parent_id | This entry contains a reference to the parent category. NULL or -1 if this is a toplevel category. | FK kb_category | |
| name | The name of this category. | String(64) | ● |
| fullname | The full name of this category, i.e. Foo/bar/test. | Clob | ● |
| description | The description of this category. | Clob | ● |
| sort_order | A strictly ascending number used for sorting categories when they are listed. | Int | |
| access_level | The access level for this category (enum). | access_level | ● |
| inherited_access_level | The lowest access level for this category or any parent | inherited_access_level | ● |
| created_by | The id of the user who created this category. | FK ejuser | ● |
| access_check | Contains a Parser-script used for evaluating customer access to this category. | 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 |
| parent_id | FK | Index |
| sort_order | Int | Index |
| created_by | 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 |
|---|---|
| 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). |
Replication Flags
- None
Security Flags
- No access control via user's Role.