Tables

Alphabetical Listing:

Table Name	Purpose
access_log	Records page accesses (student homepage, question-based feedback report, question-based feedback report, etc)
academic_year	Hold information on the available academic sessions
admin_access	Used to grant school-level access permissions to staff with 'Admin' rights.
announcements	Displays notices on the staff and student homepages.
audit_log	Tracks changes to user permissions (added in Rogo 7.4.0)
cache_median_question_marks	Holds the mean and median performance of a question on a particular paper.
cache_paper_stats	Holds statistics of the performance of a paper. Used in the Performance Summary reports.
cache_student_paper_marks	Holds student marks/percent by paper. Used in the Performance Summary reports.
campus	Hold information on campuses at the institution
class_totals_test_local	Used to hold information on the testing of papers between Class Totals report and individual student scripts.
client_identifiers	Holds individual IP addresses of computers in a particular lab. Used to lock down security for summative exams
config	Stores configuration items
courses	Holds course information (BA, MSC, etc)
denied_log	Stores information when a user receives an access denied warning (staff or students)
ebel	Holds data from the two Ebel grids at the bottom of the standard setting screen.
ebel_grid_templates	Holds default Ebel grid values in named templates.
exam_announcements	Used to make mid-exam announcements to invigilators and students.
extra_cal_dates	Adds extra dates into the summative exam calendar.
faculty	Holds list of Faculties used in the institution.
feedback_release	Controls the date when objectives-based feedback can be released to students.
folders	Stores data pertaining to personal folders.
folders_modules_staff	Joining table between folders and modules. Controls which modules a folder is on.
help_log	Tracks page accesses in the staff and student help systems.
help_searches	Holds information on searches conducted within the online help systems.
help_tutorial_log	Holds a log of which users accessed the online tutorials in the help system.
hofstee	Holds data regarding Hofstee standard setting.
keywords_question	Holds which keywords are linked to which questions.
keywords_user	Stores the text of keywords for both individual users and teams.
killer_questions	Holds which questions are set to be 'killer' questions.
labs	Holds information about student computer labs.
log0	Holds responses for Formative (Quiz) assessments.
log0_deleted	When SysAdmin uses 'Clear Old Logs' the old records from 'log0' are moved to 'log0_deleted'.
log1	Holds responses for Progress Test assessments.
log1_deleted	When SysAdmin uses 'Clear Old Logs' the old records from 'log1' are moved to 'log1_deleted'.
log2	Holds responses for Summative assessments.
log3	Holds responses for Surveys.
log4	Holds responses for OSCE assessments.
log4_overall	Holds responses for OSCE assessments.
log5	Holds responses for Offline papers. The idea of an offline paper is to effectively have a question skeleton. Into this marks are loaded and compared with mapped learning objectives to give students feedback.
log6	Holds responses for Peer Review assessments.
log_extra_time	Holds the amount of extra time given to a specific user on a specific assessment.
log_lab_end_time	Holds the end time of an assessment for a specific lab (different labs can have different end times).
log_late	Stores any data submitted after the end date of a paper for Progress Tests and Summative exams.
log_metadata	Holds metadata against log0, log1, log2, log3 and log5.
log_metadata_deleted	When SysAdmin uses 'Clear Old Logs' the old records from 'log_metadata' are moved to 'log_metadata_deleted'.
lti_context	Holds the link information between lti context and the rogo course.
lti_keys	Holds the lti keys information.
lti_resource	Holds the link information between lti resourse and the rogo paper.
lti_user	Holds the link information between the lti user and the rogo user.
marking_override	Stores data on manually overridden marks (e.g. human corrected calculation questions).
media	Stores the media details added to question/option (added in Rogo 7.2)
modules	Holds module information.
modules_staff	Stores staff module membership data.
modules_student	Holds student module enrolments.
objectives	When not obtaining learning objectives from a VLE through an API Rogo can store objectives internally - this table is for this purpose.
options	Holds the options of a question.
options_media	Stores the media references for an option (added in Rogo 7.2)
paper_feedback	Holds the textual feedback/percentages to use for formative papers.
paper_metadata	Used for additional paper metadata, such as the Safe Exam Browser keys. (added in Rogo 7.2)
paper_metadata_security	Used to extend the access security on a paper using metadata information.
paper_notes	Records notes pertaining to a whole paper. Most common uses would be to make a note about a question that had incorrect information or a fire alarm.
papers	Stores which questions are on a paper.
paper_settings	Store a papers settings (added in Rogo 7.2)
paper_settings_category	Stores paper setting categories (added in Rogo 7.2)
paper_settings_setting	Stores paper setting definitions (added in Rogo 7.2)
password_tokens	Used to store tokens used during password reset process.
performance_details	Stores general performance information for a question (date, cohort size, etc).
performance_main	Stores specific P and D values a question or parts of a question.
properties	Stores general setup information for a paper.
properties_modules	Joining table between properties and modules. Controls which modules a paper is on.
properties_reviewers	Holds which internal and external reviewers are assigned to which papers.
question_exclude	Stores data about which questions have been excluded post-exam for a summative paper.
question_statuses	Holds the available statuses that can be assigned to a question.
questions	Holds most of the data used by an individual question. See options table for the rest of the data.
questions_media	Stores the media references for a question (added in Rogo 7.2)
questions_metadata	Extensible table to allow any metadata information to be associated with a question.
questions_modules	Joining table between questions and modules. Controls which modules a question is on.
recent_papers	Stores the IDs of recently accessed papers. Used on the staff homepage to show last 10 papers accessed.
reference_material	Store title, content and width of sidebar reference material.
reference_modules	Holds which modules can use a particulare reference material.
reference_papers	Holds which papers are using which reference materials.
relationships	Stores relationship pairs between questions and objectives.
retention	Stores the number of days data for a particular function should be stored
review_comments	Stores external examiner and internal reviewer comments. Used mainly for summative exams.
review_metadata	Holds general information about a review of a paper.
roles	Stores the roles that a user can be assigned (from Rogo 7.2.0)
save_fail_log	Stores information about when saves fail.
scheduling	Holds a exam scheduling information for Summative Exam Scheduling
schools	Holds a list of schools by faculty. One of the main places this information is used is 'All Modules' link from the homepage.
sct_reviews	Stores answers and reasons of reviewers of a Script Concordance Test (SCT) paper.
sessions	Holds data about a session (or activity) which is a container into which objectives can be structured.
sid	Holds an institution student ID against a student user account.
sms_imports	Stores data about enrolment/deletion changes made on nightly module enrolements from SMS system. A record is used per module.
special_needs	Saves custom settings for students identified as having special needs. The special_needs field in users should be set to 1 to indicate special needs.
staff_help	Stores pages for the staff online help system.
state	Stores various user-interface states (i.e. checkboxes).
std_set	Parent record of a standard setting review session.
std_set_questions	Holds an individual standard set rating for a question.
student_help	Stores pages for the student online help system.
student_notes	Used for creating notes for specific students/papers to records such things as computer crashes or feeling ill, etc.
sys_errors	Stores information about PHP warnings and fatal errors. JavaScript and PHP Notice messages are currently not logged.
sys_updates	Stores what updates have been applied to the current Rogo installation
temp_users	Used for summative exams for students who cannot log in for whatever reason. Student fills in their personal details that can be matched up after the exam.
textbox_marking	Stores human assigned marks for textbox question type.
textbox_remark	Holds records for which students should be remarked by a second marker for a particular paper.
toilet_breaks	Records information about when a student has taken a toilet break (summative exams).
track_changes	Stores changes to data. Mainly used to log changes to questions.
user_roles	Stores the roles assigned to a user (from Rogo 7.2.0)
users	Holds information about users (staff, students and external examiners).
users_metadata	Used to add additional data to student accounts. This could be group information, preferences, sites, etc. It is based around academic years and module IDs.

