kb_group table - SuperOffice

kb_group Table (286)

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.

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
kb_category_id	The id of the kb_category in which this group is located.	FK kb_category	No
description	The description for this group.	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
parent_id	The parent group for this group. -1 if this is a toplevel group.	FK ej_category	No

kb_group table relationship diagram

Indexes

Fields	Types	Description
kb_category_id	FK	Index
dbi_agent_id	FK	Index
dbi_key	String(255)	Index
dbi_last_syncronized	DateTime	Index
dbi_last_modified	DateTime	Index
parent_id	FK	Index

Relationships

Table	Description
dbi_agent	DBI agent settings
ej_category	This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner.
kb_category	Knowledge base folder hierarchy
kb_group_entry	This table contains group entries for FAQ groups.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

kb_group_entry table kb_category table kb_entry table kb_workflow table kb_attachment table kb_workflow_access table

⌘I