kb_entry_comment table

kb_entry_comment Table (289)

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

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
kb_entry_id	The id of the kb_entry which this comment belongs to.	FK kb_entry	No
time_posted	When the comment was posted.	DateTime	No
publish_status	Publish status of comment. 0 is undefined, 1 is not published, 2 is published	publish_status	No
author	The author of the entry	String(255)	Yes
customer_id	The id of the customer that created this comment.	FK person	No
body	The contents of the comment.	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
dbi_agent	DBI agent settings
kb_entry	This table contains FAQ entries.
person	Persons