log4_overall
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
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 |