moodle Documentation

Generated on 2013-12-20 20:35:17

Schema: public
Tables	Views	Functions
mdl_assign mdl_assign_grades mdl_assign_plugin_config mdl_assign_submission mdl_assign_user_flags mdl_assign_user_mapping mdl_assignfeedback_comments mdl_assignfeedback_editpdf_annot mdl_assignfeedback_editpdf_cmnt mdl_assignfeedback_editpdf_quick mdl_assignfeedback_file mdl_assignment mdl_assignment_submissions mdl_assignsubmission_file mdl_assignsubmission_onlinetext mdl_backup_controllers mdl_backup_courses mdl_backup_logs mdl_badge mdl_badge_backpack mdl_badge_criteria mdl_badge_criteria_met mdl_badge_criteria_param mdl_badge_external mdl_badge_issued mdl_badge_manual_award mdl_block mdl_block_community mdl_block_instances mdl_block_positions mdl_block_rss_client mdl_blog_association mdl_blog_external mdl_book mdl_book_chapters mdl_cache_filters mdl_cache_flags mdl_cache_text mdl_capabilities mdl_chat mdl_chat_messages mdl_chat_messages_current mdl_chat_users mdl_choice mdl_choice_answers mdl_choice_options mdl_cohort mdl_cohort_members mdl_comments mdl_config mdl_config_log mdl_config_plugins mdl_context mdl_context_temp mdl_course mdl_course_categories mdl_course_completion_aggr_methd mdl_course_completion_crit_compl mdl_course_completion_criteria mdl_course_completions mdl_course_format_options mdl_course_modules mdl_course_modules_avail_fields mdl_course_modules_availability mdl_course_modules_completion mdl_course_published mdl_course_request mdl_course_sections mdl_course_sections_avail_fields mdl_course_sections_availability mdl_data mdl_data_content mdl_data_fields mdl_data_records mdl_enrol mdl_enrol_flatfile mdl_enrol_paypal mdl_event mdl_event_subscriptions mdl_events_handlers mdl_events_queue mdl_events_queue_handlers mdl_external_functions mdl_external_services mdl_external_services_functions mdl_external_services_users mdl_external_tokens mdl_feedback mdl_feedback_completed mdl_feedback_completedtmp mdl_feedback_item mdl_feedback_sitecourse_map mdl_feedback_template mdl_feedback_tracking mdl_feedback_value mdl_feedback_valuetmp mdl_files mdl_files_reference mdl_filter_active mdl_filter_config mdl_folder mdl_forum mdl_forum_digests mdl_forum_discussions mdl_forum_posts mdl_forum_queue mdl_forum_read mdl_forum_subscriptions mdl_forum_track_prefs mdl_glossary mdl_glossary_alias mdl_glossary_categories mdl_glossary_entries mdl_glossary_entries_categories mdl_glossary_formats mdl_grade_categories mdl_grade_categories_history mdl_grade_grades mdl_grade_grades_history mdl_grade_import_newitem mdl_grade_import_values mdl_grade_items mdl_grade_items_history mdl_grade_letters mdl_grade_outcomes mdl_grade_outcomes_courses mdl_grade_outcomes_history mdl_grade_settings mdl_grading_areas mdl_grading_definitions mdl_grading_instances mdl_gradingform_guide_comments mdl_gradingform_guide_criteria mdl_gradingform_guide_fillings mdl_gradingform_rubric_criteria mdl_gradingform_rubric_fillings mdl_gradingform_rubric_levels mdl_groupings mdl_groupings_groups mdl_groups mdl_groups_members mdl_imscp mdl_label mdl_lesson mdl_lesson_answers mdl_lesson_attempts mdl_lesson_branch mdl_lesson_grades mdl_lesson_high_scores mdl_lesson_pages mdl_lesson_timer mdl_license mdl_log mdl_log_display mdl_log_queries mdl_lti mdl_lti_submission mdl_lti_types mdl_lti_types_config mdl_message mdl_message_contacts mdl_message_processors mdl_message_providers mdl_message_read mdl_message_working mdl_mnet_application mdl_mnet_host mdl_mnet_host2service mdl_mnet_log mdl_mnet_remote_rpc mdl_mnet_remote_service2rpc mdl_mnet_rpc mdl_mnet_service mdl_mnet_service2rpc mdl_mnet_session mdl_mnet_sso_access_control mdl_mnetservice_enrol_courses mdl_mnetservice_enrol_enrolments mdl_modules mdl_my_pages mdl_openmeetings mdl_page mdl_portfolio_instance mdl_portfolio_instance_config mdl_portfolio_instance_user mdl_portfolio_log mdl_portfolio_mahara_queue mdl_portfolio_tempdata mdl_post mdl_profiling mdl_qtype_essay_options mdl_qtype_match_options mdl_qtype_match_subquestions mdl_qtype_multichoice_options mdl_qtype_shortanswer_options mdl_question mdl_question_answers mdl_question_attempt_step_data mdl_question_attempt_steps mdl_question_attempts mdl_question_calculated mdl_question_calculated_options mdl_question_categories mdl_question_dataset_definitions mdl_question_dataset_items mdl_question_datasets mdl_question_hints mdl_question_multianswer mdl_question_numerical mdl_question_numerical_options mdl_question_numerical_units mdl_question_randomsamatch mdl_question_response_analysis mdl_question_sessions mdl_question_states mdl_question_statistics mdl_question_truefalse mdl_question_usages mdl_quiz mdl_quiz_attempts mdl_quiz_feedback mdl_quiz_grades mdl_quiz_overrides mdl_quiz_overview_regrades mdl_quiz_question_instances mdl_quiz_reports mdl_quiz_statistics mdl_rating mdl_registration_hubs mdl_repository mdl_repository_instance_config mdl_repository_instances mdl_resource mdl_resource_old mdl_role mdl_role_allow_assign mdl_role_allow_override mdl_role_allow_switch mdl_role_assignments mdl_role_capabilities mdl_role_context_levels mdl_role_names mdl_role_sortorder mdl_scale mdl_scale_history mdl_scorm mdl_scorm_aicc_session mdl_scorm_scoes mdl_scorm_scoes_data mdl_scorm_scoes_track mdl_scorm_seq_mapinfo mdl_scorm_seq_objective mdl_scorm_seq_rolluprule mdl_scorm_seq_rolluprulecond mdl_scorm_seq_rulecond mdl_scorm_seq_ruleconds mdl_sessions mdl_stats_daily mdl_stats_monthly mdl_stats_user_daily mdl_stats_user_monthly mdl_stats_user_weekly mdl_stats_weekly mdl_survey mdl_survey_analysis mdl_survey_answers mdl_survey_questions mdl_tag mdl_tag_correlation mdl_tag_instance mdl_timezone mdl_tool_customlang mdl_tool_customlang_components mdl_upgrade_log mdl_url mdl_user mdl_user_devices mdl_user_enrolments mdl_user_info_category mdl_user_info_data mdl_user_info_field mdl_user_lastaccess mdl_user_password_resets mdl_user_preferences mdl_user_private_key mdl_webdav_locks mdl_wiki mdl_wiki_links mdl_wiki_locks mdl_wiki_pages mdl_wiki_subwikis mdl_wiki_synonyms mdl_wiki_versions mdl_workshop mdl_workshop_aggregations mdl_workshop_assessments mdl_workshop_assessments_old mdl_workshop_comments_old mdl_workshop_elements_old mdl_workshop_grades mdl_workshop_grades_old mdl_workshop_old mdl_workshop_rubrics_old mdl_workshop_stockcomments_old mdl_workshop_submissions mdl_workshop_submissions_old mdl_workshopallocation_scheduled mdl_workshopeval_best_settings mdl_workshopform_accumulative mdl_workshopform_comments mdl_workshopform_numerrors mdl_workshopform_numerrors_map mdl_workshopform_rubric mdl_workshopform_rubric_config mdl_workshopform_rubric_levels

Table: mdl_assign

This table saves information about an instance of mod_assign in a course.

mdl_assign Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	alwaysshowdescription	smallint	NOT NULL
	nosubmissions	smallint	NOT NULL
	submissiondrafts	smallint	NOT NULL
	sendnotifications	smallint	NOT NULL
	sendlatenotifications	smallint	NOT NULL
	duedate	bigint	NOT NULL
	allowsubmissionsfromdate	bigint	NOT NULL
	grade	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	requiresubmissionstatement	smallint	NOT NULL
	completionsubmit	smallint	NOT NULL
	cutoffdate	bigint	NOT NULL
	teamsubmission	smallint	NOT NULL
	requireallteammemberssubmit	smallint	NOT NULL
	teamsubmissiongroupingid	bigint	NOT NULL
	blindmarking	smallint	NOT NULL
	revealidentities	smallint	NOT NULL
	attemptreopenmethod	character varying(10)	NOT NULL DEFAULT 'none'::character varying
	maxattempts	integer	NOT NULL DEFAULT (-1)
	markingworkflow	smallint	NOT NULL
	markingallocation	smallint	NOT NULL

mdl_assign Indexes
Index Name	Definition
mdl_assi_cou_ix	CREATE INDEX mdl_assi_cou_ix ON mdl_assign USING btree (course)
mdl_assi_tea_ix	CREATE INDEX mdl_assi_tea_ix ON mdl_assign USING btree (teamsubmissiongroupingid)

Index - Schema public

Table: mdl_assign_grades

Grading information about a single assignment submission.

mdl_assign_grades Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	userid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	grader	bigint	NOT NULL
	grade	numeric(10,5)
	attemptnumber	bigint	NOT NULL

mdl_assign_grades Indexes
Index Name	Definition
mdl_assigrad_ass_ix	CREATE INDEX mdl_assigrad_ass_ix ON mdl_assign_grades USING btree (assignment)
mdl_assigrad_att_ix	CREATE INDEX mdl_assigrad_att_ix ON mdl_assign_grades USING btree (attemptnumber)
mdl_assigrad_use_ix	CREATE INDEX mdl_assigrad_use_ix ON mdl_assign_grades USING btree (userid)

Index - Schema public

Table: mdl_assign_plugin_config

Config data for an instance of a plugin in an assignment.

mdl_assign_plugin_config Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	plugin	character varying(28)	NOT NULL DEFAULT ''::character varying
	subtype	character varying(28)	NOT NULL DEFAULT ''::character varying
	name	character varying(28)	NOT NULL DEFAULT ''::character varying
	value	text

mdl_assign_plugin_config Indexes
Index Name	Definition
mdl_assiplugconf_ass_ix	CREATE INDEX mdl_assiplugconf_ass_ix ON mdl_assign_plugin_config USING btree (assignment)
mdl_assiplugconf_nam_ix	CREATE INDEX mdl_assiplugconf_nam_ix ON mdl_assign_plugin_config USING btree (name)
mdl_assiplugconf_plu_ix	CREATE INDEX mdl_assiplugconf_plu_ix ON mdl_assign_plugin_config USING btree (plugin)
mdl_assiplugconf_sub_ix	CREATE INDEX mdl_assiplugconf_sub_ix ON mdl_assign_plugin_config USING btree (subtype)

Index - Schema public

Table: mdl_assign_submission

This table keeps information about student interactions with the mod/assign. This is limited to metadata about a student submission but does not include the submission itself which is stored by plugins.

mdl_assign_submission Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	userid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	status	character varying(10)
	groupid	bigint	NOT NULL
	attemptnumber	bigint	NOT NULL

mdl_assign_submission Indexes
Index Name	Definition
mdl_assisubm_ass_ix	CREATE INDEX mdl_assisubm_ass_ix ON mdl_assign_submission USING btree (assignment)
mdl_assisubm_att_ix	CREATE INDEX mdl_assisubm_att_ix ON mdl_assign_submission USING btree (attemptnumber)
mdl_assisubm_use_ix	CREATE INDEX mdl_assisubm_use_ix ON mdl_assign_submission USING btree (userid)

Index - Schema public

Table: mdl_assign_user_flags

mdl_assign_user_flags Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	assignment	bigint	NOT NULL
	locked	bigint	NOT NULL
	mailed	smallint	NOT NULL
	extensionduedate	bigint	NOT NULL
	workflowstate	character varying(20)
	allocatedmarker	bigint	NOT NULL

mdl_assign_user_flags Indexes
Index Name	Definition
mdl_assiuserflag_ass_ix	CREATE INDEX mdl_assiuserflag_ass_ix ON mdl_assign_user_flags USING btree (assignment)
mdl_assiuserflag_mai_ix	CREATE INDEX mdl_assiuserflag_mai_ix ON mdl_assign_user_flags USING btree (mailed)
mdl_assiuserflag_use_ix	CREATE INDEX mdl_assiuserflag_use_ix ON mdl_assign_user_flags USING btree (userid)

Index - Schema public

Table: mdl_assign_user_mapping

Map an assignment specific id number to a user

mdl_assign_user_mapping Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	userid	bigint	NOT NULL

mdl_assign_user_mapping Indexes
Index Name	Definition
mdl_assiusermapp_ass_ix	CREATE INDEX mdl_assiusermapp_ass_ix ON mdl_assign_user_mapping USING btree (assignment)
mdl_assiusermapp_use_ix	CREATE INDEX mdl_assiusermapp_use_ix ON mdl_assign_user_mapping USING btree (userid)

Index - Schema public

Table: mdl_assignfeedback_comments

Text feedback for submitted assignments

mdl_assignfeedback_comments Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	grade	bigint	NOT NULL
	commenttext	text
	commentformat	smallint	NOT NULL

mdl_assignfeedback_comments Indexes
Index Name	Definition
mdl_assicomm_ass_ix	CREATE INDEX mdl_assicomm_ass_ix ON mdl_assignfeedback_comments USING btree (assignment)
mdl_assicomm_gra_ix	CREATE INDEX mdl_assicomm_gra_ix ON mdl_assignfeedback_comments USING btree (grade)

Index - Schema public

Table: mdl_assignfeedback_editpdf_annot

stores annotations added to pdfs submitted by students

mdl_assignfeedback_editpdf_annot Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	gradeid	bigint	NOT NULL
	pageno	bigint	NOT NULL
	x	bigint
	y	bigint
	endx	bigint
	endy	bigint
	path	text
	type	character varying(10)	DEFAULT 'line'::character varying
	colour	character varying(10)	DEFAULT 'black'::character varying
	draft	smallint	NOT NULL DEFAULT 1

mdl_assignfeedback_editpdf_annot Indexes
Index Name	Definition
mdl_assieditanno_gra_ix	CREATE INDEX mdl_assieditanno_gra_ix ON mdl_assignfeedback_editpdf_annot USING btree (gradeid)
mdl_assieditanno_grapag_ix	CREATE INDEX mdl_assieditanno_grapag_ix ON mdl_assignfeedback_editpdf_annot USING btree (gradeid, pageno)

Index - Schema public

Table: mdl_assignfeedback_editpdf_cmnt

Stores comments added to pdfs

mdl_assignfeedback_editpdf_cmnt Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	gradeid	bigint	NOT NULL
	x	bigint
	y	bigint
	width	bigint	DEFAULT 120
	rawtext	text
	pageno	bigint	NOT NULL
	colour	character varying(10)	DEFAULT 'black'::character varying
	draft	smallint	NOT NULL DEFAULT 1

mdl_assignfeedback_editpdf_cmnt Indexes
Index Name	Definition
mdl_assieditcmnt_gra_ix	CREATE INDEX mdl_assieditcmnt_gra_ix ON mdl_assignfeedback_editpdf_cmnt USING btree (gradeid)
mdl_assieditcmnt_grapag_ix	CREATE INDEX mdl_assieditcmnt_grapag_ix ON mdl_assignfeedback_editpdf_cmnt USING btree (gradeid, pageno)

Index - Schema public

Table: mdl_assignfeedback_editpdf_quick

Stores teacher specified quicklist comments

mdl_assignfeedback_editpdf_quick Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	rawtext	text	NOT NULL
	width	bigint	NOT NULL DEFAULT 120
	colour	character varying(10)	DEFAULT 'yellow'::character varying

mdl_assignfeedback_editpdf_quick Indexes
Index Name	Definition
mdl_assieditquic_use_ix	CREATE INDEX mdl_assieditquic_use_ix ON mdl_assignfeedback_editpdf_quick USING btree (userid)

Index - Schema public

Table: mdl_assignfeedback_file

Stores info about the number of files submitted by a student.

mdl_assignfeedback_file Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	grade	bigint	NOT NULL
	numfiles	bigint	NOT NULL

mdl_assignfeedback_file Indexes
Index Name	Definition
mdl_assifile_ass2_ix	CREATE INDEX mdl_assifile_ass2_ix ON mdl_assignfeedback_file USING btree (assignment)
mdl_assifile_gra_ix	CREATE INDEX mdl_assifile_gra_ix ON mdl_assignfeedback_file USING btree (grade)

Index - Schema public

Table: mdl_assignment

Defines assignments

mdl_assignment Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	assignmenttype	character varying(50)	NOT NULL DEFAULT ''::character varying
	resubmit	smallint	NOT NULL
	preventlate	smallint	NOT NULL
	emailteachers	smallint	NOT NULL
	var1	bigint
	var2	bigint
	var3	bigint
	var4	bigint
	var5	bigint
	maxbytes	bigint	NOT NULL DEFAULT 100000
	timedue	bigint	NOT NULL
	timeavailable	bigint	NOT NULL
	grade	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_assignment Indexes
Index Name	Definition
mdl_assi_cou2_ix	CREATE INDEX mdl_assi_cou2_ix ON mdl_assignment USING btree (course)

Index - Schema public

Table: mdl_assignment_submissions

Info about submitted assignments

mdl_assignment_submissions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	userid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	numfiles	bigint	NOT NULL
	data1	text
	data2	text
	grade	bigint	NOT NULL
	submissioncomment	text	NOT NULL
	format	smallint	NOT NULL
	teacher	bigint	NOT NULL
	timemarked	bigint	NOT NULL
	mailed	smallint	NOT NULL

mdl_assignment_submissions Indexes
Index Name	Definition
mdl_assisubm_ass2_ix	CREATE INDEX mdl_assisubm_ass2_ix ON mdl_assignment_submissions USING btree (assignment)
mdl_assisubm_mai_ix	CREATE INDEX mdl_assisubm_mai_ix ON mdl_assignment_submissions USING btree (mailed)
mdl_assisubm_tim_ix	CREATE INDEX mdl_assisubm_tim_ix ON mdl_assignment_submissions USING btree (timemarked)
mdl_assisubm_use2_ix	CREATE INDEX mdl_assisubm_use2_ix ON mdl_assignment_submissions USING btree (userid)

Index - Schema public

Table: mdl_assignsubmission_file

Info about file submissions for assignments

mdl_assignsubmission_file Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	submission	bigint	NOT NULL
	numfiles	bigint	NOT NULL

mdl_assignsubmission_file Indexes
Index Name	Definition
mdl_assifile_ass_ix	CREATE INDEX mdl_assifile_ass_ix ON mdl_assignsubmission_file USING btree (assignment)
mdl_assifile_sub_ix	CREATE INDEX mdl_assifile_sub_ix ON mdl_assignsubmission_file USING btree (submission)

Index - Schema public

Table: mdl_assignsubmission_onlinetext

Info about onlinetext submission

mdl_assignsubmission_onlinetext Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assignment	bigint	NOT NULL
	submission	bigint	NOT NULL
	onlinetext	text
	onlineformat	smallint	NOT NULL

mdl_assignsubmission_onlinetext Indexes
Index Name	Definition
mdl_assionli_ass_ix	CREATE INDEX mdl_assionli_ass_ix ON mdl_assignsubmission_onlinetext USING btree (assignment)
mdl_assionli_sub_ix	CREATE INDEX mdl_assionli_sub_ix ON mdl_assignsubmission_onlinetext USING btree (submission)

Index - Schema public

Table: mdl_backup_controllers

To store the backup_controllers as they are used

mdl_backup_controllers Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	backupid	character varying(32)	NOT NULL DEFAULT ''::character varying
	operation	character varying(20)	NOT NULL DEFAULT 'backup'::character varying
	type	character varying(10)	NOT NULL DEFAULT ''::character varying
	itemid	bigint	NOT NULL
	format	character varying(20)	NOT NULL DEFAULT ''::character varying
	interactive	smallint	NOT NULL
	purpose	smallint	NOT NULL
	userid	bigint	NOT NULL
	status	smallint	NOT NULL
	execution	smallint	NOT NULL
	executiontime	bigint	NOT NULL
	checksum	character varying(32)	NOT NULL DEFAULT ''::character varying
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	controller	text	NOT NULL

mdl_backup_controllers Indexes
Index Name	Definition
mdl_backcont_typite_ix	CREATE INDEX mdl_backcont_typite_ix ON mdl_backup_controllers USING btree (type, itemid)
mdl_backcont_use_ix	CREATE INDEX mdl_backcont_use_ix ON mdl_backup_controllers USING btree (userid)

Index - Schema public

Table: mdl_backup_courses

To store every course backup status

mdl_backup_courses Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	laststarttime	bigint	NOT NULL
	lastendtime	bigint	NOT NULL
	laststatus	character varying(1)	NOT NULL DEFAULT '5'::character varying
	nextstarttime	bigint	NOT NULL

Index - Schema public

Table: mdl_backup_logs

To store all the logs from backup and restore operations (by db logger)

mdl_backup_logs Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	backupid	character varying(32)	NOT NULL DEFAULT ''::character varying
	loglevel	smallint	NOT NULL
	message	text	NOT NULL
	timecreated	bigint	NOT NULL

mdl_backup_logs Indexes
Index Name	Definition
mdl_backlogs_bac_ix	CREATE INDEX mdl_backlogs_bac_ix ON mdl_backup_logs USING btree (backupid)

Index - Schema public

Table: mdl_badge

mdl_badge Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	description	text
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	usercreated	bigint	NOT NULL
	usermodified	bigint	NOT NULL
	issuername	character varying(255)	NOT NULL DEFAULT ''::character varying
	issuerurl	character varying(255)	NOT NULL DEFAULT ''::character varying
	issuercontact	character varying(255)
	expiredate	bigint
	expireperiod	bigint
	type	smallint	NOT NULL DEFAULT 1
	courseid	bigint
	message	text	NOT NULL
	messagesubject	text	NOT NULL
	attachment	smallint	NOT NULL DEFAULT 1
	notification	smallint	NOT NULL DEFAULT 1
	status	smallint	NOT NULL
	nextcron	bigint

mdl_badge Indexes
Index Name	Definition
mdl_badg_cou_ix	CREATE INDEX mdl_badg_cou_ix ON mdl_badge USING btree (courseid)
mdl_badg_typ_ix	CREATE INDEX mdl_badg_typ_ix ON mdl_badge USING btree (type)
mdl_badg_use2_ix	CREATE INDEX mdl_badg_use2_ix ON mdl_badge USING btree (usercreated)
mdl_badg_use_ix	CREATE INDEX mdl_badg_use_ix ON mdl_badge USING btree (usermodified)

Index - Schema public

Table: mdl_badge_backpack

mdl_badge_backpack Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	email	character varying(100)	NOT NULL DEFAULT ''::character varying
	backpackurl	character varying(255)	NOT NULL DEFAULT ''::character varying
	backpackuid	bigint	NOT NULL
	autosync	smallint	NOT NULL
	password	character varying(50)

mdl_badge_backpack Indexes
Index Name	Definition
mdl_badgback_use_ix	CREATE INDEX mdl_badgback_use_ix ON mdl_badge_backpack USING btree (userid)

Index - Schema public

Table: mdl_badge_criteria

mdl_badge_criteria Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	badgeid	bigint	NOT NULL
	criteriatype	bigint
	method	smallint	NOT NULL DEFAULT 1

mdl_badge_criteria Indexes
Index Name	Definition
mdl_badgcrit_bad_ix	CREATE INDEX mdl_badgcrit_bad_ix ON mdl_badge_criteria USING btree (badgeid)
mdl_badgcrit_cri_ix	CREATE INDEX mdl_badgcrit_cri_ix ON mdl_badge_criteria USING btree (criteriatype)

Index - Schema public

Table: mdl_badge_criteria_met

mdl_badge_criteria_met Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	issuedid	bigint
	critid	bigint	NOT NULL
	userid	bigint	NOT NULL
	datemet	bigint	NOT NULL

mdl_badge_criteria_met Indexes
Index Name	Definition
mdl_badgcritmet_cri_ix	CREATE INDEX mdl_badgcritmet_cri_ix ON mdl_badge_criteria_met USING btree (critid)
mdl_badgcritmet_iss_ix	CREATE INDEX mdl_badgcritmet_iss_ix ON mdl_badge_criteria_met USING btree (issuedid)
mdl_badgcritmet_use_ix	CREATE INDEX mdl_badgcritmet_use_ix ON mdl_badge_criteria_met USING btree (userid)

Index - Schema public

Table: mdl_badge_criteria_param

mdl_badge_criteria_param Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	critid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	character varying(255)

mdl_badge_criteria_param Indexes
Index Name	Definition
mdl_badgcritpara_cri_ix	CREATE INDEX mdl_badgcritpara_cri_ix ON mdl_badge_criteria_param USING btree (critid)

Index - Schema public

Table: mdl_badge_external

mdl_badge_external Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	backpackid	bigint	NOT NULL
	collectionid	bigint	NOT NULL

mdl_badge_external Indexes
Index Name	Definition
mdl_badgexte_bac_ix	CREATE INDEX mdl_badgexte_bac_ix ON mdl_badge_external USING btree (backpackid)

Index - Schema public

Table: mdl_badge_issued

mdl_badge_issued Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	badgeid	bigint	NOT NULL
	userid	bigint	NOT NULL
	uniquehash	text	NOT NULL
	dateissued	bigint	NOT NULL
	dateexpire	bigint
	visible	smallint	NOT NULL
	issuernotified	bigint

mdl_badge_issued Indexes
Index Name	Definition
mdl_badgissu_bad_ix	CREATE INDEX mdl_badgissu_bad_ix ON mdl_badge_issued USING btree (badgeid)
mdl_badgissu_use_ix	CREATE INDEX mdl_badgissu_use_ix ON mdl_badge_issued USING btree (userid)

Index - Schema public

Table: mdl_badge_manual_award

mdl_badge_manual_award Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	badgeid	bigint	NOT NULL
	recipientid	bigint	NOT NULL
	issuerid	bigint	NOT NULL
	issuerrole	bigint	NOT NULL
	datemet	bigint	NOT NULL

mdl_badge_manual_award Indexes
Index Name	Definition
mdl_badgmanuawar_bad_ix	CREATE INDEX mdl_badgmanuawar_bad_ix ON mdl_badge_manual_award USING btree (badgeid)
mdl_badgmanuawar_iss2_ix	CREATE INDEX mdl_badgmanuawar_iss2_ix ON mdl_badge_manual_award USING btree (issuerrole)
mdl_badgmanuawar_iss_ix	CREATE INDEX mdl_badgmanuawar_iss_ix ON mdl_badge_manual_award USING btree (issuerid)
mdl_badgmanuawar_rec_ix	CREATE INDEX mdl_badgmanuawar_rec_ix ON mdl_badge_manual_award USING btree (recipientid)

Index - Schema public

Table: mdl_block

contains all installed blocks

mdl_block Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(40)	NOT NULL DEFAULT ''::character varying
	cron	bigint	NOT NULL
	lastcron	bigint	NOT NULL
	visible	smallint	NOT NULL DEFAULT 1

Index - Schema public

Table: mdl_block_community

Community block

mdl_block_community Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	coursename	character varying(255)	NOT NULL DEFAULT ''::character varying
	coursedescription	text
	courseurl	character varying(255)	NOT NULL DEFAULT ''::character varying
	imageurl	character varying(255)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_block_instances

This table stores block instances. The type of block this is is given by the blockname column. The places this block instance appears is controlled by the parentcontexid, showinsubcontexts, pagetypepattern and subpagepattern fields. Where the block a

mdl_block_instances Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	blockname	character varying(40)	NOT NULL DEFAULT ''::character varying
	parentcontextid	bigint	NOT NULL
	showinsubcontexts	smallint	NOT NULL
	pagetypepattern	character varying(64)	NOT NULL DEFAULT ''::character varying
	subpagepattern	character varying(16)
	defaultregion	character varying(16)	NOT NULL DEFAULT ''::character varying
	defaultweight	bigint	NOT NULL
	configdata	text

mdl_block_instances Indexes
Index Name	Definition
mdl_blocinst_par_ix	CREATE INDEX mdl_blocinst_par_ix ON mdl_block_instances USING btree (parentcontextid)
mdl_blocinst_parshopagsub_ix	CREATE INDEX mdl_blocinst_parshopagsub_ix ON mdl_block_instances USING btree (parentcontextid, showinsubcontexts, pagetypepattern, subpagepattern)

Index - Schema public

Table: mdl_block_positions

Stores the position of a sticky block_instance on a another page than the one where it was added.

mdl_block_positions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	blockinstanceid	bigint	NOT NULL
	contextid	bigint	NOT NULL
	pagetype	character varying(64)	NOT NULL DEFAULT ''::character varying
	subpage	character varying(16)	NOT NULL DEFAULT ''::character varying
	visible	smallint	NOT NULL
	region	character varying(16)	NOT NULL DEFAULT ''::character varying
	weight	bigint	NOT NULL

