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

      Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...

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