public.kq_analysis

public.kq_analysis

Columns

Name Type Default Nullable Children Parents Comment
kq_analysisid varchar(50) false Primary key for the knowledge analysis record
conversationid varchar(50) true ID of the Genesys Cloud conversation this analysis relates to
communicationid varchar(50) true ID of the specific communication within the conversation
callsummary text true AI-generated summary of the call/interaction
callresolution text true Description of how the call was resolved
callbackrequired boolean true Boolean indicating if a callback was requested
selfserviceattempted boolean true Boolean indicating if self-service was attempted
selfserviceproblems boolean true Boolean indicating if self-service problems occurred
satisfactionsentiment numeric(5,2) true Customer satisfaction sentiment score (-1.00 to 1.00 typical)
knowledgeareaid varchar(50) true Canonical ID for the knowledge area connected to this analysis (nullable)
knowledgeareaname varchar(400) true Human-readable name of the knowledge area assigned to the analysis (nullable)
qualityinteraction boolean true Boolean flag marking if the interaction is considered a quality interaction (nullable)
updated timestamp without time zone true

Constraints

Name Type Definition
kq_analysis_pkey PRIMARY KEY PRIMARY KEY (kq_analysisid)

Indexes

Name Definition
kq_analysis_pkey CREATE UNIQUE INDEX kq_analysis_pkey ON public.kq_analysis USING btree (kq_analysisid)
idx_kq_analysis_communicationid CREATE INDEX idx_kq_analysis_communicationid ON public.kq_analysis USING btree (communicationid)
idx_kq_analysis_conversationid CREATE INDEX idx_kq_analysis_conversationid ON public.kq_analysis USING btree (conversationid)