public.botreportingturnsdata

public.botreportingturnsdata

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 varchar(100) true
actionnumber integer true
actiontype varchar(100) true
intentname varchar(50) true
intentconfidence numeric(4,2) true
intentslotname varchar(50) true
intentsslotvalue text 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
eventsknowledgebaseid 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
botreportingturnsdata_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
botreportingturnsdata_pkey CREATE UNIQUE INDEX botreportingturnsdata_pkey ON public.botreportingturnsdata USING btree (id)

    • Related Articles

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

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true score ...

    • public.participantattributesdynamic

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

    • public.hoursblockdata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...

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