public.kq_analysis_question
Description
Columns
| kq_analysisquestionid |
uuid |
|
false |
public.kq_analysis_question_keyword |
|
Primary key UUID for the question analysis record |
| kq_analysisid |
uuid |
|
true |
|
|
Foreign key UUID referencing 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 |
uuid |
|
true |
|
|
UUID 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 |
uuid |
|
true |
|
|
Canonical taxonomy UUID assigned to the question (nullable) |
| taxonomypath |
varchar(512) |
|
true |
|
|
Hierarchical taxonomy path for the question (nullable) |
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 uuid false kq_analysisquestionid uuid false public.kq_analysis_question keyword varchar(100) false created_date timestamp without time zone now() ...
public.kq_analysis_keyword
Description Columns Name Type Default Nullable Children Parents Comment kq_analysiskeywordid uuid false kq_analysisid uuid false public.kq_analysis keyword varchar(100) false created_date timestamp without time zone now() true updated_date timestamp ...
public.kq_analysis_taxonomy
Description Columns Name Type Default Nullable Children Parents Comment kq_analysistaxonomyid uuid false Primary key UUID for the taxonomy analysis record kq_analysisid uuid true Foreign key UUID referencing the parent kq_analysis record taxonomy ...
public.kq_analysis
Description Columns Name Type Default Nullable Children Parents Comment kq_analysisid uuid false public.kq_analysis_keyword Primary key UUID for the knowledge analysis record conversationid uuid true UUID of the Genesys Cloud conversation this ...
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 ...