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

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true participant varchar(50) true ...

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