mdl_block_positions Indexes
Index Name	Definition
mdl_blocposi_blo_ix	CREATE INDEX mdl_blocposi_blo_ix ON mdl_block_positions USING btree (blockinstanceid)
mdl_blocposi_con_ix	CREATE INDEX mdl_blocposi_con_ix ON mdl_block_positions USING btree (contextid)

Index - Schema public

Table: mdl_block_rss_client

Remote news feed information. Contains the news feed id, the userid of the user who added the feed, the title of the feed itself and a description of the feed contents along with the url used to access the remote feed. Preferredtitle is a field for f

mdl_block_rss_client Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	title	text	NOT NULL
	preferredtitle	character varying(64)	NOT NULL DEFAULT ''::character varying
	description	text	NOT NULL
	shared	smallint	NOT NULL
	url	character varying(255)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_blog_association

Associations of blog entries with courses and module instances

mdl_blog_association Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextid	bigint	NOT NULL
	blogid	bigint	NOT NULL

mdl_blog_association Indexes
Index Name	Definition
mdl_blogasso_blo_ix	CREATE INDEX mdl_blogasso_blo_ix ON mdl_blog_association USING btree (blogid)
mdl_blogasso_con_ix	CREATE INDEX mdl_blogasso_con_ix ON mdl_blog_association USING btree (contextid)

Index - Schema public

Table: mdl_blog_external

External blog links used for RSS copying of blog entries to Moodle user blogs

mdl_blog_external Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	description	text
	url	text	NOT NULL
	filtertags	character varying(255)
	failedlastsync	smallint	NOT NULL
	timemodified	bigint
	timefetched	bigint	NOT NULL

mdl_blog_external Indexes
Index Name	Definition
mdl_blogexte_use_ix	CREATE INDEX mdl_blogexte_use_ix ON mdl_blog_external USING btree (userid)

Index - Schema public

Table: mdl_book

Defines book

mdl_book Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint	NOT NULL
	numbering	smallint	NOT NULL
	customtitles	smallint	NOT NULL
	revision	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

Index - Schema public

Table: mdl_book_chapters

Defines book_chapters

mdl_book_chapters Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	bookid	bigint	NOT NULL
	pagenum	bigint	NOT NULL
	subchapter	bigint	NOT NULL
	title	character varying(255)	NOT NULL DEFAULT ''::character varying
	content	text	NOT NULL
	contentformat	smallint	NOT NULL
	hidden	smallint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	importsrc	character varying(255)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_cache_filters

For keeping information about cached data

mdl_cache_filters Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	filter	character varying(32)	NOT NULL DEFAULT ''::character varying
	version	bigint	NOT NULL
	md5key	character varying(32)	NOT NULL DEFAULT ''::character varying
	rawtext	text	NOT NULL
	timemodified	bigint	NOT NULL

mdl_cache_filters Indexes
Index Name	Definition
mdl_cachfilt_filmd5_ix	CREATE INDEX mdl_cachfilt_filmd5_ix ON mdl_cache_filters USING btree (filter, md5key)

Index - Schema public

Table: mdl_cache_flags

Cache of time-sensitive flags

mdl_cache_flags Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	flagtype	character varying(255)	NOT NULL DEFAULT ''::character varying
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	timemodified	bigint	NOT NULL
	value	text	NOT NULL
	expiry	bigint	NOT NULL

mdl_cache_flags Indexes
Index Name	Definition
mdl_cachflag_fla_ix	CREATE INDEX mdl_cachflag_fla_ix ON mdl_cache_flags USING btree (flagtype)
mdl_cachflag_nam_ix	CREATE INDEX mdl_cachflag_nam_ix ON mdl_cache_flags USING btree (name)

Index - Schema public

Table: mdl_cache_text

For storing temporary copies of processed texts

mdl_cache_text Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	md5key	character varying(32)	NOT NULL DEFAULT ''::character varying
	formattedtext	text	NOT NULL
	timemodified	bigint	NOT NULL

mdl_cache_text Indexes
Index Name	Definition
mdl_cachtext_md5_ix	CREATE INDEX mdl_cachtext_md5_ix ON mdl_cache_text USING btree (md5key)
mdl_cachtext_tim_ix	CREATE INDEX mdl_cachtext_tim_ix ON mdl_cache_text USING btree (timemodified)

Index - Schema public

Table: mdl_capabilities

this defines all capabilities

mdl_capabilities Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	captype	character varying(50)	NOT NULL DEFAULT ''::character varying
	contextlevel	bigint	NOT NULL
	component	character varying(100)	NOT NULL DEFAULT ''::character varying
	riskbitmask	bigint	NOT NULL

Index - Schema public

Table: mdl_chat

Each of these is a chat room

mdl_chat Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	keepdays	bigint	NOT NULL
	studentlogs	smallint	NOT NULL
	chattime	bigint	NOT NULL
	schedule	smallint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_chat Indexes
Index Name	Definition
mdl_chat_cou_ix	CREATE INDEX mdl_chat_cou_ix ON mdl_chat USING btree (course)

Index - Schema public

Table: mdl_chat_messages

Stores all the actual chat messages

mdl_chat_messages Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	chatid	bigint	NOT NULL
	userid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	system	smallint	NOT NULL
	message	text	NOT NULL
	timestamp	bigint	NOT NULL

mdl_chat_messages Indexes
Index Name	Definition
mdl_chatmess_cha_ix	CREATE INDEX mdl_chatmess_cha_ix ON mdl_chat_messages USING btree (chatid)
mdl_chatmess_gro_ix	CREATE INDEX mdl_chatmess_gro_ix ON mdl_chat_messages USING btree (groupid)
mdl_chatmess_timcha_ix	CREATE INDEX mdl_chatmess_timcha_ix ON mdl_chat_messages USING btree ("timestamp", chatid)
mdl_chatmess_use_ix	CREATE INDEX mdl_chatmess_use_ix ON mdl_chat_messages USING btree (userid)

Index - Schema public

Table: mdl_chat_messages_current

Stores current session

mdl_chat_messages_current Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	chatid	bigint	NOT NULL
	userid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	system	smallint	NOT NULL
	message	text	NOT NULL
	timestamp	bigint	NOT NULL

mdl_chat_messages_current Indexes
Index Name	Definition
mdl_chatmesscurr_cha_ix	CREATE INDEX mdl_chatmesscurr_cha_ix ON mdl_chat_messages_current USING btree (chatid)
mdl_chatmesscurr_gro_ix	CREATE INDEX mdl_chatmesscurr_gro_ix ON mdl_chat_messages_current USING btree (groupid)
mdl_chatmesscurr_timcha_ix	CREATE INDEX mdl_chatmesscurr_timcha_ix ON mdl_chat_messages_current USING btree ("timestamp", chatid)
mdl_chatmesscurr_use_ix	CREATE INDEX mdl_chatmesscurr_use_ix ON mdl_chat_messages_current USING btree (userid)

Index - Schema public

Table: mdl_chat_users

Keeps track of which users are in which chat rooms

mdl_chat_users Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	chatid	bigint	NOT NULL
	userid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	version	character varying(16)	NOT NULL DEFAULT ''::character varying
	ip	character varying(45)	NOT NULL DEFAULT ''::character varying
	firstping	bigint	NOT NULL
	lastping	bigint	NOT NULL
	lastmessageping	bigint	NOT NULL
	sid	character varying(32)	NOT NULL DEFAULT ''::character varying
	course	bigint	NOT NULL
	lang	character varying(30)	NOT NULL DEFAULT ''::character varying

mdl_chat_users Indexes
Index Name	Definition
mdl_chatuser_cha_ix	CREATE INDEX mdl_chatuser_cha_ix ON mdl_chat_users USING btree (chatid)
mdl_chatuser_gro_ix	CREATE INDEX mdl_chatuser_gro_ix ON mdl_chat_users USING btree (groupid)
mdl_chatuser_las_ix	CREATE INDEX mdl_chatuser_las_ix ON mdl_chat_users USING btree (lastping)
mdl_chatuser_use_ix	CREATE INDEX mdl_chatuser_use_ix ON mdl_chat_users USING btree (userid)

Index - Schema public

Table: mdl_choice

Available choices are stored here

mdl_choice Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	publish	smallint	NOT NULL
	showresults	smallint	NOT NULL
	display	smallint	NOT NULL
	allowupdate	smallint	NOT NULL
	showunanswered	smallint	NOT NULL
	limitanswers	smallint	NOT NULL
	timeopen	bigint	NOT NULL
	timeclose	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	completionsubmit	smallint	NOT NULL

mdl_choice Indexes
Index Name	Definition
mdl_choi_cou_ix	CREATE INDEX mdl_choi_cou_ix ON mdl_choice USING btree (course)

Index - Schema public

Table: mdl_choice_answers

choices performed by users

mdl_choice_answers Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	choiceid	bigint	NOT NULL
	userid	bigint	NOT NULL
	optionid	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_choice_answers Indexes
Index Name	Definition
mdl_choiansw_cho_ix	CREATE INDEX mdl_choiansw_cho_ix ON mdl_choice_answers USING btree (choiceid)
mdl_choiansw_opt_ix	CREATE INDEX mdl_choiansw_opt_ix ON mdl_choice_answers USING btree (optionid)
mdl_choiansw_use_ix	CREATE INDEX mdl_choiansw_use_ix ON mdl_choice_answers USING btree (userid)

Index - Schema public

Table: mdl_choice_options

available options to choice

mdl_choice_options Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	choiceid	bigint	NOT NULL
	text	text
	maxanswers	bigint
	timemodified	bigint	NOT NULL

mdl_choice_options Indexes
Index Name	Definition
mdl_choiopti_cho_ix	CREATE INDEX mdl_choiopti_cho_ix ON mdl_choice_options USING btree (choiceid)

Index - Schema public

Table: mdl_cohort

Each record represents one cohort (aka site-wide group).

mdl_cohort Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextid	bigint	NOT NULL
	name	character varying(254)	NOT NULL DEFAULT ''::character varying
	idnumber	character varying(100)
	description	text
	descriptionformat	smallint	NOT NULL
	component	character varying(100)	NOT NULL DEFAULT ''::character varying
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_cohort Indexes
Index Name	Definition
mdl_coho_con_ix	CREATE INDEX mdl_coho_con_ix ON mdl_cohort USING btree (contextid)

Index - Schema public

Table: mdl_cohort_members

Link a user to a cohort.

mdl_cohort_members Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	cohortid	bigint	NOT NULL
	userid	bigint	NOT NULL
	timeadded	bigint	NOT NULL

mdl_cohort_members Indexes
Index Name	Definition
mdl_cohomemb_coh_ix	CREATE INDEX mdl_cohomemb_coh_ix ON mdl_cohort_members USING btree (cohortid)
mdl_cohomemb_use_ix	CREATE INDEX mdl_cohomemb_use_ix ON mdl_cohort_members USING btree (userid)

Index - Schema public

Table: mdl_comments

moodle comments module

mdl_comments Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextid	bigint	NOT NULL
	commentarea	character varying(255)	NOT NULL DEFAULT ''::character varying
	itemid	bigint	NOT NULL
	content	text	NOT NULL
	format	smallint	NOT NULL
	userid	bigint	NOT NULL
	timecreated	bigint	NOT NULL

Index - Schema public

Table: mdl_config

Moodle configuration variables

mdl_config Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	text	NOT NULL

Index - Schema public

Table: mdl_config_log

Changes done in server configuration through admin UI

mdl_config_log Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	plugin	character varying(100)
	name	character varying(100)	NOT NULL DEFAULT ''::character varying
	value	text
	oldvalue	text

mdl_config_log Indexes
Index Name	Definition
mdl_conflog_tim_ix	CREATE INDEX mdl_conflog_tim_ix ON mdl_config_log USING btree (timemodified)
mdl_conflog_use_ix	CREATE INDEX mdl_conflog_use_ix ON mdl_config_log USING btree (userid)

Index - Schema public

Table: mdl_config_plugins

Moodle modules and plugins configuration variables

mdl_config_plugins Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	plugin	character varying(100)	NOT NULL DEFAULT 'core'::character varying
	name	character varying(100)	NOT NULL DEFAULT ''::character varying
	value	text	NOT NULL

Index - Schema public

Table: mdl_context

one of these must be set

mdl_context Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextlevel	bigint	NOT NULL
	instanceid	bigint	NOT NULL
	path	character varying(255)
	depth	smallint	NOT NULL

mdl_context Indexes
Index Name	Definition
mdl_cont_ins_ix	CREATE INDEX mdl_cont_ins_ix ON mdl_context USING btree (instanceid)
mdl_cont_pat_ix	CREATE INDEX mdl_cont_pat_ix ON mdl_context USING btree (path)
mdl_cont_pat_ix_pattern	CREATE INDEX mdl_cont_pat_ix_pattern ON mdl_context USING btree (path varchar_pattern_ops)

Index - Schema public

Table: mdl_context_temp

Used by build_context_path() in upgrade and cron to keep context depths and paths in sync.

mdl_context_temp Structure
F-Key	Name	Type	Description
	id	bigint	PRIMARY KEY
	path	character varying(255)	NOT NULL DEFAULT ''::character varying
	depth	smallint	NOT NULL

Index - Schema public

Table: mdl_course

Central course table

mdl_course Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	category	bigint	NOT NULL
	sortorder	bigint	NOT NULL
	fullname	character varying(254)	NOT NULL DEFAULT ''::character varying
	shortname	character varying(255)	NOT NULL DEFAULT ''::character varying
	idnumber	character varying(100)	NOT NULL DEFAULT ''::character varying
	summary	text
	summaryformat	smallint	NOT NULL
	format	character varying(21)	NOT NULL DEFAULT 'topics'::character varying
	showgrades	smallint	NOT NULL DEFAULT 1
	newsitems	integer	NOT NULL DEFAULT 1
	startdate	bigint	NOT NULL
	marker	bigint	NOT NULL
	maxbytes	bigint	NOT NULL
	legacyfiles	smallint	NOT NULL
	showreports	smallint	NOT NULL
	visible	smallint	NOT NULL DEFAULT 1
	visibleold	smallint	NOT NULL DEFAULT 1
	groupmode	smallint	NOT NULL
	groupmodeforce	smallint	NOT NULL
	defaultgroupingid	bigint	NOT NULL
	lang	character varying(30)	NOT NULL DEFAULT ''::character varying
	theme	character varying(50)	NOT NULL DEFAULT ''::character varying
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	requested	smallint	NOT NULL
	enablecompletion	smallint	NOT NULL
	completionnotify	smallint	NOT NULL
	calendartype	character varying(30)	NOT NULL DEFAULT ''::character varying
	cacherev	bigint	NOT NULL

mdl_course Indexes
Index Name	Definition
mdl_cour_cat_ix	CREATE INDEX mdl_cour_cat_ix ON mdl_course USING btree (category)
mdl_cour_idn_ix	CREATE INDEX mdl_cour_idn_ix ON mdl_course USING btree (idnumber)
mdl_cour_sho_ix	CREATE INDEX mdl_cour_sho_ix ON mdl_course USING btree (shortname)
mdl_cour_sor_ix	CREATE INDEX mdl_cour_sor_ix ON mdl_course USING btree (sortorder)

Index - Schema public

Table: mdl_course_categories

Course categories

mdl_course_categories Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	idnumber	character varying(100)
	description	text
	descriptionformat	smallint	NOT NULL
	parent	bigint	NOT NULL
	sortorder	bigint	NOT NULL
	coursecount	bigint	NOT NULL
	visible	smallint	NOT NULL DEFAULT 1
	visibleold	smallint	NOT NULL DEFAULT 1
	timemodified	bigint	NOT NULL
	depth	bigint	NOT NULL
	path	character varying(255)	NOT NULL DEFAULT ''::character varying
	theme	character varying(50)

mdl_course_categories Indexes
Index Name	Definition
mdl_courcate_par_ix	CREATE INDEX mdl_courcate_par_ix ON mdl_course_categories USING btree (parent)

Index - Schema public

Table: mdl_course_completion_aggr_methd

Course completion aggregation methods for criteria

mdl_course_completion_aggr_methd Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	criteriatype	bigint
	method	smallint	NOT NULL
	value	numeric(10,5)

mdl_course_completion_aggr_methd Indexes
Index Name	Definition
mdl_courcompaggrmeth_cou_ix	CREATE INDEX mdl_courcompaggrmeth_cou_ix ON mdl_course_completion_aggr_methd USING btree (course)
mdl_courcompaggrmeth_cri_ix	CREATE INDEX mdl_courcompaggrmeth_cri_ix ON mdl_course_completion_aggr_methd USING btree (criteriatype)

Index - Schema public

Table: mdl_course_completion_crit_compl

Course completion user records

mdl_course_completion_crit_compl Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	course	bigint	NOT NULL
	criteriaid	bigint	NOT NULL
	gradefinal	numeric(10,5)
	unenroled	bigint
	timecompleted	bigint

mdl_course_completion_crit_compl Indexes
Index Name	Definition
mdl_courcompcritcomp_cou_ix	CREATE INDEX mdl_courcompcritcomp_cou_ix ON mdl_course_completion_crit_compl USING btree (course)
mdl_courcompcritcomp_cri_ix	CREATE INDEX mdl_courcompcritcomp_cri_ix ON mdl_course_completion_crit_compl USING btree (criteriaid)
mdl_courcompcritcomp_tim_ix	CREATE INDEX mdl_courcompcritcomp_tim_ix ON mdl_course_completion_crit_compl USING btree (timecompleted)
mdl_courcompcritcomp_use_ix	CREATE INDEX mdl_courcompcritcomp_use_ix ON mdl_course_completion_crit_compl USING btree (userid)

Index - Schema public

Table: mdl_course_completion_criteria

Course completion criteria

mdl_course_completion_criteria Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	criteriatype	bigint	NOT NULL
	module	character varying(100)
	moduleinstance	bigint
	courseinstance	bigint
	enrolperiod	bigint
	timeend	bigint
	gradepass	numeric(10,5)
	role	bigint

mdl_course_completion_criteria Indexes
Index Name	Definition
mdl_courcompcrit_cou_ix	CREATE INDEX mdl_courcompcrit_cou_ix ON mdl_course_completion_criteria USING btree (course)

Index - Schema public

Table: mdl_course_completions

Course completion records

mdl_course_completions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	course	bigint	NOT NULL
	timeenrolled	bigint	NOT NULL
	timestarted	bigint	NOT NULL
	timecompleted	bigint
	reaggregate	bigint	NOT NULL

mdl_course_completions Indexes
Index Name	Definition
mdl_courcomp_cou_ix	CREATE INDEX mdl_courcomp_cou_ix ON mdl_course_completions USING btree (course)
mdl_courcomp_tim_ix	CREATE INDEX mdl_courcomp_tim_ix ON mdl_course_completions USING btree (timecompleted)
mdl_courcomp_use_ix	CREATE INDEX mdl_courcomp_use_ix ON mdl_course_completions USING btree (userid)

Index - Schema public

Table: mdl_course_format_options

Stores format-specific options for the course or course section

mdl_course_format_options Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	format	character varying(21)	NOT NULL DEFAULT ''::character varying
	sectionid	bigint	NOT NULL
	name	character varying(100)	NOT NULL DEFAULT ''::character varying
	value	text

mdl_course_format_options Indexes
Index Name	Definition
mdl_courformopti_cou_ix	CREATE INDEX mdl_courformopti_cou_ix ON mdl_course_format_options USING btree (courseid)

Index - Schema public

Table: mdl_course_modules

course_modules table retrofitted from MySQL

mdl_course_modules Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	module	bigint	NOT NULL
	instance	bigint	NOT NULL
	section	bigint	NOT NULL
	idnumber	character varying(100)
	added	bigint	NOT NULL
	score	smallint	NOT NULL
	indent	integer	NOT NULL
	visible	smallint	NOT NULL DEFAULT 1
	visibleold	smallint	NOT NULL DEFAULT 1
	groupmode	smallint	NOT NULL
	groupingid	bigint	NOT NULL
	groupmembersonly	smallint	NOT NULL
	completion	smallint	NOT NULL
	completiongradeitemnumber	bigint
	completionview	smallint	NOT NULL
	completionexpected	bigint	NOT NULL
	availablefrom	bigint	NOT NULL
	availableuntil	bigint	NOT NULL
	showavailability	smallint	NOT NULL
	showdescription	smallint	NOT NULL

mdl_course_modules Indexes
Index Name	Definition
mdl_courmodu_cou_ix	CREATE INDEX mdl_courmodu_cou_ix ON mdl_course_modules USING btree (course)
mdl_courmodu_gro_ix	CREATE INDEX mdl_courmodu_gro_ix ON mdl_course_modules USING btree (groupingid)
mdl_courmodu_idncou_ix	CREATE INDEX mdl_courmodu_idncou_ix ON mdl_course_modules USING btree (idnumber, course)
mdl_courmodu_ins_ix	CREATE INDEX mdl_courmodu_ins_ix ON mdl_course_modules USING btree (instance)
mdl_courmodu_mod_ix	CREATE INDEX mdl_courmodu_mod_ix ON mdl_course_modules USING btree (module)
mdl_courmodu_vis_ix	CREATE INDEX mdl_courmodu_vis_ix ON mdl_course_modules USING btree (visible)

Index - Schema public

Table: mdl_course_modules_avail_fields

Stores user field conditions that affect whether an activity is currently available.

mdl_course_modules_avail_fields Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	coursemoduleid	bigint	NOT NULL
	userfield	character varying(50)
	customfieldid	bigint
	operator	character varying(20)	NOT NULL DEFAULT ''::character varying
	value	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_course_modules_avail_fields Indexes
Index Name	Definition
mdl_courmoduavaifiel_cou_ix	CREATE INDEX mdl_courmoduavaifiel_cou_ix ON mdl_course_modules_avail_fields USING btree (coursemoduleid)

Index - Schema public

Table: mdl_course_modules_availability

Table stores conditions that affect whether a module/activity is currently available to students or not.

mdl_course_modules_availability Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	coursemoduleid	bigint	NOT NULL
	sourcecmid	bigint
	requiredcompletion	smallint
	gradeitemid	bigint
	grademin	numeric(10,5)
	grademax	numeric(10,5)

mdl_course_modules_availability Indexes
Index Name	Definition
mdl_courmoduavai_cou_ix	CREATE INDEX mdl_courmoduavai_cou_ix ON mdl_course_modules_availability USING btree (coursemoduleid)
mdl_courmoduavai_gra_ix	CREATE INDEX mdl_courmoduavai_gra_ix ON mdl_course_modules_availability USING btree (gradeitemid)
mdl_courmoduavai_sou_ix	CREATE INDEX mdl_courmoduavai_sou_ix ON mdl_course_modules_availability USING btree (sourcecmid)

Index - Schema public

Table: mdl_course_modules_completion

Stores the completion state (completed or not completed, etc) of each user on each activity.

mdl_course_modules_completion Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	coursemoduleid	bigint	NOT NULL
	userid	bigint	NOT NULL
	completionstate	smallint	NOT NULL
	viewed	smallint
	timemodified	bigint	NOT NULL

mdl_course_modules_completion Indexes
Index Name	Definition
mdl_courmoducomp_cou_ix	CREATE INDEX mdl_courmoducomp_cou_ix ON mdl_course_modules_completion USING btree (coursemoduleid)

Index - Schema public

Table: mdl_course_published

Information about how and when an local courses were published to hubs

mdl_course_published Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	huburl	character varying(255)
	courseid	bigint	NOT NULL
	timepublished	bigint	NOT NULL
	enrollable	smallint	NOT NULL DEFAULT 1
	hubcourseid	bigint	NOT NULL
	status	smallint
	timechecked	bigint

Index - Schema public

Table: mdl_course_request

course requests

mdl_course_request Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	fullname	character varying(254)	NOT NULL DEFAULT ''::character varying
	shortname	character varying(100)	NOT NULL DEFAULT ''::character varying
	summary	text	NOT NULL
	summaryformat	smallint	NOT NULL
	category	bigint	NOT NULL
	reason	text	NOT NULL
	requester	bigint	NOT NULL
	password	character varying(50)	NOT NULL DEFAULT ''::character varying

mdl_course_request Indexes
Index Name	Definition
mdl_courrequ_sho_ix	CREATE INDEX mdl_courrequ_sho_ix ON mdl_course_request USING btree (shortname)

Index - Schema public

Table: mdl_course_sections

to define the sections for each course

mdl_course_sections Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	section	bigint	NOT NULL
	name	character varying(255)
	summary	text
	summaryformat	smallint	NOT NULL
	sequence	text
	visible	smallint	NOT NULL DEFAULT 1
	availablefrom	bigint	NOT NULL
	availableuntil	bigint	NOT NULL
	showavailability	smallint	NOT NULL
	groupingid	bigint	NOT NULL

Index - Schema public

Table: mdl_course_sections_avail_fields

Stores user field conditions that affect whether an activity is currently available.

mdl_course_sections_avail_fields Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	coursesectionid	bigint	NOT NULL
	userfield	character varying(50)
	customfieldid	bigint
	operator	character varying(20)	NOT NULL DEFAULT ''::character varying
	value	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_course_sections_avail_fields Indexes
Index Name	Definition
mdl_coursectavaifiel_cou_ix	CREATE INDEX mdl_coursectavaifiel_cou_ix ON mdl_course_sections_avail_fields USING btree (coursesectionid)

Index - Schema public

Table: mdl_course_sections_availability

Completion or grade conditions that affect if a section is currently available to students.

mdl_course_sections_availability Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	coursesectionid	bigint	NOT NULL
	sourcecmid	bigint
	requiredcompletion	smallint
	gradeitemid	bigint
	grademin	numeric(10,5)
	grademax	numeric(10,5)

mdl_course_sections_availability Indexes
Index Name	Definition
mdl_coursectavai_cou_ix	CREATE INDEX mdl_coursectavai_cou_ix ON mdl_course_sections_availability USING btree (coursesectionid)
mdl_coursectavai_gra_ix	CREATE INDEX mdl_coursectavai_gra_ix ON mdl_course_sections_availability USING btree (gradeitemid)
mdl_coursectavai_sou_ix	CREATE INDEX mdl_coursectavai_sou_ix ON mdl_course_sections_availability USING btree (sourcecmid)

Index - Schema public

Table: mdl_data

all database activities

mdl_data Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	comments	smallint	NOT NULL
	timeavailablefrom	bigint	NOT NULL
	timeavailableto	bigint	NOT NULL
	timeviewfrom	bigint	NOT NULL
	timeviewto	bigint	NOT NULL
	requiredentries	integer	NOT NULL
	requiredentriestoview	integer	NOT NULL
	maxentries	integer	NOT NULL
	rssarticles	smallint	NOT NULL
	singletemplate	text
	listtemplate	text
	listtemplateheader	text
	listtemplatefooter	text
	addtemplate	text
	rsstemplate	text
	rsstitletemplate	text
	csstemplate	text
	jstemplate	text
	asearchtemplate	text
	approval	smallint	NOT NULL
	scale	bigint	NOT NULL
	assessed	bigint	NOT NULL
	assesstimestart	bigint	NOT NULL
	assesstimefinish	bigint	NOT NULL
	defaultsort	bigint	NOT NULL
	defaultsortdir	smallint	NOT NULL
	editany	smallint	NOT NULL
	notification	bigint	NOT NULL

mdl_data Indexes
Index Name	Definition
mdl_data_cou_ix	CREATE INDEX mdl_data_cou_ix ON mdl_data USING btree (course)

Index - Schema public

Table: mdl_data_content

the content introduced in each record/fields

mdl_data_content Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	fieldid	bigint	NOT NULL
	recordid	bigint	NOT NULL
	content	text
	content1	text
	content2	text
	content3	text
	content4	text

mdl_data_content Indexes
Index Name	Definition
mdl_datacont_fie_ix	CREATE INDEX mdl_datacont_fie_ix ON mdl_data_content USING btree (fieldid)
mdl_datacont_rec_ix	CREATE INDEX mdl_datacont_rec_ix ON mdl_data_content USING btree (recordid)

Index - Schema public

Table: mdl_data_fields

every field available

mdl_data_fields Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	dataid	bigint	NOT NULL
	type	character varying(255)	NOT NULL DEFAULT ''::character varying
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	description	text	NOT NULL
	param1	text
	param2	text
	param3	text
	param4	text
	param5	text
	param6	text
	param7	text
	param8	text
	param9	text
	param10	text

mdl_data_fields Indexes
Index Name	Definition
mdl_datafiel_dat_ix	CREATE INDEX mdl_datafiel_dat_ix ON mdl_data_fields USING btree (dataid)
mdl_datafiel_typdat_ix	CREATE INDEX mdl_datafiel_typdat_ix ON mdl_data_fields USING btree (type, dataid)

Index - Schema public

Table: mdl_data_records

every record introduced

mdl_data_records Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	dataid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	approved	smallint	NOT NULL

mdl_data_records Indexes
Index Name	Definition
mdl_datareco_dat_ix	CREATE INDEX mdl_datareco_dat_ix ON mdl_data_records USING btree (dataid)

Index - Schema public

Table: mdl_enrol

Instances of enrolment plugins used in courses, fields marked as custom have a plugin defined meaning, core does not touch them. Create a new linked table if you need even more custom fields.

