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

    • 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.mvwconvvoiceoverviewdata

      Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...

    • public.mvwconvvoicesentimentdetaildata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...