public.evalquestiongroupdata

public.evalquestiongroupdata

Description

Evaluation Question Group Detailed Data

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(50) false Primary Key
evaluationid varchar(50) false Evaluation GUID
evaluationformid varchar(50) false Evaluation Form GUID
questiongroupid varchar(50) true Evaluation Question Group Comments
totalscore numeric(20,2) true Evaluation Question Group Total Score
maxtotalscore numeric(20,2) true Evaluation Question Group Max Total Score
markedna bit(1) true Evaluation Question Group Marked Not Applicable (True/False)
totalcriticalscore numeric(20,2) true Evaluation Question Group Total Critical Score
maxtotalcriticalscore numeric(20,2) true Evaluation Question Group Total Max Critical Score
totalnoncriticalscore numeric(20,2) true Evaluation Question Group Total Non Critical Score
maxtotalnoncriticalscore numeric(20,2) true Evaluation Question GroupTotal Max Non Critical Score
totalscoreunweighted numeric(20,2) true Evaluation Question Group Total Score Un-Weighted
maxtotalscoreunweighted numeric(20,2) true Evaluation Question Group Max Total Score Un-Weighted
failedkillquestions bit(1) true Evaluation Question Group Falled Kill Questions
comments text true Evaluation Question Group Comments
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
evalquestiongroupdata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
evalquestiongroupdata_pkey CREATE UNIQUE INDEX evalquestiongroupdata_pkey ON public.evalquestiongroupdata USING btree (keyid)
evaluationgroupdataevaluationid CREATE INDEX evaluationgroupdataevaluationid ON public.evalquestiongroupdata USING btree (evaluationid)