mdl_enrol Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	enrol	character varying(20)	NOT NULL DEFAULT ''::character varying
	status	bigint	NOT NULL
	courseid	bigint	NOT NULL
	sortorder	bigint	NOT NULL
	name	character varying(255)
	enrolperiod	bigint
	enrolstartdate	bigint
	enrolenddate	bigint
	expirynotify	smallint
	expirythreshold	bigint
	notifyall	smallint
	password	character varying(50)
	cost	character varying(20)
	currency	character varying(3)
	roleid	bigint
	customint1	bigint
	customint2	bigint
	customint3	bigint
	customint4	bigint
	customint5	bigint
	customint6	bigint
	customint7	bigint
	customint8	bigint
	customchar1	character varying(255)
	customchar2	character varying(255)
	customchar3	character varying(1333)
	customdec1	numeric(12,7)
	customdec2	numeric(12,7)
	customtext1	text
	customtext2	text
	customtext3	text
	customtext4	text
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_enrol Indexes
Index Name	Definition
mdl_enro_cou_ix	CREATE INDEX mdl_enro_cou_ix ON mdl_enrol USING btree (courseid)
mdl_enro_enr_ix	CREATE INDEX mdl_enro_enr_ix ON mdl_enrol USING btree (enrol)

Index - Schema public

Table: mdl_enrol_flatfile

enrol_flatfile table retrofitted from MySQL

mdl_enrol_flatfile Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	action	character varying(30)	NOT NULL DEFAULT ''::character varying
	roleid	bigint	NOT NULL
	userid	bigint	NOT NULL
	courseid	bigint	NOT NULL
	timestart	bigint	NOT NULL
	timeend	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_enrol_flatfile Indexes
Index Name	Definition
mdl_enroflat_cou_ix	CREATE INDEX mdl_enroflat_cou_ix ON mdl_enrol_flatfile USING btree (courseid)
mdl_enroflat_rol_ix	CREATE INDEX mdl_enroflat_rol_ix ON mdl_enrol_flatfile USING btree (roleid)
mdl_enroflat_use_ix	CREATE INDEX mdl_enroflat_use_ix ON mdl_enrol_flatfile USING btree (userid)

Index - Schema public

Table: mdl_enrol_paypal

Holds all known information about PayPal transactions

mdl_enrol_paypal Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	business	character varying(255)	NOT NULL DEFAULT ''::character varying
	receiver_email	character varying(255)	NOT NULL DEFAULT ''::character varying
	receiver_id	character varying(255)	NOT NULL DEFAULT ''::character varying
	item_name	character varying(255)	NOT NULL DEFAULT ''::character varying
	courseid	bigint	NOT NULL
	userid	bigint	NOT NULL
	instanceid	bigint	NOT NULL
	memo	character varying(255)	NOT NULL DEFAULT ''::character varying
	tax	character varying(255)	NOT NULL DEFAULT ''::character varying
	option_name1	character varying(255)	NOT NULL DEFAULT ''::character varying
	option_selection1_x	character varying(255)	NOT NULL DEFAULT ''::character varying
	option_name2	character varying(255)	NOT NULL DEFAULT ''::character varying
	option_selection2_x	character varying(255)	NOT NULL DEFAULT ''::character varying
	payment_status	character varying(255)	NOT NULL DEFAULT ''::character varying
	pending_reason	character varying(255)	NOT NULL DEFAULT ''::character varying
	reason_code	character varying(30)	NOT NULL DEFAULT ''::character varying
	txn_id	character varying(255)	NOT NULL DEFAULT ''::character varying
	parent_txn_id	character varying(255)	NOT NULL DEFAULT ''::character varying
	payment_type	character varying(30)	NOT NULL DEFAULT ''::character varying
	timeupdated	bigint	NOT NULL

Index - Schema public

Table: mdl_event

For everything with a time associated to it

mdl_event Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	text	NOT NULL
	description	text	NOT NULL
	format	smallint	NOT NULL
	courseid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	userid	bigint	NOT NULL
	repeatid	bigint	NOT NULL
	modulename	character varying(20)	NOT NULL DEFAULT ''::character varying
	instance	bigint	NOT NULL
	eventtype	character varying(20)	NOT NULL DEFAULT ''::character varying
	timestart	bigint	NOT NULL
	timeduration	bigint	NOT NULL
	visible	smallint	NOT NULL DEFAULT 1
	uuid	character varying(255)	NOT NULL DEFAULT ''::character varying
	sequence	bigint	NOT NULL DEFAULT 1
	timemodified	bigint	NOT NULL
	subscriptionid	bigint

mdl_event Indexes
Index Name	Definition
mdl_even_cou_ix	CREATE INDEX mdl_even_cou_ix ON mdl_event USING btree (courseid)
mdl_even_grocouvisuse_ix	CREATE INDEX mdl_even_grocouvisuse_ix ON mdl_event USING btree (groupid, courseid, visible, userid)
mdl_even_tim2_ix	CREATE INDEX mdl_even_tim2_ix ON mdl_event USING btree (timeduration)
mdl_even_tim_ix	CREATE INDEX mdl_even_tim_ix ON mdl_event USING btree (timestart)
mdl_even_use_ix	CREATE INDEX mdl_even_use_ix ON mdl_event USING btree (userid)

Index - Schema public

Table: mdl_event_subscriptions

Tracks subscriptions to remote calendars.

mdl_event_subscriptions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	url	character varying(255)	NOT NULL DEFAULT ''::character varying
	courseid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	userid	bigint	NOT NULL
	eventtype	character varying(20)	NOT NULL DEFAULT ''::character varying
	pollinterval	bigint	NOT NULL
	lastupdated	bigint
	name	character varying(255)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_events_handlers

This table is for storing which components requests what type of event, and the location of the responsible handlers. For example, the assignment registers 'grade_updated' event with a function assignment_grade_handler() that should be called event t

mdl_events_handlers Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	eventname	character varying(166)	NOT NULL DEFAULT ''::character varying
	component	character varying(166)	NOT NULL DEFAULT ''::character varying
	handlerfile	character varying(255)	NOT NULL DEFAULT ''::character varying
	handlerfunction	text
	schedule	character varying(255)
	status	bigint	NOT NULL
	internal	smallint	NOT NULL DEFAULT 1

Index - Schema public

Table: mdl_events_queue

This table is for storing queued events. It stores only one copy of the eventdata here, and entries from this table are being references by the event_queue_handlers table.

mdl_events_queue Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	eventdata	text	NOT NULL
	stackdump	text
	userid	bigint
	timecreated	bigint	NOT NULL

mdl_events_queue Indexes
Index Name	Definition
mdl_evenqueu_use_ix	CREATE INDEX mdl_evenqueu_use_ix ON mdl_events_queue USING btree (userid)

Index - Schema public

Table: mdl_events_queue_handlers

This is the list of queued handlers for processing. The event object is retrieved from the events_queue table. When no further reference is made to the event_queues table, the corresponding entry in the events_queue table should be deleted. Entry sho

mdl_events_queue_handlers Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	queuedeventid	bigint	NOT NULL
	handlerid	bigint	NOT NULL
	status	bigint
	errormessage	text
	timemodified	bigint	NOT NULL

mdl_events_queue_handlers Indexes
Index Name	Definition
mdl_evenqueuhand_han_ix	CREATE INDEX mdl_evenqueuhand_han_ix ON mdl_events_queue_handlers USING btree (handlerid)
mdl_evenqueuhand_que_ix	CREATE INDEX mdl_evenqueuhand_que_ix ON mdl_events_queue_handlers USING btree (queuedeventid)

Index - Schema public

Table: mdl_external_functions

list of all external functions

mdl_external_functions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(200)	NOT NULL DEFAULT ''::character varying
	classname	character varying(100)	NOT NULL DEFAULT ''::character varying
	methodname	character varying(100)	NOT NULL DEFAULT ''::character varying
	classpath	character varying(255)
	component	character varying(100)	NOT NULL DEFAULT ''::character varying
	capabilities	character varying(255)

Index - Schema public

Table: mdl_external_services

built in and custom external services

mdl_external_services Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(200)	NOT NULL DEFAULT ''::character varying
	enabled	smallint	NOT NULL
	requiredcapability	character varying(150)
	restrictedusers	smallint	NOT NULL
	component	character varying(100)
	timecreated	bigint	NOT NULL
	timemodified	bigint
	shortname	character varying(255)
	downloadfiles	smallint	NOT NULL
	uploadfiles	smallint	NOT NULL

Index - Schema public

Table: mdl_external_services_functions

lists functions available in each service group

mdl_external_services_functions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	externalserviceid	bigint	NOT NULL
	functionname	character varying(200)	NOT NULL DEFAULT ''::character varying

mdl_external_services_functions Indexes
Index Name	Definition
mdl_exteservfunc_ext_ix	CREATE INDEX mdl_exteservfunc_ext_ix ON mdl_external_services_functions USING btree (externalserviceid)

Index - Schema public

Table: mdl_external_services_users

users allowed to use services with restricted users flag

mdl_external_services_users Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	externalserviceid	bigint	NOT NULL
	userid	bigint	NOT NULL
	iprestriction	character varying(255)
	validuntil	bigint
	timecreated	bigint

mdl_external_services_users Indexes
Index Name	Definition
mdl_exteservuser_ext_ix	CREATE INDEX mdl_exteservuser_ext_ix ON mdl_external_services_users USING btree (externalserviceid)
mdl_exteservuser_use_ix	CREATE INDEX mdl_exteservuser_use_ix ON mdl_external_services_users USING btree (userid)

Index - Schema public

Table: mdl_external_tokens

Security tokens for accessing of external services

mdl_external_tokens Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	token	character varying(128)	NOT NULL DEFAULT ''::character varying
	tokentype	smallint	NOT NULL
	userid	bigint	NOT NULL
	externalserviceid	bigint	NOT NULL
	sid	character varying(128)
	contextid	bigint	NOT NULL
	creatorid	bigint	NOT NULL DEFAULT 1
	iprestriction	character varying(255)
	validuntil	bigint
	timecreated	bigint	NOT NULL
	lastaccess	bigint

mdl_external_tokens Indexes
Index Name	Definition
mdl_extetoke_con_ix	CREATE INDEX mdl_extetoke_con_ix ON mdl_external_tokens USING btree (contextid)
mdl_extetoke_cre_ix	CREATE INDEX mdl_extetoke_cre_ix ON mdl_external_tokens USING btree (creatorid)
mdl_extetoke_ext_ix	CREATE INDEX mdl_extetoke_ext_ix ON mdl_external_tokens USING btree (externalserviceid)
mdl_extetoke_use_ix	CREATE INDEX mdl_extetoke_use_ix ON mdl_external_tokens USING btree (userid)

Index - Schema public

Table: mdl_feedback

all feedbacks

mdl_feedback Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	anonymous	smallint	NOT NULL DEFAULT 1
	email_notification	smallint	NOT NULL DEFAULT 1
	multiple_submit	smallint	NOT NULL DEFAULT 1
	autonumbering	smallint	NOT NULL DEFAULT 1
	site_after_submit	character varying(255)	NOT NULL DEFAULT ''::character varying
	page_after_submit	text	NOT NULL
	page_after_submitformat	smallint	NOT NULL
	publish_stats	smallint	NOT NULL
	timeopen	bigint	NOT NULL
	timeclose	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	completionsubmit	smallint	NOT NULL

mdl_feedback Indexes
Index Name	Definition
mdl_feed_cou_ix	CREATE INDEX mdl_feed_cou_ix ON mdl_feedback USING btree (course)

Index - Schema public

Table: mdl_feedback_completed

filled out feedback

mdl_feedback_completed Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	feedback	bigint	NOT NULL
	userid	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	random_response	bigint	NOT NULL
	anonymous_response	smallint	NOT NULL

mdl_feedback_completed Indexes
Index Name	Definition
mdl_feedcomp_fee_ix	CREATE INDEX mdl_feedcomp_fee_ix ON mdl_feedback_completed USING btree (feedback)
mdl_feedcomp_use_ix	CREATE INDEX mdl_feedcomp_use_ix ON mdl_feedback_completed USING btree (userid)

Index - Schema public

Table: mdl_feedback_completedtmp

filled out feedback

mdl_feedback_completedtmp Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	feedback	bigint	NOT NULL
	userid	bigint	NOT NULL
	guestid	character varying(255)	NOT NULL DEFAULT ''::character varying
	timemodified	bigint	NOT NULL
	random_response	bigint	NOT NULL
	anonymous_response	smallint	NOT NULL

mdl_feedback_completedtmp Indexes
Index Name	Definition
mdl_feedcomp_fee2_ix	CREATE INDEX mdl_feedcomp_fee2_ix ON mdl_feedback_completedtmp USING btree (feedback)
mdl_feedcomp_use2_ix	CREATE INDEX mdl_feedcomp_use2_ix ON mdl_feedback_completedtmp USING btree (userid)

Index - Schema public

Table: mdl_feedback_item

feedback_items

mdl_feedback_item Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	feedback	bigint	NOT NULL
	template	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	label	character varying(255)	NOT NULL DEFAULT ''::character varying
	presentation	text	NOT NULL
	typ	character varying(255)	NOT NULL DEFAULT ''::character varying
	hasvalue	smallint	NOT NULL
	position	smallint	NOT NULL
	required	smallint	NOT NULL
	dependitem	bigint	NOT NULL
	dependvalue	character varying(255)	NOT NULL DEFAULT ''::character varying
	options	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_feedback_item Indexes
Index Name	Definition
mdl_feeditem_fee_ix	CREATE INDEX mdl_feeditem_fee_ix ON mdl_feedback_item USING btree (feedback)
mdl_feeditem_tem_ix	CREATE INDEX mdl_feeditem_tem_ix ON mdl_feedback_item USING btree (template)

Index - Schema public

Table: mdl_feedback_sitecourse_map

feedback sitecourse map

mdl_feedback_sitecourse_map Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	feedbackid	bigint	NOT NULL
	courseid	bigint	NOT NULL

mdl_feedback_sitecourse_map Indexes
Index Name	Definition
mdl_feedsitemap_cou_ix	CREATE INDEX mdl_feedsitemap_cou_ix ON mdl_feedback_sitecourse_map USING btree (courseid)
mdl_feedsitemap_fee_ix	CREATE INDEX mdl_feedsitemap_fee_ix ON mdl_feedback_sitecourse_map USING btree (feedbackid)

Index - Schema public

Table: mdl_feedback_template

templates of feedbackstructures

mdl_feedback_template Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	ispublic	smallint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_feedback_template Indexes
Index Name	Definition
mdl_feedtemp_cou_ix	CREATE INDEX mdl_feedtemp_cou_ix ON mdl_feedback_template USING btree (course)

Index - Schema public

Table: mdl_feedback_tracking

feedback trackingdata

mdl_feedback_tracking Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	feedback	bigint	NOT NULL
	completed	bigint	NOT NULL
	tmp_completed	bigint	NOT NULL

mdl_feedback_tracking Indexes
Index Name	Definition
mdl_feedtrac_com_ix	CREATE INDEX mdl_feedtrac_com_ix ON mdl_feedback_tracking USING btree (completed)
mdl_feedtrac_fee_ix	CREATE INDEX mdl_feedtrac_fee_ix ON mdl_feedback_tracking USING btree (feedback)
mdl_feedtrac_use_ix	CREATE INDEX mdl_feedtrac_use_ix ON mdl_feedback_tracking USING btree (userid)

Index - Schema public

Table: mdl_feedback_value

values of the completeds

mdl_feedback_value Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course_id	bigint	NOT NULL
	item	bigint	NOT NULL
	completed	bigint	NOT NULL
	tmp_completed	bigint	NOT NULL
	value	text	NOT NULL

mdl_feedback_value Indexes
Index Name	Definition
mdl_feedvalu_cou_ix	CREATE INDEX mdl_feedvalu_cou_ix ON mdl_feedback_value USING btree (course_id)
mdl_feedvalu_ite_ix	CREATE INDEX mdl_feedvalu_ite_ix ON mdl_feedback_value USING btree (item)

Index - Schema public

Table: mdl_feedback_valuetmp

values of the completedstmp

mdl_feedback_valuetmp Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course_id	bigint	NOT NULL
	item	bigint	NOT NULL
	completed	bigint	NOT NULL
	tmp_completed	bigint	NOT NULL
	value	text	NOT NULL

mdl_feedback_valuetmp Indexes
Index Name	Definition
mdl_feedvalu_cou2_ix	CREATE INDEX mdl_feedvalu_cou2_ix ON mdl_feedback_valuetmp USING btree (course_id)
mdl_feedvalu_ite2_ix	CREATE INDEX mdl_feedvalu_ite2_ix ON mdl_feedback_valuetmp USING btree (item)

Index - Schema public

Table: mdl_files

description of files, content is stored in sha1 file pool

mdl_files Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contenthash	character varying(40)	NOT NULL DEFAULT ''::character varying
	pathnamehash	character varying(40)	NOT NULL DEFAULT ''::character varying
	contextid	bigint	NOT NULL
	component	character varying(100)	NOT NULL DEFAULT ''::character varying
	filearea	character varying(50)	NOT NULL DEFAULT ''::character varying
	itemid	bigint	NOT NULL
	filepath	character varying(255)	NOT NULL DEFAULT ''::character varying
	filename	character varying(255)	NOT NULL DEFAULT ''::character varying
	userid	bigint
	filesize	bigint	NOT NULL
	mimetype	character varying(100)
	status	bigint	NOT NULL
	source	text
	author	character varying(255)
	license	character varying(255)
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	sortorder	bigint	NOT NULL
	referencefileid	bigint

mdl_files Indexes
Index Name	Definition
mdl_file_comfilconite_ix	CREATE INDEX mdl_file_comfilconite_ix ON mdl_files USING btree (component, filearea, contextid, itemid)
mdl_file_con2_ix	CREATE INDEX mdl_file_con2_ix ON mdl_files USING btree (contextid)
mdl_file_con_ix	CREATE INDEX mdl_file_con_ix ON mdl_files USING btree (contenthash)
mdl_file_ref_ix	CREATE INDEX mdl_file_ref_ix ON mdl_files USING btree (referencefileid)
mdl_file_use_ix	CREATE INDEX mdl_file_use_ix ON mdl_files USING btree (userid)

Index - Schema public

Table: mdl_files_reference

Store files references

mdl_files_reference Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	repositoryid	bigint	NOT NULL
	lastsync	bigint
	reference	text
	referencehash	character varying(40)	NOT NULL DEFAULT ''::character varying

mdl_files_reference Indexes
Index Name	Definition
mdl_filerefe_rep_ix	CREATE INDEX mdl_filerefe_rep_ix ON mdl_files_reference USING btree (repositoryid)

Index - Schema public

Table: mdl_filter_active

Stores information about which filters are active in which contexts. Also the filter sort order. See get_active_filters in lib/filterlib.php for how this data is used.

mdl_filter_active Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	filter	character varying(32)	NOT NULL DEFAULT ''::character varying
	contextid	bigint	NOT NULL
	active	smallint	NOT NULL
	sortorder	bigint	NOT NULL

mdl_filter_active Indexes
Index Name	Definition
mdl_filtacti_con_ix	CREATE INDEX mdl_filtacti_con_ix ON mdl_filter_active USING btree (contextid)

Index - Schema public

Table: mdl_filter_config

Stores per-context configuration settings for filters which have them.

mdl_filter_config Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	filter	character varying(32)	NOT NULL DEFAULT ''::character varying
	contextid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	text

mdl_filter_config Indexes
Index Name	Definition
mdl_filtconf_con_ix	CREATE INDEX mdl_filtconf_con_ix ON mdl_filter_config USING btree (contextid)

Index - Schema public

Table: mdl_folder

each record is one folder resource

mdl_folder Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint	NOT NULL
	revision	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	display	smallint	NOT NULL
	showexpanded	smallint	NOT NULL DEFAULT 1

mdl_folder Indexes
Index Name	Definition
mdl_fold_cou_ix	CREATE INDEX mdl_fold_cou_ix ON mdl_folder USING btree (course)

Index - Schema public

Table: mdl_forum

Forums contain and structure discussion

mdl_forum Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	type	character varying(20)	NOT NULL DEFAULT 'general'::character varying
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	assessed	bigint	NOT NULL
	assesstimestart	bigint	NOT NULL
	assesstimefinish	bigint	NOT NULL
	scale	bigint	NOT NULL
	maxbytes	bigint	NOT NULL
	maxattachments	bigint	NOT NULL DEFAULT 1
	forcesubscribe	smallint	NOT NULL
	trackingtype	smallint	NOT NULL DEFAULT 1
	rsstype	smallint	NOT NULL
	rssarticles	smallint	NOT NULL
	timemodified	bigint	NOT NULL
	warnafter	bigint	NOT NULL
	blockafter	bigint	NOT NULL
	blockperiod	bigint	NOT NULL
	completiondiscussions	integer	NOT NULL
	completionreplies	integer	NOT NULL
	completionposts	integer	NOT NULL
	displaywordcount	smallint	NOT NULL

mdl_forum Indexes
Index Name	Definition
mdl_foru_cou_ix	CREATE INDEX mdl_foru_cou_ix ON mdl_forum USING btree (course)

Index - Schema public

Table: mdl_forum_digests

mdl_forum_digests Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	forum	bigint	NOT NULL
	maildigest	smallint	NOT NULL DEFAULT (-1)

mdl_forum_digests Indexes
Index Name	Definition
mdl_forudige_for_ix	CREATE INDEX mdl_forudige_for_ix ON mdl_forum_digests USING btree (forum)
mdl_forudige_use_ix	CREATE INDEX mdl_forudige_use_ix ON mdl_forum_digests USING btree (userid)

Index - Schema public

Table: mdl_forum_discussions

Forums are composed of discussions

mdl_forum_discussions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	forum	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	firstpost	bigint	NOT NULL
	userid	bigint	NOT NULL
	groupid	bigint	NOT NULL DEFAULT (-1)
	assessed	smallint	NOT NULL DEFAULT 1
	timemodified	bigint	NOT NULL
	usermodified	bigint	NOT NULL
	timestart	bigint	NOT NULL
	timeend	bigint	NOT NULL

mdl_forum_discussions Indexes
Index Name	Definition
mdl_forudisc_for_ix	CREATE INDEX mdl_forudisc_for_ix ON mdl_forum_discussions USING btree (forum)
mdl_forudisc_use_ix	CREATE INDEX mdl_forudisc_use_ix ON mdl_forum_discussions USING btree (userid)

Index - Schema public

Table: mdl_forum_posts

All posts are stored in this table

mdl_forum_posts Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	discussion	bigint	NOT NULL
	parent	bigint	NOT NULL
	userid	bigint	NOT NULL
	created	bigint	NOT NULL
	modified	bigint	NOT NULL
	mailed	smallint	NOT NULL
	subject	character varying(255)	NOT NULL DEFAULT ''::character varying
	message	text	NOT NULL
	messageformat	smallint	NOT NULL
	messagetrust	smallint	NOT NULL
	attachment	character varying(100)	NOT NULL DEFAULT ''::character varying
	totalscore	smallint	NOT NULL
	mailnow	bigint	NOT NULL

mdl_forum_posts Indexes
Index Name	Definition
mdl_forupost_cre_ix	CREATE INDEX mdl_forupost_cre_ix ON mdl_forum_posts USING btree (created)
mdl_forupost_dis_ix	CREATE INDEX mdl_forupost_dis_ix ON mdl_forum_posts USING btree (discussion)
mdl_forupost_mai_ix	CREATE INDEX mdl_forupost_mai_ix ON mdl_forum_posts USING btree (mailed)
mdl_forupost_par_ix	CREATE INDEX mdl_forupost_par_ix ON mdl_forum_posts USING btree (parent)
mdl_forupost_use_ix	CREATE INDEX mdl_forupost_use_ix ON mdl_forum_posts USING btree (userid)

Index - Schema public

Table: mdl_forum_queue

For keeping track of posts that will be mailed in digest form

mdl_forum_queue Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	discussionid	bigint	NOT NULL
	postid	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_forum_queue Indexes
Index Name	Definition
mdl_foruqueu_dis_ix	CREATE INDEX mdl_foruqueu_dis_ix ON mdl_forum_queue USING btree (discussionid)
mdl_foruqueu_pos_ix	CREATE INDEX mdl_foruqueu_pos_ix ON mdl_forum_queue USING btree (postid)
mdl_foruqueu_use_ix	CREATE INDEX mdl_foruqueu_use_ix ON mdl_forum_queue USING btree (userid)

Index - Schema public

Table: mdl_forum_read

Tracks each users read posts

mdl_forum_read Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	forumid	bigint	NOT NULL
	discussionid	bigint	NOT NULL
	postid	bigint	NOT NULL
	firstread	bigint	NOT NULL
	lastread	bigint	NOT NULL

mdl_forum_read Indexes
Index Name	Definition
mdl_foruread_usedis_ix	CREATE INDEX mdl_foruread_usedis_ix ON mdl_forum_read USING btree (userid, discussionid)
mdl_foruread_usefor_ix	CREATE INDEX mdl_foruread_usefor_ix ON mdl_forum_read USING btree (userid, forumid)
mdl_foruread_usepos_ix	CREATE INDEX mdl_foruread_usepos_ix ON mdl_forum_read USING btree (userid, postid)

Index - Schema public

Table: mdl_forum_subscriptions

Keeps track of who is subscribed to what forum

mdl_forum_subscriptions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	forum	bigint	NOT NULL

mdl_forum_subscriptions Indexes
Index Name	Definition
mdl_forusubs_for_ix	CREATE INDEX mdl_forusubs_for_ix ON mdl_forum_subscriptions USING btree (forum)
mdl_forusubs_use_ix	CREATE INDEX mdl_forusubs_use_ix ON mdl_forum_subscriptions USING btree (userid)

Index - Schema public

Table: mdl_forum_track_prefs

Tracks each users untracked forums

mdl_forum_track_prefs Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	forumid	bigint	NOT NULL

mdl_forum_track_prefs Indexes
Index Name	Definition
mdl_forutracpref_usefor_ix	CREATE INDEX mdl_forutracpref_usefor_ix ON mdl_forum_track_prefs USING btree (userid, forumid)

Index - Schema public

Table: mdl_glossary

all glossaries

mdl_glossary Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	allowduplicatedentries	smallint	NOT NULL
	displayformat	character varying(50)	NOT NULL DEFAULT 'dictionary'::character varying
	mainglossary	smallint	NOT NULL
	showspecial	smallint	NOT NULL DEFAULT 1
	showalphabet	smallint	NOT NULL DEFAULT 1
	showall	smallint	NOT NULL DEFAULT 1
	allowcomments	smallint	NOT NULL
	allowprintview	smallint	NOT NULL DEFAULT 1
	usedynalink	smallint	NOT NULL DEFAULT 1
	defaultapproval	smallint	NOT NULL DEFAULT 1
	approvaldisplayformat	character varying(50)	NOT NULL DEFAULT 'default'::character varying
	globalglossary	smallint	NOT NULL
	entbypage	smallint	NOT NULL DEFAULT 10
	editalways	smallint	NOT NULL
	rsstype	smallint	NOT NULL
	rssarticles	smallint	NOT NULL
	assessed	bigint	NOT NULL
	assesstimestart	bigint	NOT NULL
	assesstimefinish	bigint	NOT NULL
	scale	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	completionentries	integer	NOT NULL

mdl_glossary Indexes
Index Name	Definition
mdl_glos_cou_ix	CREATE INDEX mdl_glos_cou_ix ON mdl_glossary USING btree (course)

Index - Schema public

Table: mdl_glossary_alias

entries alias

mdl_glossary_alias Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	entryid	bigint	NOT NULL
	alias	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_glossary_alias Indexes
Index Name	Definition
mdl_glosalia_ent_ix	CREATE INDEX mdl_glosalia_ent_ix ON mdl_glossary_alias USING btree (entryid)

Index - Schema public

Table: mdl_glossary_categories

all categories for glossary entries

mdl_glossary_categories Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	glossaryid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	usedynalink	smallint	NOT NULL DEFAULT 1

mdl_glossary_categories Indexes
Index Name	Definition
mdl_gloscate_glo_ix	CREATE INDEX mdl_gloscate_glo_ix ON mdl_glossary_categories USING btree (glossaryid)

Index - Schema public

Table: mdl_glossary_entries

all glossary entries

mdl_glossary_entries Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	glossaryid	bigint	NOT NULL
	userid	bigint	NOT NULL
	concept	character varying(255)	NOT NULL DEFAULT ''::character varying
	definition	text	NOT NULL
	definitionformat	smallint	NOT NULL
	definitiontrust	smallint	NOT NULL
	attachment	character varying(100)	NOT NULL DEFAULT ''::character varying
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	teacherentry	smallint	NOT NULL
	sourceglossaryid	bigint	NOT NULL
	usedynalink	smallint	NOT NULL DEFAULT 1
	casesensitive	smallint	NOT NULL
	fullmatch	smallint	NOT NULL DEFAULT 1
	approved	smallint	NOT NULL DEFAULT 1

mdl_glossary_entries Indexes
Index Name	Definition
mdl_glosentr_con_ix	CREATE INDEX mdl_glosentr_con_ix ON mdl_glossary_entries USING btree (concept)
mdl_glosentr_glo_ix	CREATE INDEX mdl_glosentr_glo_ix ON mdl_glossary_entries USING btree (glossaryid)
mdl_glosentr_use_ix	CREATE INDEX mdl_glosentr_use_ix ON mdl_glossary_entries USING btree (userid)

