special_needs
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) |
globalthemecolour | varchar(20) | added in 7.4 background colour of paper header/footer |
globalthemefont_colour | varchar(20) | added in 7.4 font colour of paper header/footer |
highlight_bgcolour | varchar(20) | added in 7.4 colour of option highlight |
See also: Accessibility Options