public.evaldetails

public.evaldetails

Description

Evaluation Lookup Data

Columns

Name Type Default Nullable Extra Definition Children Parents Comment
id varchar(200) false Primary Key
evaluationid varchar(50) true Evaluation Form GUID (Historical column name - this actually contains the form ID, not the evaluation ID)
evaluationformid varchar(50) true Evaluation Form GUID
evaluationname varchar(500) true Evaluation Name
questiongroupid varchar(50) true Question Group GUID
questiongroupname varchar(500) true Question Group Name
questiongrouptohighest bit(1) true Question Group To Highest (True/False)
questiongrouptona bit(1) true Question Group Not Applicable (True/False)
questiongroupwieght numeric(20,2) true Question Group Weight (historical column spelling)
questiongroupmanwieght bit(1) true Question Group Man Weight
questionid varchar(50) true Question GUID
questiontext varchar(400) true Question Text
questionhelptext text true Question Help Text
questiontype varchar(50) true Question Type
questionnaenabled bit(1) true Question Enabled (True/False)
questioncommentsreq bit(1) true Question Comments Required (True/False)
questioniskill bit(1) true Question Is a Kill Question (True/False)
questioniscritical bit(1) true
questionanwserid varchar(50) true Question Answer GUID (historical column spelling)
questionanswertext varchar(200) true Question Answer Text
questionanswervalue numeric(20,2) true Question Value
updated timestamp without time zone true Date Row Updated (UTC)
quesiontype varchar(50) true GENERATED ALWAYS AS questiontype STORED
questionanswerid varchar(50) true GENERATED ALWAYS AS questionanwserid STORED Question Answer GUID (generated read alias of questionanwserid)
questiongroupweight numeric(20,2) true GENERATED ALWAYS AS questiongroupwieght STORED Question Group Weight (generated read alias of questiongroupwieght)
questiongroupmanweight bit(1) true GENERATED ALWAYS AS questiongroupmanwieght STORED Question Group Manual Weight (generated read alias of questiongroupmanwieght)

Constraints

Name Type Definition
evaldetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
evaldetails_pkey CREATE UNIQUE INDEX evaldetails_pkey ON public.evaldetails USING btree (id)
evaldetailsformsid CREATE INDEX evaldetailsformsid ON public.evaldetails USING btree (evaluationformid)
evaldetails_questiongroupid_idx CREATE INDEX evaldetails_questiongroupid_idx ON public.evaldetails USING btree (questiongroupid)
evaldetails_composite_idx CREATE INDEX evaldetails_composite_idx ON public.evaldetails USING btree (evaluationformid, questiongroupid, questionid, questionanwserid)
evaldetails_evaluationformid_questiongroupid_idx CREATE INDEX evaldetails_evaluationformid_questiongroupid_idx ON public.evaldetails USING btree (evaluationformid, questiongroupid)
evaldetails_questiontext_idx CREATE INDEX evaldetails_questiontext_idx ON public.evaldetails USING btree (lower((questiontext)::text) varchar_pattern_ops)
evaldetails_questiongroupname_idx CREATE INDEX evaldetails_questiongroupname_idx ON public.evaldetails USING btree (lower((questiongroupname)::text) varchar_pattern_ops)