public.kq_analysis_question

public.kq_analysis_question

Description

Columns

Name Type Default Nullable Children Parents Comment
kq_analysisquestionid uuid false
kq_analysisid uuid true
question text true
answer text true
taxonomy varchar(200) true
knowledgeid uuid true
knowledge_confidence numeric(5,2) true

Constraints

Name Type Definition
kq_analysis_question_pkey PRIMARY KEY PRIMARY KEY (kq_analysisquestionid)

Indexes

Name Definition
kq_analysis_question_pkey CREATE UNIQUE INDEX kq_analysis_question_pkey ON public.kq_analysis_question USING btree (kq_analysisquestionid)
idx_kq_analysis_question_kq_analysisid CREATE INDEX idx_kq_analysis_question_kq_analysisid ON public.kq_analysis_question USING btree (kq_analysisid)

    • Related Articles

    • public.kq_analysis_taxonomy

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysistaxonomyid uuid false kq_analysisid uuid true taxonomy varchar(200) true Constraints Name Type Definition kq_analysis_taxonomy_pkey PRIMARY KEY PRIMARY KEY ...
    • public.kq_analysis

      Description Columns Name Type Default Nullable Children Parents Comment kq_analysisid uuid false conversationid uuid true communicationid uuid true callsummary text true callresolution text true callbackrequired boolean true selfserviceattempted ...
    • 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 ...
    • public.evaldetails

      Description Evaluation Lookup Data Columns Name Type Default Nullable Children Parents Comment id varchar(200) false Primary Key evaluationid varchar(50) true Evaluation Form GUID (Historical column name - this actually contains the form ID, not the ...
    • public.vwevaldetails

      Description See EvalDetails- Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwevaldetails AS ( SELECT evaldetails.id, evaldetails.evaluationid, evaldetails.evaluationformid, evaldetails.evaluationname, ...