Index - Schema public

Table: mdl_glossary_entries_categories

categories of each glossary entry

mdl_glossary_entries_categories Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	categoryid	bigint	NOT NULL
	entryid	bigint	NOT NULL

mdl_glossary_entries_categories Indexes
Index Name	Definition
mdl_glosentrcate_cat_ix	CREATE INDEX mdl_glosentrcate_cat_ix ON mdl_glossary_entries_categories USING btree (categoryid)
mdl_glosentrcate_ent_ix	CREATE INDEX mdl_glosentrcate_ent_ix ON mdl_glossary_entries_categories USING btree (entryid)

Index - Schema public

Table: mdl_glossary_formats

Setting of the display formats

mdl_glossary_formats Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(50)	NOT NULL DEFAULT ''::character varying
	popupformatname	character varying(50)	NOT NULL DEFAULT ''::character varying
	visible	smallint	NOT NULL DEFAULT 1
	showgroup	smallint	NOT NULL DEFAULT 1
	defaultmode	character varying(50)	NOT NULL DEFAULT ''::character varying
	defaulthook	character varying(50)	NOT NULL DEFAULT ''::character varying
	sortkey	character varying(50)	NOT NULL DEFAULT ''::character varying
	sortorder	character varying(50)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_grade_categories

This table keeps information about categories, used for grouping items.

mdl_grade_categories Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	parent	bigint
	depth	bigint	NOT NULL
	path	character varying(255)
	fullname	character varying(255)	NOT NULL DEFAULT ''::character varying
	aggregation	bigint	NOT NULL
	keephigh	bigint	NOT NULL
	droplow	bigint	NOT NULL
	aggregateonlygraded	smallint	NOT NULL
	aggregateoutcomes	smallint	NOT NULL
	aggregatesubcats	smallint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	hidden	smallint	NOT NULL

mdl_grade_categories Indexes
Index Name	Definition
mdl_gradcate_cou_ix	CREATE INDEX mdl_gradcate_cou_ix ON mdl_grade_categories USING btree (courseid)
mdl_gradcate_par_ix	CREATE INDEX mdl_gradcate_par_ix ON mdl_grade_categories USING btree (parent)

Index - Schema public

Table: mdl_grade_categories_history

History of grade_categories

mdl_grade_categories_history Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	action	bigint	NOT NULL
	oldid	bigint	NOT NULL
	source	character varying(255)
	timemodified	bigint
	loggeduser	bigint
	courseid	bigint	NOT NULL
	parent	bigint
	depth	bigint	NOT NULL
	path	character varying(255)
	fullname	character varying(255)	NOT NULL DEFAULT ''::character varying
	aggregation	bigint	NOT NULL
	keephigh	bigint	NOT NULL
	droplow	bigint	NOT NULL
	aggregateonlygraded	smallint	NOT NULL
	aggregateoutcomes	smallint	NOT NULL
	aggregatesubcats	smallint	NOT NULL
	hidden	smallint	NOT NULL

mdl_grade_categories_history Indexes
Index Name	Definition
mdl_gradcatehist_act_ix	CREATE INDEX mdl_gradcatehist_act_ix ON mdl_grade_categories_history USING btree (action)
mdl_gradcatehist_cou_ix	CREATE INDEX mdl_gradcatehist_cou_ix ON mdl_grade_categories_history USING btree (courseid)
mdl_gradcatehist_log_ix	CREATE INDEX mdl_gradcatehist_log_ix ON mdl_grade_categories_history USING btree (loggeduser)
mdl_gradcatehist_old_ix	CREATE INDEX mdl_gradcatehist_old_ix ON mdl_grade_categories_history USING btree (oldid)
mdl_gradcatehist_par_ix	CREATE INDEX mdl_gradcatehist_par_ix ON mdl_grade_categories_history USING btree (parent)

Index - Schema public

Table: mdl_grade_grades

grade_grades This table keeps individual grades for each user and each item, exactly as imported or submitted by modules. The rawgrademax/min and rawscaleid are stored here to record the values at the time the grade was stored, because teachers migh

mdl_grade_grades Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	itemid	bigint	NOT NULL
	userid	bigint	NOT NULL
	rawgrade	numeric(10,5)
	rawgrademax	numeric(10,5)	NOT NULL DEFAULT 100
	rawgrademin	numeric(10,5)	NOT NULL
	rawscaleid	bigint
	usermodified	bigint
	finalgrade	numeric(10,5)
	hidden	bigint	NOT NULL
	locked	bigint	NOT NULL
	locktime	bigint	NOT NULL
	exported	bigint	NOT NULL
	overridden	bigint	NOT NULL
	excluded	bigint	NOT NULL
	feedback	text
	feedbackformat	bigint	NOT NULL
	information	text
	informationformat	bigint	NOT NULL
	timecreated	bigint
	timemodified	bigint

mdl_grade_grades Indexes
Index Name	Definition
mdl_gradgrad_ite_ix	CREATE INDEX mdl_gradgrad_ite_ix ON mdl_grade_grades USING btree (itemid)
mdl_gradgrad_locloc_ix	CREATE INDEX mdl_gradgrad_locloc_ix ON mdl_grade_grades USING btree (locked, locktime)
mdl_gradgrad_raw_ix	CREATE INDEX mdl_gradgrad_raw_ix ON mdl_grade_grades USING btree (rawscaleid)
mdl_gradgrad_use2_ix	CREATE INDEX mdl_gradgrad_use2_ix ON mdl_grade_grades USING btree (usermodified)
mdl_gradgrad_use_ix	CREATE INDEX mdl_gradgrad_use_ix ON mdl_grade_grades USING btree (userid)

Index - Schema public

Table: mdl_grade_grades_history

History table

mdl_grade_grades_history Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	action	bigint	NOT NULL
	oldid	bigint	NOT NULL
	source	character varying(255)
	timemodified	bigint
	loggeduser	bigint
	itemid	bigint	NOT NULL
	userid	bigint	NOT NULL
	rawgrade	numeric(10,5)
	rawgrademax	numeric(10,5)	NOT NULL DEFAULT 100
	rawgrademin	numeric(10,5)	NOT NULL
	rawscaleid	bigint
	usermodified	bigint
	finalgrade	numeric(10,5)
	hidden	bigint	NOT NULL
	locked	bigint	NOT NULL
	locktime	bigint	NOT NULL
	exported	bigint	NOT NULL
	overridden	bigint	NOT NULL
	excluded	bigint	NOT NULL
	feedback	text
	feedbackformat	bigint	NOT NULL
	information	text
	informationformat	bigint	NOT NULL

mdl_grade_grades_history Indexes
Index Name	Definition
mdl_gradgradhist_act_ix	CREATE INDEX mdl_gradgradhist_act_ix ON mdl_grade_grades_history USING btree (action)
mdl_gradgradhist_ite_ix	CREATE INDEX mdl_gradgradhist_ite_ix ON mdl_grade_grades_history USING btree (itemid)
mdl_gradgradhist_log_ix	CREATE INDEX mdl_gradgradhist_log_ix ON mdl_grade_grades_history USING btree (loggeduser)
mdl_gradgradhist_old_ix	CREATE INDEX mdl_gradgradhist_old_ix ON mdl_grade_grades_history USING btree (oldid)
mdl_gradgradhist_raw_ix	CREATE INDEX mdl_gradgradhist_raw_ix ON mdl_grade_grades_history USING btree (rawscaleid)
mdl_gradgradhist_tim_ix	CREATE INDEX mdl_gradgradhist_tim_ix ON mdl_grade_grades_history USING btree (timemodified)
mdl_gradgradhist_use2_ix	CREATE INDEX mdl_gradgradhist_use2_ix ON mdl_grade_grades_history USING btree (usermodified)
mdl_gradgradhist_use_ix	CREATE INDEX mdl_gradgradhist_use_ix ON mdl_grade_grades_history USING btree (userid)

Index - Schema public

Table: mdl_grade_import_newitem

temporary table for storing new grade_item names from grade import

mdl_grade_import_newitem Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	itemname	character varying(255)	NOT NULL DEFAULT ''::character varying
	importcode	bigint	NOT NULL
	importer	bigint	NOT NULL

mdl_grade_import_newitem Indexes
Index Name	Definition
mdl_gradimponewi_imp_ix	CREATE INDEX mdl_gradimponewi_imp_ix ON mdl_grade_import_newitem USING btree (importer)

Index - Schema public

Table: mdl_grade_import_values

Temporary table for importing grades

mdl_grade_import_values Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	itemid	bigint
	newgradeitem	bigint
	userid	bigint	NOT NULL
	finalgrade	numeric(10,5)
	feedback	text
	importcode	bigint	NOT NULL
	importer	bigint

mdl_grade_import_values Indexes
Index Name	Definition
mdl_gradimpovalu_imp_ix	CREATE INDEX mdl_gradimpovalu_imp_ix ON mdl_grade_import_values USING btree (importer)
mdl_gradimpovalu_ite_ix	CREATE INDEX mdl_gradimpovalu_ite_ix ON mdl_grade_import_values USING btree (itemid)
mdl_gradimpovalu_new_ix	CREATE INDEX mdl_gradimpovalu_new_ix ON mdl_grade_import_values USING btree (newgradeitem)

Index - Schema public

Table: mdl_grade_items

This table keeps information about gradeable items (ie columns). If an activity (eg an assignment or quiz) has multiple grade_items associated with it (eg several outcomes or numerical grades), then there will be a corresponding multiple number of ro

mdl_grade_items Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint
	categoryid	bigint
	itemname	character varying(255)
	itemtype	character varying(30)	NOT NULL DEFAULT ''::character varying
	itemmodule	character varying(30)
	iteminstance	bigint
	itemnumber	bigint
	iteminfo	text
	idnumber	character varying(255)
	calculation	text
	gradetype	smallint	NOT NULL DEFAULT 1
	grademax	numeric(10,5)	NOT NULL DEFAULT 100
	grademin	numeric(10,5)	NOT NULL
	scaleid	bigint
	outcomeid	bigint
	gradepass	numeric(10,5)	NOT NULL
	multfactor	numeric(10,5)	NOT NULL DEFAULT 1.0
	plusfactor	numeric(10,5)	NOT NULL
	aggregationcoef	numeric(10,5)	NOT NULL
	sortorder	bigint	NOT NULL
	display	bigint	NOT NULL
	decimals	smallint
	hidden	bigint	NOT NULL
	locked	bigint	NOT NULL
	locktime	bigint	NOT NULL
	needsupdate	bigint	NOT NULL
	timecreated	bigint
	timemodified	bigint

mdl_grade_items Indexes
Index Name	Definition
mdl_graditem_cat_ix	CREATE INDEX mdl_graditem_cat_ix ON mdl_grade_items USING btree (categoryid)
mdl_graditem_cou_ix	CREATE INDEX mdl_graditem_cou_ix ON mdl_grade_items USING btree (courseid)
mdl_graditem_gra_ix	CREATE INDEX mdl_graditem_gra_ix ON mdl_grade_items USING btree (gradetype)
mdl_graditem_idncou_ix	CREATE INDEX mdl_graditem_idncou_ix ON mdl_grade_items USING btree (idnumber, courseid)
mdl_graditem_itenee_ix	CREATE INDEX mdl_graditem_itenee_ix ON mdl_grade_items USING btree (itemtype, needsupdate)
mdl_graditem_locloc_ix	CREATE INDEX mdl_graditem_locloc_ix ON mdl_grade_items USING btree (locked, locktime)
mdl_graditem_out_ix	CREATE INDEX mdl_graditem_out_ix ON mdl_grade_items USING btree (outcomeid)
mdl_graditem_sca_ix	CREATE INDEX mdl_graditem_sca_ix ON mdl_grade_items USING btree (scaleid)

Index - Schema public

Table: mdl_grade_items_history

History of grade_items

mdl_grade_items_history Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	action	bigint	NOT NULL
	oldid	bigint	NOT NULL
	source	character varying(255)
	timemodified	bigint
	loggeduser	bigint
	courseid	bigint
	categoryid	bigint
	itemname	character varying(255)
	itemtype	character varying(30)	NOT NULL DEFAULT ''::character varying
	itemmodule	character varying(30)
	iteminstance	bigint
	itemnumber	bigint
	iteminfo	text
	idnumber	character varying(255)
	calculation	text
	gradetype	smallint	NOT NULL DEFAULT 1
	grademax	numeric(10,5)	NOT NULL DEFAULT 100
	grademin	numeric(10,5)	NOT NULL
	scaleid	bigint
	outcomeid	bigint
	gradepass	numeric(10,5)	NOT NULL
	multfactor	numeric(10,5)	NOT NULL DEFAULT 1.0
	plusfactor	numeric(10,5)	NOT NULL
	aggregationcoef	numeric(10,5)	NOT NULL
	sortorder	bigint	NOT NULL
	hidden	bigint	NOT NULL
	locked	bigint	NOT NULL
	locktime	bigint	NOT NULL
	needsupdate	bigint	NOT NULL
	display	bigint	NOT NULL
	decimals	smallint

mdl_grade_items_history Indexes
Index Name	Definition
mdl_graditemhist_act_ix	CREATE INDEX mdl_graditemhist_act_ix ON mdl_grade_items_history USING btree (action)
mdl_graditemhist_cat_ix	CREATE INDEX mdl_graditemhist_cat_ix ON mdl_grade_items_history USING btree (categoryid)
mdl_graditemhist_cou_ix	CREATE INDEX mdl_graditemhist_cou_ix ON mdl_grade_items_history USING btree (courseid)
mdl_graditemhist_log_ix	CREATE INDEX mdl_graditemhist_log_ix ON mdl_grade_items_history USING btree (loggeduser)
mdl_graditemhist_old_ix	CREATE INDEX mdl_graditemhist_old_ix ON mdl_grade_items_history USING btree (oldid)
mdl_graditemhist_out_ix	CREATE INDEX mdl_graditemhist_out_ix ON mdl_grade_items_history USING btree (outcomeid)
mdl_graditemhist_sca_ix	CREATE INDEX mdl_graditemhist_sca_ix ON mdl_grade_items_history USING btree (scaleid)

Index - Schema public

Table: mdl_grade_letters

Repository for grade letters, for courses and other moodle entities that use grades.

mdl_grade_letters Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextid	bigint	NOT NULL
	lowerboundary	numeric(10,5)	NOT NULL
	letter	character varying(255)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_grade_outcomes

This table describes the outcomes used in the system. An outcome is a statement tied to a rubric scale from low to high, such as âNot met, Borderline, Metâ (stored as 0,1 or 2)

mdl_grade_outcomes Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint
	shortname	character varying(255)	NOT NULL DEFAULT ''::character varying
	fullname	text	NOT NULL
	scaleid	bigint
	description	text
	descriptionformat	smallint	NOT NULL
	timecreated	bigint
	timemodified	bigint
	usermodified	bigint

mdl_grade_outcomes Indexes
Index Name	Definition
mdl_gradoutc_cou_ix	CREATE INDEX mdl_gradoutc_cou_ix ON mdl_grade_outcomes USING btree (courseid)
mdl_gradoutc_sca_ix	CREATE INDEX mdl_gradoutc_sca_ix ON mdl_grade_outcomes USING btree (scaleid)
mdl_gradoutc_use_ix	CREATE INDEX mdl_gradoutc_use_ix ON mdl_grade_outcomes USING btree (usermodified)

Index - Schema public

Table: mdl_grade_outcomes_courses

stores what outcomes are used in what courses.

mdl_grade_outcomes_courses Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	outcomeid	bigint	NOT NULL

mdl_grade_outcomes_courses Indexes
Index Name	Definition
mdl_gradoutccour_cou_ix	CREATE INDEX mdl_gradoutccour_cou_ix ON mdl_grade_outcomes_courses USING btree (courseid)
mdl_gradoutccour_out_ix	CREATE INDEX mdl_gradoutccour_out_ix ON mdl_grade_outcomes_courses USING btree (outcomeid)

Index - Schema public

Table: mdl_grade_outcomes_history

History table

mdl_grade_outcomes_history Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	action	bigint	NOT NULL
	oldid	bigint	NOT NULL
	source	character varying(255)
	timemodified	bigint
	loggeduser	bigint
	courseid	bigint
	shortname	character varying(255)	NOT NULL DEFAULT ''::character varying
	fullname	text	NOT NULL
	scaleid	bigint
	description	text
	descriptionformat	smallint	NOT NULL

mdl_grade_outcomes_history Indexes
Index Name	Definition
mdl_gradoutchist_act_ix	CREATE INDEX mdl_gradoutchist_act_ix ON mdl_grade_outcomes_history USING btree (action)
mdl_gradoutchist_cou_ix	CREATE INDEX mdl_gradoutchist_cou_ix ON mdl_grade_outcomes_history USING btree (courseid)
mdl_gradoutchist_log_ix	CREATE INDEX mdl_gradoutchist_log_ix ON mdl_grade_outcomes_history USING btree (loggeduser)
mdl_gradoutchist_old_ix	CREATE INDEX mdl_gradoutchist_old_ix ON mdl_grade_outcomes_history USING btree (oldid)
mdl_gradoutchist_sca_ix	CREATE INDEX mdl_gradoutchist_sca_ix ON mdl_grade_outcomes_history USING btree (scaleid)

Index - Schema public

Table: mdl_grade_settings

gradebook settings

mdl_grade_settings Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	text

mdl_grade_settings Indexes
Index Name	Definition
mdl_gradsett_cou_ix	CREATE INDEX mdl_gradsett_cou_ix ON mdl_grade_settings USING btree (courseid)

Index - Schema public

Table: mdl_grading_areas

Identifies gradable areas where advanced grading can happen. For each area, the current active plugin can be set.

mdl_grading_areas Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextid	bigint	NOT NULL
	component	character varying(100)	NOT NULL DEFAULT ''::character varying
	areaname	character varying(100)	NOT NULL DEFAULT ''::character varying
	activemethod	character varying(100)

mdl_grading_areas Indexes
Index Name	Definition
mdl_gradarea_con_ix	CREATE INDEX mdl_gradarea_con_ix ON mdl_grading_areas USING btree (contextid)

Index - Schema public

Table: mdl_grading_definitions

Contains the basic information about an advanced grading form defined in the given gradable area

mdl_grading_definitions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	areaid	bigint	NOT NULL
	method	character varying(100)	NOT NULL DEFAULT ''::character varying
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	description	text
	descriptionformat	smallint
	status	bigint	NOT NULL
	copiedfromid	bigint
	timecreated	bigint	NOT NULL
	usercreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	usermodified	bigint	NOT NULL
	timecopied	bigint
	options	text

mdl_grading_definitions Indexes
Index Name	Definition
mdl_graddefi_are_ix	CREATE INDEX mdl_graddefi_are_ix ON mdl_grading_definitions USING btree (areaid)
mdl_graddefi_use2_ix	CREATE INDEX mdl_graddefi_use2_ix ON mdl_grading_definitions USING btree (usercreated)
mdl_graddefi_use_ix	CREATE INDEX mdl_graddefi_use_ix ON mdl_grading_definitions USING btree (usermodified)

Index - Schema public

Table: mdl_grading_instances

Grading form instance is an assessment record for one gradable item assessed by one rater

mdl_grading_instances Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	definitionid	bigint	NOT NULL
	raterid	bigint	NOT NULL
	itemid	bigint
	rawgrade	numeric(10,5)
	status	bigint	NOT NULL
	feedback	text
	feedbackformat	smallint
	timemodified	bigint	NOT NULL

mdl_grading_instances Indexes
Index Name	Definition
mdl_gradinst_def_ix	CREATE INDEX mdl_gradinst_def_ix ON mdl_grading_instances USING btree (definitionid)
mdl_gradinst_rat_ix	CREATE INDEX mdl_gradinst_rat_ix ON mdl_grading_instances USING btree (raterid)

Index - Schema public

Table: mdl_gradingform_guide_comments

frequently used comments used in marking guide

mdl_gradingform_guide_comments Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	definitionid	bigint	NOT NULL
	sortorder	bigint	NOT NULL
	description	text
	descriptionformat	smallint

mdl_gradingform_guide_comments Indexes
Index Name	Definition
mdl_gradguidcomm_def_ix	CREATE INDEX mdl_gradguidcomm_def_ix ON mdl_gradingform_guide_comments USING btree (definitionid)

Index - Schema public

Table: mdl_gradingform_guide_criteria

Stores the rows of the criteria grid.

mdl_gradingform_guide_criteria Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	definitionid	bigint	NOT NULL
	sortorder	bigint	NOT NULL
	shortname	character varying(255)	NOT NULL DEFAULT ''::character varying
	description	text
	descriptionformat	smallint
	descriptionmarkers	text
	descriptionmarkersformat	smallint
	maxscore	numeric(10,5)	NOT NULL

mdl_gradingform_guide_criteria Indexes
Index Name	Definition
mdl_gradguidcrit_def_ix	CREATE INDEX mdl_gradguidcrit_def_ix ON mdl_gradingform_guide_criteria USING btree (definitionid)

Index - Schema public

Table: mdl_gradingform_guide_fillings

Stores the data of how the guide is filled by a particular rater

mdl_gradingform_guide_fillings Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	instanceid	bigint	NOT NULL
	criterionid	bigint	NOT NULL
	remark	text
	remarkformat	smallint
	score	numeric(10,5)	NOT NULL

mdl_gradingform_guide_fillings Indexes
Index Name	Definition
mdl_gradguidfill_cri_ix	CREATE INDEX mdl_gradguidfill_cri_ix ON mdl_gradingform_guide_fillings USING btree (criterionid)
mdl_gradguidfill_ins_ix	CREATE INDEX mdl_gradguidfill_ins_ix ON mdl_gradingform_guide_fillings USING btree (instanceid)

Index - Schema public

Table: mdl_gradingform_rubric_criteria

Stores the rows of the rubric grid.

mdl_gradingform_rubric_criteria Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	definitionid	bigint	NOT NULL
	sortorder	bigint	NOT NULL
	description	text
	descriptionformat	smallint

mdl_gradingform_rubric_criteria Indexes
Index Name	Definition
mdl_gradrubrcrit_def_ix	CREATE INDEX mdl_gradrubrcrit_def_ix ON mdl_gradingform_rubric_criteria USING btree (definitionid)

Index - Schema public

Table: mdl_gradingform_rubric_fillings

Stores the data of how the rubric is filled by a particular rater

mdl_gradingform_rubric_fillings Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	instanceid	bigint	NOT NULL
	criterionid	bigint	NOT NULL
	levelid	bigint
	remark	text
	remarkformat	smallint

mdl_gradingform_rubric_fillings Indexes
Index Name	Definition
mdl_gradrubrfill_cri_ix	CREATE INDEX mdl_gradrubrfill_cri_ix ON mdl_gradingform_rubric_fillings USING btree (criterionid)
mdl_gradrubrfill_ins_ix	CREATE INDEX mdl_gradrubrfill_ins_ix ON mdl_gradingform_rubric_fillings USING btree (instanceid)
mdl_gradrubrfill_lev_ix	CREATE INDEX mdl_gradrubrfill_lev_ix ON mdl_gradingform_rubric_fillings USING btree (levelid)

Index - Schema public

Table: mdl_gradingform_rubric_levels

Stores the columns of the rubric grid.

mdl_gradingform_rubric_levels Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	criterionid	bigint	NOT NULL
	score	numeric(10,5)	NOT NULL
	definition	text
	definitionformat	bigint

mdl_gradingform_rubric_levels Indexes
Index Name	Definition
mdl_gradrubrleve_cri_ix	CREATE INDEX mdl_gradrubrleve_cri_ix ON mdl_gradingform_rubric_levels USING btree (criterionid)

Index - Schema public

Table: mdl_groupings

A grouping is a collection of groups. WAS: groups_groupings

mdl_groupings Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	idnumber	character varying(100)	NOT NULL DEFAULT ''::character varying
	description	text
	descriptionformat	smallint	NOT NULL
	configdata	text
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_groupings Indexes
Index Name	Definition
mdl_grou_cou2_ix	CREATE INDEX mdl_grou_cou2_ix ON mdl_groupings USING btree (courseid)
mdl_grou_idn2_ix	CREATE INDEX mdl_grou_idn2_ix ON mdl_groupings USING btree (idnumber)

Index - Schema public

Table: mdl_groupings_groups

Link a grouping to a group (note, groups can be in multiple groupings ONLY in a course). WAS: groups_groupings_groups

mdl_groupings_groups Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	groupingid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	timeadded	bigint	NOT NULL

mdl_groupings_groups Indexes
Index Name	Definition
mdl_grougrou_gro2_ix	CREATE INDEX mdl_grougrou_gro2_ix ON mdl_groupings_groups USING btree (groupid)
mdl_grougrou_gro_ix	CREATE INDEX mdl_grougrou_gro_ix ON mdl_groupings_groups USING btree (groupingid)

Index - Schema public

Table: mdl_groups

Each record represents a group.

mdl_groups Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	idnumber	character varying(100)	NOT NULL DEFAULT ''::character varying
	name	character varying(254)	NOT NULL DEFAULT ''::character varying
	description	text
	descriptionformat	smallint	NOT NULL
	enrolmentkey	character varying(50)
	picture	bigint	NOT NULL
	hidepicture	smallint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_groups Indexes
Index Name	Definition
mdl_grou_cou_ix	CREATE INDEX mdl_grou_cou_ix ON mdl_groups USING btree (courseid)
mdl_grou_idn_ix	CREATE INDEX mdl_grou_idn_ix ON mdl_groups USING btree (idnumber)

Index - Schema public

Table: mdl_groups_members

Link a user to a group.

mdl_groups_members Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	groupid	bigint	NOT NULL
	userid	bigint	NOT NULL
	timeadded	bigint	NOT NULL
	component	character varying(100)	NOT NULL DEFAULT ''::character varying
	itemid	bigint	NOT NULL

mdl_groups_members Indexes
Index Name	Definition
mdl_groumemb_gro_ix	CREATE INDEX mdl_groumemb_gro_ix ON mdl_groups_members USING btree (groupid)
mdl_groumemb_use_ix	CREATE INDEX mdl_groumemb_use_ix ON mdl_groups_members USING btree (userid)

Index - Schema public

Table: mdl_imscp

each record is one imscp resource

mdl_imscp Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint	NOT NULL
	revision	bigint	NOT NULL
	keepold	bigint	NOT NULL DEFAULT (-1)
	structure	text
	timemodified	bigint	NOT NULL

mdl_imscp Indexes
Index Name	Definition
mdl_imsc_cou_ix	CREATE INDEX mdl_imsc_cou_ix ON mdl_imscp USING btree (course)

Index - Schema public

Table: mdl_label

Defines labels

mdl_label Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint
	timemodified	bigint	NOT NULL

mdl_label Indexes
Index Name	Definition
mdl_labe_cou_ix	CREATE INDEX mdl_labe_cou_ix ON mdl_label USING btree (course)

Index - Schema public

Table: mdl_lesson

Defines lesson

mdl_lesson Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	practice	smallint	NOT NULL
	modattempts	smallint	NOT NULL
	usepassword	smallint	NOT NULL
	password	character varying(32)	NOT NULL DEFAULT ''::character varying
	dependency	bigint	NOT NULL
	conditions	text	NOT NULL
	grade	smallint	NOT NULL
	custom	smallint	NOT NULL
	ongoing	smallint	NOT NULL
	usemaxgrade	smallint	NOT NULL
	maxanswers	smallint	NOT NULL DEFAULT 4
	maxattempts	smallint	NOT NULL DEFAULT 5
	review	smallint	NOT NULL
	nextpagedefault	smallint	NOT NULL
	feedback	smallint	NOT NULL DEFAULT 1
	minquestions	smallint	NOT NULL
	maxpages	smallint	NOT NULL
	timed	smallint	NOT NULL
	maxtime	bigint	NOT NULL
	retake	smallint	NOT NULL DEFAULT 1
	activitylink	bigint	NOT NULL
	mediafile	character varying(255)	NOT NULL DEFAULT ''::character varying
	mediaheight	bigint	NOT NULL DEFAULT 100
	mediawidth	bigint	NOT NULL DEFAULT 650
	mediaclose	smallint	NOT NULL
	slideshow	smallint	NOT NULL
	width	bigint	NOT NULL DEFAULT 640
	height	bigint	NOT NULL DEFAULT 480
	bgcolor	character varying(7)	NOT NULL DEFAULT '#FFFFFF'::character varying
	displayleft	smallint	NOT NULL
	displayleftif	smallint	NOT NULL
	progressbar	smallint	NOT NULL
	highscores	smallint	NOT NULL
	maxhighscores	bigint	NOT NULL
	available	bigint	NOT NULL
	deadline	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_lesson Indexes
Index Name	Definition
mdl_less_cou_ix	CREATE INDEX mdl_less_cou_ix ON mdl_lesson USING btree (course)

Index - Schema public

Table: mdl_lesson_answers

Defines lesson_answers

mdl_lesson_answers Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	lessonid	bigint	NOT NULL
	pageid	bigint	NOT NULL
	jumpto	bigint	NOT NULL
	grade	smallint	NOT NULL
	score	bigint	NOT NULL
	flags	smallint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	answer	text
	answerformat	smallint	NOT NULL
	response	text
	responseformat	smallint	NOT NULL

