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 int Since ExamSys 7.6.0 | 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. Since 7.6.0 this has been a 64-bit Unix timestamp | |
end_date | datetime int Since ExamSys 7.6.0 | 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. Since 7.6.0 this has been a 64-bit Unix timestamp | |
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. 0 = No adjustment, 1 = Random mark, 2 = Standard setting | |
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 int Since ExamSys 7.6.0 | Datetime when a paper is retired. Since 7.6.0 this has been a 64-bit Unix timestamp | |
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. |