public.knowledgebasedocument
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.knowledgebasedocumentversion
Columns Name Type Default Nullable Children Parents Comment id varchar(50) false datepublished timestamp without time zone true dateexpires timestamp without time zone true documentid varchar(50) true versionnumber integer true updated timestamp ...