kb_entry_comment Table (289)

•
Environment: onsite, online
• 1 minute to read
 • 1 minute to read

Comments to entries in the knowledge base, typically made by customers

Fields

Name Description Type Null
id The primary key (auto-incremented) PK
kb_entry_id The id of the kb_entry which this comment belongs to. FK kb_entry
time_posted When the comment was posted. DateTime
publish_status Publish status of comment. 0 is undefined, 1 is not published, 2 is published publish_status
author The author of the entry String(255) ●
customer_id The id of the customer that created this comment. FK person
body The contents of the comment. 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

kb_entry_comment table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
kb_entry_id FK Index
customer_id 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
dbi_agent DBI agent settings
kb_entry This table contains FAQ entries.
person Persons

Replication Flags

  • None

Security Flags

  • No access control via user's Role.