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)
evaldata_status_idx CREATE INDEX evaldata_status_idx ON public.evaldata USING btree (status)
evaldata_userid_idx CREATE INDEX evaldata_userid_idx ON public.evaldata USING btree (userid)
evaldata_evaluatorid_idx CREATE INDEX evaldata_evaluatorid_idx ON public.evaldata USING btree (evaluatorid)
evaldata_releasedate_idx CREATE INDEX evaldata_releasedate_idx ON public.evaldata USING btree (releasedate)
idx_evaldata_release_status_users CREATE INDEX idx_evaldata_release_status_users ON public.evaldata USING btree (releasedate, status, userid, evaluatorid) WHERE (((status)::text = ‘FINISHED’::text) AND (releasedate IS NOT NULL))
idx_evaldata_form_release_status CREATE INDEX idx_evaldata_form_release_status ON public.evaldata USING btree (evaluationformid, releasedate, status) INCLUDE (totalscore, totalcriticalscore, totalnoncriticalscore) WHERE ((status)::text = ‘FINISHED’::text)
idx_evaldata_userid_release_status CREATE INDEX idx_evaldata_userid_release_status ON public.evaldata USING btree (userid, releasedate DESC, status) INCLUDE (totalscore, evaluatorid, evaluationformid) WHERE ((status)::text = ‘FINISHED’::text)
idx_evaldata_evaluator_release_status CREATE INDEX idx_evaldata_evaluator_release_status ON public.evaldata USING btree (evaluatorid, releasedate DESC, status) INCLUDE (userid, totalscore, evaluationformid) WHERE ((status)::text = ‘FINISHED’::text)
evaldata_assigneddate_idx CREATE INDEX evaldata_assigneddate_idx ON public.evaldata USING btree (assigneddate)
evaldata_status_userid_evaluatorid_idx CREATE INDEX evaldata_status_userid_evaluatorid_idx ON public.evaldata USING btree (status, userid, evaluatorid)
evaldata_evaluationformid_idx CREATE INDEX evaldata_evaluationformid_idx ON public.evaldata USING btree (evaluationformid)
evaldata_releasedate_userid_formid_evaluator_idx CREATE INDEX evaldata_releasedate_userid_formid_evaluator_idx ON public.evaldata USING btree (releasedate, userid, evaluationformid, evaluatorid)

    • Related Articles

    • public.vwevaluationoverview

      Description View for evaluation overview data (converted from materialized view) Table Definition CREATE VIEW vwevaluationoverview AS ( SELECT concat(evaldata.conversationid, '|', evaldata.evaluationid, '|', evaldata.evaluationformid) AS keyid, ...

    • public.vwevaluationgroupdata

      Description View for evaluation group data (converted from table) Table Definition CREATE VIEW vwevaluationgroupdata AS ( SELECT egd.keyid, egd.evaluationid, egd.questiongroupid, ( SELECT ed.questiongroupname FROM evaldetails ed WHERE ...

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

      Description View for evaluation question data (converted from materialized view) Table Definition CREATE VIEW vwevaluationquestiondata AS ( SELECT DISTINCT eq.keyid, eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, ...

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