public.kq_analysis_taxonomy

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 (kq_analysistaxonomyid)

Indexes

Name Definition
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 kq_analysisid uuid true question text true answer text true taxonomy varchar(200) true knowledgeid uuid true knowledge_confidence numeric(5,2) ...

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

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

    • public.convsummarydata

      Description Conversation Summary Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true Conversation GUID conversationstartdate timestamp without time zone false Conversation Start ...

    • public.convvoiceoverviewdata

      Description Voice Analysis Overview Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false Primary Key conversationid varchar(50) true Conversation GUID sentimentscore numeric(20,2) true Convesation Sentiment Score ...