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)