mdl_lesson_answers Indexes
Index Name	Definition
mdl_lessansw_les_ix	CREATE INDEX mdl_lessansw_les_ix ON mdl_lesson_answers USING btree (lessonid)
mdl_lessansw_pag_ix	CREATE INDEX mdl_lessansw_pag_ix ON mdl_lesson_answers USING btree (pageid)

Index - Schema public

Table: mdl_lesson_attempts

Defines lesson_attempts

mdl_lesson_attempts Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	lessonid	bigint	NOT NULL
	pageid	bigint	NOT NULL
	userid	bigint	NOT NULL
	answerid	bigint	NOT NULL
	retry	smallint	NOT NULL
	correct	bigint	NOT NULL
	useranswer	text
	timeseen	bigint	NOT NULL

mdl_lesson_attempts Indexes
Index Name	Definition
mdl_lessatte_ans_ix	CREATE INDEX mdl_lessatte_ans_ix ON mdl_lesson_attempts USING btree (answerid)
mdl_lessatte_les_ix	CREATE INDEX mdl_lessatte_les_ix ON mdl_lesson_attempts USING btree (lessonid)
mdl_lessatte_pag_ix	CREATE INDEX mdl_lessatte_pag_ix ON mdl_lesson_attempts USING btree (pageid)
mdl_lessatte_use_ix	CREATE INDEX mdl_lessatte_use_ix ON mdl_lesson_attempts USING btree (userid)

Index - Schema public

Table: mdl_lesson_branch

branches for each lesson/user

mdl_lesson_branch Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	lessonid	bigint	NOT NULL
	userid	bigint	NOT NULL
	pageid	bigint	NOT NULL
	retry	bigint	NOT NULL
	flag	smallint	NOT NULL
	timeseen	bigint	NOT NULL

mdl_lesson_branch Indexes
Index Name	Definition
mdl_lessbran_les_ix	CREATE INDEX mdl_lessbran_les_ix ON mdl_lesson_branch USING btree (lessonid)
mdl_lessbran_pag_ix	CREATE INDEX mdl_lessbran_pag_ix ON mdl_lesson_branch USING btree (pageid)
mdl_lessbran_use_ix	CREATE INDEX mdl_lessbran_use_ix ON mdl_lesson_branch USING btree (userid)

Index - Schema public

Table: mdl_lesson_grades

Defines lesson_grades

mdl_lesson_grades Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	lessonid	bigint	NOT NULL
	userid	bigint	NOT NULL
	grade	double precision	NOT NULL
	late	smallint	NOT NULL
	completed	bigint	NOT NULL

mdl_lesson_grades Indexes
Index Name	Definition
mdl_lessgrad_les_ix	CREATE INDEX mdl_lessgrad_les_ix ON mdl_lesson_grades USING btree (lessonid)
mdl_lessgrad_use_ix	CREATE INDEX mdl_lessgrad_use_ix ON mdl_lesson_grades USING btree (userid)

Index - Schema public

Table: mdl_lesson_high_scores

high scores for each lesson

mdl_lesson_high_scores Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	lessonid	bigint	NOT NULL
	userid	bigint	NOT NULL
	gradeid	bigint	NOT NULL
	nickname	character varying(5)	NOT NULL DEFAULT ''::character varying

mdl_lesson_high_scores Indexes
Index Name	Definition
mdl_lesshighscor_les_ix	CREATE INDEX mdl_lesshighscor_les_ix ON mdl_lesson_high_scores USING btree (lessonid)
mdl_lesshighscor_use_ix	CREATE INDEX mdl_lesshighscor_use_ix ON mdl_lesson_high_scores USING btree (userid)

Index - Schema public

Table: mdl_lesson_pages

Defines lesson_pages

mdl_lesson_pages Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	lessonid	bigint	NOT NULL
	prevpageid	bigint	NOT NULL
	nextpageid	bigint	NOT NULL
	qtype	smallint	NOT NULL
	qoption	smallint	NOT NULL
	layout	smallint	NOT NULL DEFAULT 1
	display	smallint	NOT NULL DEFAULT 1
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	title	character varying(255)	NOT NULL DEFAULT ''::character varying
	contents	text	NOT NULL
	contentsformat	smallint	NOT NULL

mdl_lesson_pages Indexes
Index Name	Definition
mdl_lesspage_les_ix	CREATE INDEX mdl_lesspage_les_ix ON mdl_lesson_pages USING btree (lessonid)

Index - Schema public

Table: mdl_lesson_timer

lesson timer for each lesson

mdl_lesson_timer Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	lessonid	bigint	NOT NULL
	userid	bigint	NOT NULL
	starttime	bigint	NOT NULL
	lessontime	bigint	NOT NULL

mdl_lesson_timer Indexes
Index Name	Definition
mdl_lesstime_les_ix	CREATE INDEX mdl_lesstime_les_ix ON mdl_lesson_timer USING btree (lessonid)
mdl_lesstime_use_ix	CREATE INDEX mdl_lesstime_use_ix ON mdl_lesson_timer USING btree (userid)

Index - Schema public

Table: mdl_license

store licenses used by moodle

mdl_license Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	shortname	character varying(255)
	fullname	text
	source	character varying(255)
	enabled	smallint	NOT NULL DEFAULT 1
	version	bigint	NOT NULL

Index - Schema public

Table: mdl_log

Every action is logged as far as possible

mdl_log Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	time	bigint	NOT NULL
	userid	bigint	NOT NULL
	ip	character varying(45)	NOT NULL DEFAULT ''::character varying
	course	bigint	NOT NULL
	module	character varying(20)	NOT NULL DEFAULT ''::character varying
	cmid	bigint	NOT NULL
	action	character varying(40)	NOT NULL DEFAULT ''::character varying
	url	character varying(100)	NOT NULL DEFAULT ''::character varying
	info	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_log Indexes
Index Name	Definition
mdl_log_act_ix	CREATE INDEX mdl_log_act_ix ON mdl_log USING btree (action)
mdl_log_cmi_ix	CREATE INDEX mdl_log_cmi_ix ON mdl_log USING btree (cmid)
mdl_log_coumodact_ix	CREATE INDEX mdl_log_coumodact_ix ON mdl_log USING btree (course, module, action)
mdl_log_tim_ix	CREATE INDEX mdl_log_tim_ix ON mdl_log USING btree ("time")
mdl_log_usecou_ix	CREATE INDEX mdl_log_usecou_ix ON mdl_log USING btree (userid, course)

Index - Schema public

Table: mdl_log_display

For a particular module/action, specifies a moodle table/field

mdl_log_display Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	module	character varying(20)	NOT NULL DEFAULT ''::character varying
	action	character varying(40)	NOT NULL DEFAULT ''::character varying
	mtable	character varying(30)	NOT NULL DEFAULT ''::character varying
	field	character varying(200)	NOT NULL DEFAULT ''::character varying
	component	character varying(100)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_log_queries

Logged database queries.

mdl_log_queries Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	qtype	integer	NOT NULL
	sqltext	text	NOT NULL
	sqlparams	text
	error	integer	NOT NULL
	info	text
	backtrace	text
	exectime	numeric(10,5)	NOT NULL
	timelogged	bigint	NOT NULL

Index - Schema public

Table: mdl_lti

This table contains Basic LTI activities instances

mdl_lti Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	typeid	bigint
	toolurl	text	NOT NULL
	securetoolurl	text
	instructorchoicesendname	smallint
	instructorchoicesendemailaddr	smallint
	instructorchoiceallowroster	smallint
	instructorchoiceallowsetting	smallint
	instructorcustomparameters	character varying(255)
	instructorchoiceacceptgrades	smallint
	grade	numeric(10,5)	NOT NULL DEFAULT 100
	launchcontainer	smallint	NOT NULL DEFAULT 1
	resourcekey	character varying(255)
	password	character varying(255)
	debuglaunch	smallint	NOT NULL
	showtitlelaunch	smallint	NOT NULL
	showdescriptionlaunch	smallint	NOT NULL
	servicesalt	character varying(40)
	icon	text
	secureicon	text

mdl_lti Indexes
Index Name	Definition
mdl_lti_cou_ix	CREATE INDEX mdl_lti_cou_ix ON mdl_lti USING btree (course)

Index - Schema public

Table: mdl_lti_submission

Keeps track of individual submissions for LTI activities.

mdl_lti_submission Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	ltiid	bigint	NOT NULL
	userid	bigint	NOT NULL
	datesubmitted	bigint	NOT NULL
	dateupdated	bigint	NOT NULL
	gradepercent	numeric(10,5)	NOT NULL
	originalgrade	numeric(10,5)	NOT NULL
	launchid	bigint	NOT NULL
	state	smallint	NOT NULL

mdl_lti_submission Indexes
Index Name	Definition
mdl_ltisubm_lti_ix	CREATE INDEX mdl_ltisubm_lti_ix ON mdl_lti_submission USING btree (ltiid)

Index - Schema public

Table: mdl_lti_types

Basic LTI pre-configured activities

mdl_lti_types Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT 'basiclti Activity'::character varying
	baseurl	text	NOT NULL
	tooldomain	character varying(255)	NOT NULL DEFAULT ''::character varying
	state	smallint	NOT NULL DEFAULT 2
	course	bigint	NOT NULL
	coursevisible	smallint	NOT NULL
	createdby	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_lti_types Indexes
Index Name	Definition
mdl_ltitype_cou_ix	CREATE INDEX mdl_ltitype_cou_ix ON mdl_lti_types USING btree (course)
mdl_ltitype_too_ix	CREATE INDEX mdl_ltitype_too_ix ON mdl_lti_types USING btree (tooldomain)

Index - Schema public

Table: mdl_lti_types_config

Basic LTI types configuration

mdl_lti_types_config Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	typeid	bigint	NOT NULL
	name	character varying(100)	NOT NULL DEFAULT ''::character varying
	value	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_lti_types_config Indexes
Index Name	Definition
mdl_ltitypeconf_typ_ix	CREATE INDEX mdl_ltitypeconf_typ_ix ON mdl_lti_types_config USING btree (typeid)

Index - Schema public

Table: mdl_message

Stores all unread messages

mdl_message Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	useridfrom	bigint	NOT NULL
	useridto	bigint	NOT NULL
	subject	text
	fullmessage	text
	fullmessageformat	smallint
	fullmessagehtml	text
	smallmessage	text
	notification	smallint
	contexturl	text
	contexturlname	text
	timecreated	bigint	NOT NULL

mdl_message Indexes
Index Name	Definition
mdl_mess_use2_ix	CREATE INDEX mdl_mess_use2_ix ON mdl_message USING btree (useridto)
mdl_mess_use_ix	CREATE INDEX mdl_mess_use_ix ON mdl_message USING btree (useridfrom)

Index - Schema public

Table: mdl_message_contacts

Maintains lists of relationships between users

mdl_message_contacts Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	contactid	bigint	NOT NULL
	blocked	smallint	NOT NULL

Index - Schema public

Table: mdl_message_processors

List of message output plugins

mdl_message_processors Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(166)	NOT NULL DEFAULT ''::character varying
	enabled	smallint	NOT NULL DEFAULT 1

Index - Schema public

Table: mdl_message_providers

This table stores the message providers (modules and core systems)

mdl_message_providers Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(100)	NOT NULL DEFAULT ''::character varying
	component	character varying(200)	NOT NULL DEFAULT ''::character varying
	capability	character varying(255)

Index - Schema public

Table: mdl_message_read

Stores all messages that have been read

mdl_message_read Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	useridfrom	bigint	NOT NULL
	useridto	bigint	NOT NULL
	subject	text
	fullmessage	text
	fullmessageformat	smallint
	fullmessagehtml	text
	smallmessage	text
	notification	smallint
	contexturl	text
	contexturlname	text
	timecreated	bigint	NOT NULL
	timeread	bigint	NOT NULL

mdl_message_read Indexes
Index Name	Definition
mdl_messread_use2_ix	CREATE INDEX mdl_messread_use2_ix ON mdl_message_read USING btree (useridto)
mdl_messread_use_ix	CREATE INDEX mdl_messread_use_ix ON mdl_message_read USING btree (useridfrom)

Index - Schema public

Table: mdl_message_working

Lists all the messages and processors that need to be processed

mdl_message_working Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	unreadmessageid	bigint	NOT NULL
	processorid	bigint	NOT NULL

mdl_message_working Indexes
Index Name	Definition
mdl_messwork_unr_ix	CREATE INDEX mdl_messwork_unr_ix ON mdl_message_working USING btree (unreadmessageid)

Index - Schema public

Table: mdl_mnet_application

Information about applications on remote hosts

mdl_mnet_application Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(50)	NOT NULL DEFAULT ''::character varying
	display_name	character varying(50)	NOT NULL DEFAULT ''::character varying
	xmlrpc_server_url	character varying(255)	NOT NULL DEFAULT ''::character varying
	sso_land_url	character varying(255)	NOT NULL DEFAULT ''::character varying
	sso_jump_url	character varying(255)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_mnet_host

Information about the local and remote hosts for RPC

mdl_mnet_host Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	deleted	smallint	NOT NULL
	wwwroot	character varying(255)	NOT NULL DEFAULT ''::character varying
	ip_address	character varying(45)	NOT NULL DEFAULT ''::character varying
	name	character varying(80)	NOT NULL DEFAULT ''::character varying
	public_key	text	NOT NULL
	public_key_expires	bigint	NOT NULL
	transport	smallint	NOT NULL
	portno	integer	NOT NULL
	last_connect_time	bigint	NOT NULL
	last_log_id	bigint	NOT NULL
	force_theme	smallint	NOT NULL
	theme	character varying(100)
	applicationid	bigint	NOT NULL DEFAULT 1

mdl_mnet_host Indexes
Index Name	Definition
mdl_mnethost_app_ix	CREATE INDEX mdl_mnethost_app_ix ON mdl_mnet_host USING btree (applicationid)

Index - Schema public

Table: mdl_mnet_host2service

Information about the services for a given host

mdl_mnet_host2service Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	hostid	bigint	NOT NULL
	serviceid	bigint	NOT NULL
	publish	smallint	NOT NULL
	subscribe	smallint	NOT NULL

Index - Schema public

Table: mdl_mnet_log

Store session data from users migrating to other sites

mdl_mnet_log Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	hostid	bigint	NOT NULL
	remoteid	bigint	NOT NULL
	time	bigint	NOT NULL
	userid	bigint	NOT NULL
	ip	character varying(45)	NOT NULL DEFAULT ''::character varying
	course	bigint	NOT NULL
	coursename	character varying(40)	NOT NULL DEFAULT ''::character varying
	module	character varying(20)	NOT NULL DEFAULT ''::character varying
	cmid	bigint	NOT NULL
	action	character varying(40)	NOT NULL DEFAULT ''::character varying
	url	character varying(100)	NOT NULL DEFAULT ''::character varying
	info	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_mnet_log Indexes
Index Name	Definition
mdl_mnetlog_hosusecou_ix	CREATE INDEX mdl_mnetlog_hosusecou_ix ON mdl_mnet_log USING btree (hostid, userid, course)

Index - Schema public

Table: mdl_mnet_remote_rpc

This table describes functions that might be called remotely (we have less information about them than local functions)

mdl_mnet_remote_rpc Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	functionname	character varying(40)	NOT NULL DEFAULT ''::character varying
	xmlrpcpath	character varying(80)	NOT NULL DEFAULT ''::character varying
	plugintype	character varying(20)	NOT NULL DEFAULT ''::character varying
	pluginname	character varying(20)	NOT NULL DEFAULT ''::character varying
	enabled	smallint	NOT NULL

Index - Schema public

Table: mdl_mnet_remote_service2rpc

Group functions or methods under a service

mdl_mnet_remote_service2rpc Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	serviceid	bigint	NOT NULL
	rpcid	bigint	NOT NULL

Index - Schema public

Table: mdl_mnet_rpc

Functions or methods that we may publish or subscribe to

mdl_mnet_rpc Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	functionname	character varying(40)	NOT NULL DEFAULT ''::character varying
	xmlrpcpath	character varying(80)	NOT NULL DEFAULT ''::character varying
	plugintype	character varying(20)	NOT NULL DEFAULT ''::character varying
	pluginname	character varying(20)	NOT NULL DEFAULT ''::character varying
	enabled	smallint	NOT NULL
	help	text	NOT NULL
	profile	text	NOT NULL
	filename	character varying(100)	NOT NULL DEFAULT ''::character varying
	classname	character varying(150)
	static	smallint

mdl_mnet_rpc Indexes
Index Name	Definition
mdl_mnetrpc_enaxml_ix	CREATE INDEX mdl_mnetrpc_enaxml_ix ON mdl_mnet_rpc USING btree (enabled, xmlrpcpath)

Index - Schema public

Table: mdl_mnet_service

A service is a group of functions

mdl_mnet_service Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(40)	NOT NULL DEFAULT ''::character varying
	description	character varying(40)	NOT NULL DEFAULT ''::character varying
	apiversion	character varying(10)	NOT NULL DEFAULT ''::character varying
	offer	smallint	NOT NULL

Index - Schema public

Table: mdl_mnet_service2rpc

Group functions or methods under a service

mdl_mnet_service2rpc Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	serviceid	bigint	NOT NULL
	rpcid	bigint	NOT NULL

Index - Schema public

Table: mdl_mnet_session

Store session data from users migrating to other sites

mdl_mnet_session Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	username	character varying(100)	NOT NULL DEFAULT ''::character varying
	token	character varying(40)	NOT NULL DEFAULT ''::character varying
	mnethostid	bigint	NOT NULL
	useragent	character varying(40)	NOT NULL DEFAULT ''::character varying
	confirm_timeout	bigint	NOT NULL
	session_id	character varying(40)	NOT NULL DEFAULT ''::character varying
	expires	bigint	NOT NULL

Index - Schema public

Table: mdl_mnet_sso_access_control

Users by host permitted (or not) to login from a remote provider

mdl_mnet_sso_access_control Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	username	character varying(100)	NOT NULL DEFAULT ''::character varying
	mnet_host_id	bigint	NOT NULL
	accessctrl	character varying(20)	NOT NULL DEFAULT 'allow'::character varying

Index - Schema public

Table: mdl_mnetservice_enrol_courses

Caches the information fetched via XML-RPC about courses on remote hosts that are offered for our users

mdl_mnetservice_enrol_courses Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	hostid	bigint	NOT NULL
	remoteid	bigint	NOT NULL
	categoryid	bigint	NOT NULL
	categoryname	character varying(255)	NOT NULL DEFAULT ''::character varying
	sortorder	bigint	NOT NULL
	fullname	character varying(254)	NOT NULL DEFAULT ''::character varying
	shortname	character varying(100)	NOT NULL DEFAULT ''::character varying
	idnumber	character varying(100)	NOT NULL DEFAULT ''::character varying
	summary	text	NOT NULL
	summaryformat	smallint
	startdate	bigint	NOT NULL
	roleid	bigint	NOT NULL
	rolename	character varying(255)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_mnetservice_enrol_enrolments

Caches the information about enrolments of our local users in courses on remote hosts

mdl_mnetservice_enrol_enrolments Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	hostid	bigint	NOT NULL
	userid	bigint	NOT NULL
	remotecourseid	bigint	NOT NULL
	rolename	character varying(255)	NOT NULL DEFAULT ''::character varying
	enroltime	bigint	NOT NULL
	enroltype	character varying(20)	NOT NULL DEFAULT ''::character varying

mdl_mnetservice_enrol_enrolments Indexes
Index Name	Definition
mdl_mnetenroenro_hos_ix	CREATE INDEX mdl_mnetenroenro_hos_ix ON mdl_mnetservice_enrol_enrolments USING btree (hostid)
mdl_mnetenroenro_use_ix	CREATE INDEX mdl_mnetenroenro_use_ix ON mdl_mnetservice_enrol_enrolments USING btree (userid)

Index - Schema public

Table: mdl_modules

modules available in the site

mdl_modules Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(20)	NOT NULL DEFAULT ''::character varying
	cron	bigint	NOT NULL
	lastcron	bigint	NOT NULL
	search	character varying(255)	NOT NULL DEFAULT ''::character varying
	visible	smallint	NOT NULL DEFAULT 1

mdl_modules Indexes
Index Name	Definition
mdl_modu_nam_ix	CREATE INDEX mdl_modu_nam_ix ON mdl_modules USING btree (name)

Index - Schema public

Table: mdl_my_pages

Extra user pages for the My Moodle system

mdl_my_pages Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint
	name	character varying(200)	NOT NULL DEFAULT ''::character varying
	private	smallint	NOT NULL DEFAULT 1
	sortorder	integer	NOT NULL

mdl_my_pages Indexes
Index Name	Definition
mdl_mypage_usepri_ix	CREATE INDEX mdl_mypage_usepri_ix ON mdl_my_pages USING btree (userid, private)

Index - Schema public

Table: mdl_openmeetings

openmeetings

mdl_openmeetings Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	teacher	bigint	NOT NULL
	type	bigint	NOT NULL DEFAULT 1
	is_moderated_room	bigint	NOT NULL DEFAULT 1
	max_user	bigint	NOT NULL DEFAULT 4
	language	bigint	NOT NULL DEFAULT 1
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	room_id	bigint	NOT NULL
	room_recording_id	bigint	NOT NULL
	allow_recording	bigint	NOT NULL DEFAULT 1

mdl_openmeetings Indexes
Index Name	Definition
mdl_open_cou_ix	CREATE INDEX mdl_open_cou_ix ON mdl_openmeetings USING btree (course)

Index - Schema public

Table: mdl_page

Each record is one page and its config data

mdl_page Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint	NOT NULL
	content	text
	contentformat	smallint	NOT NULL
	legacyfiles	smallint	NOT NULL
	legacyfileslast	bigint
	display	smallint	NOT NULL
	displayoptions	text
	revision	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_page Indexes
Index Name	Definition
mdl_page_cou_ix	CREATE INDEX mdl_page_cou_ix ON mdl_page USING btree (course)

Index - Schema public

Table: mdl_portfolio_instance

base table (not including config data) for instances of portfolio plugins.

mdl_portfolio_instance Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	plugin	character varying(50)	NOT NULL DEFAULT ''::character varying
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	visible	smallint	NOT NULL DEFAULT 1

Index - Schema public

Table: mdl_portfolio_instance_config

config for portfolio plugin instances

mdl_portfolio_instance_config Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	instance	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	text

mdl_portfolio_instance_config Indexes
Index Name	Definition
mdl_portinstconf_ins_ix	CREATE INDEX mdl_portinstconf_ins_ix ON mdl_portfolio_instance_config USING btree (instance)
mdl_portinstconf_nam_ix	CREATE INDEX mdl_portinstconf_nam_ix ON mdl_portfolio_instance_config USING btree (name)

Index - Schema public

Table: mdl_portfolio_instance_user

user data for portfolio instances.

mdl_portfolio_instance_user Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	instance	bigint	NOT NULL
	userid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	text

mdl_portfolio_instance_user Indexes
Index Name	Definition
mdl_portinstuser_ins_ix	CREATE INDEX mdl_portinstuser_ins_ix ON mdl_portfolio_instance_user USING btree (instance)
mdl_portinstuser_use_ix	CREATE INDEX mdl_portinstuser_use_ix ON mdl_portfolio_instance_user USING btree (userid)

Index - Schema public

Table: mdl_portfolio_log

log of portfolio transfers (used to later check for duplicates)

mdl_portfolio_log Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	time	bigint	NOT NULL
	portfolio	bigint	NOT NULL
	caller_class	character varying(150)	NOT NULL DEFAULT ''::character varying
	caller_file	character varying(255)	NOT NULL DEFAULT ''::character varying
	caller_component	character varying(255)
	caller_sha1	character varying(255)	NOT NULL DEFAULT ''::character varying
	tempdataid	bigint	NOT NULL
	returnurl	character varying(255)	NOT NULL DEFAULT ''::character varying
	continueurl	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_portfolio_log Indexes
Index Name	Definition
mdl_portlog_por_ix	CREATE INDEX mdl_portlog_por_ix ON mdl_portfolio_log USING btree (portfolio)
mdl_portlog_use_ix	CREATE INDEX mdl_portlog_use_ix ON mdl_portfolio_log USING btree (userid)

Index - Schema public

Table: mdl_portfolio_mahara_queue

maps mahara tokens to transfer ids

mdl_portfolio_mahara_queue Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	transferid	bigint	NOT NULL
	token	character varying(50)	NOT NULL DEFAULT ''::character varying

mdl_portfolio_mahara_queue Indexes
Index Name	Definition
mdl_portmahaqueu_tok_ix	CREATE INDEX mdl_portmahaqueu_tok_ix ON mdl_portfolio_mahara_queue USING btree (token)
mdl_portmahaqueu_tra_ix	CREATE INDEX mdl_portmahaqueu_tra_ix ON mdl_portfolio_mahara_queue USING btree (transferid)

Index - Schema public

Table: mdl_portfolio_tempdata

stores temporary data for portfolio exports. the id of this table is used for the itemid for the temporary files area. cron can clean up stale records (and associated file data) after expirytime.

mdl_portfolio_tempdata Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	data	text
	expirytime	bigint	NOT NULL
	userid	bigint	NOT NULL
	instance	bigint

mdl_portfolio_tempdata Indexes
Index Name	Definition
mdl_porttemp_ins_ix	CREATE INDEX mdl_porttemp_ins_ix ON mdl_portfolio_tempdata USING btree (instance)
mdl_porttemp_use_ix	CREATE INDEX mdl_porttemp_use_ix ON mdl_portfolio_tempdata USING btree (userid)

Index - Schema public

Table: mdl_post

Generic post table to hold data blog entries etc in different modules

mdl_post Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	module	character varying(20)	NOT NULL DEFAULT ''::character varying
	userid	bigint	NOT NULL
	courseid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	moduleid	bigint	NOT NULL
	coursemoduleid	bigint	NOT NULL
	subject	character varying(128)	NOT NULL DEFAULT ''::character varying
	summary	text
	content	text
	uniquehash	character varying(255)	NOT NULL DEFAULT ''::character varying
	rating	bigint	NOT NULL
	format	bigint	NOT NULL
	summaryformat	smallint	NOT NULL
	attachment	character varying(100)
	publishstate	character varying(20)	NOT NULL DEFAULT 'draft'::character varying
	lastmodified	bigint	NOT NULL
	created	bigint	NOT NULL
	usermodified	bigint

mdl_post Indexes
Index Name	Definition
mdl_post_las_ix	CREATE INDEX mdl_post_las_ix ON mdl_post USING btree (lastmodified)
mdl_post_mod_ix	CREATE INDEX mdl_post_mod_ix ON mdl_post USING btree (module)
mdl_post_sub_ix	CREATE INDEX mdl_post_sub_ix ON mdl_post USING btree (subject)
mdl_post_use_ix	CREATE INDEX mdl_post_use_ix ON mdl_post USING btree (usermodified)

Index - Schema public

Table: mdl_profiling

Stores the results of all the profiling runs

mdl_profiling Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	runid	character varying(32)	NOT NULL DEFAULT ''::character varying
	url	character varying(255)	NOT NULL DEFAULT ''::character varying
	data	text	NOT NULL
	totalexecutiontime	bigint	NOT NULL
	totalcputime	bigint	NOT NULL
	totalcalls	bigint	NOT NULL
	totalmemory	bigint	NOT NULL
	runreference	smallint	NOT NULL
	runcomment	character varying(255)	NOT NULL DEFAULT ''::character varying
	timecreated	bigint	NOT NULL

mdl_profiling Indexes
Index Name	Definition
mdl_prof_timrun_ix	CREATE INDEX mdl_prof_timrun_ix ON mdl_profiling USING btree (timecreated, runreference)
mdl_prof_urlrun_ix	CREATE INDEX mdl_prof_urlrun_ix ON mdl_profiling USING btree (url, runreference)

Index - Schema public

Table: mdl_qtype_essay_options

Extra options for essay questions.

mdl_qtype_essay_options Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionid	bigint	NOT NULL
	responseformat	character varying(16)	NOT NULL DEFAULT 'editor'::character varying
	responsefieldlines	smallint	NOT NULL DEFAULT 15
	attachments	smallint	NOT NULL
	graderinfo	text
	graderinfoformat	smallint	NOT NULL
	responsetemplate	text
	responsetemplateformat	smallint	NOT NULL

Index - Schema public

Table: mdl_qtype_match_options

Defines fixed matching questions

mdl_qtype_match_options Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionid	bigint	NOT NULL
	shuffleanswers	smallint	NOT NULL DEFAULT 1
	correctfeedback	text	NOT NULL
	correctfeedbackformat	smallint	NOT NULL
	partiallycorrectfeedback	text	NOT NULL
	partiallycorrectfeedbackformat	smallint	NOT NULL
	incorrectfeedback	text	NOT NULL
	incorrectfeedbackformat	smallint	NOT NULL
	shownumcorrect	smallint	NOT NULL

Index - Schema public

Table: mdl_qtype_match_subquestions

Defines the subquestions that make up a matching question

mdl_qtype_match_subquestions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionid	bigint	NOT NULL
	questiontext	text	NOT NULL
	questiontextformat	smallint	NOT NULL
	answertext	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_qtype_match_subquestions Indexes
Index Name	Definition
mdl_qtypmatcsubq_que_ix	CREATE INDEX mdl_qtypmatcsubq_que_ix ON mdl_qtype_match_subquestions USING btree (questionid)

Index - Schema public

Table: mdl_qtype_multichoice_options

Options for multiple choice questions

