properties

property_id

mediumint(8) unsigned

auto increment.

PRIMARY KEY

paper_title

varchar(255)

Name of the assessment or survey.

start_date

datetime

Datetime when students can start to access the paper. There is a 2 minute grace on this to account for client-server clocks being different.

end_date

datetime

Datetime when students will loose access to the paper. Data recorded after the end date will go into log_late.

timezone

varchar(255)

What timezone should be used.

paper_type

enum('0','1','2','3','4','5','6')

0=Formative, 1=Progress Test, 2=Summative, 3=Survey, 4=OSCE Station, 5=Offline paper, 6=peer review

paper_prologue

text

Text to display at the top of screen 1.

paper_postscript

text

Text to display after the student clicks 'Finish'

bgcolor

varchar(20)

Background colour of the paper.

fgcolor

varchar(20)

Foreground colour of the paper.

themecolor

varchar(20)

Colour of themes (headings).

labelcolor

varchar(20)

Colour of labels.

fullscreen

enum('0','1')

0=Windowed, 1=Fullscreen. Fullscreen works only in Internet Explorer.

marking

char(60)

Marking scheme used for the paper.

bidirectional

enum('0','1')

0=Linear navigation, 1=Bidirectional - students may return to previous screens.

pass_mark

tinyint(4)

Percentage pass mark for the paper.

distinction_mark

tinyint(4)

Percentage distinction mark for the paper.

paper_ownerID

int(10) unsigned

User ID of the paper owner.

folder

varchar(255)

Personal folder the paper is stored in (optional).

labs

text

Comma separated list of lab IDs that a summative paper is restricted to.

rubric

text

The exam rubric displayed to students before they start the exam.

calculator

tinyint(4)

0=No calculator, 1=Display JavaScript calculator

exam_duration

smallint(6)

Exam duration specified in minutes.

deleted

datetime

Datetime the paper was deleted. NULL means the paper is still active.

created

datetime

Datetime the paper was created.

random_mark

float

The calculated random mark that someone would get based on probability.

total_mark

mediumint(9)

Total available marks.

display_correct_answer

enum('0','1')

0=Hide correct answers, 1=Display correct answers.

display_question_mark

enum('0','1')

0=Hide question marks, 1=Show question marks.

display_students_response

enum('0','1')

0=Hide student responses, 1=Show student responses.

display_feedback

enum('0','1')

0=Hide feedback, 1=Show feedback.

hide_if_unanswered

enum('0','1')

1=If student leaves a question unanswered then receive no feedback.

calendar_year

int(4)

Academic year the metadata applies to.

FOREIGN KEY academic_year.calendar_year

external_review_deadline

date

Deadline when external reviews should be completed by.

internal_review_deadline

date

Deadline when internal reviews should be completed by.

sound_demo

enum('0','1')

0=No sound demo, 1=Include sound demo.

latex_needed

tinyint(4)

1=Include Latex rendering libraries because a question with Latex has been detected.

password

char(20)

Password protect a summative exam.

retired

datetime

Datetime when a paper is retired.

crypt_name

varchar(32)

An encrypted ID for the paper.

recache_marks

tinyint(3)

If set to 1 then /paper/details.php will call Class Totals and recache values. Necessary if the marking method changes, for example.