log4_overall
Purpose: Holds responses for OSCE assessments.
Joins: users, papers, questions and log4 tables.
Field | Type | Purpose |
|---|---|---|
id | int(8) | Primary Key – auto increment. |
userID | int(10) unsigned | ID of the user who's responses are being recorded. |
started | datetime | Datetime the assessment paper was started |
q_paper | mediumint(8) unsigned | ID of the paper |
overall_rating | text | The marker's overall rating for the whole OSCE station (i.e. Fail, Borderline, Pass, etc) |
numeric_score | int(11) | The numeric sum of all the individual ratings from log4 |
feedback | text | Free text feedback from the marker for the student |
student_grade | char(25) | What degree or programme of study the student is on |
examinerID | mediumint(8) unsigned | User ID of the OSCE station marker |
osce_type | enum('electronic','paper') | Type of station (e.g. electronic or paper) |
year | tinyint(4) | Year of study for the current student |