mdl_qtype_multichoice_options Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionid	bigint	NOT NULL
	layout	smallint	NOT NULL
	single	smallint	NOT NULL
	shuffleanswers	smallint	NOT NULL DEFAULT 1
	correctfeedback	text	NOT NULL
	correctfeedbackformat	smallint	NOT NULL
	partiallycorrectfeedback	text	NOT NULL
	partiallycorrectfeedbackformat	smallint	NOT NULL
	incorrectfeedback	text	NOT NULL
	incorrectfeedbackformat	smallint	NOT NULL
	answernumbering	character varying(10)	NOT NULL DEFAULT 'abc'::character varying
	shownumcorrect	smallint	NOT NULL

Index - Schema public

Table: mdl_qtype_shortanswer_options

Options for short answer questions

mdl_qtype_shortanswer_options Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionid	bigint	NOT NULL
	usecase	smallint	NOT NULL

Index - Schema public

Table: mdl_question

The questions themselves

mdl_question Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	category	bigint	NOT NULL
	parent	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	questiontext	text	NOT NULL
	questiontextformat	smallint	NOT NULL
	generalfeedback	text	NOT NULL
	generalfeedbackformat	smallint	NOT NULL
	defaultmark	numeric(12,7)	NOT NULL DEFAULT 1
	penalty	numeric(12,7)	NOT NULL DEFAULT 0.3333333
	qtype	character varying(20)	NOT NULL DEFAULT ''::character varying
	length	bigint	NOT NULL DEFAULT 1
	stamp	character varying(255)	NOT NULL DEFAULT ''::character varying
	version	character varying(255)	NOT NULL DEFAULT ''::character varying
	hidden	smallint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	createdby	bigint
	modifiedby	bigint

mdl_question Indexes
Index Name	Definition
mdl_ques_cat_ix	CREATE INDEX mdl_ques_cat_ix ON mdl_question USING btree (category)
mdl_ques_cre_ix	CREATE INDEX mdl_ques_cre_ix ON mdl_question USING btree (createdby)
mdl_ques_mod_ix	CREATE INDEX mdl_ques_mod_ix ON mdl_question USING btree (modifiedby)
mdl_ques_par_ix	CREATE INDEX mdl_ques_par_ix ON mdl_question USING btree (parent)

Index - Schema public

Table: mdl_question_answers

Answers, with a fractional grade (0-1) and feedback

mdl_question_answers Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	answer	text	NOT NULL
	answerformat	smallint	NOT NULL
	fraction	numeric(12,7)	NOT NULL
	feedback	text	NOT NULL
	feedbackformat	smallint	NOT NULL

mdl_question_answers Indexes
Index Name	Definition
mdl_quesansw_que_ix	CREATE INDEX mdl_quesansw_que_ix ON mdl_question_answers USING btree (question)

Index - Schema public

Table: mdl_question_attempt_step_data

Each question_attempt_step has an associative array of the data that was submitted by the user in the POST request. It can also contain extra data from the question type or behaviour to avoid re-computation. The convention is that names belonging to

mdl_question_attempt_step_data Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	attemptstepid	bigint	NOT NULL
	name	character varying(32)	NOT NULL DEFAULT ''::character varying
	value	text

mdl_question_attempt_step_data Indexes
Index Name	Definition
mdl_quesattestepdata_att_ix	CREATE INDEX mdl_quesattestepdata_att_ix ON mdl_question_attempt_step_data USING btree (attemptstepid)

Index - Schema public

Table: mdl_question_attempt_steps

Stores one step in in a question attempt. As well as the data here, the step will have some data in the question_attempt_step_data table.

mdl_question_attempt_steps Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionattemptid	bigint	NOT NULL
	sequencenumber	bigint	NOT NULL
	state	character varying(13)	NOT NULL DEFAULT ''::character varying
	fraction	numeric(12,7)
	timecreated	bigint	NOT NULL
	userid	bigint

mdl_question_attempt_steps Indexes
Index Name	Definition
mdl_quesattestep_que_ix	CREATE INDEX mdl_quesattestep_que_ix ON mdl_question_attempt_steps USING btree (questionattemptid)
mdl_quesattestep_use_ix	CREATE INDEX mdl_quesattestep_use_ix ON mdl_question_attempt_steps USING btree (userid)

Index - Schema public

Table: mdl_question_attempts

Each row here corresponds to an attempt at one question, as part of a question_usage. A question_attempt will have some question_attempt_steps

mdl_question_attempts Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionusageid	bigint	NOT NULL
	slot	bigint	NOT NULL
	behaviour	character varying(32)	NOT NULL DEFAULT ''::character varying
	questionid	bigint	NOT NULL
	variant	bigint	NOT NULL DEFAULT 1
	maxmark	numeric(12,7)	NOT NULL
	minfraction	numeric(12,7)	NOT NULL
	flagged	smallint	NOT NULL
	questionsummary	text
	rightanswer	text
	responsesummary	text
	timemodified	bigint	NOT NULL
	maxfraction	numeric(12,7)	NOT NULL DEFAULT 1

mdl_question_attempts Indexes
Index Name	Definition
mdl_quesatte_que2_ix	CREATE INDEX mdl_quesatte_que2_ix ON mdl_question_attempts USING btree (questionusageid)
mdl_quesatte_que_ix	CREATE INDEX mdl_quesatte_que_ix ON mdl_question_attempts USING btree (questionid)

Index - Schema public

Table: mdl_question_calculated

Options for questions of type calculated

mdl_question_calculated Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	answer	bigint	NOT NULL
	tolerance	character varying(20)	NOT NULL DEFAULT '0.0'::character varying
	tolerancetype	bigint	NOT NULL DEFAULT 1
	correctanswerlength	bigint	NOT NULL DEFAULT 2
	correctanswerformat	bigint	NOT NULL DEFAULT 2

mdl_question_calculated Indexes
Index Name	Definition
mdl_quescalc_ans_ix	CREATE INDEX mdl_quescalc_ans_ix ON mdl_question_calculated USING btree (answer)
mdl_quescalc_que_ix	CREATE INDEX mdl_quescalc_que_ix ON mdl_question_calculated USING btree (question)

Index - Schema public

Table: mdl_question_calculated_options

Options for questions of type calculated

mdl_question_calculated_options Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	synchronize	smallint	NOT NULL
	single	smallint	NOT NULL
	shuffleanswers	smallint	NOT NULL
	correctfeedback	text
	correctfeedbackformat	smallint	NOT NULL
	partiallycorrectfeedback	text
	partiallycorrectfeedbackformat	smallint	NOT NULL
	incorrectfeedback	text
	incorrectfeedbackformat	smallint	NOT NULL
	answernumbering	character varying(10)	NOT NULL DEFAULT 'abc'::character varying
	shownumcorrect	smallint	NOT NULL

mdl_question_calculated_options Indexes
Index Name	Definition
mdl_quescalcopti_que_ix	CREATE INDEX mdl_quescalcopti_que_ix ON mdl_question_calculated_options USING btree (question)

Index - Schema public

Table: mdl_question_categories

Categories are for grouping questions

mdl_question_categories Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	contextid	bigint	NOT NULL
	info	text	NOT NULL
	infoformat	smallint	NOT NULL
	stamp	character varying(255)	NOT NULL DEFAULT ''::character varying
	parent	bigint	NOT NULL
	sortorder	bigint	NOT NULL DEFAULT 999

mdl_question_categories Indexes
Index Name	Definition
mdl_quescate_con_ix	CREATE INDEX mdl_quescate_con_ix ON mdl_question_categories USING btree (contextid)
mdl_quescate_par_ix	CREATE INDEX mdl_quescate_par_ix ON mdl_question_categories USING btree (parent)

Index - Schema public

Table: mdl_question_dataset_definitions

Organises and stores properties for dataset items

mdl_question_dataset_definitions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	category	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	type	bigint	NOT NULL
	options	character varying(255)	NOT NULL DEFAULT ''::character varying
	itemcount	bigint	NOT NULL

mdl_question_dataset_definitions Indexes
Index Name	Definition
mdl_quesdatadefi_cat_ix	CREATE INDEX mdl_quesdatadefi_cat_ix ON mdl_question_dataset_definitions USING btree (category)

Index - Schema public

Table: mdl_question_dataset_items

Individual dataset items

mdl_question_dataset_items Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	definition	bigint	NOT NULL
	itemnumber	bigint	NOT NULL
	value	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_question_dataset_items Indexes
Index Name	Definition
mdl_quesdataitem_def_ix	CREATE INDEX mdl_quesdataitem_def_ix ON mdl_question_dataset_items USING btree (definition)

Index - Schema public

Table: mdl_question_datasets

Many-many relation between questions and dataset definitions

mdl_question_datasets Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	datasetdefinition	bigint	NOT NULL

mdl_question_datasets Indexes
Index Name	Definition
mdl_quesdata_dat_ix	CREATE INDEX mdl_quesdata_dat_ix ON mdl_question_datasets USING btree (datasetdefinition)
mdl_quesdata_que_ix	CREATE INDEX mdl_quesdata_que_ix ON mdl_question_datasets USING btree (question)
mdl_quesdata_quedat_ix	CREATE INDEX mdl_quesdata_quedat_ix ON mdl_question_datasets USING btree (question, datasetdefinition)

Index - Schema public

Table: mdl_question_hints

Stores the the part of the question definition that gives different feedback after each try in interactive and similar behaviours.

mdl_question_hints Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionid	bigint	NOT NULL
	hint	text	NOT NULL
	hintformat	smallint	NOT NULL
	shownumcorrect	smallint
	clearwrong	smallint
	options	character varying(255)

mdl_question_hints Indexes
Index Name	Definition
mdl_queshint_que_ix	CREATE INDEX mdl_queshint_que_ix ON mdl_question_hints USING btree (questionid)

Index - Schema public

Table: mdl_question_multianswer

Options for multianswer questions

mdl_question_multianswer Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	sequence	text	NOT NULL

mdl_question_multianswer Indexes
Index Name	Definition
mdl_quesmult_que_ix	CREATE INDEX mdl_quesmult_que_ix ON mdl_question_multianswer USING btree (question)

Index - Schema public

Table: mdl_question_numerical

Options for numerical questions.

mdl_question_numerical Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	answer	bigint	NOT NULL
	tolerance	character varying(255)	NOT NULL DEFAULT '0.0'::character varying

mdl_question_numerical Indexes
Index Name	Definition
mdl_quesnume_ans_ix	CREATE INDEX mdl_quesnume_ans_ix ON mdl_question_numerical USING btree (answer)
mdl_quesnume_que_ix	CREATE INDEX mdl_quesnume_que_ix ON mdl_question_numerical USING btree (question)

Index - Schema public

Table: mdl_question_numerical_options

Options for questions of type numerical This table is also used by the calculated question type

mdl_question_numerical_options Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	showunits	smallint	NOT NULL
	unitsleft	smallint	NOT NULL
	unitgradingtype	smallint	NOT NULL
	unitpenalty	numeric(12,7)	NOT NULL DEFAULT 0.1

mdl_question_numerical_options Indexes
Index Name	Definition
mdl_quesnumeopti_que_ix	CREATE INDEX mdl_quesnumeopti_que_ix ON mdl_question_numerical_options USING btree (question)

Index - Schema public

Table: mdl_question_numerical_units

Optional unit options for numerical questions. This table is also used by the calculated question type.

mdl_question_numerical_units Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	multiplier	numeric(40,20)	NOT NULL DEFAULT 1.00000000000000000000
	unit	character varying(50)	NOT NULL DEFAULT ''::character varying

mdl_question_numerical_units Indexes
Index Name	Definition
mdl_quesnumeunit_que_ix	CREATE INDEX mdl_quesnumeunit_que_ix ON mdl_question_numerical_units USING btree (question)

Index - Schema public

Table: mdl_question_randomsamatch

Info about a random short-answer matching question

mdl_question_randomsamatch Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	choose	bigint	NOT NULL DEFAULT 4

mdl_question_randomsamatch Indexes
Index Name	Definition
mdl_quesrand_que_ix	CREATE INDEX mdl_quesrand_que_ix ON mdl_question_randomsamatch USING btree (question)

Index - Schema public

Table: mdl_question_response_analysis

mdl_question_response_analysis Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	hashcode	character varying(40)	NOT NULL DEFAULT ''::character varying
	timemodified	bigint	NOT NULL
	questionid	bigint	NOT NULL
	subqid	character varying(100)	NOT NULL DEFAULT ''::character varying
	aid	character varying(100)
	response	text
	rcount	bigint
	credit	numeric(15,5)	NOT NULL

Index - Schema public

Table: mdl_question_sessions

Gives ids of the newest open and newest graded states

mdl_question_sessions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	attemptid	bigint	NOT NULL
	questionid	bigint	NOT NULL
	newest	bigint	NOT NULL
	newgraded	bigint	NOT NULL
	sumpenalty	numeric(12,7)	NOT NULL
	manualcomment	text	NOT NULL
	manualcommentformat	smallint	NOT NULL
	flagged	smallint	NOT NULL

mdl_question_sessions Indexes
Index Name	Definition
mdl_quessess_att_ix	CREATE INDEX mdl_quessess_att_ix ON mdl_question_sessions USING btree (attemptid)
mdl_quessess_new2_ix	CREATE INDEX mdl_quessess_new2_ix ON mdl_question_sessions USING btree (newgraded)
mdl_quessess_new_ix	CREATE INDEX mdl_quessess_new_ix ON mdl_question_sessions USING btree (newest)
mdl_quessess_que_ix	CREATE INDEX mdl_quessess_que_ix ON mdl_question_sessions USING btree (questionid)

Index - Schema public

Table: mdl_question_states

Stores user responses to an attempt, and percentage grades

mdl_question_states Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	attempt	bigint	NOT NULL
	question	bigint	NOT NULL
	seq_number	integer	NOT NULL
	answer	text	NOT NULL
	timestamp	bigint	NOT NULL
	event	smallint	NOT NULL
	grade	numeric(12,7)	NOT NULL
	raw_grade	numeric(12,7)	NOT NULL
	penalty	numeric(12,7)	NOT NULL

mdl_question_states Indexes
Index Name	Definition
mdl_quesstat_att_ix	CREATE INDEX mdl_quesstat_att_ix ON mdl_question_states USING btree (attempt)
mdl_quesstat_que_ix	CREATE INDEX mdl_quesstat_que_ix ON mdl_question_states USING btree (question)

Index - Schema public

Table: mdl_question_statistics

mdl_question_statistics Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	hashcode	character varying(40)	NOT NULL DEFAULT ''::character varying
	timemodified	bigint	NOT NULL
	questionid	bigint	NOT NULL
	slot	bigint
	subquestion	smallint	NOT NULL
	s	bigint	NOT NULL
	effectiveweight	numeric(15,5)
	negcovar	smallint	NOT NULL
	discriminationindex	numeric(15,5)
	discriminativeefficiency	numeric(15,5)
	sd	numeric(15,10)
	facility	numeric(15,10)
	subquestions	text
	maxmark	numeric(12,7)
	positions	text
	randomguessscore	numeric(12,7)

Index - Schema public

Table: mdl_question_truefalse

Options for True-False questions

mdl_question_truefalse Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	question	bigint	NOT NULL
	trueanswer	bigint	NOT NULL
	falseanswer	bigint	NOT NULL

mdl_question_truefalse Indexes
Index Name	Definition
mdl_questrue_que_ix	CREATE INDEX mdl_questrue_que_ix ON mdl_question_truefalse USING btree (question)

Index - Schema public

Table: mdl_question_usages

This table's main purpose it to assign a unique id to each attempt at a set of questions by some part of Moodle. A question usage is made up of a number of question_attempts.

mdl_question_usages Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextid	bigint	NOT NULL
	component	character varying(255)	NOT NULL DEFAULT ''::character varying
	preferredbehaviour	character varying(32)	NOT NULL DEFAULT ''::character varying

mdl_question_usages Indexes
Index Name	Definition
mdl_quesusag_con_ix	CREATE INDEX mdl_quesusag_con_ix ON mdl_question_usages USING btree (contextid)

Index - Schema public

Table: mdl_quiz

The settings for each quiz.

mdl_quiz Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	timeopen	bigint	NOT NULL
	timeclose	bigint	NOT NULL
	timelimit	bigint	NOT NULL
	overduehandling	character varying(16)	NOT NULL DEFAULT 'autoabandon'::character varying
	graceperiod	bigint	NOT NULL
	preferredbehaviour	character varying(32)	NOT NULL DEFAULT ''::character varying
	attempts	integer	NOT NULL
	attemptonlast	smallint	NOT NULL
	grademethod	smallint	NOT NULL DEFAULT 1
	decimalpoints	smallint	NOT NULL DEFAULT 2
	questiondecimalpoints	smallint	NOT NULL DEFAULT (-1)
	reviewattempt	integer	NOT NULL
	reviewcorrectness	integer	NOT NULL
	reviewmarks	integer	NOT NULL
	reviewspecificfeedback	integer	NOT NULL
	reviewgeneralfeedback	integer	NOT NULL
	reviewrightanswer	integer	NOT NULL
	reviewoverallfeedback	integer	NOT NULL
	questionsperpage	bigint	NOT NULL
	navmethod	character varying(16)	NOT NULL DEFAULT 'free'::character varying
	shufflequestions	smallint	NOT NULL
	shuffleanswers	smallint	NOT NULL
	questions	text	NOT NULL
	sumgrades	numeric(10,5)	NOT NULL
	grade	numeric(10,5)	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	password	character varying(255)	NOT NULL DEFAULT ''::character varying
	subnet	character varying(255)	NOT NULL DEFAULT ''::character varying
	browsersecurity	character varying(32)	NOT NULL DEFAULT ''::character varying
	delay1	bigint	NOT NULL
	delay2	bigint	NOT NULL
	showuserpicture	smallint	NOT NULL
	showblocks	smallint	NOT NULL

mdl_quiz Indexes
Index Name	Definition
mdl_quiz_cou_ix	CREATE INDEX mdl_quiz_cou_ix ON mdl_quiz USING btree (course)

Index - Schema public

Table: mdl_quiz_attempts

Stores users attempts at quizzes.

mdl_quiz_attempts Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	quiz	bigint	NOT NULL
	userid	bigint	NOT NULL
	attempt	integer	NOT NULL
	uniqueid	bigint	NOT NULL
	layout	text	NOT NULL
	currentpage	bigint	NOT NULL
	preview	smallint	NOT NULL
	state	character varying(16)	NOT NULL DEFAULT 'inprogress'::character varying
	timestart	bigint	NOT NULL
	timefinish	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	timecheckstate	bigint
	sumgrades	numeric(10,5)
	needsupgradetonewqe	smallint	NOT NULL

mdl_quiz_attempts Indexes
Index Name	Definition
mdl_quizatte_qui_ix	CREATE INDEX mdl_quizatte_qui_ix ON mdl_quiz_attempts USING btree (quiz)
mdl_quizatte_statim_ix	CREATE INDEX mdl_quizatte_statim_ix ON mdl_quiz_attempts USING btree (state, timecheckstate)
mdl_quizatte_use_ix	CREATE INDEX mdl_quizatte_use_ix ON mdl_quiz_attempts USING btree (userid)

Index - Schema public

Table: mdl_quiz_feedback

Feedback given to students based on which grade band their overall score lies.

mdl_quiz_feedback Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	quizid	bigint	NOT NULL
	feedbacktext	text	NOT NULL
	feedbacktextformat	smallint	NOT NULL
	mingrade	numeric(10,5)	NOT NULL
	maxgrade	numeric(10,5)	NOT NULL

mdl_quiz_feedback Indexes
Index Name	Definition
mdl_quizfeed_qui_ix	CREATE INDEX mdl_quizfeed_qui_ix ON mdl_quiz_feedback USING btree (quizid)

Index - Schema public

Table: mdl_quiz_grades

Stores the overall grade for each user on the quiz, based on their various attempts and the quiz.grademethod setting.

mdl_quiz_grades Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	quiz	bigint	NOT NULL
	userid	bigint	NOT NULL
	grade	numeric(10,5)	NOT NULL
	timemodified	bigint	NOT NULL

mdl_quiz_grades Indexes
Index Name	Definition
mdl_quizgrad_qui_ix	CREATE INDEX mdl_quizgrad_qui_ix ON mdl_quiz_grades USING btree (quiz)
mdl_quizgrad_use_ix	CREATE INDEX mdl_quizgrad_use_ix ON mdl_quiz_grades USING btree (userid)

Index - Schema public

Table: mdl_quiz_overrides

The overrides to quiz settings on a per-user and per-group basis.

mdl_quiz_overrides Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	quiz	bigint	NOT NULL
	groupid	bigint
	userid	bigint
	timeopen	bigint
	timeclose	bigint
	timelimit	bigint
	attempts	integer
	password	character varying(255)

mdl_quiz_overrides Indexes
Index Name	Definition
mdl_quizover_gro_ix	CREATE INDEX mdl_quizover_gro_ix ON mdl_quiz_overrides USING btree (groupid)
mdl_quizover_qui_ix	CREATE INDEX mdl_quizover_qui_ix ON mdl_quiz_overrides USING btree (quiz)
mdl_quizover_use_ix	CREATE INDEX mdl_quizover_use_ix ON mdl_quiz_overrides USING btree (userid)

Index - Schema public

Table: mdl_quiz_overview_regrades

This table records which question attempts need regrading and the grade they will be regraded to.

mdl_quiz_overview_regrades Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	questionusageid	bigint	NOT NULL
	slot	bigint	NOT NULL
	newfraction	numeric(12,7)
	oldfraction	numeric(12,7)
	regraded	smallint	NOT NULL
	timemodified	bigint	NOT NULL

Index - Schema public

Table: mdl_quiz_question_instances

Stores the maximum possible grade (weight) for each question used in a quiz.

mdl_quiz_question_instances Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	quiz	bigint	NOT NULL
	question	bigint	NOT NULL
	grade	numeric(12,7)	NOT NULL

mdl_quiz_question_instances Indexes
Index Name	Definition
mdl_quizquesinst_que_ix	CREATE INDEX mdl_quizquesinst_que_ix ON mdl_quiz_question_instances USING btree (question)
mdl_quizquesinst_qui_ix	CREATE INDEX mdl_quizquesinst_qui_ix ON mdl_quiz_question_instances USING btree (quiz)

Index - Schema public

Table: mdl_quiz_reports

Lists all the installed quiz reports and their display order and so on. No need to worry about deleting old records. Only records with an equivalent directory are displayed.

mdl_quiz_reports Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)
	displayorder	bigint	NOT NULL
	capability	character varying(255)

Index - Schema public

Table: mdl_quiz_statistics

mdl_quiz_statistics Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	hashcode	character varying(40)	NOT NULL DEFAULT ''::character varying
	whichattempts	smallint	NOT NULL
	timemodified	bigint	NOT NULL
	firstattemptscount	bigint	NOT NULL
	highestattemptscount	bigint	NOT NULL
	lastattemptscount	bigint	NOT NULL
	allattemptscount	bigint	NOT NULL
	firstattemptsavg	numeric(15,5)
	highestattemptsavg	numeric(15,5)
	lastattemptsavg	numeric(15,5)
	allattemptsavg	numeric(15,5)
	median	numeric(15,5)
	standarddeviation	numeric(15,5)
	skewness	numeric(15,10)
	kurtosis	numeric(15,5)
	cic	numeric(15,10)
	errorratio	numeric(15,10)
	standarderror	numeric(15,10)

Index - Schema public

Table: mdl_rating

moodle ratings

mdl_rating Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextid	bigint	NOT NULL
	component	character varying(100)	NOT NULL DEFAULT ''::character varying
	ratingarea	character varying(50)	NOT NULL DEFAULT ''::character varying
	itemid	bigint	NOT NULL
	scaleid	bigint	NOT NULL
	rating	bigint	NOT NULL
	userid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_rating Indexes
Index Name	Definition
mdl_rati_comratconite_ix	CREATE INDEX mdl_rati_comratconite_ix ON mdl_rating USING btree (component, ratingarea, contextid, itemid)
mdl_rati_con_ix	CREATE INDEX mdl_rati_con_ix ON mdl_rating USING btree (contextid)
mdl_rati_use_ix	CREATE INDEX mdl_rati_use_ix ON mdl_rating USING btree (userid)

Index - Schema public

Table: mdl_registration_hubs

hub where the site is registered on with their associated token

mdl_registration_hubs Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	token	character varying(255)	NOT NULL DEFAULT ''::character varying
	hubname	character varying(255)	NOT NULL DEFAULT ''::character varying
	huburl	character varying(255)	NOT NULL DEFAULT ''::character varying
	confirmed	smallint	NOT NULL
	secret	character varying(255)

Index - Schema public

Table: mdl_repository

This table contains one entry for every configured external repository instance.

mdl_repository Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	type	character varying(255)	NOT NULL DEFAULT ''::character varying
	visible	smallint	DEFAULT 1
	sortorder	bigint	NOT NULL

Index - Schema public

Table: mdl_repository_instance_config

The config for intances

mdl_repository_instance_config Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	instanceid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	text

Index - Schema public

Table: mdl_repository_instances

This table contains one entry for every configured external repository instance.

mdl_repository_instances Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	typeid	bigint	NOT NULL
	userid	bigint	NOT NULL
	contextid	bigint	NOT NULL
	username	character varying(255)
	password	character varying(255)
	timecreated	bigint
	timemodified	bigint
	readonly	smallint	NOT NULL

Index - Schema public

Table: mdl_resource

Each record is one resource and its config data

mdl_resource Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint	NOT NULL
	tobemigrated	smallint	NOT NULL
	legacyfiles	smallint	NOT NULL
	legacyfileslast	bigint
	display	smallint	NOT NULL
	displayoptions	text
	filterfiles	smallint	NOT NULL
	revision	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_resource Indexes
Index Name	Definition
mdl_reso_cou_ix	CREATE INDEX mdl_reso_cou_ix ON mdl_resource USING btree (course)

Index - Schema public

Table: mdl_resource_old

backup of all old resource instances from 1.9

mdl_resource_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	type	character varying(30)	NOT NULL DEFAULT ''::character varying
	reference	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint	NOT NULL
	alltext	text	NOT NULL
	popup	text	NOT NULL
	options	character varying(255)	NOT NULL DEFAULT ''::character varying
	timemodified	bigint	NOT NULL
	oldid	bigint	NOT NULL
	cmid	bigint
	newmodule	character varying(50)
	newid	bigint
	migrated	bigint	NOT NULL

mdl_resource_old Indexes
Index Name	Definition
mdl_resoold_cmi_ix	CREATE INDEX mdl_resoold_cmi_ix ON mdl_resource_old USING btree (cmid)

Index - Schema public

Table: mdl_role

moodle roles

mdl_role Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	shortname	character varying(100)	NOT NULL DEFAULT ''::character varying
	description	text	NOT NULL
	sortorder	bigint	NOT NULL
	archetype	character varying(30)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_role_allow_assign

this defines what role can assign what role

mdl_role_allow_assign Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	roleid	bigint	NOT NULL
	allowassign	bigint	NOT NULL

mdl_role_allow_assign Indexes
Index Name	Definition
mdl_rolealloassi_all_ix	CREATE INDEX mdl_rolealloassi_all_ix ON mdl_role_allow_assign USING btree (allowassign)
mdl_rolealloassi_rol_ix	CREATE INDEX mdl_rolealloassi_rol_ix ON mdl_role_allow_assign USING btree (roleid)

Index - Schema public

Table: mdl_role_allow_override

this defines what role can override what role

mdl_role_allow_override Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	roleid	bigint	NOT NULL
	allowoverride	bigint	NOT NULL

mdl_role_allow_override Indexes
Index Name	Definition
mdl_rolealloover_all_ix	CREATE INDEX mdl_rolealloover_all_ix ON mdl_role_allow_override USING btree (allowoverride)
mdl_rolealloover_rol_ix	CREATE INDEX mdl_rolealloover_rol_ix ON mdl_role_allow_override USING btree (roleid)

Index - Schema public

Table: mdl_role_allow_switch

This table stores which which other roles a user is allowed to switch to if they have one role.

mdl_role_allow_switch Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	roleid	bigint	NOT NULL
	allowswitch	bigint	NOT NULL

mdl_role_allow_switch Indexes
Index Name	Definition
mdl_rolealloswit_all_ix	CREATE INDEX mdl_rolealloswit_all_ix ON mdl_role_allow_switch USING btree (allowswitch)
mdl_rolealloswit_rol_ix	CREATE INDEX mdl_rolealloswit_rol_ix ON mdl_role_allow_switch USING btree (roleid)

Index - Schema public

Table: mdl_role_assignments

assigning roles in different context

mdl_role_assignments Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	roleid	bigint	NOT NULL
	contextid	bigint	NOT NULL
	userid	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	modifierid	bigint	NOT NULL
	component	character varying(100)	NOT NULL DEFAULT ''::character varying
	itemid	bigint	NOT NULL
	sortorder	bigint	NOT NULL

