public.kq_analysis_taxonomy
Description
Columns
| 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 |
varchar(200) |
|
true |
|
|
Legacy taxonomy string assigned to this analysis segment |
| taxonomyid |
uuid |
|
true |
|
|
Canonical taxonomy UUID (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) |
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 uuid false public.kq_analysis_question_keyword Primary key UUID for the question analysis record kq_analysisid uuid true Foreign key UUID referencing the ...
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
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 ...
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() ...
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 ...