public.knowledgedocumentfeedbackdata
Description
Columns
| keyid |
varchar(200) |
|
false |
|
|
|
| feedbackid |
varchar(50) |
|
false |
|
|
|
| knowledgebaseid |
varchar(50) |
|
false |
|
|
|
| documentid |
varchar(50) |
|
false |
|
|
|
| rating |
varchar(20) |
|
true |
|
|
|
| reason |
varchar(50) |
|
true |
|
|
|
| comment |
text |
|
true |
|
|
|
| userid |
varchar(50) |
|
true |
|
|
|
| documentversionid |
varchar(50) |
|
true |
|
|
|
| documentvariationid |
varchar(50) |
|
true |
|
|
|
| sessionid |
varchar(50) |
|
true |
|
|
|
| querytype |
varchar(50) |
|
true |
|
|
|
| searchid |
varchar(50) |
|
true |
|
|
|
| datecreated |
timestamp without time zone |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| knowledgedocumentfeedbackdata_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| knowledgedocumentfeedbackdata_pkey |
CREATE UNIQUE INDEX knowledgedocumentfeedbackdata_pkey ON
public.knowledgedocumentfeedbackdata USING btree (keyid) |
| idx_knowledgedocumentfeedbackdata_knowledgebaseid |
CREATE INDEX idx_knowledgedocumentfeedbackdata_knowledgebaseid ON
public.knowledgedocumentfeedbackdata USING btree (knowledgebaseid) |
| idx_knowledgedocumentfeedbackdata_documentid |
CREATE INDEX idx_knowledgedocumentfeedbackdata_documentid ON
public.knowledgedocumentfeedbackdata USING btree (documentid) |
| idx_knowledgedocumentfeedbackdata_rating |
CREATE INDEX idx_knowledgedocumentfeedbackdata_rating ON
public.knowledgedocumentfeedbackdata USING btree (rating) |
| idx_knowledgedocumentfeedbackdata_datecreated |
CREATE INDEX idx_knowledgedocumentfeedbackdata_datecreated ON
public.knowledgedocumentfeedbackdata USING btree (datecreated) |
Related Articles
public.vwknowledgebase
Description Comprehensive view of knowledge bases with document, category, feedback, and usage statistics Table Definition CREATE VIEW vwknowledgebase AS ( SELECT kb.id, kb.name, kb.description, kb.corelanguage AS core_language, kb.datecreated AS ...
public.vwknowledgedocument
Description Comprehensive view of knowledge documents with knowledge base, category context, and feedback statistics Table Definition CREATE VIEW vwknowledgedocument AS ( SELECT doc.id, doc.title, doc.visible, doc.state, doc.datecreated AS ...
public.vwknowledgedocumentfeedback
Description Comprehensive view of knowledge document feedback with user, document, version, and knowledge base context Table Definition CREATE VIEW vwknowledgedocumentfeedback AS ( SELECT fb.keyid, fb.feedbackid AS feedback_id, fb.datecreated AS ...
public.vwknowledgecategory
Description Knowledge base categories with KB context, document statistics, feedback metrics, and hierarchy information Table Definition CREATE VIEW vwknowledgecategory AS ( SELECT cat.id AS category_id, cat.name AS category_name, cat.description AS ...
public.evalquestiondata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true ...