mdl_role_assignments Indexes
Index Name	Definition
mdl_roleassi_comiteuse_ix	CREATE INDEX mdl_roleassi_comiteuse_ix ON mdl_role_assignments USING btree (component, itemid, userid)
mdl_roleassi_con_ix	CREATE INDEX mdl_roleassi_con_ix ON mdl_role_assignments USING btree (contextid)
mdl_roleassi_rol_ix	CREATE INDEX mdl_roleassi_rol_ix ON mdl_role_assignments USING btree (roleid)
mdl_roleassi_rolcon_ix	CREATE INDEX mdl_roleassi_rolcon_ix ON mdl_role_assignments USING btree (roleid, contextid)
mdl_roleassi_sor_ix	CREATE INDEX mdl_roleassi_sor_ix ON mdl_role_assignments USING btree (sortorder)
mdl_roleassi_use_ix	CREATE INDEX mdl_roleassi_use_ix ON mdl_role_assignments USING btree (userid)
mdl_roleassi_useconrol_ix	CREATE INDEX mdl_roleassi_useconrol_ix ON mdl_role_assignments USING btree (userid, contextid, roleid)

Index - Schema public

Table: mdl_role_capabilities

permission has to be signed, overriding a capability for a particular role in a particular context

mdl_role_capabilities Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	contextid	bigint	NOT NULL
	roleid	bigint	NOT NULL
	capability	character varying(255)	NOT NULL DEFAULT ''::character varying
	permission	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	modifierid	bigint	NOT NULL

mdl_role_capabilities Indexes
Index Name	Definition
mdl_rolecapa_cap_ix	CREATE INDEX mdl_rolecapa_cap_ix ON mdl_role_capabilities USING btree (capability)
mdl_rolecapa_con_ix	CREATE INDEX mdl_rolecapa_con_ix ON mdl_role_capabilities USING btree (contextid)
mdl_rolecapa_mod_ix	CREATE INDEX mdl_rolecapa_mod_ix ON mdl_role_capabilities USING btree (modifierid)
mdl_rolecapa_rol_ix	CREATE INDEX mdl_rolecapa_rol_ix ON mdl_role_capabilities USING btree (roleid)

Index - Schema public

Table: mdl_role_context_levels

Lists which roles can be assigned at which context levels. The assignment is allowed in the corresponding row is present in this table.

mdl_role_context_levels Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	roleid	bigint	NOT NULL
	contextlevel	bigint	NOT NULL

mdl_role_context_levels Indexes
Index Name	Definition
mdl_rolecontleve_rol_ix	CREATE INDEX mdl_rolecontleve_rol_ix ON mdl_role_context_levels USING btree (roleid)

Index - Schema public

Table: mdl_role_names

role names in native strings

mdl_role_names Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	roleid	bigint	NOT NULL
	contextid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_role_names Indexes
Index Name	Definition
mdl_rolename_con_ix	CREATE INDEX mdl_rolename_con_ix ON mdl_role_names USING btree (contextid)
mdl_rolename_rol_ix	CREATE INDEX mdl_rolename_rol_ix ON mdl_role_names USING btree (roleid)

Index - Schema public

Table: mdl_role_sortorder

sort order of course managers in a course

mdl_role_sortorder Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	roleid	bigint	NOT NULL
	contextid	bigint	NOT NULL
	sortoder	bigint	NOT NULL

mdl_role_sortorder Indexes
Index Name	Definition
mdl_rolesort_con_ix	CREATE INDEX mdl_rolesort_con_ix ON mdl_role_sortorder USING btree (contextid)
mdl_rolesort_rol_ix	CREATE INDEX mdl_rolesort_rol_ix ON mdl_role_sortorder USING btree (roleid)
mdl_rolesort_use_ix	CREATE INDEX mdl_rolesort_use_ix ON mdl_role_sortorder USING btree (userid)

Index - Schema public

Table: mdl_scale

Defines grading scales

mdl_scale Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	userid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	scale	text	NOT NULL
	description	text	NOT NULL
	descriptionformat	smallint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_scale Indexes
Index Name	Definition
mdl_scal_cou_ix	CREATE INDEX mdl_scal_cou_ix ON mdl_scale USING btree (courseid)

Index - Schema public

Table: mdl_scale_history

History table

mdl_scale_history Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	action	bigint	NOT NULL
	oldid	bigint	NOT NULL
	source	character varying(255)
	timemodified	bigint
	loggeduser	bigint
	courseid	bigint	NOT NULL
	userid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	scale	text	NOT NULL
	description	text	NOT NULL

mdl_scale_history Indexes
Index Name	Definition
mdl_scalhist_act_ix	CREATE INDEX mdl_scalhist_act_ix ON mdl_scale_history USING btree (action)
mdl_scalhist_cou_ix	CREATE INDEX mdl_scalhist_cou_ix ON mdl_scale_history USING btree (courseid)
mdl_scalhist_log_ix	CREATE INDEX mdl_scalhist_log_ix ON mdl_scale_history USING btree (loggeduser)
mdl_scalhist_old_ix	CREATE INDEX mdl_scalhist_old_ix ON mdl_scale_history USING btree (oldid)

Index - Schema public

Table: mdl_scorm

each table is one SCORM module and its configuration

mdl_scorm Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	scormtype	character varying(50)	NOT NULL DEFAULT 'local'::character varying
	reference	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	version	character varying(9)	NOT NULL DEFAULT ''::character varying
	maxgrade	double precision	NOT NULL
	grademethod	smallint	NOT NULL
	whatgrade	bigint	NOT NULL
	maxattempt	bigint	NOT NULL DEFAULT 1
	forcecompleted	smallint	NOT NULL DEFAULT 1
	forcenewattempt	smallint	NOT NULL
	lastattemptlock	smallint	NOT NULL
	displayattemptstatus	smallint	NOT NULL DEFAULT 1
	displaycoursestructure	smallint	NOT NULL DEFAULT 1
	updatefreq	smallint	NOT NULL
	sha1hash	character varying(40)
	md5hash	character varying(32)	NOT NULL DEFAULT ''::character varying
	revision	bigint	NOT NULL
	launch	bigint	NOT NULL
	skipview	smallint	NOT NULL DEFAULT 1
	hidebrowse	smallint	NOT NULL
	hidetoc	smallint	NOT NULL
	auto	smallint	NOT NULL
	popup	smallint	NOT NULL
	options	character varying(255)	NOT NULL DEFAULT ''::character varying
	width	bigint	NOT NULL DEFAULT 100
	height	bigint	NOT NULL DEFAULT 600
	timeopen	bigint	NOT NULL
	timeclose	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	completionstatusrequired	smallint
	completionscorerequired	smallint
	nav	smallint	NOT NULL DEFAULT 1
	navpositionleft	bigint	DEFAULT (-100)
	navpositiontop	bigint	DEFAULT (-100)

mdl_scorm Indexes
Index Name	Definition
mdl_scor_cou_ix	CREATE INDEX mdl_scor_cou_ix ON mdl_scorm USING btree (course)

Index - Schema public

Table: mdl_scorm_aicc_session

Used by AICC HACP to store session information

mdl_scorm_aicc_session Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	scormid	bigint	NOT NULL
	hacpsession	character varying(255)	NOT NULL DEFAULT ''::character varying
	scoid	bigint
	scormmode	character varying(50)
	scormstatus	character varying(255)
	attempt	bigint
	lessonstatus	character varying(255)
	sessiontime	character varying(255)
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_scorm_aicc_session Indexes
Index Name	Definition
mdl_scoraiccsess_sco_ix	CREATE INDEX mdl_scoraiccsess_sco_ix ON mdl_scorm_aicc_session USING btree (scormid)
mdl_scoraiccsess_use_ix	CREATE INDEX mdl_scoraiccsess_use_ix ON mdl_scorm_aicc_session USING btree (userid)

Index - Schema public

Table: mdl_scorm_scoes

each SCO part of the SCORM module

mdl_scorm_scoes Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	scorm	bigint	NOT NULL
	manifest	character varying(255)	NOT NULL DEFAULT ''::character varying
	organization	character varying(255)	NOT NULL DEFAULT ''::character varying
	parent	character varying(255)	NOT NULL DEFAULT ''::character varying
	identifier	character varying(255)	NOT NULL DEFAULT ''::character varying
	launch	text	NOT NULL
	scormtype	character varying(5)	NOT NULL DEFAULT ''::character varying
	title	character varying(255)	NOT NULL DEFAULT ''::character varying
	sortorder	bigint	NOT NULL

mdl_scorm_scoes Indexes
Index Name	Definition
mdl_scorscoe_sco_ix	CREATE INDEX mdl_scorscoe_sco_ix ON mdl_scorm_scoes USING btree (scorm)

Index - Schema public

Table: mdl_scorm_scoes_data

Contains variable data get from packages

mdl_scorm_scoes_data Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	scoid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	text	NOT NULL

mdl_scorm_scoes_data Indexes
Index Name	Definition
mdl_scorscoedata_sco_ix	CREATE INDEX mdl_scorscoedata_sco_ix ON mdl_scorm_scoes_data USING btree (scoid)

Index - Schema public

Table: mdl_scorm_scoes_track

to track SCOes

mdl_scorm_scoes_track Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	scormid	bigint	NOT NULL
	scoid	bigint	NOT NULL
	attempt	bigint	NOT NULL DEFAULT 1
	element	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	text	NOT NULL
	timemodified	bigint	NOT NULL

mdl_scorm_scoes_track Indexes
Index Name	Definition
mdl_scorscoetrac_ele_ix	CREATE INDEX mdl_scorscoetrac_ele_ix ON mdl_scorm_scoes_track USING btree (element)
mdl_scorscoetrac_sco2_ix	CREATE INDEX mdl_scorscoetrac_sco2_ix ON mdl_scorm_scoes_track USING btree (scoid)
mdl_scorscoetrac_sco_ix	CREATE INDEX mdl_scorscoetrac_sco_ix ON mdl_scorm_scoes_track USING btree (scormid)
mdl_scorscoetrac_use_ix	CREATE INDEX mdl_scorscoetrac_use_ix ON mdl_scorm_scoes_track USING btree (userid)

Index - Schema public

Table: mdl_scorm_seq_mapinfo

SCORM2004 objective mapinfo description

mdl_scorm_seq_mapinfo Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	scoid	bigint	NOT NULL
	objectiveid	bigint	NOT NULL
	targetobjectiveid	bigint	NOT NULL
	readsatisfiedstatus	smallint	NOT NULL DEFAULT 1
	readnormalizedmeasure	smallint	NOT NULL DEFAULT 1
	writesatisfiedstatus	smallint	NOT NULL
	writenormalizedmeasure	smallint	NOT NULL

mdl_scorm_seq_mapinfo Indexes
Index Name	Definition
mdl_scorseqmapi_obj_ix	CREATE INDEX mdl_scorseqmapi_obj_ix ON mdl_scorm_seq_mapinfo USING btree (objectiveid)
mdl_scorseqmapi_sco_ix	CREATE INDEX mdl_scorseqmapi_sco_ix ON mdl_scorm_seq_mapinfo USING btree (scoid)

Index - Schema public

Table: mdl_scorm_seq_objective

SCORM2004 objective description

mdl_scorm_seq_objective Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	scoid	bigint	NOT NULL
	primaryobj	smallint	NOT NULL
	objectiveid	character varying(255)	NOT NULL DEFAULT ''::character varying
	satisfiedbymeasure	smallint	NOT NULL DEFAULT 1
	minnormalizedmeasure	real	NOT NULL DEFAULT 0.0000

mdl_scorm_seq_objective Indexes
Index Name	Definition
mdl_scorseqobje_sco_ix	CREATE INDEX mdl_scorseqobje_sco_ix ON mdl_scorm_seq_objective USING btree (scoid)

Index - Schema public

Table: mdl_scorm_seq_rolluprule

SCORM2004 sequencing rule

mdl_scorm_seq_rolluprule Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	scoid	bigint	NOT NULL
	childactivityset	character varying(15)	NOT NULL DEFAULT ''::character varying
	minimumcount	bigint	NOT NULL
	minimumpercent	real	NOT NULL DEFAULT 0.0000
	conditioncombination	character varying(3)	NOT NULL DEFAULT 'all'::character varying
	action	character varying(15)	NOT NULL DEFAULT ''::character varying

mdl_scorm_seq_rolluprule Indexes
Index Name	Definition
mdl_scorseqroll_sco_ix	CREATE INDEX mdl_scorseqroll_sco_ix ON mdl_scorm_seq_rolluprule USING btree (scoid)

Index - Schema public

Table: mdl_scorm_seq_rolluprulecond

SCORM2004 sequencing rule

mdl_scorm_seq_rolluprulecond Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	scoid	bigint	NOT NULL
	rollupruleid	bigint	NOT NULL
	operator	character varying(5)	NOT NULL DEFAULT 'noOp'::character varying
	cond	character varying(25)	NOT NULL DEFAULT ''::character varying

mdl_scorm_seq_rolluprulecond Indexes
Index Name	Definition
mdl_scorseqroll_rol_ix	CREATE INDEX mdl_scorseqroll_rol_ix ON mdl_scorm_seq_rolluprulecond USING btree (rollupruleid)
mdl_scorseqroll_sco2_ix	CREATE INDEX mdl_scorseqroll_sco2_ix ON mdl_scorm_seq_rolluprulecond USING btree (scoid)

Index - Schema public

Table: mdl_scorm_seq_rulecond

SCORM2004 rule condition

mdl_scorm_seq_rulecond Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	scoid	bigint	NOT NULL
	ruleconditionsid	bigint	NOT NULL
	refrencedobjective	character varying(255)	NOT NULL DEFAULT ''::character varying
	measurethreshold	real	NOT NULL DEFAULT 0.0000
	operator	character varying(5)	NOT NULL DEFAULT 'noOp'::character varying
	cond	character varying(30)	NOT NULL DEFAULT 'always'::character varying

mdl_scorm_seq_rulecond Indexes
Index Name	Definition
mdl_scorseqrule_rul_ix	CREATE INDEX mdl_scorseqrule_rul_ix ON mdl_scorm_seq_rulecond USING btree (ruleconditionsid)
mdl_scorseqrule_sco2_ix	CREATE INDEX mdl_scorseqrule_sco2_ix ON mdl_scorm_seq_rulecond USING btree (scoid)

Index - Schema public

Table: mdl_scorm_seq_ruleconds

SCORM2004 rule conditions

mdl_scorm_seq_ruleconds Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	scoid	bigint	NOT NULL
	conditioncombination	character varying(3)	NOT NULL DEFAULT 'all'::character varying
	ruletype	smallint	NOT NULL
	action	character varying(25)	NOT NULL DEFAULT ''::character varying

mdl_scorm_seq_ruleconds Indexes
Index Name	Definition
mdl_scorseqrule_sco_ix	CREATE INDEX mdl_scorseqrule_sco_ix ON mdl_scorm_seq_ruleconds USING btree (scoid)

Index - Schema public

Table: mdl_sessions

Database based session storage - now recommended

mdl_sessions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	state	bigint	NOT NULL
	sid	character varying(128)	NOT NULL DEFAULT ''::character varying
	userid	bigint	NOT NULL
	sessdata	text
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	firstip	character varying(45)
	lastip	character varying(45)

mdl_sessions Indexes
Index Name	Definition
mdl_sess_sta_ix	CREATE INDEX mdl_sess_sta_ix ON mdl_sessions USING btree (state)
mdl_sess_tim2_ix	CREATE INDEX mdl_sess_tim2_ix ON mdl_sessions USING btree (timemodified)
mdl_sess_tim_ix	CREATE INDEX mdl_sess_tim_ix ON mdl_sessions USING btree (timecreated)
mdl_sess_use_ix	CREATE INDEX mdl_sess_use_ix ON mdl_sessions USING btree (userid)

Index - Schema public

Table: mdl_stats_daily

to accumulate daily stats

mdl_stats_daily Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	timeend	bigint	NOT NULL
	roleid	bigint	NOT NULL
	stattype	character varying(20)	NOT NULL DEFAULT 'activity'::character varying
	stat1	bigint	NOT NULL
	stat2	bigint	NOT NULL

mdl_stats_daily Indexes
Index Name	Definition
mdl_statdail_cou_ix	CREATE INDEX mdl_statdail_cou_ix ON mdl_stats_daily USING btree (courseid)
mdl_statdail_rol_ix	CREATE INDEX mdl_statdail_rol_ix ON mdl_stats_daily USING btree (roleid)
mdl_statdail_tim_ix	CREATE INDEX mdl_statdail_tim_ix ON mdl_stats_daily USING btree (timeend)

Index - Schema public

Table: mdl_stats_monthly

To accumulate monthly stats

mdl_stats_monthly Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	timeend	bigint	NOT NULL
	roleid	bigint	NOT NULL
	stattype	character varying(20)	NOT NULL DEFAULT 'activity'::character varying
	stat1	bigint	NOT NULL
	stat2	bigint	NOT NULL

mdl_stats_monthly Indexes
Index Name	Definition
mdl_statmont_cou_ix	CREATE INDEX mdl_statmont_cou_ix ON mdl_stats_monthly USING btree (courseid)
mdl_statmont_rol_ix	CREATE INDEX mdl_statmont_rol_ix ON mdl_stats_monthly USING btree (roleid)
mdl_statmont_tim_ix	CREATE INDEX mdl_statmont_tim_ix ON mdl_stats_monthly USING btree (timeend)

Index - Schema public

Table: mdl_stats_user_daily

To accumulate daily stats per course/user

mdl_stats_user_daily Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	userid	bigint	NOT NULL
	roleid	bigint	NOT NULL
	timeend	bigint	NOT NULL
	statsreads	bigint	NOT NULL
	statswrites	bigint	NOT NULL
	stattype	character varying(30)	NOT NULL DEFAULT ''::character varying

mdl_stats_user_daily Indexes
Index Name	Definition
mdl_statuserdail_cou_ix	CREATE INDEX mdl_statuserdail_cou_ix ON mdl_stats_user_daily USING btree (courseid)
mdl_statuserdail_rol_ix	CREATE INDEX mdl_statuserdail_rol_ix ON mdl_stats_user_daily USING btree (roleid)
mdl_statuserdail_tim_ix	CREATE INDEX mdl_statuserdail_tim_ix ON mdl_stats_user_daily USING btree (timeend)
mdl_statuserdail_use_ix	CREATE INDEX mdl_statuserdail_use_ix ON mdl_stats_user_daily USING btree (userid)

Index - Schema public

Table: mdl_stats_user_monthly

To accumulate monthly stats per course/user

mdl_stats_user_monthly Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	userid	bigint	NOT NULL
	roleid	bigint	NOT NULL
	timeend	bigint	NOT NULL
	statsreads	bigint	NOT NULL
	statswrites	bigint	NOT NULL
	stattype	character varying(30)	NOT NULL DEFAULT ''::character varying

mdl_stats_user_monthly Indexes
Index Name	Definition
mdl_statusermont_cou_ix	CREATE INDEX mdl_statusermont_cou_ix ON mdl_stats_user_monthly USING btree (courseid)
mdl_statusermont_rol_ix	CREATE INDEX mdl_statusermont_rol_ix ON mdl_stats_user_monthly USING btree (roleid)
mdl_statusermont_tim_ix	CREATE INDEX mdl_statusermont_tim_ix ON mdl_stats_user_monthly USING btree (timeend)
mdl_statusermont_use_ix	CREATE INDEX mdl_statusermont_use_ix ON mdl_stats_user_monthly USING btree (userid)

Index - Schema public

Table: mdl_stats_user_weekly

To accumulate weekly stats per course/user

mdl_stats_user_weekly Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	userid	bigint	NOT NULL
	roleid	bigint	NOT NULL
	timeend	bigint	NOT NULL
	statsreads	bigint	NOT NULL
	statswrites	bigint	NOT NULL
	stattype	character varying(30)	NOT NULL DEFAULT ''::character varying

mdl_stats_user_weekly Indexes
Index Name	Definition
mdl_statuserweek_cou_ix	CREATE INDEX mdl_statuserweek_cou_ix ON mdl_stats_user_weekly USING btree (courseid)
mdl_statuserweek_rol_ix	CREATE INDEX mdl_statuserweek_rol_ix ON mdl_stats_user_weekly USING btree (roleid)
mdl_statuserweek_tim_ix	CREATE INDEX mdl_statuserweek_tim_ix ON mdl_stats_user_weekly USING btree (timeend)
mdl_statuserweek_use_ix	CREATE INDEX mdl_statuserweek_use_ix ON mdl_stats_user_weekly USING btree (userid)

Index - Schema public

Table: mdl_stats_weekly

To accumulate weekly stats

mdl_stats_weekly Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	courseid	bigint	NOT NULL
	timeend	bigint	NOT NULL
	roleid	bigint	NOT NULL
	stattype	character varying(20)	NOT NULL DEFAULT 'activity'::character varying
	stat1	bigint	NOT NULL
	stat2	bigint	NOT NULL

mdl_stats_weekly Indexes
Index Name	Definition
mdl_statweek_cou_ix	CREATE INDEX mdl_statweek_cou_ix ON mdl_stats_weekly USING btree (courseid)
mdl_statweek_rol_ix	CREATE INDEX mdl_statweek_rol_ix ON mdl_stats_weekly USING btree (roleid)
mdl_statweek_tim_ix	CREATE INDEX mdl_statweek_tim_ix ON mdl_stats_weekly USING btree (timeend)

Index - Schema public

Table: mdl_survey

Each record is one SURVEY module with its configuration

mdl_survey Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	template	bigint	NOT NULL
	days	integer	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text	NOT NULL
	introformat	smallint	NOT NULL
	questions	character varying(255)	NOT NULL DEFAULT ''::character varying

mdl_survey Indexes
Index Name	Definition
mdl_surv_cou_ix	CREATE INDEX mdl_surv_cou_ix ON mdl_survey USING btree (course)

Index - Schema public

Table: mdl_survey_analysis

text about each survey submission

mdl_survey_analysis Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	survey	bigint	NOT NULL
	userid	bigint	NOT NULL
	notes	text	NOT NULL

mdl_survey_analysis Indexes
Index Name	Definition
mdl_survanal_sur_ix	CREATE INDEX mdl_survanal_sur_ix ON mdl_survey_analysis USING btree (survey)
mdl_survanal_use_ix	CREATE INDEX mdl_survanal_use_ix ON mdl_survey_analysis USING btree (userid)

Index - Schema public

Table: mdl_survey_answers

the answers to each questions filled by the users

mdl_survey_answers Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	survey	bigint	NOT NULL
	question	bigint	NOT NULL
	time	bigint	NOT NULL
	answer1	text	NOT NULL
	answer2	text	NOT NULL

mdl_survey_answers Indexes
Index Name	Definition
mdl_survansw_que_ix	CREATE INDEX mdl_survansw_que_ix ON mdl_survey_answers USING btree (question)
mdl_survansw_sur_ix	CREATE INDEX mdl_survansw_sur_ix ON mdl_survey_answers USING btree (survey)
mdl_survansw_use_ix	CREATE INDEX mdl_survansw_use_ix ON mdl_survey_answers USING btree (userid)

Index - Schema public

Table: mdl_survey_questions

the questions conforming one survey

mdl_survey_questions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	text	character varying(255)	NOT NULL DEFAULT ''::character varying
	shorttext	character varying(30)	NOT NULL DEFAULT ''::character varying
	multi	character varying(100)	NOT NULL DEFAULT ''::character varying
	intro	character varying(50)	NOT NULL DEFAULT ''::character varying
	type	smallint	NOT NULL
	options	text

Index - Schema public

Table: mdl_tag

Tag table - this generic table will replace the old "tags" table.

mdl_tag Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	rawname	character varying(255)	NOT NULL DEFAULT ''::character varying
	tagtype	character varying(255)
	description	text
	descriptionformat	smallint	NOT NULL
	flag	smallint
	timemodified	bigint

mdl_tag Indexes
Index Name	Definition
mdl_tag_use_ix	CREATE INDEX mdl_tag_use_ix ON mdl_tag USING btree (userid)

Index - Schema public

Table: mdl_tag_correlation

The rationale for the 'tag_correlation' table is performance. It works as a cache for a potentially heavy load query done at the 'tag_instance' table. So, the 'tag_correlation' table stores redundant information derived from the 'tag_instance' ta

mdl_tag_correlation Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	tagid	bigint	NOT NULL
	correlatedtags	text	NOT NULL

mdl_tag_correlation Indexes
Index Name	Definition
mdl_tagcorr_tag_ix	CREATE INDEX mdl_tagcorr_tag_ix ON mdl_tag_correlation USING btree (tagid)

Index - Schema public

Table: mdl_tag_instance

tag_instance table holds the information of associations between tags and other items

mdl_tag_instance Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	tagid	bigint	NOT NULL
	itemtype	character varying(255)	NOT NULL DEFAULT ''::character varying
	itemid	bigint	NOT NULL
	tiuserid	bigint	NOT NULL
	ordering	bigint
	timemodified	bigint	NOT NULL

mdl_tag_instance Indexes
Index Name	Definition
mdl_taginst_tag_ix	CREATE INDEX mdl_taginst_tag_ix ON mdl_tag_instance USING btree (tagid)

Index - Schema public

Table: mdl_timezone

Rules for calculating local wall clock time for users

mdl_timezone Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(100)	NOT NULL DEFAULT ''::character varying
	year	bigint	NOT NULL
	tzrule	character varying(20)	NOT NULL DEFAULT ''::character varying
	gmtoff	bigint	NOT NULL
	dstoff	bigint	NOT NULL
	dst_month	smallint	NOT NULL
	dst_startday	smallint	NOT NULL
	dst_weekday	smallint	NOT NULL
	dst_skipweeks	smallint	NOT NULL
	dst_time	character varying(6)	NOT NULL DEFAULT '00:00'::character varying
	std_month	smallint	NOT NULL
	std_startday	smallint	NOT NULL
	std_weekday	smallint	NOT NULL
	std_skipweeks	smallint	NOT NULL
	std_time	character varying(6)	NOT NULL DEFAULT '00:00'::character varying

Index - Schema public

Table: mdl_tool_customlang

Contains the working checkout of all strings and their customization

mdl_tool_customlang Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	lang	character varying(20)	NOT NULL DEFAULT ''::character varying
	componentid	bigint	NOT NULL
	stringid	character varying(255)	NOT NULL DEFAULT ''::character varying
	original	text	NOT NULL
	master	text
	local	text
	timemodified	bigint	NOT NULL
	timecustomized	bigint
	outdated	smallint
	modified	smallint

mdl_tool_customlang Indexes
Index Name	Definition
mdl_toolcust_com_ix	CREATE INDEX mdl_toolcust_com_ix ON mdl_tool_customlang USING btree (componentid)

Index - Schema public

Table: mdl_tool_customlang_components

Contains the list of all installed plugins that provide their own language pack

mdl_tool_customlang_components Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	version	character varying(255)

Index - Schema public

Table: mdl_upgrade_log

Upgrade logging

mdl_upgrade_log Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	type	bigint	NOT NULL
	plugin	character varying(100)
	version	character varying(100)
	targetversion	character varying(100)
	info	character varying(255)	NOT NULL DEFAULT ''::character varying
	details	text
	backtrace	text
	userid	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_upgrade_log Indexes
Index Name	Definition
mdl_upgrlog_tim_ix	CREATE INDEX mdl_upgrlog_tim_ix ON mdl_upgrade_log USING btree (timemodified)
mdl_upgrlog_typtim_ix	CREATE INDEX mdl_upgrlog_typtim_ix ON mdl_upgrade_log USING btree (type, timemodified)
mdl_upgrlog_use_ix	CREATE INDEX mdl_upgrlog_use_ix ON mdl_upgrade_log USING btree (userid)

Index - Schema public

Table: mdl_url

each record is one url resource

mdl_url Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint	NOT NULL
	externalurl	text	NOT NULL
	display	smallint	NOT NULL
	displayoptions	text
	parameters	text
	timemodified	bigint	NOT NULL

mdl_url Indexes
Index Name	Definition
mdl_url_cou_ix	CREATE INDEX mdl_url_cou_ix ON mdl_url USING btree (course)

Index - Schema public

Table: mdl_user

One record for each person

mdl_user Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	auth	character varying(20)	NOT NULL DEFAULT 'manual'::character varying
	confirmed	smallint	NOT NULL
	policyagreed	smallint	NOT NULL
	deleted	smallint	NOT NULL
	suspended	smallint	NOT NULL
	mnethostid	bigint	NOT NULL
	username	character varying(100)	NOT NULL DEFAULT ''::character varying
	password	character varying(255)	NOT NULL DEFAULT ''::character varying
	idnumber	character varying(255)	NOT NULL DEFAULT ''::character varying
	firstname	character varying(100)	NOT NULL DEFAULT ''::character varying
	lastname	character varying(100)	NOT NULL DEFAULT ''::character varying
	email	character varying(100)	NOT NULL DEFAULT ''::character varying
	emailstop	smallint	NOT NULL
	icq	character varying(15)	NOT NULL DEFAULT ''::character varying
	skype	character varying(50)	NOT NULL DEFAULT ''::character varying
	yahoo	character varying(50)	NOT NULL DEFAULT ''::character varying
	aim	character varying(50)	NOT NULL DEFAULT ''::character varying
	msn	character varying(50)	NOT NULL DEFAULT ''::character varying
	phone1	character varying(20)	NOT NULL DEFAULT ''::character varying
	phone2	character varying(20)	NOT NULL DEFAULT ''::character varying
	institution	character varying(255)	NOT NULL DEFAULT ''::character varying
	department	character varying(255)	NOT NULL DEFAULT ''::character varying
	address	character varying(255)	NOT NULL DEFAULT ''::character varying
	city	character varying(120)	NOT NULL DEFAULT ''::character varying
	country	character varying(2)	NOT NULL DEFAULT ''::character varying
	lang	character varying(30)	NOT NULL DEFAULT 'en'::character varying
	theme	character varying(50)	NOT NULL DEFAULT ''::character varying
	timezone	character varying(100)	NOT NULL DEFAULT '99'::character varying
	firstaccess	bigint	NOT NULL
	lastaccess	bigint	NOT NULL
	lastlogin	bigint	NOT NULL
	currentlogin	bigint	NOT NULL
	lastip	character varying(45)	NOT NULL DEFAULT ''::character varying
	secret	character varying(15)	NOT NULL DEFAULT ''::character varying
	picture	bigint	NOT NULL
	url	character varying(255)	NOT NULL DEFAULT ''::character varying
	description	text
	descriptionformat	smallint	NOT NULL DEFAULT 1
	mailformat	smallint	NOT NULL DEFAULT 1
	maildigest	smallint	NOT NULL
	maildisplay	smallint	NOT NULL DEFAULT 2
	autosubscribe	smallint	NOT NULL DEFAULT 1
	trackforums	smallint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	trustbitmask	bigint	NOT NULL
	imagealt	character varying(255)
	lastnamephonetic	character varying(255)
	firstnamephonetic	character varying(255)
	middlename	character varying(255)
	alternatename	character varying(255)
	calendartype	character varying(30)	NOT NULL DEFAULT 'gregorian'::character varying

