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)
idx_evalquestiondata_evaluation_group_question CREATE INDEX idx_evalquestiondata_evaluation_group_question ON public.evalquestiondata USING btree (evaluationid, questiongroupid, questionid) INCLUDE (score, answerid, markedna)
idx_evalquestiondata_form_composite CREATE INDEX idx_evalquestiondata_form_composite ON public.evalquestiondata USING btree (evaluationformid, questiongroupid, questionid, answerid) INCLUDE (score, markedna, failedkillquestions)

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

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...

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

    • public.userinteractionpresencedetaileddata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone ...