public.knowledgebase

public.knowledgebase

Description

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false
name varchar(100) true
description varchar(255) true
corelanguage varchar(50) true
datecreated timestamp without time zone true
datemodified timestamp without time zone true
datedocumentlastmodified timestamp without time zone true
faqcount integer true
articlecount integer true
published boolean true
updated timestamp without time zone true

Constraints

Name Type Definition
knowledgebase_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
knowledgebase_pkey CREATE UNIQUE INDEX knowledgebase_pkey ON public.knowledgebase 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.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 ...

    • public.vwknowledgeaggregatesdata

      Description Knowledge usage analytics with user and knowledge base context for reporting Table Definition CREATE VIEW vwknowledgeaggregatesdata AS ( SELECT ka.keyid, ka.intervalstart AS interval_start, ka.intervalend AS interval_end, ka.usagedate AS ...