View for evaluation group data (converted from table)
CREATE VIEW vwevaluationgroupdata AS (
SELECT egd.keyid,
egd.evaluationid,
egd.questiongroupid,
( SELECT ed.questiongroupname
FROM evaldetails ed
WHERE ((ed.questiongroupid)::text = (egd.questiongroupid)::text)
LIMIT 1) AS questiongroupname,
egd.totalscore,
egd.maxtotalscore,
egd.markedna,
egd.totalcriticalscore,
egd.maxtotalcriticalscore,
egd.totalnoncriticalscore,
egd.maxtotalnoncriticalscore,
egd.totalscoreunweighted,
egd.maxtotalscoreunweighted,
egd.failedkillquestions,
ud.divisionid,
egd.comments,
eda.conversationid
FROM ((evalquestiongroupdata egd
LEFT JOIN evaldata eda ON (((eda.evaluationid)::text = (egd.evaluationid)::text)))
LEFT JOIN userdetails ud ON (((ud.id)::text = (eda.userid)::text)))
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| keyid | varchar(50) | true | Primary Key | |||
| evaluationid | varchar(50) | true | Evaluation GUID | |||
| questiongroupid | varchar(50) | true | Question Group GUID | |||
| questiongroupname | varchar(500) | true | Question Group Name | |||
| totalscore | numeric(20,2) | true | Total Score | |||
| maxtotalscore | numeric(20,2) | true | Max Total Score | |||
| markedna | bit(1) | true | Marked as NA | |||
| totalcriticalscore | numeric(20,2) | true | Total Critical Score | |||
| maxtotalcriticalscore | numeric(20,2) | true | Max Total Critical Score | |||
| totalnoncriticalscore | numeric(20,2) | true | Total Non-Critical Score | |||
| maxtotalnoncriticalscore | numeric(20,2) | true | Max Total Non-Critical Score | |||
| totalscoreunweighted | numeric(20,2) | true | Total Score Unweighted | |||
| maxtotalscoreunweighted | numeric(20,2) | true | Max Total Score Unweighted | |||
| failedkillquestions | bit(1) | true | Failed Kill Questions | |||
| divisionid | varchar(50) | true | Division GUID | |||
| comments | text | true | Comments | |||
| conversationid | varchar(50) | true | Conversation GUID |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.evaldetails | 22 | Evaluation Lookup Data | BASE TABLE |
| public.evalquestiongroupdata | 16 | Evaluation Question Group Detailed Data | BASE TABLE |
| public.evaldata | 21 | BASE TABLE | |
| public.userdetails | 14 | BASE TABLE |