public.evaldata

public.evaldata

Description

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
conversationid varchar(50) false
evaluationid varchar(50) false
calibrationid varchar(50) true
evaluationformid varchar(50) true
evaluatorid varchar(50) true
userid varchar(50) true
status varchar(20) true
totalscore numeric(20,2) true
averagescore numeric(20,2) true
lowscore numeric(20,2) true
highscore numeric(20,2) true
totalcriticalscore numeric(20,2) true
totalnoncriticalscore numeric(20,2) true
agenthasread bit(1) true
releasedate timestamp without time zone true
releasedateltc timestamp without time zone true
assigneddate timestamp without time zone true
assigneddateltc timestamp without time zone true
updated timestamp without time zone true

Constraints

Name Type Definition
evaldata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
evaldata_pkey CREATE UNIQUE INDEX evaldata_pkey ON public.evaldata USING btree (keyid)
evaldataconversationid CREATE INDEX evaldataconversationid ON public.evaldata USING btree (conversationid)
evaldataevaluationid CREATE INDEX evaldataevaluationid ON public.evaldata USING btree (evaluationid)

    • Related Articles

    • public.mvwevaluationoverview

      Description Materialized view for evaluation overview data Table Definition CREATE MATERIALIZED VIEW mvwevaluationoverview AS ( SELECT concat(evaldata.conversationid, '|', evaldata.evaluationid, '|', evaldata.evaluationformid) AS keyid, ...

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

      Description See Evaluation Data Table Definition CREATE VIEW vwevaldata AS ( SELECT DISTINCT ed.keyid, ed.agenthasread, ed.assigneddate, ed.assigneddateltc, ed.conversationid, ed.evaluationformid, ed.evaluationid, ed.evaluatorid, ed.releasedate, ...

    • public.participantattributesdynamic

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...