kb_group Table (286)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
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 | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| kb_category_id | The id of the kb_category in which this group is located. | FK kb_category | |
| description | The description for this group. | 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 | |
| parent_id | The parent group for this group. -1 if this is a toplevel group. | FK ej_category |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| 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.