public.kq_analysis_question
Description
Columns
| kq_analysisquestionid |
varchar(50) |
|
false |
|
|
Primary key for the question analysis record |
| kq_analysisid |
varchar(50) |
|
true |
|
|
References the parent kq_analysis record |
| question |
text |
|
true |
|
|
The question text extracted from the interaction |
| answer |
text |
|
true |
|
|
The answer text provided for the question |
| taxonomy |
varchar(200) |
|
true |
|
|
Legacy taxonomy string (may be deprecated in favor of
taxonomyid/taxonomypath) |
| knowledgeid |
varchar(50) |
|
true |
|
|
ID referencing the knowledge base entry used for this question |
| knowledge_confidence |
numeric(5,2) |
|
true |
|
|
Confidence score for the knowledge match (0.00 - 1.00 typical) |
| taxonomyid |
varchar(50) |
|
true |
|
|
Canonical taxonomy ID assigned to the question (nullable) |
| taxonomypath |
varchar(512) |
|
true |
|
|
Hierarchical taxonomy path for the question (nullable) |
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| kq_analysis_question_pkey |
PRIMARY KEY |
PRIMARY KEY (kq_analysisquestionid) |
Indexes
| kq_analysis_question_pkey |
CREATE UNIQUE INDEX kq_analysis_question_pkey ON
public.kq_analysis_question USING btree (kq_analysisquestionid) |
| idx_kq_analysis_question_kq_analysisid |
CREATE INDEX idx_kq_analysis_question_kq_analysisid ON
public.kq_analysis_question USING btree (kq_analysisid) |
Related Articles
public.kq_analysis_question_keyword
Description Columns Name Type Default Nullable Children Parents Comment kq_analysisquestionkeywordid varchar(50) false kq_analysisquestionid varchar(50) false keyword varchar(100) false updated timestamp without time zone true Constraints Name Type ...
public.kq_analysis_keyword
Description Columns Name Type Default Nullable Children Parents Comment kq_analysiskeywordid varchar(50) false kq_analysisid varchar(50) false keyword varchar(100) false updated timestamp without time zone true Constraints Name Type Definition ...
public.kq_analysis_taxonomy
Description Columns Name Type Default Nullable Children Parents Comment kq_analysistaxonomyid varchar(50) false Primary key for the taxonomy analysis record kq_analysisid varchar(50) true References the parent kq_analysis record taxonomy varchar(200) ...
public.kq_analysis
Description 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 ...
README
Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...