mdl_user Indexes
Index Name	Definition
mdl_user_alt_ix	CREATE INDEX mdl_user_alt_ix ON mdl_user USING btree (alternatename)
mdl_user_aut_ix	CREATE INDEX mdl_user_aut_ix ON mdl_user USING btree (auth)
mdl_user_cit_ix	CREATE INDEX mdl_user_cit_ix ON mdl_user USING btree (city)
mdl_user_con_ix	CREATE INDEX mdl_user_con_ix ON mdl_user USING btree (confirmed)
mdl_user_cou_ix	CREATE INDEX mdl_user_cou_ix ON mdl_user USING btree (country)
mdl_user_del_ix	CREATE INDEX mdl_user_del_ix ON mdl_user USING btree (deleted)
mdl_user_ema_ix	CREATE INDEX mdl_user_ema_ix ON mdl_user USING btree (email)
mdl_user_fir2_ix	CREATE INDEX mdl_user_fir2_ix ON mdl_user USING btree (firstnamephonetic)
mdl_user_fir_ix	CREATE INDEX mdl_user_fir_ix ON mdl_user USING btree (firstname)
mdl_user_idn_ix	CREATE INDEX mdl_user_idn_ix ON mdl_user USING btree (idnumber)
mdl_user_las2_ix	CREATE INDEX mdl_user_las2_ix ON mdl_user USING btree (lastaccess)
mdl_user_las3_ix	CREATE INDEX mdl_user_las3_ix ON mdl_user USING btree (lastnamephonetic)
mdl_user_las_ix	CREATE INDEX mdl_user_las_ix ON mdl_user USING btree (lastname)
mdl_user_mid_ix	CREATE INDEX mdl_user_mid_ix ON mdl_user USING btree (middlename)

Index - Schema public

Table: mdl_user_devices

mdl_user_devices Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	appid	character varying(128)	NOT NULL DEFAULT ''::character varying
	name	character varying(32)	NOT NULL DEFAULT ''::character varying
	model	character varying(32)	NOT NULL DEFAULT ''::character varying
	platform	character varying(32)	NOT NULL DEFAULT ''::character varying
	version	character varying(32)	NOT NULL DEFAULT ''::character varying
	pushid	character varying(255)	NOT NULL DEFAULT ''::character varying
	uuid	character varying(255)	NOT NULL DEFAULT ''::character varying
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_user_devices Indexes
Index Name	Definition
mdl_userdevi_use_ix	CREATE INDEX mdl_userdevi_use_ix ON mdl_user_devices USING btree (userid)

Index - Schema public

Table: mdl_user_enrolments

Users participating in courses (aka enrolled users) - everybody who is participating/visible in course, that means both teachers and students

mdl_user_enrolments Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	status	bigint	NOT NULL
	enrolid	bigint	NOT NULL
	userid	bigint	NOT NULL
	timestart	bigint	NOT NULL
	timeend	bigint	NOT NULL DEFAULT 2147483647
	modifierid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL

mdl_user_enrolments Indexes
Index Name	Definition
mdl_userenro_enr_ix	CREATE INDEX mdl_userenro_enr_ix ON mdl_user_enrolments USING btree (enrolid)
mdl_userenro_mod_ix	CREATE INDEX mdl_userenro_mod_ix ON mdl_user_enrolments USING btree (modifierid)
mdl_userenro_use_ix	CREATE INDEX mdl_userenro_use_ix ON mdl_user_enrolments USING btree (userid)

Index - Schema public

Table: mdl_user_info_category

Customisable fields categories

mdl_user_info_category Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	sortorder	bigint	NOT NULL

Index - Schema public

Table: mdl_user_info_data

Data for the customisable user fields

mdl_user_info_data Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	fieldid	bigint	NOT NULL
	data	text	NOT NULL
	dataformat	smallint	NOT NULL

mdl_user_info_data Indexes
Index Name	Definition
mdl_userinfodata_usefie_ix	CREATE INDEX mdl_userinfodata_usefie_ix ON mdl_user_info_data USING btree (userid, fieldid)

Index - Schema public

Table: mdl_user_info_field

Customisable user profile fields

mdl_user_info_field Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	shortname	character varying(255)	NOT NULL DEFAULT 'shortname'::character varying
	name	text	NOT NULL
	datatype	character varying(255)	NOT NULL DEFAULT ''::character varying
	description	text
	descriptionformat	smallint	NOT NULL
	categoryid	bigint	NOT NULL
	sortorder	bigint	NOT NULL
	required	smallint	NOT NULL
	locked	smallint	NOT NULL
	visible	smallint	NOT NULL
	forceunique	smallint	NOT NULL
	signup	smallint	NOT NULL
	defaultdata	text
	defaultdataformat	smallint	NOT NULL
	param1	text
	param2	text
	param3	text
	param4	text
	param5	text

Index - Schema public

Table: mdl_user_lastaccess

To keep track of course page access times, used in online participants block, and participants list

mdl_user_lastaccess Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	courseid	bigint	NOT NULL
	timeaccess	bigint	NOT NULL

mdl_user_lastaccess Indexes
Index Name	Definition
mdl_userlast_cou_ix	CREATE INDEX mdl_userlast_cou_ix ON mdl_user_lastaccess USING btree (courseid)
mdl_userlast_use_ix	CREATE INDEX mdl_userlast_use_ix ON mdl_user_lastaccess USING btree (userid)

Index - Schema public

Table: mdl_user_password_resets

mdl_user_password_resets Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	timerequested	bigint	NOT NULL
	timererequested	bigint	NOT NULL
	token	character varying(32)	NOT NULL DEFAULT ''::character varying

mdl_user_password_resets Indexes
Index Name	Definition
mdl_userpassrese_use_ix	CREATE INDEX mdl_userpassrese_use_ix ON mdl_user_password_resets USING btree (userid)

Index - Schema public

Table: mdl_user_preferences

Allows modules to store arbitrary user preferences

mdl_user_preferences Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	userid	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	value	character varying(1333)	NOT NULL DEFAULT ''::character varying

Index - Schema public

Table: mdl_user_private_key

access keys used in cookieless scripts - rss, etc.

mdl_user_private_key Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	script	character varying(128)	NOT NULL DEFAULT ''::character varying
	value	character varying(128)	NOT NULL DEFAULT ''::character varying
	userid	bigint	NOT NULL
	instance	bigint
	iprestriction	character varying(255)
	validuntil	bigint
	timecreated	bigint

mdl_user_private_key Indexes
Index Name	Definition
mdl_userprivkey_scrval_ix	CREATE INDEX mdl_userprivkey_scrval_ix ON mdl_user_private_key USING btree (script, value)
mdl_userprivkey_use_ix	CREATE INDEX mdl_userprivkey_use_ix ON mdl_user_private_key USING btree (userid)

Index - Schema public

Table: mdl_webdav_locks

Resource locks for WebDAV users

mdl_webdav_locks Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	token	character varying(255)	NOT NULL DEFAULT ''::character varying
	path	character varying(255)	NOT NULL DEFAULT ''::character varying
	expiry	bigint	NOT NULL
	userid	bigint	NOT NULL
	recursive	smallint	NOT NULL
	exclusivelock	smallint	NOT NULL
	created	bigint	NOT NULL
	modified	bigint	NOT NULL
	owner	character varying(255)

mdl_webdav_locks Indexes
Index Name	Definition
mdl_webdlock_exp_ix	CREATE INDEX mdl_webdlock_exp_ix ON mdl_webdav_locks USING btree (expiry)
mdl_webdlock_pat_ix	CREATE INDEX mdl_webdlock_pat_ix ON mdl_webdav_locks USING btree (path)

Index - Schema public

Table: mdl_wiki

Stores Wiki activity configuration

mdl_wiki Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT 'Wiki'::character varying
	intro	text
	introformat	smallint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	firstpagetitle	character varying(255)	NOT NULL DEFAULT 'First Page'::character varying
	wikimode	character varying(20)	NOT NULL DEFAULT 'collaborative'::character varying
	defaultformat	character varying(20)	NOT NULL DEFAULT 'creole'::character varying
	forceformat	smallint	NOT NULL DEFAULT 1
	editbegin	bigint	NOT NULL
	editend	bigint

mdl_wiki Indexes
Index Name	Definition
mdl_wiki_cou_ix	CREATE INDEX mdl_wiki_cou_ix ON mdl_wiki USING btree (course)

Index - Schema public

Table: mdl_wiki_links

Page wiki links

mdl_wiki_links Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	subwikiid	bigint	NOT NULL
	frompageid	bigint	NOT NULL
	topageid	bigint	NOT NULL
	tomissingpage	character varying(255)

mdl_wiki_links Indexes
Index Name	Definition
mdl_wikilink_fro_ix	CREATE INDEX mdl_wikilink_fro_ix ON mdl_wiki_links USING btree (frompageid)
mdl_wikilink_sub_ix	CREATE INDEX mdl_wikilink_sub_ix ON mdl_wiki_links USING btree (subwikiid)

Index - Schema public

Table: mdl_wiki_locks

Manages page locks

mdl_wiki_locks Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	pageid	bigint	NOT NULL
	sectionname	character varying(255)
	userid	bigint	NOT NULL
	lockedat	bigint	NOT NULL

Index - Schema public

Table: mdl_wiki_pages

Stores wiki pages

mdl_wiki_pages Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	subwikiid	bigint	NOT NULL
	title	character varying(255)	NOT NULL DEFAULT 'title'::character varying
	cachedcontent	text	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	timerendered	bigint	NOT NULL
	userid	bigint	NOT NULL
	pageviews	bigint	NOT NULL
	readonly	smallint	NOT NULL

mdl_wiki_pages Indexes
Index Name	Definition
mdl_wikipage_sub_ix	CREATE INDEX mdl_wikipage_sub_ix ON mdl_wiki_pages USING btree (subwikiid)

Index - Schema public

Table: mdl_wiki_subwikis

Stores subwiki instances

mdl_wiki_subwikis Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	wikiid	bigint	NOT NULL
	groupid	bigint	NOT NULL
	userid	bigint	NOT NULL

mdl_wiki_subwikis Indexes
Index Name	Definition
mdl_wikisubw_wik_ix	CREATE INDEX mdl_wikisubw_wik_ix ON mdl_wiki_subwikis USING btree (wikiid)

Index - Schema public

Table: mdl_wiki_synonyms

Stores wiki pages synonyms

mdl_wiki_synonyms Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	subwikiid	bigint	NOT NULL
	pageid	bigint	NOT NULL
	pagesynonym	character varying(255)	NOT NULL DEFAULT 'Pagesynonym'::character varying

Index - Schema public

Table: mdl_wiki_versions

Stores wiki page history

mdl_wiki_versions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	pageid	bigint	NOT NULL
	content	text	NOT NULL
	contentformat	character varying(20)	NOT NULL DEFAULT 'creole'::character varying
	version	integer	NOT NULL
	timecreated	bigint	NOT NULL
	userid	bigint	NOT NULL

mdl_wiki_versions Indexes
Index Name	Definition
mdl_wikivers_pag_ix	CREATE INDEX mdl_wikivers_pag_ix ON mdl_wiki_versions USING btree (pageid)

Index - Schema public

Table: mdl_workshop

This table keeps information about the module instances and their settings

mdl_workshop Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	intro	text
	introformat	smallint	NOT NULL
	instructauthors	text
	instructauthorsformat	smallint	NOT NULL
	instructreviewers	text
	instructreviewersformat	smallint	NOT NULL
	timemodified	bigint	NOT NULL
	phase	smallint
	useexamples	smallint
	usepeerassessment	smallint
	useselfassessment	smallint
	grade	numeric(10,5)	DEFAULT 80
	gradinggrade	numeric(10,5)	DEFAULT 20
	strategy	character varying(30)	NOT NULL DEFAULT ''::character varying
	evaluation	character varying(30)	NOT NULL DEFAULT ''::character varying
	gradedecimals	smallint
	nattachments	smallint
	latesubmissions	smallint
	maxbytes	bigint	DEFAULT 100000
	examplesmode	smallint
	submissionstart	bigint
	submissionend	bigint
	assessmentstart	bigint
	assessmentend	bigint
	phaseswitchassessment	smallint	NOT NULL
	conclusion	text
	conclusionformat	smallint	NOT NULL DEFAULT 1
	overallfeedbackmode	smallint	DEFAULT 1
	overallfeedbackfiles	smallint
	overallfeedbackmaxbytes	bigint	DEFAULT 100000

mdl_workshop Indexes
Index Name	Definition
mdl_work_cou_ix	CREATE INDEX mdl_work_cou_ix ON mdl_workshop USING btree (course)

Index - Schema public

Table: mdl_workshop_aggregations

Aggregated grades for assessment are stored here. The aggregated grade for submission is stored in workshop_submissions

mdl_workshop_aggregations Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	userid	bigint	NOT NULL
	gradinggrade	numeric(10,5)
	timegraded	bigint

mdl_workshop_aggregations Indexes
Index Name	Definition
mdl_workaggr_use_ix	CREATE INDEX mdl_workaggr_use_ix ON mdl_workshop_aggregations USING btree (userid)
mdl_workaggr_wor_ix	CREATE INDEX mdl_workaggr_wor_ix ON mdl_workshop_aggregations USING btree (workshopid)

Index - Schema public

Table: mdl_workshop_assessments

Info about the made assessment and automatically calculated grade for it. The proposed grade can be overridden by teacher.

mdl_workshop_assessments Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	submissionid	bigint	NOT NULL
	reviewerid	bigint	NOT NULL
	weight	bigint	NOT NULL DEFAULT 1
	timecreated	bigint
	timemodified	bigint
	grade	numeric(10,5)
	gradinggrade	numeric(10,5)
	gradinggradeover	numeric(10,5)
	gradinggradeoverby	bigint
	feedbackauthor	text
	feedbackauthorformat	smallint
	feedbackreviewer	text
	feedbackreviewerformat	smallint
	feedbackauthorattachment	smallint

mdl_workshop_assessments Indexes
Index Name	Definition
mdl_workasse_gra_ix	CREATE INDEX mdl_workasse_gra_ix ON mdl_workshop_assessments USING btree (gradinggradeoverby)
mdl_workasse_rev_ix	CREATE INDEX mdl_workasse_rev_ix ON mdl_workshop_assessments USING btree (reviewerid)
mdl_workasse_sub_ix	CREATE INDEX mdl_workasse_sub_ix ON mdl_workshop_assessments USING btree (submissionid)

Index - Schema public

Table: mdl_workshop_assessments_old

Legacy workshop_assessments table to be dropped later in Moodle 2.x

mdl_workshop_assessments_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	submissionid	bigint	NOT NULL
	userid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timegraded	bigint	NOT NULL
	timeagreed	bigint	NOT NULL
	grade	double precision	NOT NULL
	gradinggrade	smallint	NOT NULL
	teachergraded	smallint	NOT NULL
	mailed	smallint	NOT NULL
	resubmission	smallint	NOT NULL
	donotuse	smallint	NOT NULL
	generalcomment	text
	teachercomment	text
	newplugin	character varying(28)
	newid	bigint

mdl_workshop_assessments_old Indexes
Index Name	Definition
mdl_workasseold_mai_ix	CREATE INDEX mdl_workasseold_mai_ix ON mdl_workshop_assessments_old USING btree (mailed)
mdl_workasseold_sub_ix	CREATE INDEX mdl_workasseold_sub_ix ON mdl_workshop_assessments_old USING btree (submissionid)
mdl_workasseold_use_ix	CREATE INDEX mdl_workasseold_use_ix ON mdl_workshop_assessments_old USING btree (userid)
mdl_workasseold_wor_ix	CREATE INDEX mdl_workasseold_wor_ix ON mdl_workshop_assessments_old USING btree (workshopid)

Index - Schema public

Table: mdl_workshop_comments_old

Legacy workshop_comments table to be dropped later in Moodle 2.x

mdl_workshop_comments_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	assessmentid	bigint	NOT NULL
	userid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	mailed	smallint	NOT NULL
	comments	text	NOT NULL
	newplugin	character varying(28)
	newid	bigint

mdl_workshop_comments_old Indexes
Index Name	Definition
mdl_workcommold_ass_ix	CREATE INDEX mdl_workcommold_ass_ix ON mdl_workshop_comments_old USING btree (assessmentid)
mdl_workcommold_mai_ix	CREATE INDEX mdl_workcommold_mai_ix ON mdl_workshop_comments_old USING btree (mailed)
mdl_workcommold_use_ix	CREATE INDEX mdl_workcommold_use_ix ON mdl_workshop_comments_old USING btree (userid)
mdl_workcommold_wor_ix	CREATE INDEX mdl_workcommold_wor_ix ON mdl_workshop_comments_old USING btree (workshopid)

Index - Schema public

Table: mdl_workshop_elements_old

Legacy workshop_elements table to be dropped later in Moodle 2.x

mdl_workshop_elements_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	elementno	smallint	NOT NULL
	description	text	NOT NULL
	scale	smallint	NOT NULL
	maxscore	smallint	NOT NULL DEFAULT 1
	weight	smallint	NOT NULL DEFAULT 11
	stddev	double precision	NOT NULL
	totalassessments	bigint	NOT NULL
	newplugin	character varying(28)
	newid	bigint

mdl_workshop_elements_old Indexes
Index Name	Definition
mdl_workelemold_wor_ix	CREATE INDEX mdl_workelemold_wor_ix ON mdl_workshop_elements_old USING btree (workshopid)

Index - Schema public

Table: mdl_workshop_grades

How the reviewers filled-up the grading forms, given grades and comments

mdl_workshop_grades Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	assessmentid	bigint	NOT NULL
	strategy	character varying(30)	NOT NULL DEFAULT ''::character varying
	dimensionid	bigint	NOT NULL
	grade	numeric(10,5)	NOT NULL
	peercomment	text
	peercommentformat	smallint

mdl_workshop_grades Indexes
Index Name	Definition
mdl_workgrad_ass_ix	CREATE INDEX mdl_workgrad_ass_ix ON mdl_workshop_grades USING btree (assessmentid)

Index - Schema public

Table: mdl_workshop_grades_old

Legacy workshop_grades table to be dropped later in Moodle 2.x

mdl_workshop_grades_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	assessmentid	bigint	NOT NULL
	elementno	bigint	NOT NULL
	feedback	text	NOT NULL
	grade	smallint	NOT NULL
	newplugin	character varying(28)
	newid	bigint

mdl_workshop_grades_old Indexes
Index Name	Definition
mdl_workgradold_ass_ix	CREATE INDEX mdl_workgradold_ass_ix ON mdl_workshop_grades_old USING btree (assessmentid)
mdl_workgradold_wor_ix	CREATE INDEX mdl_workgradold_wor_ix ON mdl_workshop_grades_old USING btree (workshopid)

Index - Schema public

Table: mdl_workshop_old

Legacy workshop table to be dropped later in Moodle 2.x

mdl_workshop_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	course	bigint	NOT NULL
	name	character varying(255)	NOT NULL DEFAULT ''::character varying
	description	text	NOT NULL
	wtype	smallint	NOT NULL
	nelements	smallint	NOT NULL DEFAULT 1
	nattachments	smallint	NOT NULL
	phase	smallint	NOT NULL
	format	smallint	NOT NULL
	gradingstrategy	smallint	NOT NULL DEFAULT 1
	resubmit	smallint	NOT NULL
	agreeassessments	smallint	NOT NULL
	hidegrades	smallint	NOT NULL
	anonymous	smallint	NOT NULL
	includeself	smallint	NOT NULL
	maxbytes	bigint	NOT NULL DEFAULT 100000
	submissionstart	bigint	NOT NULL
	assessmentstart	bigint	NOT NULL
	submissionend	bigint	NOT NULL
	assessmentend	bigint	NOT NULL
	releasegrades	bigint	NOT NULL
	grade	smallint	NOT NULL
	gradinggrade	smallint	NOT NULL
	ntassessments	smallint	NOT NULL
	assessmentcomps	smallint	NOT NULL DEFAULT 2
	nsassessments	smallint	NOT NULL
	overallocation	smallint	NOT NULL
	timemodified	bigint	NOT NULL
	teacherweight	smallint	NOT NULL DEFAULT 1
	showleaguetable	smallint	NOT NULL
	usepassword	smallint	NOT NULL
	password	character varying(32)	NOT NULL DEFAULT ''::character varying
	newplugin	character varying(28)
	newid	bigint

mdl_workshop_old Indexes
Index Name	Definition
mdl_workold_cou_ix	CREATE INDEX mdl_workold_cou_ix ON mdl_workshop_old USING btree (course)

Index - Schema public

Table: mdl_workshop_rubrics_old

Legacy workshop_rubrics table to be dropped later in Moodle 2.x

mdl_workshop_rubrics_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	elementno	bigint	NOT NULL
	rubricno	smallint	NOT NULL
	description	text	NOT NULL
	newplugin	character varying(28)
	newid	bigint

mdl_workshop_rubrics_old Indexes
Index Name	Definition
mdl_workrubrold_wor_ix	CREATE INDEX mdl_workrubrold_wor_ix ON mdl_workshop_rubrics_old USING btree (workshopid)

Index - Schema public

Table: mdl_workshop_stockcomments_old

Legacy workshop_stockcomments table to be dropped later in Moodle 2.x

mdl_workshop_stockcomments_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	elementno	bigint	NOT NULL
	comments	text	NOT NULL
	newplugin	character varying(28)
	newid	bigint

mdl_workshop_stockcomments_old Indexes
Index Name	Definition
mdl_workstocold_wor_ix	CREATE INDEX mdl_workstocold_wor_ix ON mdl_workshop_stockcomments_old USING btree (workshopid)

Index - Schema public

Table: mdl_workshop_submissions

Info about the submission and the aggregation of the grade for submission, grade for assessment and final grade. Both grade for submission and grade for assessment can be overridden by teacher. Final grade is always the sum of them. All grades are st

mdl_workshop_submissions Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	example	smallint
	authorid	bigint	NOT NULL
	timecreated	bigint	NOT NULL
	timemodified	bigint	NOT NULL
	title	character varying(255)	NOT NULL DEFAULT ''::character varying
	content	text
	contentformat	smallint	NOT NULL
	contenttrust	smallint	NOT NULL
	attachment	smallint
	grade	numeric(10,5)
	gradeover	numeric(10,5)
	gradeoverby	bigint
	feedbackauthor	text
	feedbackauthorformat	smallint
	timegraded	bigint
	published	smallint
	late	smallint	NOT NULL

mdl_workshop_submissions Indexes
Index Name	Definition
mdl_worksubm_aut_ix	CREATE INDEX mdl_worksubm_aut_ix ON mdl_workshop_submissions USING btree (authorid)
mdl_worksubm_gra_ix	CREATE INDEX mdl_worksubm_gra_ix ON mdl_workshop_submissions USING btree (gradeoverby)
mdl_worksubm_wor_ix	CREATE INDEX mdl_worksubm_wor_ix ON mdl_workshop_submissions USING btree (workshopid)

Index - Schema public

Table: mdl_workshop_submissions_old

Legacy workshop_submissions table to be dropped later in Moodle 2.x

mdl_workshop_submissions_old Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	userid	bigint	NOT NULL
	title	character varying(100)	NOT NULL DEFAULT ''::character varying
	timecreated	bigint	NOT NULL
	mailed	smallint	NOT NULL
	description	text	NOT NULL
	gradinggrade	smallint	NOT NULL
	finalgrade	smallint	NOT NULL
	late	smallint	NOT NULL
	nassessments	bigint	NOT NULL
	newplugin	character varying(28)
	newid	bigint

mdl_workshop_submissions_old Indexes
Index Name	Definition
mdl_worksubmold_mai_ix	CREATE INDEX mdl_worksubmold_mai_ix ON mdl_workshop_submissions_old USING btree (mailed)
mdl_worksubmold_use_ix	CREATE INDEX mdl_worksubmold_use_ix ON mdl_workshop_submissions_old USING btree (userid)
mdl_worksubmold_wor_ix	CREATE INDEX mdl_worksubmold_wor_ix ON mdl_workshop_submissions_old USING btree (workshopid)

Index - Schema public

Table: mdl_workshopallocation_scheduled

Stores the allocation settings for the scheduled allocator

mdl_workshopallocation_scheduled Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	enabled	smallint	NOT NULL
	submissionend	bigint	NOT NULL
	timeallocated	bigint
	settings	text
	resultstatus	bigint
	resultmessage	character varying(1333)
	resultlog	text

Index - Schema public

Table: mdl_workshopeval_best_settings

Settings for the grading evaluation subplugin Comparison with the best assessment.

mdl_workshopeval_best_settings Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	comparison	smallint	DEFAULT 5

Index - Schema public

Table: mdl_workshopform_accumulative

The assessment dimensions definitions of Accumulative grading strategy forms

mdl_workshopform_accumulative Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	sort	bigint
	description	text
	descriptionformat	smallint
	grade	bigint	NOT NULL
	weight	integer	DEFAULT 1

mdl_workshopform_accumulative Indexes
Index Name	Definition
mdl_workaccu_wor_ix	CREATE INDEX mdl_workaccu_wor_ix ON mdl_workshopform_accumulative USING btree (workshopid)

Index - Schema public

Table: mdl_workshopform_comments

The assessment dimensions definitions of Comments strategy forms

mdl_workshopform_comments Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	sort	bigint
	description	text
	descriptionformat	smallint

mdl_workshopform_comments Indexes
Index Name	Definition
mdl_workcomm_wor_ix	CREATE INDEX mdl_workcomm_wor_ix ON mdl_workshopform_comments USING btree (workshopid)

Index - Schema public

Table: mdl_workshopform_numerrors

The assessment dimensions definitions of Number of errors grading strategy forms

mdl_workshopform_numerrors Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	sort	bigint
	description	text
	descriptionformat	smallint
	descriptiontrust	bigint
	grade0	character varying(50)
	grade1	character varying(50)
	weight	integer	DEFAULT 1

mdl_workshopform_numerrors Indexes
Index Name	Definition
mdl_worknume_wor_ix	CREATE INDEX mdl_worknume_wor_ix ON mdl_workshopform_numerrors USING btree (workshopid)

Index - Schema public

Table: mdl_workshopform_numerrors_map

This maps the number of errors to a percentual grade for submission

mdl_workshopform_numerrors_map Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	nonegative	bigint	NOT NULL
	grade	numeric(10,5)	NOT NULL

mdl_workshopform_numerrors_map Indexes
Index Name	Definition
mdl_worknumemap_wor_ix	CREATE INDEX mdl_worknumemap_wor_ix ON mdl_workshopform_numerrors_map USING btree (workshopid)

Index - Schema public

Table: mdl_workshopform_rubric

The assessment dimensions definitions of Rubric grading strategy forms

mdl_workshopform_rubric Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	sort	bigint
	description	text
	descriptionformat	smallint

mdl_workshopform_rubric Indexes
Index Name	Definition
mdl_workrubr_wor_ix	CREATE INDEX mdl_workrubr_wor_ix ON mdl_workshopform_rubric USING btree (workshopid)

Index - Schema public

Table: mdl_workshopform_rubric_config

Configuration table for the Rubric grading strategy

mdl_workshopform_rubric_config Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	workshopid	bigint	NOT NULL
	layout	character varying(30)	DEFAULT 'list'::character varying

Index - Schema public

Table: mdl_workshopform_rubric_levels

The definition of rubric rating scales

mdl_workshopform_rubric_levels Structure
F-Key	Name	Type	Description
	id	bigserial	PRIMARY KEY
	dimensionid	bigint	NOT NULL
	grade	numeric(10,5)	NOT NULL
	definition	text
	definitionformat	smallint

mdl_workshopform_rubric_levels Indexes
Index Name	Definition
mdl_workrubrleve_dim_ix	CREATE INDEX mdl_workrubrleve_dim_ix ON mdl_workshopform_rubric_levels USING btree (dimensionid)

Index - Schema public

Generated by PGDoc