public.botreportingturns

public.botreportingturns

Description

Columns

Name Type Default Nullable Children Parents Comment
id text false
userinput text true
botprompt text true
sessionid varchar(200) true
actionid varchar(200) true
actionname varchar(100) true
actionnumber integer true
actiontype varchar(100) true
intentname varchar(50) true
intentconfidence numeric(4,2) true
intentslotname varchar(50) true
intentsslotvalue varchar(50) true
intentslottype varchar(50) true
intentslotconfidence numeric(4,2) true
knowledgebaseid varchar(50) true
feedbacksearchid varchar(50) true
feedbackrating integer true
feedbackdocid varchar(50) true
feedbackdocquestion text true
feedbackdocanswer text true
feedbackdocconfidence numeric(4,2) true
searchid varchar(50) true
searchquery text true
searchdoc varchar(200) true
eventssearchid varchar(50) true
eventsknwowledgebaseid varchar(50) true
eventssearchquery text true
eventsanswerdocid text true
eventsdoc varchar(200) true
eventsfeedbackid varchar(50) true
eventsfeedbackkbid varchar(50) true
eventsfeedbackrating integer true
eventsfeedbackdoc varchar(200) true
eventsdocvariationid varchar(50) true
eventsdocversionid varchar(50) true
datecreated timestamp without time zone true
datecompleted timestamp without time zone true
askactionresult varchar(50) true
sessionendtype varchar(50) true
sessionendreason varchar(50) true
conversationid varchar(50) true
updated timestamp without time zone true

Constraints

Name Type Definition
botreportingturns_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
botreportingturns_pkey CREATE UNIQUE INDEX botreportingturns_pkey ON public.botreportingturns 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.botreportingturnsdata

      Description Columns Name Type Default Nullable Children Parents Comment id text false flowid varchar(100) true flowname varchar(255) true userinput text true botprompt text true sessionid varchar(200) true actionid varchar(200) true actionname ...

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

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