public.knowledgebasecategorydata
Description
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 ...
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 ...