public.knowledgebasedocument
Description
Columns
| id |
varchar(50) |
|
false |
|
|
|
| title |
varchar(255) |
|
true |
|
|
|
| visible |
boolean |
|
true |
|
|
|
| state |
varchar(50) |
|
true |
|
|
|
| datecreated |
timestamp without time zone |
|
true |
|
|
|
| datemodified |
timestamp without time zone |
|
true |
|
|
|
| dateimported |
timestamp without time zone |
|
true |
|
|
|
| datepublished |
timestamp without time zone |
|
true |
|
|
|
| lastpublishedversionnumber |
integer |
|
true |
|
|
|
| documentversion |
varchar(50) |
|
true |
|
|
|
| externalid |
varchar(100) |
|
true |
|
|
|
| categoryid |
varchar(50) |
|
true |
|
|
|
| knowledgebaseid |
varchar(50) |
|
true |
|
|
|
| readonly |
boolean |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| knowledgebasedocument_pkey |
PRIMARY KEY |
PRIMARY KEY (id) |
Indexes
| knowledgebasedocument_pkey |
CREATE UNIQUE INDEX knowledgebasedocument_pkey ON
public.knowledgebasedocument USING btree (id) |
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.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.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.agentcopilotaggregatesdata
Description Aggregated agent copilot usage metrics from Genesys Cloud Analytics API with all 24 dimensions Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false SHA256 hash of all 24 dimensions + interval for uniqueness ...