...
| Status | ||||||
|---|---|---|---|---|---|---|
|
...
Purpose: Stores general setup information for a paper.Version: 6.1
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. |