Purpose: Saves custom settings for students identified as having special needs. The special_needs field in users should be set to 1 to indicate special needs.
Joins: users table.
| Field | Type | Purpose |
|---|---|---|
| special_id | int(11) | Primary Key – auto increment. |
| userID | int(10) unsigned | User ID of the student who the special needs pertain to |
| background | varchar(20) | Background colour of the assessment. Can be named colour such as white or HTML code #FFFFFF |
| foreground | varchar(20) | Foreground colour of the assessment. |
| textsize | int(11) | Base font size for assessment. Use percentage values without the percent symbol |
| extra_time | tinyint(4) | Amount of extra time permitted expressed as a percentage (without the percent symbol) |
| marks_color | varchar(20) | Colour used to show how many marks each question is worth to the student |
| themecolor | varchar(20) | Theme (heading) colour |
| labelcolor | varchar(20) | Colour of additional headings (i.e. True/False) |
| font | varchar(50) | Base Font Family to use |
| unanswered | varchar(20) | Colour of unanswered questions. |
| dismiss | varchar(20) | Colour of the strikeout/dismiss state. |
| medical | text | 6.0: Holds medical information about a student - accessible to invigilators. |
| breaks | text | 6.0: Holds rest break information about a student - accessible to invigilators. |
| break_time | smallint | added in 7.2 amount of break time a student can have in an exam (percent or mins per hour) |
See also: Accessibility Options