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

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...

    • public.userpresencedetaileddata

      Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...