public.knowledgedocumentfeedbackdata
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 ...
README
Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...