By Function:

Administration
access_log	announcement- s	denied_log
scheduling	sms_imports	state
sys_errors	sys_updates

Organisation
courses	faculty	modules
schools	sessions

Papers
papers	properties

Mid Exam
log_late	log_metadata	log0
log1	log2	log3
log4	log4_overall	log5
log6

Post Exam
feedback_rel- ease	paper_notes	question_exc- lude
student_note- s	toilet_break- s

Security
labs	paper_metada- ta	paper_metada- ta_security
roles (table)	user_roles

Users
admin_access	modules_staf- f	modules_stud- ent
password_tok- ens	recent_paper- s	roles (table)
sid	special_need- s	temp_users
user_roles	users	users_metada- ta

Authentication
lti_context	lti_keys	lti_resource
lti_user

Standard Setting
ebel	ebel_grid_te- mplates	std_set
std_set_ques- tions

Reviewing
review_comme- nts	review_metad- ata

Reference Material
reference_ma- terial	reference_mo- dules	reference_pa- pers

Textbox Marking
textbox_mark- ing	textbox_rema- rk

Objectives
objectives	relationship- s

Questions
keywords_que- stions	keywords_use- r	options
performance_- details	performance_- main	questions
questions_me- tadata	sct_reviews	track_change- s

Help
help_log	help_searche- s	help_tutoria- l_log
staff_help	student_help

ExamSys

Tables

Analytics

Alphabetical Listing:

By Function:

Related content