public.kq_analysis_taxonomy
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
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 The question ...
public.kq_analysis_keyword
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
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 ...
public.kq_analysis_question_keyword
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 Definition ...
public.odcampaigndetails
Description Outbound Dialling Campaign Lookup Data Columns Name Type Default Nullable Children Parents Comment id varchar(50) false Primary Key / Campaign GUID name varchar(200) true Campaign Name datecreated timestamp without time zone true Campaign ...