Evaluation details with lookup expansion
CREATE VIEW vwevaldetails AS (
SELECT evaldetails.id,
evaldetails.evaluationid,
evaldetails.evaluationformid,
evaldetails.evaluationname,
evaldetails.questiongroupid,
evaldetails.questiongroupname,
evaldetails.questiongrouptohighest,
evaldetails.questiongrouptona,
evaldetails.questiongroupwieght,
evaldetails.questiongroupmanwieght,
evaldetails.questionid,
evaldetails.questiontext,
evaldetails.questionhelptext,
evaldetails.questiontype,
evaldetails.questiontype AS quesiontype,
evaldetails.questionnaenabled,
evaldetails.questioncommentsreq,
evaldetails.questioniskill,
evaldetails.questioniscritical,
evaldetails.questionanwserid,
evaldetails.questionanswertext,
evaldetails.questionanswervalue
FROM evaldetails
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | varchar(200) | true | Primary Key | |||
| evaluationid | varchar(50) | true | Evaluation GUID | |||
| 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 | ||||
| questiongroupwieght | numeric(20,2) | true | Question Group Wieght | |||
| questiongroupmanwieght | bit(1) | true | Question Group Man Weight | |||
| questionid | varchar(50) | true | Question Answer Value | |||
| questiontext | varchar(400) | true | Question Text | |||
| questionhelptext | text | true | Question Help Text | |||
| questiontype | varchar(50) | true | ||||
| quesiontype | varchar(50) | true | DEPRECATED alias for questiontype - kept for backward compatibility | |||
| 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 | Question Is a Critical Question (True/False) | |||
| questionanwserid | varchar(50) | true | Question Answer GUID | |||
| questionanswertext | varchar(200) | true | Question Answer Text | |||
| questionanswervalue | numeric(20,2) | true | Question Value |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.evaldetails | 22 | Evaluation Lookup Data | BASE TABLE |