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