public.kq_analysis_question_keyword

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() true
updated_date timestamp without time zone true

Constraints

Name Type Definition
fk_kq_analysis_question_keyword_question FOREIGN KEY FOREIGN KEY (kq_analysisquestionid) REFERENCES kq_analysis_question(kq_analysisquestionid)
kq_analysis_question_keyword_pkey PRIMARY KEY PRIMARY KEY (kq_analysisquestionkeywordid)

Indexes

Name Definition
kq_analysis_question_keyword_pkey CREATE UNIQUE INDEX kq_analysis_question_keyword_pkey ON public.kq_analysis_question_keyword USING btree (kq_analysisquestionkeywordid)
idx_kq_analysis_question_keyword_questionid CREATE INDEX idx_kq_analysis_question_keyword_questionid ON public.kq_analysis_question_keyword USING btree (kq_analysisquestionid)

    • 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_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 ...