public.kq_analysis_taxonomy
Description
Columns
| 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) |
|
true |
|
|
Legacy taxonomy string assigned to this analysis segment |
| taxonomyid |
varchar(50) |
|
true |
|
|
Canonical taxonomy ID (nullable) |
| taxonomypath |
varchar(512) |
|
true |
|
|
Hierarchical taxonomy path string (nullable) |
| taxonomyconfidence |
numeric(5,4) |
|
true |
|
|
Confidence score for taxonomy assignment (0.0000 - 1.0000
typical) |
| taxonomydecisionsource |
varchar(32) |
|
true |
|
|
Short identifier describing decision source (e.g. model, human) |
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| kq_analysis_taxonomy_pkey |
PRIMARY KEY |
PRIMARY KEY (kq_analysistaxonomyid) |
Indexes
| kq_analysis_taxonomy_pkey |
CREATE UNIQUE INDEX kq_analysis_taxonomy_pkey ON
public.kq_analysis_taxonomy USING btree (kq_analysistaxonomyid) |
| idx_kq_analysis_taxonomy_kq_analysisid |
CREATE INDEX idx_kq_analysis_taxonomy_kq_analysisid ON
public.kq_analysis_taxonomy USING btree (kq_analysisid) |
Related Articles
public.kq_analysis_question
Description Columns Name Type Default Nullable Children Parents Comment 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 ...
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
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 ...
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 ...
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 ...