...
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
| 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
| Datetime when students will loose can start to access to the paper. Data recorded after the end date will go into log_late.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
| 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. |
...