Quizaccess Seb Quizsettings Table Schema (quizaccess_seb_quizsettings)


Description

Stores the quiz level Safe Exam Browser configuration.

quizaccess_seb_quizsettings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
quizid BIGINT 19 null
quiz.id Implied Constraint R

Foreign key to quiz id.

cmid BIGINT 19 null

Foreign key to course module id.

templateid BIGINT 19 null

Foreign key to quizaccess_seb_template.id.

requiresafeexambrowser BIT 1 null

Bool whether to require SEB.

showsebtaskbar BIT 1 null

Bool to show SEB task bar

showwificontrol BIT 1 null

Bool to allow user to control networking.

showreloadbutton BIT 1 null

Bool to show reload button.

showtime BIT 1 null

Bool to show the clock.

showkeyboardlayout BIT 1 null

Bool to show keyboard layout.

allowuserquitseb BIT 1 null

Bool to show quit button.

quitpassword LONGTEXT 2147483647 null

Quit password to exit SEB.

linkquitseb LONGTEXT 2147483647 null

Link to exit SEB.

userconfirmquit BIT 1 null

Bool whether confirm quit popup should appear.

enableaudiocontrol BIT 1 null

Bool to show volume and audio controls.

muteonstartup BIT 1 null

Bool whether browser starts muted.

allowspellchecking BIT 1 null

Bool whether spell checking will happen in SEB.

allowreloadinexam BIT 1 null

Bool whether user can reload.

activateurlfiltering BIT 1 null

Bool whether URLs will be filtered.

filterembeddedcontent BIT 1 null

Bool wither embedded content will be filtered

expressionsallowed LONGTEXT 2147483647 null

Comma or newline separated list of allowed expressions

regexallowed LONGTEXT 2147483647 null

Regex of allowed URLs

expressionsblocked LONGTEXT 2147483647 null

Comma or newline separated list of blocked expressions

regexblocked LONGTEXT 2147483647 null

Regex of blocked URLs

allowedbrowserexamkeys LONGTEXT 2147483647 null

List of allowed browser exam keys.

showsebdownloadlink BIT 1 null

Bool whether SEB download link should appear

usermodified BIGINT 19 0
user.id quizsebquiz_use2_fk R
timecreated BIGINT 19 0
timemodified BIGINT 19 0

Table contained -1 rows

quizaccess_seb_quizsettings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quizsebquiz_cmi_uix Must be unique Asc cmid
quizsebquiz_qui_uix Must be unique Asc quizid
quizsebquiz_tem_ix Performance Asc templateid
quizsebquiz_use_ix Performance Asc usermodified

quizaccess_seb_quizsettings table relationships