properties

ROGO 6.1.0

Purpose: Stores general setup information for a paper.

Joins: academic_year, papers, modules, labs and users table.

Field	Type	Purpose	Key
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.