public.kq_analysis

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 boolean true
selfserviceproblems boolean true
satisfactionsentiment numeric(5,2) true

Constraints

Name Type Definition
kq_analysis_pkey PRIMARY KEY PRIMARY KEY (kq_analysisid)

Indexes

Name Definition
kq_analysis_pkey CREATE UNIQUE INDEX kq_analysis_pkey ON public.kq_analysis USING btree (kq_analysisid)
idx_kq_analysis_communicationid CREATE INDEX idx_kq_analysis_communicationid ON public.kq_analysis USING btree (communicationid)
idx_kq_analysis_conversationid CREATE INDEX idx_kq_analysis_conversationid ON public.kq_analysis USING btree (conversationid)

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