public.evalquestiondata

public.evalquestiondata

Description

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(50) false
evaluationid varchar(50) false
evaluationformid varchar(50) false
questiongroupid varchar(50) true
questionid varchar(50) true
answerid varchar(50) true
score numeric(20,2) true
markedna bit(1) true
failedkillquestions bit(1) true
comments text true
updated timestamp without time zone true

Constraints

Name Type Definition
evalquestiondata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
evalquestiondata_pkey CREATE UNIQUE INDEX evalquestiondata_pkey ON public.evalquestiondata USING btree (keyid)
evalquestionsevaluationid CREATE INDEX evalquestionsevaluationid ON public.evalquestiondata USING btree (evaluationid)
evalquestionsformid CREATE INDEX evalquestionsformid ON public.evalquestiondata USING btree (evaluationformid)
evalquestionsgroupid CREATE INDEX evalquestionsgroupid ON public.evalquestiondata USING btree (questiongroupid)

    • Related Articles

    • public.vwevalquestiondata

      Description See EvalQuestionData: View for evaluation question data with additional details Table Definition CREATE VIEW vwevalquestiondata AS ( SELECT DISTINCT eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, ...
    • public.mvwevaluationquestiondata

      Description Materialized view for evaluation question data Table Definition CREATE MATERIALIZED VIEW mvwevaluationquestiondata AS ( SELECT DISTINCT eq.keyid, eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, eq.markedna, ...
    • public.mvwconvvoiceoverviewdata

      Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...
    • public.mvwconvvoicesentimentdetaildata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...
    • public.vwteammemberdata

      Description Team Member Data View Table Definition CREATE VIEW vwteammemberdata AS ( SELECT tm.userid, ud.name AS "Agent Name", td.name AS "Team Name" FROM ((teammemberdata tm LEFT JOIN vwuserdetail ud ON (((tm.userid)::text = (ud.id)::text))) LEFT ...