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.vwbotreportingturns

      Description Normalized view of bot reporting turns with categorized confidence levels, feedback ratings, and duration calculations Table Definition CREATE VIEW vwbotreportingturns AS ( SELECT brt.id, brt.sessionid, brt.conversationid, brt.actionid, ...

    • public.vwbotreportingturnsdata

      Description Normalized view of bot reporting turns with categorized confidence levels, feedback ratings, and duration calculations Table Definition CREATE VIEW vwbotreportingturnsdata AS ( SELECT brt.id, brt.flowid, brt.flowname, brt.sessionid, ...

    • public.knowledgebasedocumentversion

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

    • public.knowledgebasedocument

      Description Columns Name Type Default Nullable Children Parents Comment 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 ...

    • public.knowledgebasecategorydata

      Description Columns Name Type Default Nullable Children Parents Comment 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 ...