public.kq_analysis_keyword
Description
Columns
| 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 without time zone |
|
true |
|
|
|
Constraints
| fk_kq_analysis_keyword_analysis |
FOREIGN KEY |
FOREIGN KEY (kq_analysisid) REFERENCES
kq_analysis(kq_analysisid) |
| kq_analysis_keyword_pkey |
PRIMARY KEY |
PRIMARY KEY (kq_analysiskeywordid) |
Indexes
| kq_analysis_keyword_pkey |
CREATE UNIQUE INDEX kq_analysis_keyword_pkey ON
public.kq_analysis_keyword USING btree (kq_analysiskeywordid) |
| idx_kq_analysis_keyword_kq_analysisid |
CREATE INDEX idx_kq_analysis_keyword_kq_analysisid ON
public.kq_analysis_keyword 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
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
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_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 ...
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 ...