public.knowledgebasecategorydata
Columns
| id |
varchar(50) |
|
false |
|
|
|
| name |
varchar(100) |
|
true |
|
|
|
| description |
varchar(255) |
|
true |
|
|
|
| externalid |
varchar(100) |
|
true |
|
|
|
| datecreated |
timestamp without time zone |
|
true |
|
|
|
| datemodified |
timestamp without time zone |
|
true |
|
|
|
| documentcount |
integer |
|
true |
|
|
|
| knowledgebaseid |
varchar(100) |
|
true |
|
|
|
| parentcategoryid |
varchar(100) |
|
true |
|
|
|
| parentcategoryname |
varchar(100) |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| knowledgebasecategorydata_pkey |
PRIMARY KEY |
PRIMARY KEY (id) |
Indexes
| knowledgebasecategorydata_pkey |
CREATE UNIQUE INDEX knowledgebasecategorydata_pkey ON
public.knowledgebasecategorydata 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 ...
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 ...