Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
grade_items Table courseid BIGINT 19 null

The course this item is part of

log Table url VARCHAR 100
enrol_lti_lti2_resource_link Table updated BIGINT 19 null
competency_modulecomp Table sortorder BIGINT 19 null

The field used to naturally sort this link.

tool_dataprivacy_ctxlevel Table categoryid BIGINT 19 null
resource_old Table introformat SMALLINT 5 0
question_ddwtos Table correctfeedbackformat TINYINT 3 0
local_ld_course_day Table ldcourseid BIGINT 19 null

Foreign key to the local_ld_course table

assign_submission Table timemodified BIGINT 19 0

The last time this assignment submission was modified by a student.

competency_relatedcomp Table relatedcompetencyid BIGINT 19 null
portfolio_log Table time BIGINT 19 null

time of transfer (in the case of a queued transfer this is the time the actual transfer ran, not when the user started)

quiz Table attempts MEDIUMINT 7 0

The maximum number of attempts a student is allowed.

qtype_ddmarker_drags Table infinite SMALLINT 5 0
competency_template Table timecreated BIGINT 19 null

The time this learning plan template was created.

block_instances Table showinsubcontexts SMALLINT 5 null

If 1, this block appears on all matching pages in subcontexts of parentcontextid, as well in pages belonging to parentcontextid.

messages Table id BIGINT 19 null
question_calculated Table id BIGINT 19 null
oauth2_issuer Table loginscopes LONGTEXT 2147483647 null

The scopes requested for a normal login attempt.

resource_old Table oldid BIGINT 19 null
glossary Table rsstype TINYINT 3 0
question_attempts Table behaviour VARCHAR 32

The name of the question behaviour that is managing this question attempt.

search_simpledb_index Table itemid BIGINT 19 null
glossary Table timecreated BIGINT 19 0
qtype_multichoice_options Table correctfeedbackformat TINYINT 3 0
competency_coursecomp Table timecreated BIGINT 19 null

The time this link was created.

badge Table timemodified BIGINT 19 0
role_names Table id BIGINT 19 null
qtype_ddimageortext_drags Table draggroup BIGINT 19 0
feedback Table id BIGINT 19 null
event Table timemodified BIGINT 19 0
course_sections Table summary LONGTEXT 2147483647 null
workshop Table overallfeedbackmode SMALLINT 5 1

Mode of the overall feedback support.

lesson_answers Table id BIGINT 19 null
question_answers Table id BIGINT 19 null
assignment_submissions Table teacher BIGINT 19 0
tool_dataprivacy_purpose Table description LONGTEXT 2147483647 null
page Table intro LONGTEXT 2147483647 null
profiling Table totalexecutiontime BIGINT 19 null

time (in microseconds) spent by the run

wiki_synonyms Table pageid BIGINT 19 0

Original page

search_simpledb_index Table owneruserid BIGINT 19 null
block_zoola_reports Table uri VARCHAR 1333

Report URI

assignfeedback_file Table assignment BIGINT 19 0
quiz Table id BIGINT 19 null

Standard Moodle primary key.

data_records Table approved SMALLINT 5 0
post Table coursemoduleid BIGINT 19 0
enrol_lti_lti2_consumer Table lastaccess BIGINT 19 null
course Table visible BIT 0 1
question_calculated_options Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

quiz_statistics Table median DECIMAL 15 null
competency_evidence Table action TINYINT 3 null
competency_template Table duedate BIGINT 19 null

The default due date for instances of this plan.

cohort Table id BIGINT 19 null
enrol Table customint1 BIGINT 19 null

Custom - general int

scorm_scoes Table scormtype VARCHAR 5
glossary Table timemodified BIGINT 19 0
groupings Table id BIGINT 19 null
course_completions Table userid BIGINT 19 0
portfolio_log Table caller_file VARCHAR 255

path to file to include where the class definition lives. (relative to dirroot)

scale Table scale LONGTEXT 2147483647 null
block_zoola_module_name Table id BIGINT 19 null
course_completion_defaults Table completionexpected BIGINT 19 0
scorm_seq_mapinfo Table scoid BIGINT 19 0
wiki_versions Table version MEDIUMINT 7 0

Wiki page version

stats_user_monthly Table roleid BIGINT 19 0
qtype_randomsamatch_options Table incorrectfeedbackformat TINYINT 3 0
lti Table timemodified BIGINT 19 0
survey Table timecreated BIGINT 19 0
sessions Table firstip VARCHAR 45 null
tool_policy_versions Table content LONGTEXT 2147483647 null

Full policy text

qtype_ddmarker_drags Table questionid BIGINT 19 0
assign_grades Table grader BIGINT 19 0
book_chapters Table contentformat SMALLINT 5 0
oauth2_endpoint Table id BIGINT 19 null
tag_instance Table id BIGINT 19 null
wiki Table course BIGINT 19 0

Course wiki activity belongs to

forum_discussion_subs Table userid BIGINT 19 null
wiki Table firstpagetitle VARCHAR 255 First Page

Wiki first page's name

tag_area Table callbackfile VARCHAR 100 null
analytics_used_files Table modelid BIGINT 19 0
grade_outcomes_history Table courseid BIGINT 19 null

Mostly these are defined site wide ie NULL

course Table sortorder BIGINT 19 0
filter_active Table sortorder BIGINT 19 0

Only relevant if contextid points to the system context. In other cases this field should contain 0. The order in which the filters should be applied.

forum_read Table postid BIGINT 19 0
book Table id BIGINT 19 null
forum_posts Table discussion BIGINT 19 0
oauth2_user_field_mapping Table id BIGINT 19 null
tool_dataprivacy_rqst_ctxlst Table contextlistid BIGINT 19 null
course_modules_completion Table overrideby BIGINT 19 null

Tracks whether this completion state has been set manually to override a previous state.

quiz Table password VARCHAR 255

A password that the student must enter before starting or continuing a quiz attempt.

user Table secret VARCHAR 15
workshopform_rubric Table id BIGINT 19 null
post Table content LONGTEXT 2147483647 null
lesson_branch Table id BIGINT 19 null
badge_issued Table badgeid BIGINT 19 0
competency_usercompplan Table id BIGINT 19 null
external_services_users Table validuntil BIGINT 19 null

timestampt - valid until data

task_scheduled Table blocking TINYINT 3 0

Block the entire cron when this task is running.

feedback_valuetmp Table course_id BIGINT 19 0
quiz_feedback Table maxgrade DECIMAL 10 0.00000

The upper limit of this grade band. Exclusive.

role_sortorder Table id BIGINT 19 null
competency Table competencyframeworkid BIGINT 19 null

The framework this competency relates to.

scorm Table whatgrade BIGINT 19 0
scale_history Table oldid BIGINT 19 null
analytics_prediction_actions Table predictionid BIGINT 19 null
license Table id BIGINT 19 null
grade_grades Table feedbackformat BIGINT 19 0

format of feedback text

lti Table introformat SMALLINT 5 0

Format of the intro field (MOODLE, HTML, MARKDOWN...)

grade_grades Table overridden BIGINT 19 0

indicates grade overridden from gradebook, 0 means none, date means overridden

competency_plan Table origtemplateid BIGINT 19 null

The template ID this plan was based on originally

grade_items_history Table decimals BIT 0 null
enrol_lti_users Table timecreated BIGINT 19 null

The time the user was created

lesson_answers Table score BIGINT 19 0
question_statistics Table negcovar TINYINT 3 0
analytics_models Table timesplitting VARCHAR 255 null
lesson Table conditions LONGTEXT 2147483647 null
scorm_seq_rolluprulecond Table rollupruleid BIGINT 19 0
grade_categories_history Table action BIGINT 19 0

created/modified/deleted constants

badge Table messagesubject LONGTEXT 2147483647 null
message_read Table eventtype VARCHAR 100 null
user_enrolments Table userid BIGINT 19 null
scorm Table id BIGINT 19 null
post Table userid BIGINT 19 0
grading_instances Table feedback LONGTEXT 2147483647 null

Overall feedback from the rater for the author of the graded item

scorm_seq_rulecond Table cond VARCHAR 30 always
user_lastaccess Table id BIGINT 19 null
log_queries Table qtype MEDIUMINT 7 null

query type constant

course_categories Table name VARCHAR 255
badge_issued Table uniquehash LONGTEXT 2147483647 null
imscp Table intro LONGTEXT 2147483647 null
competency_coursecompsetting Table courseid BIGINT 19 null

The course this setting is linked to.

messageinbound_handlers Table component VARCHAR 100

The component this handler belongs to.

groups Table courseid BIGINT 19 null
question Table category BIGINT 19 0
glossary_entries Table glossaryid BIGINT 19 0
filter_active Table contextid BIGINT 19 null

References context.id.

grading_areas Table contextid BIGINT 19 null

The context of the gradable area, eg module instance context.

workshop Table course BIGINT 19 null

ID of the parent course

chat Table chattime BIGINT 19 0
imscp Table keepold BIGINT 19 -1

incremented when after each file changes, solves browser caching issues

assignment_upgrade Table oldcmid BIGINT 19 0
external_tokens Table token VARCHAR 128

security token, aka private access key

external_services Table uploadfiles BIT 0 0

1 if the service allow people to upload files to webservice/upload.php - 0 if not

blog_external Table url LONGTEXT 2147483647 null
grade_categories_history Table id BIGINT 19 null
qtype_essay_options Table attachmentsrequired SMALLINT 5 0

The number of attachments that should be required

question_attempts Table maxfraction DECIMAL 12 1.0000000

Some questions can give fractions greater than 1. This indicates the greatest fraction that can be awarded.

competency_usercompcourse Table usermodified BIGINT 19 null
question_calculated_options Table question BIGINT 19 0
mnet_log Table url VARCHAR 100
files Table status BIGINT 19 0

number greater than 0 means something is wrong with this file (virus, missing, etc.)

user_info_field Table name LONGTEXT 2147483647 null

field name

analytics_indicator_calc Table starttime BIGINT 19 null
enrol_lti_tools Table timecreated BIGINT 19 null
scorm_aicc_session Table attempt BIGINT 19 null
forum Table type VARCHAR 20 general
event_subscriptions Table categoryid BIGINT 19 0
local_ld_import_logs_status Table adhoctaskid BIGINT 19 null

Import logs task id

logstore_standard_log Table edulevel BIT 0 null
message Table notification BIT 0 0
grade_categories Table parent BIGINT 19 null

Categories can be hierarchical

log_queries Table sqltext LONGTEXT 2147483647 null

query sql

gradingform_rubric_levels Table score DECIMAL 10 null

The score for this level

qtype_ddmarker Table correctfeedbackformat TINYINT 3 0
data_content Table content2 LONGTEXT 2147483647 null
quiz Table timemodified BIGINT 19 0

Last modified time.

data Table assessed BIGINT 19 0
backup_controllers Table checksum VARCHAR 32

checksum of the backup_controller object

course_modules Table groupingid BIGINT 19 0
forum_queue Table discussionid BIGINT 19 0
backup_courses Table laststarttime BIGINT 19 0
competency_template Table id BIGINT 19 null
grade_outcomes_history Table description LONGTEXT 2147483647 null

Outcome description

workshop_grades Table peercommentformat SMALLINT 5 0

The format of peercomment field

survey_answers Table question BIGINT 19 0
lesson_grades Table grade DOUBLE 22 0
portfolio_mahara_queue Table id BIGINT 19 null
course_completions Table timeenrolled BIGINT 19 0
role_allow_override Table allowoverride BIGINT 19 0
block_zoola_reports_cohort Table cohortid BIGINT 19 null

Cohort ID

log_display Table field VARCHAR 200
tool_dataprivacy_request Table dpo BIGINT 19 0

The user ID of the Data Protection Officer who is reviewing th request

course_completion_defaults Table customrules LONGTEXT 2147483647 null
competency_usercompcourse Table competencyid BIGINT 19 null

Competency associated to the user.

forum_subscriptions Table id BIGINT 19 null
workshop_aggregations Table gradinggrade DECIMAL 10 null

The aggregated grade for all assessments made by this reviewer. The grade is a number from interval 0..100. If NULL then the grade for assessments has not been aggregated yet.

user_password_history Table id BIGINT 19 null
logstore_standard_log Table contextid BIGINT 19 null
workshop Table instructreviewersformat SMALLINT 5 0
event_subscriptions Table url VARCHAR 255
lesson Table completionendreached BIT 0 0
imscp Table id BIGINT 19 null
scorm Table version VARCHAR 9
wiki_pages Table id BIGINT 19 null
post Table lastmodified BIGINT 19 0
competency Table parentid BIGINT 19 0

The parent competency.

role_sortorder Table userid BIGINT 19 null
book_chapters Table bookid BIGINT 19 0
log_display Table mtable VARCHAR 30
qtype_ddmarker Table shuffleanswers SMALLINT 5 1
folder Table display SMALLINT 5 0

Display type of folder contents - on a separate page or inline

glossary_formats Table sortorder VARCHAR 50
lti_types Table parameter LONGTEXT 2147483647 null

Launch parameters, one per line (null for LTI 1 tools)

logstore_standard_log Table origin VARCHAR 10 null

cli, cron, ws, etc.

competency_relatedcomp Table competencyid BIGINT 19 null
external_services Table requiredcapability VARCHAR 150 null
survey Table timemodified BIGINT 19 0
enrol_paypal Table option_selection2_x VARCHAR 255
assignfeedback_editpdf_cmnt Table colour VARCHAR 10 black

Can be red, yellow, green, blue, white, black

lesson Table usemaxgrade SMALLINT 5 0
qtype_multichoice_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

user Table icq VARCHAR 15
data Table timeviewto BIGINT 19 0
lti Table instructorcustomparameters VARCHAR 255 null

Additional custom parameters provided by the instructor

local_ld_course Table totaldedication BIGINT 19 null

Total time that user spent within the course, in seconds

external_services_users Table userid BIGINT 19 null
quiz_slots Table requireprevious SMALLINT 5 0

Set to 1 when current question requires previous one to be answered first.

course_sections Table timemodified BIGINT 19 0

Time at which the course section was last changed.

tool_policy_versions Table archived SMALLINT 5 0

Should the version be considered as archived. All non-archived, non-current versions are considered to be drafts.

gradingform_guide_comments Table id BIGINT 19 null
files Table referencefileid BIGINT 19 null

Use to indicate file is a proxy for repository file

assignsubmission_file Table submission BIGINT 19 0
portfolio_log Table continueurl VARCHAR 255

the url the external system has set to view the transfer

oauth2_issuer Table usermodified BIGINT 19 null

The user who modified this record

badge Table timecreated BIGINT 19 0
assignfeedback_file Table numfiles BIGINT 19 0

The number of files uploaded by a grader.

stats_user_monthly Table timeend BIGINT 19 0
course_categories Table depth BIGINT 19 0
resource_old Table reference VARCHAR 255
resource Table filterfiles SMALLINT 5 0
grade_grades_history Table excluded BIGINT 19 0

grade excluded from aggregation functions, date means when excluded

competency_usercomp Table usermodified BIGINT 19 null
competency_coursecomp Table timemodified BIGINT 19 null

The time this link was modified.

user_devices Table platform VARCHAR 32

the device platform, Android or iOS etc

mnet_rpc Table classname VARCHAR 150 null
course_categories Table sortorder BIGINT 19 0
files_reference Table reference LONGTEXT 2147483647 null

Identification of the external file. Repository plugins are interpreting it to locate the external file.

mnet_session Table session_id VARCHAR 40

The PHP Session ID

grade_categories_history Table depth BIGINT 19 0

How many parents does this category have?

wiki_pages Table timemodified BIGINT 19 0

page edition timestamp

block_rss_client Table id BIGINT 19 null
cache_filters Table filter VARCHAR 32
user_private_key Table validuntil BIGINT 19 null

timestampt - valid until data

enrol_lti_lti2_context Table type VARCHAR 100 null
assignment Table timeavailable BIGINT 19 0
forum_discussion_subs Table forum BIGINT 19 null
question_calculated_options Table shuffleanswers SMALLINT 5 0

Whether the choices can be randomly shuffled.

feedback_completedtmp Table timemodified BIGINT 19 0
grade_items_history Table iteminstance BIGINT 19 null

id of the item module

portfolio_log Table returnurl VARCHAR 255

the original "returnurl" of the export - takes us to the moodle page we started from

lti_types_config Table typeid BIGINT 19 null

Basic LTI type id

auth_oauth2_linked_login Table confirmtoken VARCHAR 64

If this is not empty - the user has not confirmed their email to create the link.

portfolio_tempdata Table id BIGINT 19 null
question_response_count Table rcount BIGINT 19 null
scale Table descriptionformat TINYINT 3 0
oauth2_issuer Table showonloginpage TINYINT 3 1
question_attempts Table responsesummary LONGTEXT 2147483647 null

This is a textual summary of the student's response (basically what you would expect to in the Quiz responses report).

user_info_category Table id BIGINT 19 null
enrol Table roleid BIGINT 19 0

Custom - the default role given to participants who self-enrol

competency_coursecompsetting Table usermodified BIGINT 19 null

The user who last modified this setting

grade_outcomes Table courseid BIGINT 19 null

Mostly these are defined site wide ie NULL

gradingform_rubric_fillings Table instanceid BIGINT 19 null

The ID of the grading form instance

tool_dataprivacy_purpose Table usermodified BIGINT 19 null
enrol_lti_lti2_consumer Table consumerkey LONGTEXT 2147483647 null
user Table url VARCHAR 255
grade_categories_history Table fullname VARCHAR 255

The name of this grade category

tool_monitor_events Table contextlevel BIGINT 19 null

Context level

data Table rsstitletemplate LONGTEXT 2147483647 null
user_info_field Table defaultdata LONGTEXT 2147483647 null

Default value for this field

question_ddwtos Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

workshopallocation_scheduled Table resultlog LONGTEXT 2147483647 null

The log of the most recent execution

backup_controllers Table format VARCHAR 20

format of the backup (moodle/imscc...)

role_capabilities Table roleid BIGINT 19 0
tool_dataprivacy_ctxinstance Table timecreated BIGINT 19 null
user Table firstnamephonetic VARCHAR 255 null

First name phonetic

stats_user_daily Table id BIGINT 19 null
auth_oauth2_linked_login Table userid BIGINT 19 null

The user account this oauth login is linked to.

glossary_entries_categories Table entryid BIGINT 19 0
scorm Table timeopen BIGINT 19 0
cohort Table description LONGTEXT 2147483647 null

Standard description text box

enrol_paypal Table payment_type VARCHAR 30
lti Table servicesalt VARCHAR 40 null
workshopform_numerrors Table descriptiontrust BIGINT 19 null
scorm Table md5hash VARCHAR 32

MD5 Hash of package file

quiz Table grademethod SMALLINT 5 1

One of the values QUIZ_GRADEHIGHEST, QUIZ_GRADEAVERAGE, QUIZ_ATTEMPTFIRST or QUIZ_ATTEMPTLAST.

assign_user_flags Table extensionduedate BIGINT 19 0

An extension date assigned to an individual student.

assign_plugin_config Table id BIGINT 19 null
grade_outcomes_history Table shortname VARCHAR 255

The short name or code for this outcome statement

assignsubmission_onlinetext Table onlineformat SMALLINT 5 0

The format for this online text submission.

workshopform_comments Table workshopid BIGINT 19 null

Workshop ID

mnetservice_enrol_enrolments Table hostid BIGINT 19 null

ID of the remote MNet host

block Table id BIGINT 19 null
workshopallocation_scheduled Table submissionend BIGINT 19 null

What was the workshop's submissionend when this record was created or modified

chat Table course BIGINT 19 0
data Table completionentries BIGINT 19 0

Number of entries required for completion

local_ld_lastactivity Table courseid BIGINT 19 null

Course ID

scorm Table forcecompleted BIT 0 0
badge_backpack Table userid BIGINT 19 0
quiz_slots Table slot BIGINT 19 null

Where this question comes in order in the list of questions in this quiz. Like question_attempts.slot.

question_dataset_definitions Table itemcount BIGINT 19 0
grade_items_history Table itemname VARCHAR 255 null

The name of this item (pushed in by the module)

quiz Table reviewspecificfeedback MEDIUMINT 7 0

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

files Table contenthash VARCHAR 40

sha1 hash of file content

qtype_ddimageortext_drags Table no BIGINT 19 0

drag no

glossary_formats Table defaulthook VARCHAR 50
chat_users Table userid BIGINT 19 0
course_completion_aggr_methd Table id BIGINT 19 null
question_statistics Table randomguessscore DECIMAL 12 null

An estimate of the score a student would get by guessing randomly.

scorm_scoes_track Table id BIGINT 19 null
events_queue_handlers Table status BIGINT 19 null

number of failed attempts to process this handler

enrol_lti_lti2_consumer Table secret VARCHAR 1024
cohort Table theme VARCHAR 50 null
forum_posts Table messageformat TINYINT 3 0
qtype_ddimageortext_drops Table id BIGINT 19 null
quiz Table timeclose BIGINT 19 0

The time when this quiz closes. (0 = no restriction.)

external_functions Table name VARCHAR 200
workshopeval_best_settings Table id BIGINT 19 null
qtype_essay_options Table graderinfoformat SMALLINT 5 0

The text format for graderinfo.

enrol_paypal Table courseid BIGINT 19 0
question_calculated_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

user_lastaccess Table courseid BIGINT 19 0
lti_submission Table launchid BIGINT 19 null
competency Table id BIGINT 19 null
page Table legacyfileslast BIGINT 19 null
oauth2_issuer Table sortorder BIGINT 19 null

The defined sort order.

data Table course BIGINT 19 0
competency_templatecomp Table templateid BIGINT 19 null

The template this competency is linked to.

grade_items Table hidden BIGINT 19 0

1 is hidden, > 1 is a date to hide until (prevents viewing)

forum_posts Table messagetrust TINYINT 3 0
search_simpledb_index Table contextid BIGINT 19 null
tool_dataprivacy_purpose Table timecreated BIGINT 19 null
tool_dataprivacy_category Table id BIGINT 19 null
quiz_slot_tags Table slotid BIGINT 19 null

The quiz slot that this tag belong to

survey Table intro LONGTEXT 2147483647 null
analytics_predictions Table rangeindex MEDIUMINT 7 null
groupings Table timemodified BIGINT 19 0
assignment_submissions Table timemarked BIGINT 19 0
config_log Table oldvalue LONGTEXT 2147483647 null
lesson_timer Table userid BIGINT 19 0
competency_template Table visible TINYINT 3 1

Used to show/hide this learning plan template.

local_ld_lastactivity Table lastaccess BIGINT 19 null

When the activity has occurred

forum_posts Table userid BIGINT 19 0
lti_tool_settings Table id BIGINT 19 null
assign Table duedate BIGINT 19 0

The due date for the assignment. Displayed to students.

survey_questions Table text VARCHAR 255
event_subscriptions Table pollinterval BIGINT 19 0

Frequency of checks for new/changed events

question Table version VARCHAR 255
message Table timeusertodeleted BIGINT 19 0
assignfeedback_editpdf_cmnt Table id BIGINT 19 null
user_enrolments Table modifierid BIGINT 19 0
lesson_pages Table timecreated BIGINT 19 0
feedback_completedtmp Table feedback BIGINT 19 0
book Table course BIGINT 19 0
role_sortorder Table contextid BIGINT 19 null
scale Table timemodified BIGINT 19 0
lti_types Table id BIGINT 19 null
capabilities Table contextlevel BIGINT 19 0
block_rss_client Table shared TINYINT 3 0
tag_correlation Table id BIGINT 19 null
tag_coll Table sortorder MEDIUMINT 7 0
enrol Table customtext2 LONGTEXT 2147483647 null

Custom - general text

qtype_shortanswer_options Table id BIGINT 19 null
book Table intro LONGTEXT 2147483647 null
lesson_pages Table qoption SMALLINT 5 0
mnet_application Table sso_jump_url VARCHAR 255
block_rss_client Table skiptime BIGINT 19 0

How many seconds skip this feed for (increases every time it fails, resets to 0 when it succeeds)

assignment_submissions Table mailed BIT 0 0
lti Table toolurl LONGTEXT 2147483647 null

Remote tool url

question_statistics Table subquestion SMALLINT 5 null
scorm_seq_objective Table satisfiedbymeasure BIT 0 1
enrol Table customint3 BIGINT 19 null

Custom - general int

quiz Table graceperiod BIGINT 19 0

The amount of time (in seconds) after the time limit runs out during which attempts can still be submitted, if overduehandling is set to allow it.

question_numerical_units Table unit VARCHAR 50

The unit. For example 'm' or 'kg'.

lesson_attempts Table useranswer LONGTEXT 2147483647 null
course Table marker BIGINT 19 0
context_temp Table id BIGINT 19 null

This id isn't autonumeric/sequence. It's the context->id

role_allow_switch Table allowswitch BIGINT 19 null

The id of a role that the user is allowed to switch to as a result of having this role.

competency_usercomp Table timemodified BIGINT 19 null
post Table courseid BIGINT 19 0
lesson Table maxattempts SMALLINT 5 5
forum Table assesstimefinish BIGINT 19 0
workshop_submissions Table grade DECIMAL 10 null

Aggregated grade for the submission. The grade is a decimal number from interval 0..100. If NULL then the grade for submission has not been aggregated yet.

rating Table itemid BIGINT 19 null
workshopform_numerrors Table sort BIGINT 19 0

Defines the dimension order within the assessment form

question_numerical_options Table showunits SMALLINT 5 0

How units are handled: 3) Not used at all, 0) Optional, or 1) must be right or penalty applied.

quiz Table reviewrightanswer MEDIUMINT 7 0

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

tool_dataprivacy_category Table timecreated BIGINT 19 null
lti_types Table state TINYINT 3 2

Active = 1, Pending = 2, Rejected = 3

assign Table allowsubmissionsfromdate BIGINT 19 0

If set, submissions will only be accepted after this date.

assign Table grade BIGINT 19 0

The maximum grade for this assignment. Can be negative to indicate the use of a scale.

badge_manual_award Table badgeid BIGINT 19 null
mnet_log Table userid BIGINT 19 0
mnet_rpc Table static BIT 0 null
config_log Table value LONGTEXT 2147483647 null
grading_definitions Table method VARCHAR 100

The name of the plugin providing this grading form

message_conversations Table id BIGINT 19 null
question_truefalse Table question BIGINT 19 0

Foreign key references question.id.

url Table display SMALLINT 5 0
feedback Table email_notification BIT 0 1
grade_items Table timecreated BIGINT 19 null

The first time this grade_item was created

stats_user_monthly Table statsreads BIGINT 19 0
role_assignments Table component VARCHAR 100

plugin responsible responsible for role assignment, empty when manually assigned

lti_types Table course BIGINT 19 null
data Table comments SMALLINT 5 0
role_assignments Table contextid BIGINT 19 0
grade_items Table grademax DECIMAL 10 100.00000

What is the maximum allowable grade?

external_functions Table classname VARCHAR 100
url Table intro LONGTEXT 2147483647 null
competency_plancomp Table sortorder BIGINT 19 null

Relative sort order

grade_items_history Table display BIGINT 19 0
wiki_subwikis Table groupid BIGINT 19 0

Group that owns this wiki

question_categories Table parent BIGINT 19 0
grade_outcomes_courses Table outcomeid BIGINT 19 null

id of the outcome

grading_instances Table raterid BIGINT 19 null

The ID of the user who did the assessment

backup_logs Table loglevel SMALLINT 5 null

level of the log (debug...error)

scorm_scoes Table organization VARCHAR 255
logstore_standard_log Table realuserid BIGINT 19 null

real user id when logged-in-as

competency_plan Table name VARCHAR 100
assign_grades Table attemptnumber BIGINT 19 0

The attempt number that this grade relates to

lti_tool_settings Table toolproxyid BIGINT 19 null

Primary key of related tool proxy

glossary_formats Table defaultmode VARCHAR 50
qtype_multichoice_options Table id BIGINT 19 null
qtype_ddmarker_drops Table no BIGINT 19 0

drop number

tool_monitor_history Table userid BIGINT 19 null

User to whom this notification was sent

role_allow_view Table id BIGINT 19 null
workshopform_rubric_levels Table id BIGINT 19 null
glossary_entries Table timecreated BIGINT 19 0
lesson Table maxanswers SMALLINT 5 4
analytics_used_analysables Table action VARCHAR 50
grade_items Table needsupdate BIGINT 19 0

If this flag is set, then the whole column will be recalculated

badge_criteria_met Table id BIGINT 19 null
workshop Table evaluation VARCHAR 30

The recently used grading evaluation method

resource Table name VARCHAR 255
workshopform_rubric_levels Table grade DECIMAL 10 null

Grade representing this level.

lesson_answers Table grade SMALLINT 5 0
wiki Table name VARCHAR 255 Wiki

name field for moodle instances

enrol_lti_lti2_consumer Table protected BIT 0 null
grade_grades_history Table oldid BIGINT 19 null
oauth2_endpoint Table url LONGTEXT 2147483647 null

The url to the endpoint

competency_plan Table userid BIGINT 19 null
forum Table scale BIGINT 19 0
badge Table issuerurl VARCHAR 255
choice_answers Table optionid BIGINT 19 0
gradingform_rubric_fillings Table remark LONGTEXT 2147483647 null

Side note feedback regarding this particular criterion

assign_user_flags Table workflowstate VARCHAR 20 null

The current workflow state of the grade

task_scheduled Table component VARCHAR 255

The component this scheduled task belongs to.

glossary_categories Table usedynalink TINYINT 3 1
assign_grades Table grade DECIMAL 10 0.00000

The numerical grade for this assignment submission. Can be determined by scales/advancedgradingforms etc but will always be converted back to a floating point number.

lesson Table grade BIGINT 19 0
competency_plan Table description LONGTEXT 2147483647 null
glossary Table completionentries INT 10 0

Non zero if a certain number of entries are required to mark this glossary complete for a user.

lti_submission Table gradepercent DECIMAL 10 null
survey Table introformat SMALLINT 5 0

intro text field format

oauth2_endpoint Table name VARCHAR 255

The service name.

tool_usertours_steps Table tourid BIGINT 19 null
workshopform_accumulative Table grade BIGINT 19 null

If greater than 0, then the value is maximum grade on a scale 0..grade. If lesser than 0, then its absolute value is the id of a record in scale table. If equals 0, then no grading is possible for this dimension, just commenting.

grade_items_history Table itemtype VARCHAR 30

'mod', 'blocks', 'import', 'calculated' etc

portfolio_instance Table visible BIT 0 1

whether this instance is visible or not

survey_answers Table id BIGINT 19 null
question_response_analysis Table subqid VARCHAR 100
enrol_lti_lti2_consumer Table ltiversion VARCHAR 10 null
wiki_locks Table pageid BIGINT 19 0

Locked page

user_lastaccess Table timeaccess BIGINT 19 0
question_ddwtos Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

backup_logs Table timecreated BIGINT 19 null

timestamp this log entry was created

grade_outcomes_history Table action BIGINT 19 0

created/modified/deleted constants

forum Table displaywordcount BIT 0 0
mnet_host Table last_log_id BIGINT 19 0
user_private_key Table timecreated BIGINT 19 null

created timestamp

scorm Table name VARCHAR 255
oauth2_user_field_mapping Table issuerid BIGINT 19 null

The oauth issuer.

grade_items Table iteminfo LONGTEXT 2147483647 null

Info and notes about this item XXX

config_plugins Table plugin VARCHAR 100 core
task_scheduled Table minute VARCHAR 25
local_ld_course Table userid BIGINT 19 null

Foreign key to the user

mnet_host Table ip_address VARCHAR 45
grading_instances Table timemodified BIGINT 19 null

The timestamp of when the assessment was most recently modified

notifications Table contexturlname LONGTEXT 2147483647 null
competency_usercompplan Table timemodified BIGINT 19 null
analytics_models Table id BIGINT 19 null
course_categories Table coursecount BIGINT 19 0
workshop_grades Table strategy VARCHAR 30
quiz_sections Table shufflequestions SMALLINT 5 0

Whether the question order within this section should be shuffled for each attempt.

quiz Table subnet VARCHAR 255

Used to restrict the IP addresses from which this quiz can be attempted. The format is as requried by the address_in_subnet function.

user_info_field Table sortorder BIGINT 19 0

order within the category

groups Table description LONGTEXT 2147483647 null
lesson_timer Table lessontime BIGINT 19 0
quiz_attempts Table timefinish BIGINT 19 0

Time when the attempt was submitted. 0 if the attempt has not been submitted yet.

analytics_indicator_calc Table contextid BIGINT 19 null
scorm_aicc_session Table timemodified BIGINT 19 0

time this session was last used

scorm_aicc_session Table scoid BIGINT 19 0

id from scorm_scoes table

auth_oauth2_linked_login Table usermodified BIGINT 19 null
editor_atto_autosave Table id BIGINT 19 null
badge_criteria Table id BIGINT 19 null
scorm Table maxattempt BIGINT 19 1
block_zoola_reports_schedule Table subject VARCHAR 1333 null

Email subject

data Table csstemplate LONGTEXT 2147483647 null
comments Table timecreated BIGINT 19 null
enrol Table enrolstartdate BIGINT 19 0

Custom - start of self enrolment

assignment_submissions Table assignment BIGINT 19 0
event Table courseid BIGINT 19 0
message_read Table fullmessagehtml LONGTEXT 2147483647 null

html format of message

quiz Table browsersecurity VARCHAR 32

Restriciton on the browser the student must use. E.g. 'securewindow'.

workshopform_rubric Table sort BIGINT 19 0

Defines the dimension order within the assessment form

enrol Table courseid BIGINT 19 null
scorm Table popup BIT 0 0
lti_submission Table datesubmitted BIGINT 19 null
question_gapselect Table shownumcorrect TINYINT 3 0
tool_policy_versions Table type SMALLINT 5 0

Type of the policy: 0 - Site policy, 1 - Privacy policy, 2 - Third party policy, 99 - Other

log_queries Table id BIGINT 19 null
enrol Table customdec1 DECIMAL 12 null

Custom - general decimal

course_modules Table showdescription BIT 0 0

Some module types support a 'description' which shows within the module pages. This option controls whether it also displays on the course main page. 0 = does not display (default), 1 = displays

course_completion_criteria Table enrolperiod BIGINT 19 null

Number of days after enrolment the course is completed (if using enrolperiod criteria type)

events_queue Table userid BIGINT 19 null

$USER->id when the event was fired

log_queries Table info LONGTEXT 2147483647 null

detailed info such as error text

registration_hubs Table huburl VARCHAR 255
imscp Table course BIGINT 19 0
analytics_models_log Table id BIGINT 19 null
messageinbound_datakeys Table timecreated BIGINT 19 null

The time that the data key was created.

quiz_overrides Table timeclose BIGINT 19 null

Time by which students must have completed their attempt. Can be null, in which case the quiz default is used.

mnet_rpc Table pluginname VARCHAR 20
quiz Table timelimit BIGINT 19 0

The time limit for quiz attempts, in seconds.

feedback_completedtmp Table id BIGINT 19 null
grade_items Table id BIGINT 19 null
tool_dataprivacy_request Table dpocommentformat TINYINT 3 0
quiz Table intro LONGTEXT 2147483647 null

Quiz introduction text.

question Table defaultmark DECIMAL 12 1.0000000
data_fields Table id BIGINT 19 null
qtype_ddimageortext_drops Table label LONGTEXT 2147483647 null

Alt label for drop box

lti_types Table secureicon LONGTEXT 2147483647 null

Secure URL to icon file

scorm Table intro LONGTEXT 2147483647 null
course_modules Table course BIGINT 19 0
course Table category BIGINT 19 0
grade_settings Table value LONGTEXT 2147483647 null
tool_dataprivacy_ctxlst_ctx Table contextid BIGINT 19 null
label Table course BIGINT 19 0
groups Table name VARCHAR 254

Short human readable unique name for the group.

question_statistics Table id BIGINT 19 null
analytics_train_samples Table fileid BIGINT 19 null
task_adhoc Table blocking TINYINT 3 0
competency_usercompcourse Table id BIGINT 19 null
messageinbound_messagelist Table id BIGINT 19 null
competency_framework Table usermodified BIGINT 19 null

The user who last modified this framework

user_devices Table timecreated BIGINT 19 null
scorm_seq_ruleconds Table action VARCHAR 25
forum_discussions Table course BIGINT 19 0
message_providers Table id BIGINT 19 null

id of the table, please edit me

user Table middlename VARCHAR 255 null

Middle name

gradingform_rubric_levels Table definitionformat BIGINT 19 null

The format of the definition field

block_zoola_module_name Table instanceid BIGINT 19 null

Instance id

stats_daily Table timeend BIGINT 19 0
gradingform_guide_criteria Table id BIGINT 19 null
external_tokens Table userid BIGINT 19 null

owner of the token

badge_issued Table dateexpire BIGINT 19 null
enrol_lti_tools Table city VARCHAR 120
course Table startdate BIGINT 19 0
scorm Table introformat SMALLINT 5 0
mnet_host2service Table serviceid BIGINT 19 0
mnet_rpc Table id BIGINT 19 null

Unique Function ID

tool_usertours_tours Table id BIGINT 19 null
data Table listtemplatefooter LONGTEXT 2147483647 null
tool_recyclebin_category Table timecreated BIGINT 19 null
badge_criteria Table criteriatype BIGINT 19 null

The criteria type we are aggregating

chat Table id BIGINT 19 null
sessions Table timemodified BIGINT 19 null
feedback Table introformat SMALLINT 5 0
assign Table maxattempts MEDIUMINT 7 -1

What is the maximum number of student attempts allowed for this assignment? -1 means unlimited.

enrol_lti_lti2_context Table created BIGINT 19 null
upgrade_log Table id BIGINT 19 null
tool_dataprivacy_ctxinstance Table timemodified BIGINT 19 null
qtype_match_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

quiz_attempts Table timestart BIGINT 19 0

Time when the attempt was started.

grading_definitions Table description LONGTEXT 2147483647 null

More detailed description of the form

oauth2_system_account Table id BIGINT 19 null
files Table filearea VARCHAR 50

Like "coursefiles". "submission", "intro" and "content" (images and swf linked from summaries), etc.

tool_customlang_components Table name VARCHAR 255

The normalized name of the plugin

post Table summaryformat TINYINT 3 0
assignment_submissions Table data1 LONGTEXT 2147483647 null
workshop_assessments Table feedbackreviewer LONGTEXT 2147483647 null

The comment/feedback from the teacher for the reviewer. For example the reason why the grade for assessment was overridden

course_completion_defaults Table completionusegrade BIT 0 0
task_scheduled Table classname VARCHAR 255

The class extending scheduled_task to be called when running this task.

event_subscriptions Table userid BIGINT 19 0
forum_discussion_subs Table preference BIGINT 19 1
role_capabilities Table contextid BIGINT 19 0
portfolio_instance Table name VARCHAR 255

name of plugin instance

backup_controllers Table itemid BIGINT 19 null

id of the module/section/activity being backup

feedback_template Table ispublic BIT 0 0
role_capabilities Table id BIGINT 19 null
mnet_host Table deleted BIT 0 0
scorm_scoes_track Table timemodified BIGINT 19 0
scorm_seq_mapinfo Table readsatisfiedstatus BIT 0 1
course_modules_completion Table id BIGINT 19 null
enrol Table customchar3 VARCHAR 1333 null

Custom - general short name

course_modules Table section BIGINT 19 0
quiz Table questionsperpage BIGINT 19 0

How often to insert a page break when editing the quiz, or when shuffling the question order.

message_conversation_members Table userid BIGINT 19 null
assignfeedback_comments Table commenttext LONGTEXT 2147483647 null

The feedback text

tool_policy_versions Table revision VARCHAR 1333

Human readable version of the policy document

cohort Table component VARCHAR 100

Component (plugintype_pluignname) that manages the cohort, manual modifications are allowed only when set to NULL

workshop Table examplesmode SMALLINT 5 0

0 = example assessments are voluntary, 1 = examples must be assessed before submission, 2 = examples are available after own submission and must be assessed before peer/self assessment phase

assignment_submissions Table timemodified BIGINT 19 0
book Table revision BIGINT 19 0
data Table notification BIGINT 19 0

Notify people when things change

qtype_ddimageortext_drops Table ytop BIGINT 19 0
question_attempts Table maxmark DECIMAL 12 null

The grade this question is marked out of in this attempt.

block_recent_activity Table cmid BIGINT 19 null

Course module id

question_hints Table shownumcorrect BIT 0 null

Whether the feedback should include a message about how many things the student got right. This is only applicable to certain question types (for example matching or multiple choice multiple-response).

workshopform_comments Table descriptionformat SMALLINT 5 0

The format of the description field

mnet_remote_rpc Table pluginname VARCHAR 20
stats_user_weekly Table stattype VARCHAR 30
qtype_ddimageortext Table shownumcorrect TINYINT 3 0
qtype_ddimageortext_drags Table questionid BIGINT 19 0
qtype_multichoice_options Table answernumbering VARCHAR 10 abc

Indicates how and whether the choices should be numbered.

quiz_attempts Table timemodified BIGINT 19 0

Last modified time.

backup_controllers Table purpose SMALLINT 5 null

purpose (target) of the backup (general, import, hub...)

competency_relatedcomp Table id BIGINT 19 null
forum_posts Table message LONGTEXT 2147483647 null
scorm_aicc_session Table userid BIGINT 19 0

id from user table

qtype_essay_options Table responsetemplateformat SMALLINT 5 0

The text format for responsetemplate.

post Table id BIGINT 19 null
portfolio_tempdata Table instance BIGINT 19 0

which portfolio plugin instance is being used

context Table depth TINYINT 3 0
lti Table password VARCHAR 255 null
assign_overrides Table sortorder BIGINT 19 null

Rank for sorting overrides.

tool_policy_acceptances Table policyversionid BIGINT 19 null

ID of the policy document version

backup_controllers Table executiontime BIGINT 19 null

epoch secs when the backup should be executed (for delayed backups only)

data Table defaultsort BIGINT 19 0
competency_userevidence Table timecreated BIGINT 19 null
qtype_ddimageortext_drops Table choice BIGINT 19 0
file_conversion Table data LONGTEXT 2147483647 null
mnet_host Table transport TINYINT 3 0
workshopallocation_scheduled Table resultmessage VARCHAR 1333 null

Optional short message describing the resulting status

assignment Table grade BIGINT 19 0
repository_instances Table userid BIGINT 19 0
post Table summary LONGTEXT 2147483647 null
course_request Table id BIGINT 19 null
user Table idnumber VARCHAR 255
workshop_submissions Table late TINYINT 3 0

Has this submission been submitted after the deadline or during the assessment phase?

grading_instances Table feedbackformat TINYINT 3 null

The format of the feedback field

messageinbound_handlers Table classname VARCHAR 255

The class defining the Inbound Message handler to be called.

block_zoola_reports_schedule Table id BIGINT 19 null
logstore_standard_log Table crud VARCHAR 1
question_usages Table contextid BIGINT 19 null

Every question usage must be associated with some context.

assignfeedback_editpdf_quick Table width BIGINT 19 120
grade_grades Table usermodified BIGINT 19 null

the userid of the person who last modified this grade

competency_usercompplan Table proficiency TINYINT 3 null

Indicate if the competency is proficient not.

files Table filename VARCHAR 255

The full Unicode name of this file (case sensitive) - some chars are not allowed though

task_adhoc Table id BIGINT 19 null
enrol_lti_users Table membershipsid LONGTEXT 2147483647 null
lesson Table bgcolor VARCHAR 7 #FFFFFF
mnet_log Table hostid BIGINT 19 0

Unique host ID

competency_templatecohort Table timemodified BIGINT 19 null
book Table customtitles TINYINT 3 0
quiz_attempts Table timemodifiedoffline BIGINT 19 0

Last modified time via web services.

grade_import_values Table importer BIGINT 19 null
workshop_assessments Table weight BIGINT 19 1

The weight of the assessment for the purposes of aggregation

enrol Table enrolperiod BIGINT 19 0

Custom - enrolment duration

badge_external Table id BIGINT 19 null
external_tokens Table timecreated BIGINT 19 null

created timestamp

scorm Table maxgrade DOUBLE 22 0
analytics_prediction_actions Table actionname VARCHAR 255
workshop_submissions Table contentformat SMALLINT 5 0

The format of submission text

course_categories Table path VARCHAR 255
qtype_randomsamatch_options Table partiallycorrectfeedbackformat TINYINT 3 0
block_community Table imageurl VARCHAR 255
external_services Table timemodified BIGINT 19 null
question_gapselect Table partiallycorrectfeedbackformat TINYINT 3 0
mnetservice_enrol_enrolments Table userid BIGINT 19 null

ID of our local user on this server

feedback_item Table presentation LONGTEXT 2147483647 null
tool_policy_versions Table id BIGINT 19 null
upgrade_log Table plugin VARCHAR 100 null
enrol_lti_lti2_resource_link Table contextid BIGINT 19 null
workshop_grades Table peercomment LONGTEXT 2147483647 null

Reviewer's comment to the grade value.

badge Table issuername VARCHAR 255
feedback_item Table typ VARCHAR 255
gradingform_guide_fillings Table id BIGINT 19 null
notifications Table smallmessage LONGTEXT 2147483647 null
tool_dataprivacy_ctxlevel Table purposeid BIGINT 19 null
course_published Table enrollable BIT 0 1

1 = enrollable, 0 = downloadable

glossary Table name VARCHAR 255
competency_evidence Table desccomponent VARCHAR 255
enrol_lti_tools Table gradesync BIT 0 0
grade_outcomes_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

question_gapselect Table correctfeedbackformat TINYINT 3 0
grade_outcomes_courses Table courseid BIGINT 19 null

id of the course

task_adhoc Table customdata LONGTEXT 2147483647 null

Custom data to be passed to the adhoc task. Must be serialisable using json_encode()

groupings_groups Table timeadded BIGINT 19 0
question_numerical_units Table question BIGINT 19 0

Foreign key references question.id

grading_definitions Table areaid BIGINT 19 null
groupings Table timecreated BIGINT 19 0
mnet_service Table name VARCHAR 40
tool_dataprivacy_request Table status BIT 0 0

The current status of the data request

message_contacts Table blocked BIT 0 0
forum_discussions Table groupid BIGINT 19 -1
groups_members Table timeadded BIGINT 19 0
book Table introformat SMALLINT 5 0
block_zoola_reports Table id BIGINT 19 null
message Table fullmessage LONGTEXT 2147483647 null
assignfeedback_editpdf_annot Table x BIGINT 19 0

x-position of the start of the annotation (in pixels - image resolution is set to 100 pixels per inch)

lesson Table intro LONGTEXT 2147483647 null
enrol_paypal Table reason_code VARCHAR 30
course Table format VARCHAR 21 topics
assign Table teamsubmission TINYINT 3 0

Do students submit in teams?

feedback Table multiple_submit BIT 0 1
tool_monitor_events Table id BIGINT 19 null
question_calculated_options Table shownumcorrect TINYINT 3 0

If true, then when the user gets a multiple-response question partially correct, tell them how many choices they got correct alongside the feedback.

course_modules_completion Table completionstate BIT 0 null

Whether or not the user has completed the activity. Available states: 0 = not completed if there's no row in this table, that also counts as 0 1 = completed 2 = completed, show passed 3 = completed, show failed

qtype_ddmarker Table questionid BIGINT 19 0
block_instances Table requiredbytheme SMALLINT 5 0

If 1, this block was created because it was required by the theme and did not exist.

tool_policy_versions Table summaryformat SMALLINT 5 null

Format of the summary field

tag_area Table id BIGINT 19 null
external_functions Table classpath VARCHAR 255 null
data Table id BIGINT 19 null
scorm_seq_mapinfo Table targetobjectiveid BIGINT 19 0
tool_usertours_tours Table pathmatch VARCHAR 255 null
message Table smallmessage LONGTEXT 2147483647 null

Smal version of message (eg sms)

block_rss_client Table userid BIGINT 19 0
enrol_lti_lti2_tool_proxy Table id BIGINT 19 null
lesson_branch Table timeseen BIGINT 19 0
course Table lang VARCHAR 30
search_simpledb_index Table id BIGINT 19 null
quiz Table delay2 BIGINT 19 0

Delay that must be left between the second and subsequent attempt, in seconds.

tag_area Table showstandard BIT 0 0
lti Table typeid BIGINT 19 null

Basic LTI type

competency_coursecompsetting Table pushratingstouserplans TINYINT 3 null

Does this course push ratings to user plans?

user Table deleted BIT 0 0
portfolio_tempdata Table userid BIGINT 19 null

psuedo fk to user. this is stored in the serialised data structure in the data field, but added here for ease of lookups.

stats_monthly Table courseid BIGINT 19 0
analytics_predictions Table prediction DECIMAL 10 null
mnet_application Table sso_land_url VARCHAR 255
assign Table teamsubmissiongroupingid BIGINT 19 0

A grouping id to get groups for team submissions

qtype_match_options Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

forum_digests Table userid BIGINT 19 null
filter_active Table filter VARCHAR 32

The filter internal name, like 'tex'.

message_popup_notifications Table id BIGINT 19 null
files Table id BIGINT 19 null
upgrade_log Table version VARCHAR 100 null

plugin or main version if known

cohort_members Table cohortid BIGINT 19 0
notifications Table fullmessageformat BIT 0 0
question_calculated_options Table partiallycorrectfeedbackformat TINYINT 3 0
competency_coursecompsetting Table timecreated BIGINT 19 null

The time this setting was created.

workshop_aggregations Table id BIGINT 19 null
lesson_answers Table answer LONGTEXT 2147483647 null
scorm Table auto BIT 0 0
tool_monitor_subscriptions Table lastnotificationsent BIGINT 19 0

Timestamp of the time when a notification was last sent for this subscription.

block Table visible BIT 0 1
mnet_rpc Table functionname VARCHAR 40
event Table uuid VARCHAR 255
grade_categories Table aggregateonlygraded BIT 0 0

aggregate only graded activities

resource_old Table id BIGINT 19 null
badge_criteria_met Table critid BIGINT 19 null
oauth2_issuer Table timecreated BIGINT 19 null

Time this record was created.

survey Table name VARCHAR 255
question_gapselect Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

notifications Table eventtype VARCHAR 100 null
grade_grades_history Table rawgrademin DECIMAL 10 0.00000

The minimum allowable grade when this was created

user Table country VARCHAR 2
grade_items_history Table action BIGINT 19 0

created/modified/deleted constants

page Table course BIGINT 19 0
rating Table userid BIGINT 19 null
upgrade_log Table details LONGTEXT 2147483647 null
data_fields Table dataid BIGINT 19 0
user_info_field Table datatype VARCHAR 255

Type of data held in this field

blog_external Table id BIGINT 19 null
question_gapselect Table shuffleanswers SMALLINT 5 1
tag_instance Table component VARCHAR 100

Defines the Moodle component which the tag was added to

assign Table revealidentities TINYINT 3 0

Show identities for a blind marking assignment

auth_oauth2_linked_login Table username VARCHAR 255

The external username to map to this moodle account

qtype_essay_options Table responsefieldlines SMALLINT 5 15

Approximate height, in lines, of the input box the students should be given for their response.

competency_modulecomp Table cmid BIGINT 19 null

ID of the record in the course_modules table.

grade_items Table locked BIGINT 19 0

1 is locked, > 1 is a date to lock until (prevents update)

scorm_seq_mapinfo Table objectiveid BIGINT 19 0
block_zoola_reports_user Table userid BIGINT 19 null

User ID

data Table maxentries INT 10 0
tool_dataprivacy_ctxlevel Table usermodified BIGINT 19 null
forum Table completionreplies INT 10 0

Nonzero if a certain number of replies are required to mark this forum complete for a user.

mnet_application Table display_name VARCHAR 50
competency_usercomp Table grade BIGINT 19 null

Grade assigned to the competency.

tool_usertours_steps Table targetvalue LONGTEXT 2147483647 null

The value for the specified target type.

message_read Table component VARCHAR 100 null
user_preferences Table userid BIGINT 19 0
assignsubmission_onlinetext Table assignment BIGINT 19 0
chat_users Table firstping BIGINT 19 0
event Table format SMALLINT 5 0
forum_read Table discussionid BIGINT 19 0
survey Table completionsubmit BIT 0 0

If this field is set to 1, then the activity will be automatically marked as 'complete' once the user submits the survey.

assignment Table var3 BIGINT 19 0
tool_dataprivacy_category Table timemodified BIGINT 19 null
grade_categories Table droplow BIGINT 19 0

Drop the X lowest items

portfolio_instance_user Table id BIGINT 19 null
lti Table instructorchoicesendname BIT 0 null

Send user's name

workshop Table conclusionformat SMALLINT 5 1

The format of the conclusion field content.

badge_manual_award Table datemet BIGINT 19 null
post Table groupid BIGINT 19 0
forum Table course BIGINT 19 0
scorm Table height BIGINT 19 600
messageinbound_messagelist Table timecreated BIGINT 19 null
survey_answers Table answer2 LONGTEXT 2147483647 null
enrol_lti_lti2_resource_link Table consumerid BIGINT 19 null
feedback_sitecourse_map Table feedbackid BIGINT 19 0
cache_flags Table name VARCHAR 255
cache_filters Table timemodified BIGINT 19 0
event Table eventtype VARCHAR 20
user_info_data Table id BIGINT 19 null
survey_analysis Table userid BIGINT 19 0
folder Table showdownloadfolder BIT 0 1

1 = show download folder button

lti_tool_proxies Table vendorcode VARCHAR 255 null
message Table fullmessagehtml LONGTEXT 2147483647 null

html format of message

workshopform_numerrors_map Table grade DECIMAL 10 null

Percentual grade 0..100 for this number of negative responses

course_modules Table id BIGINT 19 null
enrol_lti_tool_consumer_map Table consumerid BIGINT 19 null

The consumer ID.

qtype_match_options Table correctfeedbackformat TINYINT 3 0
glossary Table mainglossary TINYINT 3 0
tool_monitor_subscriptions Table inactivedate BIGINT 19 0
choice Table limitanswers TINYINT 3 0
tag_area Table multiplecontexts BIT 0 0

Whether the tag area allows tag instances to be created in multiple contexts.

file_conversion Table sourcefileid BIGINT 19 null
grade_grades Table rawgrademax DECIMAL 10 100.00000

The maximum allowable grade when this was created

competency Table ruletype VARCHAR 100 null
tool_monitor_events Table contextid BIGINT 19 null

Context id

badge_backpack Table backpackurl VARCHAR 255
tool_monitor_subscriptions Table cmid BIGINT 19 null

Course module id

feedback_valuetmp Table completed BIGINT 19 0
local_ld_import_logs_status Table status VARCHAR 20 notscheduled

Current status of the import log task ('notscheduled', 'scheduled', 'inprogress', 'finished')

assignsubmission_file Table numfiles BIGINT 19 0

The number of files the student submitted.

resource Table introformat SMALLINT 5 0
groupings_groups Table groupid BIGINT 19 0
mnet_service Table id BIGINT 19 null

Unique Service ID

mnet_host2service Table publish BIT 0 0
workshop Table useselfassessment TINYINT 3 0

optional feature: students perform self assessment of their own work

role_capabilities Table modifierid BIGINT 19 0
badge Table message LONGTEXT 2147483647 null
lti_types Table tooldomain VARCHAR 255
logstore_standard_log Table eventname VARCHAR 255
scorm Table displayactivityname SMALLINT 5 1
course_modules Table instance BIGINT 19 0
scale_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

mnet_sso_access_control Table mnet_host_id BIGINT 19 0

id of mnet host

enrol_paypal Table option_selection1_x VARCHAR 255
enrol_lti_users Table id BIGINT 19 null
tool_customlang Table timecustomized BIGINT 19 null

The timestamp of when the value of the local translation was recently modified, null if not customized yet

mnet_remote_service2rpc Table rpcid BIGINT 19 0

Unique Function ID

local_ld_import_logs_status Table progress DECIMAL 10 0.00

Percentage of work done (0 - 100)

scorm Table timemodified BIGINT 19 0
tool_dataprivacy_request Table type BIGINT 19 0

Data request type

badge_criteria_met Table userid BIGINT 19 null
log_display Table module VARCHAR 20
analytics_models_log Table version BIGINT 19 null
glossary Table displayformat VARCHAR 50 dictionary
analytics_used_files Table time BIGINT 19 0
filter_config Table filter VARCHAR 32

The filter internal name, like 'tex'.

grade_items Table sortorder BIGINT 19 0

Sorting order of the columns

forum Table blockperiod BIGINT 19 0
block_positions Table weight BIGINT 19 null

Used to order the blocks within a block region.

grade_items Table categoryid BIGINT 19 null

(optional) the category group this item belongs to

message_popup Table isread BIT 0 0
qtype_ddimageortext_drops Table questionid BIGINT 19 0
config_plugins Table name VARCHAR 100
glossary_alias Table alias VARCHAR 255
grade_import_values Table importonlyfeedback BIT 0 0
block_community Table id BIGINT 19 null
feedback Table name VARCHAR 255
quiz Table decimalpoints SMALLINT 5 2

Number of decimal points to use when displaying grades.

analytics_models Table timemodified BIGINT 19 null
workshop_assessments Table gradinggrade DECIMAL 10 null

The computed grade 0..100 for this assessment. If NULL then it has not been computed yet.

scorm_seq_rulecond Table measurethreshold FLOAT 11 0.0000
lesson_grades Table userid BIGINT 19 0
course_sections Table name VARCHAR 255 null
feedback_item Table required BIT 0 0
enrol Table customchar1 VARCHAR 255 null

Custom - general short name

tool_dataprivacy_ctxexpired Table status TINYINT 3 0
workshopform_rubric_levels Table dimensionid BIGINT 19 null

Which criterion this level is part of

grade_letters Table contextid BIGINT 19 null

What contextid does this letter apply to (for now these will always be courses, but later...)

role_names Table name VARCHAR 255
stats_user_daily Table courseid BIGINT 19 0
portfolio_tempdata Table data LONGTEXT 2147483647 null

dumping ground for portfolio callers to store their data in.

workshop_assessments Table id BIGINT 19 null
lti_types_config Table id BIGINT 19 null
logstore_standard_log Table contextlevel BIGINT 19 null
mnet_log Table id BIGINT 19 null
lesson_overrides Table timelimit BIGINT 19 null

Time limit in seconds. Can be null, in which case the lesson default is used.

role_assignments Table itemid BIGINT 19 0

Id of enrolment/auth instance responsible for this role assignment

enrol_lti_lti2_context Table consumerid BIGINT 19 null
enrol_lti_lti2_user_result Table ltiuserkey VARCHAR 255
workshop_submissions Table gradeoverby BIGINT 19 null

The id of the user who has overridden the grade for submission.

lesson_timer Table lessonid BIGINT 19 0
qtype_ddimageortext Table shuffleanswers SMALLINT 5 1
user Table maildigest BIT 0 0
grading_areas Table id BIGINT 19 null
qtype_shortanswer_options Table questionid BIGINT 19 0

Foreign key references question.id.

competency_coursecomp Table usermodified BIGINT 19 null

The user who modified this link.

tool_usertours_tours Table enabled BIT 0 0
scorm Table navpositionleft BIGINT 19 -100
lesson_attempts Table userid BIGINT 19 0
local_ld_module_day Table daytime BIGINT 19 null

Timestamp of the beginning of the day

user Table lastnamephonetic VARCHAR 255 null

Last name phonetic

stats_user_monthly Table stattype VARCHAR 30
stats_daily Table stat1 BIGINT 19 0

stat1. usually used for reads

grade_import_values Table userid BIGINT 19 null
tag_instance Table contextid BIGINT 19 null

The context id of the item that was tagged

feedback_value Table completed BIGINT 19 0
repository Table type VARCHAR 255
scorm_aicc_session Table scormid BIGINT 19 0

id from scorm table

repository_instances Table readonly BIT 0 0
assign_user_flags Table locked BIGINT 19 0

Student cannot make any changes to their submission if this flag is set.

course Table newsitems MEDIUMINT 7 1
competency_plan Table timecreated BIGINT 19 null
assign_submission Table id BIGINT 19 null
glossary_alias Table id BIGINT 19 null
assignment Table preventlate TINYINT 3 0
local_ld_module_day Table day VARCHAR 10

Day formatted as 'YYYY-MM-DD'

choice Table display SMALLINT 5 0
my_pages Table name VARCHAR 200

The page name (freeform text)

workshop Table maxbytes BIGINT 19 100000

Maximum size of the one attached file

grade_items Table idnumber VARCHAR 255 null

Arbitrary idnumber provided by the module responsible

choice_options Table id BIGINT 19 null
stats_weekly Table roleid BIGINT 19 0

id of role for the aggregates

qtype_randomsamatch_options Table choose BIGINT 19 4

Number of subquestions to randomly generate.

grade_items Table outcomeid BIGINT 19 null

If this grade is related to an outcome, which one is it?

grade_items_history Table itemnumber BIGINT 19 null

Can be used to distinguish multiple grades for an activity

repository Table sortorder BIGINT 19 0
workshopform_numerrors Table grade0 VARCHAR 50 null

The word describing the negative evaluation (like Poor, Missing, Absent, etc.). If NULL, it defaults to a translated string False

user_info_category Table name VARCHAR 255

Category name

lesson_answers Table lessonid BIGINT 19 0
file_conversion Table converter VARCHAR 255 null
data_content Table content1 LONGTEXT 2147483647 null
forum Table assesstimestart BIGINT 19 0
search_simpledb_index Table modified BIGINT 19 null
qtype_essay_options Table questionid BIGINT 19 null

Foreign key linking to the question table.

wiki Table forceformat BIT 0 1

Forces the default editor

lesson_grades Table id BIGINT 19 null
enrol_lti_tools Table membersync BIT 0 0
portfolio_instance_config Table instance BIGINT 19 null

instance of plugin we're configurating

event Table timeduration BIGINT 19 0
auth_oauth2_linked_login Table confirmtokenexpires BIGINT 19 null
gradingform_guide_comments Table descriptionformat TINYINT 3 null

The format of the description field

tool_dataprivacy_purpose Table descriptionformat BIT 0 null
course Table idnumber VARCHAR 100
course_format_options Table courseid BIGINT 19 null

Id of the course

local_ld_module_day Table id BIGINT 19 null
tag_correlation Table tagid BIGINT 19 null
competency_usercomp Table id BIGINT 19 null
oauth2_user_field_mapping Table usermodified BIGINT 19 null

The user who modified this record.

competency Table scaleconfiguration LONGTEXT 2147483647 null
task_scheduled Table nextruntime BIGINT 19 null
mnet_sso_access_control Table id BIGINT 19 null

Required ID field

badge_criteria_param Table id BIGINT 19 null
backup_controllers Table timemodified BIGINT 19 null

last time the controller was modified

grade_grades Table finalgrade DECIMAL 10 null

The final grade (cached) after all calculations are made

question_numerical_options Table unitsleft SMALLINT 5 0

display the unit at left as in $1.00

external_tokens Table externalserviceid BIGINT 19 null
question_attempts Table questionusageid BIGINT 19 null

Foreign key, references question_usages.id

feedback_item Table template BIGINT 19 0
assignfeedback_editpdf_cmnt Table y BIGINT 19 0

y-position of the top-left corner of the comment (in pixels - image resolution is set to 100 pixels per inch)

badge_backpack Table autosync BIT 0 0
gradingform_guide_fillings Table remarkformat TINYINT 3 null

The format of the remark field

local_ld_course Table courseid BIGINT 19 null

Foreign key to the course

wiki_pages Table timerendered BIGINT 19 0

Last render timestamp

analytics_predict_samples Table modelid BIGINT 19 null
competency Table ruleoutcome TINYINT 3 0
backup_courses Table id BIGINT 19 null
messages Table smallmessage LONGTEXT 2147483647 null
user Table picture BIGINT 19 0

0 means no image uploaded, positive values are revisions thta prevent caching problems, negative values are reserved for future use

analytics_used_analysables Table id BIGINT 19 null
quiz Table preferredbehaviour VARCHAR 32

The behaviour to ask questions to use.

assign Table sendlatenotifications TINYINT 3 0

Allows separate enabling of notifications for late assignment submissions.

page Table contentformat SMALLINT 5 0
user_private_key Table script VARCHAR 128

plugin, module - unique identifier

page Table timemodified BIGINT 19 0
question_dataset_definitions Table category BIGINT 19 0
message_read Table timeuserfromdeleted BIGINT 19 0
survey_questions Table intro VARCHAR 50
backup_controllers Table execution SMALLINT 5 null

type of execution (immediate/delayed)

grade_items_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

course_categories Table descriptionformat TINYINT 3 0
lti Table secureicon LONGTEXT 2147483647 null
messageinbound_messagelist Table userid BIGINT 19 null
tool_dataprivacy_ctxlst_ctx Table id BIGINT 19 null
chat Table studentlogs SMALLINT 5 0
glossary_entries Table userid BIGINT 19 0
post Table subject VARCHAR 128
workshop Table assessmentstart BIGINT 19 0

0 = will be started manually, greater than 0 the timestamp of the start of the assessment phase

glossary_formats Table showtabs VARCHAR 100 null
competency_usercompplan Table usermodified BIGINT 19 null
task_scheduled Table month VARCHAR 25
mnet_host2service Table hostid BIGINT 19 0
grade_grades_history Table usermodified BIGINT 19 null

the userid of the person who last modified this grade

tool_policy_acceptances Table lang VARCHAR 30

Code of the language the user had when the policy document was displayed

enrol_lti_users Table consumerkey LONGTEXT 2147483647 null
gradingform_rubric_levels Table definition LONGTEXT 2147483647 null

The optional text describing the level

analytics_indicator_calc Table value DECIMAL 10 null

The calculated value, it can be null.

competency_userevidence Table description LONGTEXT 2147483647 null
forum Table completiondiscussions INT 10 0

Nonzero if a certain number of posts are required to mark this forum completed for a user.

stats_user_weekly Table id BIGINT 19 null
feedback_completedtmp Table userid BIGINT 19 0
competency_usercompplan Table planid BIGINT 19 null

Plan associated to the user.

quiz_overrides Table groupid BIGINT 19 null

Foreign key references groups.id. Can be null if this is a per-user override.

workshop Table grade DECIMAL 10 80.00000

The maximum grade for submission

workshop Table assessmentend BIGINT 19 0

0 = will be closed manually, greater than 0 the timestamp of the end of the assessment phase

logstore_standard_log Table objectid BIGINT 19 null
question_calculated_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

competency_coursecomp Table id BIGINT 19 null
workshop Table instructauthors LONGTEXT 2147483647 null

Instructions for the submission phase

qtype_ddimageortext Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

grade_categories_history Table aggregateonlygraded BIT 0 0

aggregate only graded items

user Table lastlogin BIGINT 19 0
message Table id BIGINT 19 null
question_calculated Table tolerance VARCHAR 20 0.0
question_multianswer Table question BIGINT 19 0
data_records Table timemodified BIGINT 19 0
qtype_ddmarker_drags Table noofdrags BIGINT 19 1

No of drag items, ignored if drag is infinite.

lesson_overrides Table userid BIGINT 19 null

Foreign key references user.id. Can be null if this is a per-group override.

analytics_predictions Table calculations LONGTEXT 2147483647 null
wiki Table timemodified BIGINT 19 0
block_zoola_reports Table type VARCHAR 20

Resource type: reportUnit or reportOptions

forum_posts Table id BIGINT 19 null
lesson_answers Table timemodified BIGINT 19 0
message Table useridto BIGINT 19 0
lti Table intro LONGTEXT 2147483647 null

General introduction of the basiclti activity

question_answers Table question BIGINT 19 0
question_attempt_step_data Table id BIGINT 19 null
gradingform_guide_criteria Table maxscore DECIMAL 10 null

maximum grade that can be assigned using this criterion

tool_dataprivacy_contextlist Table timemodified BIGINT 19 0
events_handlers Table handlerfunction LONGTEXT 2147483647 null

serialized string or array describing function, suitable to be passed to call_user_func()

user_private_key Table iprestriction VARCHAR 255 null

ip restriction

scale_history Table name VARCHAR 255
event Table visible SMALLINT 5 1
tool_monitor_subscriptions Table ruleid BIGINT 19 null

Rule id

repository_onedrive_access Table itemid VARCHAR 255

The item id in OneDrive.

role_assignments Table modifierid BIGINT 19 0
data_records Table dataid BIGINT 19 0
qtype_ddmarker Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

role_assignments Table timemodified BIGINT 19 0
block_zoola_module_name Table coursemoduleid BIGINT 19 null

Course module id

enrol_lti_tools Table maxenrolled BIGINT 19 0
grade_items_history Table hidden BIGINT 19 0

1 is hidden, > 1 is a date to hide until (prevents viewing)

data Table intro LONGTEXT 2147483647 null
resource_old Table type VARCHAR 30
grade_outcomes_history Table source VARCHAR 255 null

What caused the modification? manual/module/import/...

upgrade_log Table info VARCHAR 255
logstore_standard_log Table other LONGTEXT 2147483647 null
filter_config Table value LONGTEXT 2147483647 null

The correspoding config variable value.

badge_external Table collectionid BIGINT 19 null

Badge collection id in the backpack

resource Table tobemigrated SMALLINT 5 0
grade_items_history Table courseid BIGINT 19 null

The course this item is part of

mnet_log Table course BIGINT 19 0
lti Table showdescriptionlaunch BIT 0 0
workshopallocation_scheduled Table workshopid BIGINT 19 null

workshop id we are part of

mnet_host Table wwwroot VARCHAR 255
lesson_timer Table timemodifiedoffline BIGINT 19 0

Last modified time via web services (mobile app).

question_truefalse Table id BIGINT 19 null
logstore_standard_log Table courseid BIGINT 19 null
scorm Table revision BIGINT 19 0

revison number

badge Table type BIT 0 1

1 = site, 2 = course

mnetservice_enrol_courses Table id BIGINT 19 null

Unique remote-course ID

groupings Table name VARCHAR 255

Short human readable unique name for group.

enrol_lti_tools Table institution VARCHAR 40
notifications Table fullmessagehtml LONGTEXT 2147483647 null
groupings Table configdata LONGTEXT 2147483647 null

extra configuration data - may be used by group IU tools

label Table intro LONGTEXT 2147483647 null
workshopform_rubric_config Table layout VARCHAR 30 list

How should the rubric be displayed for reviewers

data_fields Table param9 LONGTEXT 2147483647 null
mnet_session Table expires BIGINT 19 0

Expire time of session on peer

groupings_groups Table groupingid BIGINT 19 0
course_request Table summaryformat TINYINT 3 0
course_completion_defaults Table module BIGINT 19 null
mnet_log Table cmid BIGINT 19 0
logstore_standard_log Table objecttable VARCHAR 50 null
qtype_ddmarker Table incorrectfeedbackformat TINYINT 3 0
question_statistics Table discriminationindex DECIMAL 15 null
tool_dataprivacy_ctxlevel Table timecreated BIGINT 19 null
block_recent_activity Table modname VARCHAR 20 null

module type name (for delete action)

search_simpledb_index Table docid VARCHAR 255
rating Table rating BIGINT 19 null
competency_userevidence Table url LONGTEXT 2147483647 null
assign_grades Table timemodified BIGINT 19 0

The most recent modification time for the assignment submission by a grader.

question_gapselect Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

role_assignments Table userid BIGINT 19 0
grade_grades_history Table finalgrade DECIMAL 10 null

The final grade (cached) after all calculations are made

tool_monitor_rules Table name VARCHAR 254

Name of the rule

mnet_host Table force_theme BIT 0 0
lesson_attempts Table lessonid BIGINT 19 0
quiz_slots Table quizid BIGINT 19 0

Foreign key references quiz.id.

files Table itemid BIGINT 19 null

Optional - some plugin specific item id (eg. forum post, blog entry or assignment submission, user id for user files)

course_completion_criteria Table id BIGINT 19 null
lesson Table nextpagedefault SMALLINT 5 0
competency_modulecomp Table ruleoutcome TINYINT 3 null

The outcome when an activity is completed.

competency_coursecomp Table courseid BIGINT 19 null

The course this competency is linked to.

sessions Table state BIGINT 19 0

0 means normal session

enrol Table customchar2 VARCHAR 255 null

Custom - general short name

book_chapters Table pagenum BIGINT 19 0
competency_plan Table id BIGINT 19 null
competency_template Table contextid BIGINT 19 null
grading_instances Table itemid BIGINT 19 null

This identifies the graded item within the grabable area

message_contacts Table userid BIGINT 19 0
repository_instance_config Table value LONGTEXT 2147483647 null
external_services Table enabled BIT 0 null
tag Table descriptionformat TINYINT 3 0
analytics_models_log Table timecreated BIGINT 19 null
tool_cohortroles Table userid BIGINT 19 null

The user to sync

scorm Table lastattemptlock BIT 0 0
competency_plan Table descriptionformat SMALLINT 5 0
scorm_scoes Table title VARCHAR 255
grade_outcomes_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

user Table id BIGINT 19 null
resource_old Table name VARCHAR 255
registration_hubs Table secret VARCHAR 255 null

the unique site identifier for this hub

user_devices Table appid VARCHAR 128

the app id, usually something like com.moodle.moodlemobile

folder Table showexpanded BIT 0 1

1 = expanded, 0 = collapsed for sub-folders

workshopform_numerrors_map Table id BIGINT 19 null
grade_grades_history Table exported BIGINT 19 0

date of last grade export, 0 if none

data Table singletemplate LONGTEXT 2147483647 null
assignfeedback_editpdf_quick Table userid BIGINT 19 0
course_completion_defaults Table completionview BIT 0 0
quiz Table timeopen BIGINT 19 0

The time when this quiz opens. (0 = no restriction.)

glossary Table allowprintview TINYINT 3 1
forum Table name VARCHAR 255
quiz_slots Table includingsubcategories SMALLINT 5 null

Whether the random question can be picked from sub categories or not. Will be null if questioncategoryid is null.

lesson Table height BIGINT 19 480
feedback_valuetmp Table tmp_completed BIGINT 19 0
assign_user_mapping Table userid BIGINT 19 0
file_conversion Table id BIGINT 19 null
groups Table hidepicture BIT 0 0
assignment Table timemodified BIGINT 19 0
competency_framework Table description LONGTEXT 2147483647 null

Description of this competency framework

scorm_scoes_track Table element VARCHAR 255
user_info_field Table param5 LONGTEXT 2147483647 null

General parameter field

survey Table id BIGINT 19 null
folder Table course BIGINT 19 0
scorm Table completionstatusallscos BIT 0 null
workshop Table conclusion LONGTEXT 2147483647 null

A text to be displayed at the end of the workshop.

course_published Table huburl VARCHAR 255 null

the url of the "registered on" hub

gradingform_rubric_criteria Table id BIGINT 19 null
workshop_submissions Table workshopid BIGINT 19 null

the id of the workshop instance

qtype_match_subquestions Table id BIGINT 19 null
lesson_timer Table starttime BIGINT 19 0
config Table name VARCHAR 255
grade_items_history Table id BIGINT 19 null
workshop_assessments Table feedbackreviewerformat SMALLINT 5 0
gradingform_guide_fillings Table instanceid BIGINT 19 null

The ID of the grading form instance

portfolio_instance_config Table value LONGTEXT 2147483647 null

config value

external_services Table id BIGINT 19 null
user_info_field Table signup TINYINT 3 0

display field on signup page

page Table introformat SMALLINT 5 0
messages Table subject LONGTEXT 2147483647 null
auth_oauth2_linked_login Table email LONGTEXT 2147483647 null

The external email to map to this moodle account

choice Table timeopen BIGINT 19 0
scorm_seq_rolluprulecond Table cond VARCHAR 25
data Table assesstimefinish BIGINT 19 0
feedback_template Table name VARCHAR 255
backup_logs Table id BIGINT 19 null
file_conversion Table destfileid BIGINT 19 null
lesson Table deadline BIGINT 19 0
analytics_models_log Table target VARCHAR 255
scorm_seq_ruleconds Table ruletype TINYINT 3 0
badge Table issuercontact VARCHAR 255 null
course_categories Table visibleold BIT 0 1

the state of visible field when hiding parent category, this helps us to recover hidden states when unhiding the parent category later

competency_relatedcomp Table usermodified BIGINT 19 null
feedback_completedtmp Table anonymous_response BIT 0 0
grading_definitions Table id BIGINT 19 null
badge Table usercreated BIGINT 19 null
wiki_locks Table lockedat BIGINT 19 0

timestamp

cache_flags Table timemodified BIGINT 19 0
mnet_service Table offer BIT 0 0

Do we even offer this service?

block_recent_activity Table timecreated BIGINT 19 null
folder Table introformat SMALLINT 5 0
workshopform_numerrors Table description LONGTEXT 2147483647 null

The description of the dimension

tool_usertours_steps Table targettype TINYINT 3 null

Type of the target (e.g. block, CSS selector, etc.)

gradingform_guide_criteria Table definitionid BIGINT 19 null

The ID of the form definition this criterion is part of

message_conversations Table convhash VARCHAR 40
scale_history Table source VARCHAR 255 null

What caused the modification? manual/module/import/...

stats_weekly Table courseid BIGINT 19 0
course_completion_crit_compl Table unenroled BIGINT 19 null

Timestamp when the user was unenroled

question Table parent BIGINT 19 0
user Table calendartype VARCHAR 30 gregorian
message_read Table useridto BIGINT 19 0
feedback_value Table item BIGINT 19 0
workshop_grades Table grade DECIMAL 10 null

Given grade in the referenced assessment dimension.

assign Table attemptreopenmethod VARCHAR 10 none

How to determine when students are allowed to open a new submission. Valid options are none, manual, untilpass

editor_atto_autosave Table timemodified BIGINT 19 0

Store the last modified time for the auto save text.

question Table penalty DECIMAL 12 0.3333333
grade_grades Table rawgrade DECIMAL 10 null

If the grade is a float value (or has been converted to one)

question_attempt_steps Table timecreated BIGINT 19 null

Time-stamp of the action that lead to this state being created.

local_ld_lastactivity Table coursemoduleid BIGINT 19 0

Coursemodule id

glossary Table scale BIGINT 19 0
block_zoola_reports_cohort Table blockinstanceid BIGINT 19 null

Block instance ID

wiki Table introformat SMALLINT 5 0

Format of the intro field (MOODLE, HTML, MARKDOWN...)

quiz_slot_tags Table id BIGINT 19 null
course_published Table timepublished BIGINT 19 null

The time when the publication occurred

lesson Table timemodified BIGINT 19 0
workshop_grades Table dimensionid BIGINT 19 null

Foreign key. References dimension id in one of the grading strategy tables.

wiki_pages Table readonly BIT 0 0

Read only flag

assignment_submissions Table id BIGINT 19 null
qtype_randomsamatch_options Table correctfeedbackformat TINYINT 3 0
glossary Table entbypage SMALLINT 5 10
quiz_attempts Table sumgrades DECIMAL 10 null

Total marks for this attempt.

scorm Table navpositiontop BIGINT 19 -100
mnet_host Table applicationid BIGINT 19 1
tool_policy_acceptances Table id BIGINT 19 null
groupings Table description LONGTEXT 2147483647 null
qtype_essay_options Table attachments SMALLINT 5 0

Whether, and how many, attachments a student is allowed to include with their response. -1 means unlimited.

grading_definitions Table options LONGTEXT 2147483647 null

General field to be used by plugins as a general storage place for their own settings

enrol Table enrol VARCHAR 20
competency_userevidence Table timemodified BIGINT 19 null
tool_usertours_steps Table id BIGINT 19 null
quiz_statistics Table kurtosis DECIMAL 15 null
lti_submission Table userid BIGINT 19 null
quiz_overview_regrades Table newfraction DECIMAL 12 null

The new fraction for this question_attempt after regrading.

label Table introformat SMALLINT 5 0
tool_dataprivacy_ctxexpired Table timemodified BIGINT 19 null
enrol_paypal Table receiver_email VARCHAR 255
competency_framework Table contextid BIGINT 19 null
task_scheduled Table customised TINYINT 3 0

Used on upgrades to prevent overwriting custom schedules.

role_capabilities Table capability VARCHAR 255
forum_read Table userid BIGINT 19 0
block_positions Table pagetype VARCHAR 64

With contextid and subpage, defines the page we are setting the position for.

message_popup Table id BIGINT 19 null
stats_daily Table id BIGINT 19 null
event_subscriptions Table name VARCHAR 255
question_ddwtos Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

glossary Table showalphabet TINYINT 3 1
competency_modulecomp Table timemodified BIGINT 19 null

The time this record was last modified

workshopform_numerrors Table id BIGINT 19 null
search_index_requests Table partialarea VARCHAR 255

If processing of this context partially completed, set to the area that needs processing next. Blank indicates not processed yet.

tool_customlang Table original LONGTEXT 2147483647 null

English original of the string

tool_dataprivacy_contextlist Table timecreated BIGINT 19 0
grade_letters Table id BIGINT 19 null
lesson_pages Table id BIGINT 19 null
quiz Table name VARCHAR 255

Quiz name.

oauth2_issuer Table clientid LONGTEXT 2147483647 null

The client id used to connect to this oauth2 service.

forum_queue Table postid BIGINT 19 0
resource Table legacyfiles SMALLINT 5 0
groups Table picture BIGINT 19 0
enrol_paypal Table id BIGINT 19 null
wiki_pages Table subwikiid BIGINT 19 0

Subwiki instance of this page

enrol Table cost VARCHAR 20 null

Custom - enrolment cost

choice Table timeclose BIGINT 19 0
data Table editany SMALLINT 5 0
quiz_statistics Table highestattemptscount BIGINT 19 null
lti_tool_proxies Table timecreated BIGINT 19 null

Date/time at which the record was created

workshopform_accumulative Table sort BIGINT 19 0

Defines the dimension order within the assessment form

scorm Table width BIGINT 19 100
forum_discussions Table name VARCHAR 255
tool_usertours_tours Table name VARCHAR 255

Name of the user tour

repository_onedrive_access Table usermodified BIGINT 19 null
glossary_formats Table sortkey VARCHAR 50
scorm_seq_rulecond Table refrencedobjective VARCHAR 255
course_modules Table availability LONGTEXT 2147483647 null

Availability restrictions for viewing this activity, in JSON format. Null if no restrictions.

message_read Table id BIGINT 19 null
question Table generalfeedbackformat TINYINT 3 0
tag_area Table component VARCHAR 100
stats_user_weekly Table statsreads BIGINT 19 0
config_plugins Table value LONGTEXT 2147483647 null
messages Table conversationid BIGINT 19 null
assignment_upgrade Table newinstance BIGINT 19 0
assign_submission Table status VARCHAR 10 null

The status of this assignment submission. The current statuses are DRAFT and SUBMITTED.

qtype_match_options Table questionid BIGINT 19 0

Foreign key link to question.id.

external_tokens Table validuntil BIGINT 19 null

timestampt - valid until data

grade_items Table grademin DECIMAL 10 0.00000

What is the minimum allowable grade?

tool_monitor_rules Table templateformat BIT 0 null

Template format

badge Table expireperiod BIGINT 19 null
analytics_predictions Table timestart BIGINT 19 null
lesson_overrides Table review SMALLINT 5 null
lti Table icon LONGTEXT 2147483647 null
wiki_pages Table pageviews BIGINT 19 0

Number of page views

assignment_submissions Table userid BIGINT 19 0
files Table license VARCHAR 255 null

license of the file to guide reuse

qtype_essay_options Table responserequired TINYINT 3 1

Nonzero if an online text response is optional

workshop_grades Table assessmentid BIGINT 19 null

Part of which assessment this grade is of

event Table timesort BIGINT 19 null
quiz Table reviewcorrectness MEDIUMINT 7 0

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

upgrade_log Table type BIGINT 19 null

type: 0==info, 1==notice, 2==error

course_sections Table summaryformat TINYINT 3 0
events_handlers Table internal TINYINT 3 1

1 means standard plugin handler, 0 indicates if event handler sends data to external systems, this is used for example to prevent immediate sending of events from pending db transactions

assignment_upgrade Table oldinstance BIGINT 19 0
task_scheduled Table lastruntime BIGINT 19 null
competency_plan Table duedate BIGINT 19 0
tool_dataprivacy_ctxlevel Table id BIGINT 19 null
repository_onedrive_access Table timecreated BIGINT 19 null
chat_messages Table userid BIGINT 19 0
badge_issued Table dateissued BIGINT 19 0
tool_monitor_subscriptions Table courseid BIGINT 19 null

Course id of the subscription

folder Table timemodified BIGINT 19 0
assign_plugin_config Table assignment BIGINT 19 0
question_gapselect Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

assign_plugin_config Table value LONGTEXT 2147483647 null

The value of the config setting. Stored as text but can be interpreted by the plugin however it likes.

question_calculated Table correctanswerformat BIGINT 19 2
grade_categories_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

question_datasets Table id BIGINT 19 null
url Table introformat SMALLINT 5 0
lti_tool_proxies Table state TINYINT 3 1

Configured = 1, Pending = 2, Accepted = 3, Rejected = 4, Cancelled = 5

tool_policy_acceptances Table usermodified BIGINT 19 null

ID of the user who last modified the acceptance record

files_reference Table referencehash VARCHAR 40

Internal implementation detail, contains SHA1 hash of the reference field. Can be indexed and used for comparison. Not meant to be used by a non-core code.

workshop_assessments Table feedbackauthor LONGTEXT 2147483647 null

The comment/feedback from the reviewer for the author.

competency_framework Table idnumber VARCHAR 100 null

Unique idnumber for this competency framework.

notifications Table contexturl LONGTEXT 2147483647 null
backup_controllers Table controller LONGTEXT 2147483647 null

serialised backup_controller object

book_chapters Table content LONGTEXT 2147483647 null
grade_grades_history Table userid BIGINT 19 null

The user who this grade is for

competency_evidence Table timecreated BIGINT 19 null
workshop_assessments Table grade DECIMAL 10 null

The aggregated grade for submission suggested by the reviewer. The grade 0..100 is computed from the values assigned to the assessment dimensions fields. If NULL then it has not been aggregated yet.

events_handlers Table id BIGINT 19 null
competency Table usermodified BIGINT 19 null

The user who last modified this competency

repository_instances Table password VARCHAR 255 null
comments Table userid BIGINT 19 null
enrol_paypal Table option_name2 VARCHAR 255
context Table path VARCHAR 255 null
resource_old Table popup LONGTEXT 2147483647 null
book_chapters Table hidden TINYINT 3 0
messageinbound_messagelist Table address LONGTEXT 2147483647 null

The Inbound Message address that the message was originally sent to

data Table timemodified BIGINT 19 0

The time the settings for this database module instance were last modified.

user_password_resets Table token VARCHAR 32

secret set and emailed to user

log Table info VARCHAR 255
workshopform_numerrors_map Table nonegative BIGINT 19 null

Number of negative responses given by the reviewer

blog_external Table failedlastsync BIT 0 0

Whether or not the last sync failed for some reason

analytics_predictions Table id BIGINT 19 null
portfolio_instance_user Table value LONGTEXT 2147483647 null

value of config item

events_queue Table stackdump LONGTEXT 2147483647 null

serialized debug_backtrace showing where the event was fired from

grading_definitions Table name VARCHAR 255

The title of the form that helps users to identify it

question_attempts Table flagged BIT 0 0

Whether this question has been flagged within the attempt.

stats_monthly Table stat2 BIGINT 19 0

stat2. usually used for writes.

tool_dataprivacy_ctxexpired Table contextid BIGINT 19 null
competency_framework Table taxonomies VARCHAR 255

Sequence of terms to use for each competency level.

scorm_scoes_track Table scoid BIGINT 19 0
rating Table component VARCHAR 100
enrol_lti_lti2_tool_proxy Table toolproxy LONGTEXT 2147483647 null
quiz_attempts Table currentpage BIGINT 19 0
question_datasets Table datasetdefinition BIGINT 19 0
forum Table introformat SMALLINT 5 0

text format of intro field

workshop_assessments Table feedbackauthorformat SMALLINT 5 0
assign_submission Table latest TINYINT 3 0

Greatly simplifies queries wanting to know information about only the latest attempt.

tool_monitor_events Table timecreated BIGINT 19 null

Time created

tag Table userid BIGINT 19 null
message Table timeuserfromdeleted BIGINT 19 0
enrol_lti_lti2_consumer Table enableuntil BIGINT 19 null
assignment_upgrade Table timecreated BIGINT 19 0
feedback Table timeclose BIGINT 19 0
mnet_remote_rpc Table plugintype VARCHAR 20
analytics_prediction_actions Table id BIGINT 19 null
question_attempt_steps Table sequencenumber BIGINT 19 null

Numbers the steps in a question attempt sequentially.

tool_cohortroles Table timemodified BIGINT 19 null

The time this record was modified.

block_instances Table defaultregion VARCHAR 16

Which block region this block should appear in on each page, in the absence of a specific position in the block_positions table.

user_info_data Table fieldid BIGINT 19 0

id from the field table

wiki_subwikis Table userid BIGINT 19 0

Owner of that subwiki

grade_outcomes_history Table fullname LONGTEXT 2147483647 null

The full description of the outcome (usually 1 sentence)

role_allow_override Table roleid BIGINT 19 0
scale_history Table userid BIGINT 19 0
assignfeedback_file Table grade BIGINT 19 0
lti_types Table name VARCHAR 255 basiclti Activity

Activity name

repository_onedrive_access Table timemodified BIGINT 19 null
competency_evidence Table contextid BIGINT 19 null
mnet_application Table name VARCHAR 50
tool_recyclebin_course Table courseid BIGINT 19 null
lesson_answers Table responseformat TINYINT 3 0
portfolio_log Table id BIGINT 19 null
grade_items_history Table plusfactor DECIMAL 10 0.00000

Add this to all grades

blog_external Table filtertags VARCHAR 255 null

Comma-separated list of tags that will be used to filter which entries are copied over from the external blog. They refer to existing tags in the external blog.

competency_template Table timemodified BIGINT 19 null

The time this learning plan template was last modified.

competency_evidence Table usercompetencyid BIGINT 19 null
assign Table course BIGINT 19 0
scale Table userid BIGINT 19 0
log_display Table action VARCHAR 40
question Table timecreated BIGINT 19 0

time question was created

lti_tool_settings Table course BIGINT 19 null

Primary key of course (null for system-wide settings)

file_conversion Table timecreated BIGINT 19 null
capabilities Table id BIGINT 19 null
assign_plugin_config Table subtype VARCHAR 28
ltiservice_gradebookservices Table typeid BIGINT 19 null

ID of the LTI Type if not Proxy.

user Table autosubscribe BIT 0 1
quiz_grades Table id BIGINT 19 null
scorm_scoes Table manifest VARCHAR 255
scorm_scoes Table parent VARCHAR 255
upgrade_log Table userid BIGINT 19 null
mnetservice_enrol_enrolments Table rolename VARCHAR 255
quiz Table overduehandling VARCHAR 16 autoabandon

The method used to handle overdue attempts. 'autosubmit', 'graceperiod' or 'autoabandon'.

data Table requiredentriestoview INT 10 0
lti_types Table toolproxyid BIGINT 19 null

Primary key of related tool proxy (null for LTI 1 tools)

glossary_formats Table visible TINYINT 3 1
profiling Table runid VARCHAR 32

the unique id for this run (as generated by xhprof)

question_numerical_options Table unitgradingtype SMALLINT 5 0

0 no penalty, 1 fraction response grade, 2 fraction total grade

course_categories Table parent BIGINT 19 0
page Table id BIGINT 19 null
block_community Table userid BIGINT 19 null
badge Table usermodified BIGINT 19 null
enrol_paypal Table payment_status VARCHAR 255
repository_instances Table name VARCHAR 255
logstore_standard_log Table relateduserid BIGINT 19 null
grade_grades_history Table id BIGINT 19 null
page Table display SMALLINT 5 0
enrol_lti_lti2_resource_link Table created BIGINT 19 null
stats_weekly Table id BIGINT 19 null
grade_outcomes Table usermodified BIGINT 19 null

the userid of the person who last modified this outcome

workshop_assessments Table timecreated BIGINT 19 0

If 0 then the assessment was allocated but the reviewer has not assessed yet. If greater than 0 then the timestamp of when the reviewer assessed for the first time

oauth2_system_account Table grantedscopes LONGTEXT 2147483647 null

The scopes that this system account has been granted access to.

grade_settings Table courseid BIGINT 19 null
oauth2_issuer Table loginparamsoffline LONGTEXT 2147483647 null

Additional parameters sent for a login attempt to generate a refresh token.

block_instances Table defaultweight BIGINT 19 null

Used to order the blocks within a block region. Again, may be overridden by the block_positions table for a specific page where this block appears.

backup_controllers Table backupid VARCHAR 32

unique id of the backup

enrol_lti_users Table lastaccess BIGINT 19 null

The time the user last accessed

question_hints Table hintformat SMALLINT 5 0

The format of the hint.

lesson_answers Table pageid BIGINT 19 0
assignment_submissions Table submissioncomment LONGTEXT 2147483647 null
feedback_item Table dependvalue VARCHAR 255
qtype_multichoice_options Table layout SMALLINT 5 0

Not used. Was intended for a vertical/horizontal layout option. See MDL-18445.

choice Table showresults TINYINT 3 0
tool_monitor_rules Table eventname VARCHAR 254

Fully qualified name of the event

course_modules Table visible BIT 0 1
question_numerical_options Table id BIGINT 19 null
qtype_ddmarker_drops Table choice BIGINT 19 0
lti_submission Table dateupdated BIGINT 19 null
badge_backpack Table backpackuid BIGINT 19 null
badge_external Table backpackid BIGINT 19 null

ID of a backpack

stats_monthly Table id BIGINT 19 null
tool_customlang Table componentid BIGINT 19 null

The id of the component

lti_submission Table id BIGINT 19 null
glossary_entries Table approved TINYINT 3 1
files Table timecreated BIGINT 19 null
cache_flags Table expiry BIGINT 19 null
blog_external Table timemodified BIGINT 19 null
tool_cohortroles Table roleid BIGINT 19 null

The role to assign

oauth2_issuer Table id BIGINT 19 null
role_assignments Table id BIGINT 19 null
message_conversation_members Table id BIGINT 19 null
glossary_entries Table teacherentry TINYINT 3 0
user_password_history Table userid BIGINT 19 null
grade_grades Table userid BIGINT 19 null

The user who this grade is for

user_devices Table name VARCHAR 32

the device name, occam or iPhone etc..

post Table moduleid BIGINT 19 0
tool_customlang Table local LONGTEXT 2147483647 null

Local customization of the string, null if not customized

user_info_field Table locked TINYINT 3 0

Field locked

lesson_answers Table response LONGTEXT 2147483647 null
user_preferences Table name VARCHAR 255
feedback Table completionsubmit BIT 0 0

If this field is set to 1, then the activity will be automatically marked as 'complete' once the user submits their choice.

workshopallocation_scheduled Table timeallocated BIGINT 19 null

When was the last scheduled allocation executed

analytics_indicator_calc Table timecreated BIGINT 19 null
assignfeedback_editpdf_queue Table id BIGINT 19 null
quiz_overview_regrades Table regraded SMALLINT 5 null

set to 0 if element has just been regraded. Set to 1 if element has been marked as needing regrading.

course Table calendartype VARCHAR 30
glossary Table assesstimefinish BIGINT 19 0
mnet_application Table xmlrpc_server_url VARCHAR 255
grade_import_values Table feedback LONGTEXT 2147483647 null
tool_monitor_events Table courseid BIGINT 19 null

course id

lti_tool_proxies Table timemodified BIGINT 19 null

Date/time at which the record was last modified

cohort Table timecreated BIGINT 19 null
external_tokens Table sid VARCHAR 128 null

link to browser or emulated session

assignment_submissions Table timecreated BIGINT 19 0
grade_grades Table excluded BIGINT 19 0

grade excluded from aggregation functions, date means when excluded

workshop_aggregations Table userid BIGINT 19 null

The id of the user which aggregated grades are calculated for

scorm_scoes_track Table value LONGTEXT 2147483647 null
tool_recyclebin_course Table name VARCHAR 255 null
oauth2_user_field_mapping Table externalfield VARCHAR 64

The fieldname returned by the userinfo endpoint.

quiz Table completionpass BIT 0 0
modules Table id BIGINT 19 null
enrol Table name VARCHAR 255 null

Optional instance name

grade_categories_history Table source VARCHAR 255 null

What caused the modification? manual/module/import/...

grade_categories_history Table oldid BIGINT 19 null
course Table showgrades TINYINT 3 1
context_temp Table path VARCHAR 255
message_read Table timeread BIGINT 19 0
enrol_lti_users Table toolid BIGINT 19 null
enrol_lti_lti2_resource_link Table id BIGINT 19 null
forum_discussions Table timestart BIGINT 19 0
competency_evidence Table url VARCHAR 255 null
data_records Table timecreated BIGINT 19 0
lti Table showtitlelaunch BIT 0 0
mnet_rpc Table plugintype VARCHAR 20
quiz Table reviewoverallfeedback MEDIUMINT 7 0

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

mnet_log Table action VARCHAR 40
portfolio_log Table userid BIGINT 19 null

user who exported content

grade_outcomes Table fullname LONGTEXT 2147483647 null

The full description of the outcome (usually 1 sentence)

qtype_randomsamatch_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

context_temp Table depth TINYINT 3 null
mnet_log Table ip VARCHAR 45
scorm_seq_rolluprule Table minimumpercent FLOAT 11 0.0000
user Table phone1 VARCHAR 20
mnet_remote_service2rpc Table id BIGINT 19 null

Required ID field

wiki Table id BIGINT 19 null
qtype_ddmarker_drops Table shape VARCHAR 255 null

circle, rectangle, polygon

messageinbound_messagelist Table messageid LONGTEXT 2147483647 null
course Table shortname VARCHAR 255
quiz_statistics Table standarddeviation DECIMAL 15 null
grade_categories Table fullname VARCHAR 255

The name of this grade category

badge_criteria_param Table value VARCHAR 255 null
quiz_attempts Table userid BIGINT 19 0

Foreign key reference to the user whose attempt this is.

lesson Table completiontimespent BIGINT 19 0
grade_grades Table timemodified BIGINT 19 null

the time this grade was last modified

data_records Table id BIGINT 19 null
tool_dataprivacy_purpose Table timemodified BIGINT 19 null
resource Table displayoptions LONGTEXT 2147483647 null
blog_external Table name VARCHAR 255
grade_outcomes_history Table descriptionformat TINYINT 3 0
block_positions Table blockinstanceid BIGINT 19 null

The block_instance this position relates to.

grade_grades_history Table rawgrademax DECIMAL 10 100.00000

The maximum allowable grade when this was created

analytics_predictions Table timeend BIGINT 19 null
messages Table fullmessage LONGTEXT 2147483647 null
course_completion_crit_compl Table id BIGINT 19 null
portfolio_log Table caller_class VARCHAR 150

the name of the class used to create the transfer

grade_items_history Table locked BIGINT 19 0

1 is locked, > 1 is a date to lock until (prevents update)

events_queue Table timecreated BIGINT 19 null

time stamp of the first time this was added

sessions Table sessdata LONGTEXT 2147483647 null

session content

scale_history Table scale LONGTEXT 2147483647 null
grade_items Table timemodified BIGINT 19 null

The last time this grade_item was modified

grade_items_history Table categoryid BIGINT 19 null

(optional) the category group this item belongs to

glossary_formats Table name VARCHAR 50
glossary Table course BIGINT 19 0
task_scheduled Table dayofweek VARCHAR 25
search_simpledb_index Table areaid VARCHAR 255
enrol_flatfile Table timemodified BIGINT 19 0
course_categories Table theme VARCHAR 50 null

Theme for the category

mnetservice_enrol_courses Table remoteid BIGINT 19 null

ID of course on its home server

quiz_overview_regrades Table oldfraction DECIMAL 12 null

The previous fraction for this question_attempt.

survey_answers Table survey BIGINT 19 0
scorm_seq_rulecond Table id BIGINT 19 null
post Table module VARCHAR 20
qtype_match_subquestions Table questiontextformat TINYINT 3 0
assignment Table timedue BIGINT 19 0
course_completion_criteria Table courseinstance BIGINT 19 null

Course instance id (if using course criteria type)

enrol_flatfile Table timestart BIGINT 19 0
data_fields Table param10 LONGTEXT 2147483647 null
workshop Table id BIGINT 19 null
competency Table timecreated BIGINT 19 null

The time this competency was created.

backup_logs Table backupid VARCHAR 32

backupid the log record belongs to

repository_instance_config Table name VARCHAR 255
course_completion_crit_compl Table criteriaid BIGINT 19 0

Completion criteria this references

lti_types Table icon LONGTEXT 2147483647 null

URL to icon file

glossary Table approvaldisplayformat VARCHAR 50 default

Display Format when approving entries

workshop_submissions Table authorid BIGINT 19 null

The author of the submission

assign_user_flags Table userid BIGINT 19 0

The id of the user these flags apply to.

qtype_ddimageortext_drops Table xleft BIGINT 19 0
analytics_predictions Table timecreated BIGINT 19 0
lesson Table slideshow SMALLINT 5 0
course Table requested BIT 0 0
competency_templatecohort Table usermodified BIGINT 19 null
grade_items Table decimals BIT 0 null

Also known as precision, the number of digits after the decimal point symbol.

question_ddwtos Table shownumcorrect TINYINT 3 0
lesson_attempts Table timeseen BIGINT 19 0
editor_atto_autosave Table userid BIGINT 19 null

The id of the user that loaded the form.

lti_types Table timecreated BIGINT 19 null
analytics_models_log Table timesplitting VARCHAR 255 null
log_display Table id BIGINT 19 null
tag_area Table enabled BIT 0 1
user Table mailformat BIT 0 1
tool_dataprivacy_category Table description LONGTEXT 2147483647 null
label Table timemodified BIGINT 19 0
lesson Table ongoing SMALLINT 5 0
assignment Table var5 BIGINT 19 0
analytics_train_samples Table id BIGINT 19 null
user Table username VARCHAR 100
tag_instance Table tagid BIGINT 19 null
backup_courses Table courseid BIGINT 19 0
scorm Table updatefreq BIT 0 0

Define when the package must be automatically update

assignfeedback_editpdf_cmnt Table draft TINYINT 3 1

Is this a draft comment?

lti Table instructorchoicesendemailaddr BIT 0 null

Send user's email

analytics_predict_samples Table rangeindex BIGINT 19 null
forum_subscriptions Table userid BIGINT 19 0
question_categories Table name VARCHAR 255
block_instances Table id BIGINT 19 null
event Table id BIGINT 19 null
search_simpledb_index Table title LONGTEXT 2147483647 null
scorm_seq_objective Table objectiveid VARCHAR 255
course_request Table reason LONGTEXT 2147483647 null
chat_users Table chatid BIGINT 19 0
survey_questions Table id BIGINT 19 null
files Table mimetype VARCHAR 100 null

type of file - jpeg image, open document spreadsheet

config_log Table plugin VARCHAR 100 null
local_ld_course Table id BIGINT 19 null
badge_criteria Table method BIT 0 1

1 = all, 2 = any

course Table fullname VARCHAR 254
quiz_statistics Table allattemptsavg DECIMAL 15 null
oauth2_issuer Table image LONGTEXT 2147483647 null
enrol_flatfile Table timeend BIGINT 19 0
chat_messages Table id BIGINT 19 null
feedback Table intro LONGTEXT 2147483647 null
block_recent_activity Table action BIT 0 null

0 created, 1 updated, 2 deleted

grade_items Table aggregationcoef DECIMAL 10 0.00000

Aggregation coefficient used for category weights or other aggregation types

enrol_lti_lti2_nonce Table id BIGINT 19 null
quiz_overview_regrades Table timemodified BIGINT 19 null

Timestamp of when this row was last modified.

workshopform_numerrors Table weight MEDIUMINT 7 1

Weight of this dimension

course_request Table fullname VARCHAR 254
lesson_overrides Table available BIGINT 19 null

Time at which students may start attempting this lesson. Can be null, in which case the lesson default is used.

cache_filters Table rawtext LONGTEXT 2147483647 null
role Table id BIGINT 19 null
enrol_lti_lti2_consumer Table created BIGINT 19 null
gradingform_guide_comments Table definitionid BIGINT 19 null

The ID of the form definition this faq is part of

event_subscriptions Table groupid BIGINT 19 0
scorm_scoes Table identifier VARCHAR 255
external_tokens Table creatorid BIGINT 19 1

user id of the token creator (useful to know when the administrator created a token and so display the token to a specific administrator)

analytics_train_samples Table timesplitting VARCHAR 255
question_calculated Table tolerancetype BIGINT 19 1
competency_relatedcomp Table timecreated BIGINT 19 null
groups Table timecreated BIGINT 19 0
forum Table forcesubscribe BIT 0 0
message Table component VARCHAR 100 null
enrol_lti_users Table userid BIGINT 19 null
role_allow_override Table id BIGINT 19 null
tool_monitor_rules Table id BIGINT 19 null
grade_grades Table informationformat BIGINT 19 0

format of information text

label Table id BIGINT 19 null
page Table legacyfiles SMALLINT 5 0
backup_controllers Table timecreated BIGINT 19 null

time the controller was created

question_attempts Table slot BIGINT 19 null

Used to number the questions in one attempt sequentially.

quiz_slots Table page BIGINT 19 null

The page number that this questions appears on. If the question in slot n appears on page p, then the question in slot n+1 must appear on page p or p+1. Well, except that when a quiz is being created, there may be empty pages, which would cause the page number to jump here.

external_services Table timecreated BIGINT 19 null
mnetservice_enrol_courses Table categoryid BIGINT 19 null

The id of the category on the remote server

badge_issued Table id BIGINT 19 null
competency_framework Table descriptionformat SMALLINT 5 0

The format of the description field

tool_policy Table id BIGINT 19 null
user_private_key Table value VARCHAR 128

private access key value

competency_coursecompsetting Table timemodified BIGINT 19 null

The time this setting was last modified.

data Table introformat SMALLINT 5 0
external_functions Table services VARCHAR 1333 null

all the services (by shortname) where this function must be included

lesson_attempts Table answerid BIGINT 19 0
workshop Table phase SMALLINT 5 0

The current phase of workshop (0 = not available, 1 = submission, 2 = assessment, 3 = closed)

forum_read Table lastread BIGINT 19 0
question Table modifiedby BIGINT 19 null

userid of person who last edited this question

quiz_attempts Table layout LONGTEXT 2147483647 null
mnet_rpc Table help LONGTEXT 2147483647 null
license Table shortname VARCHAR 255 null
scorm Table launch BIGINT 19 0
tool_dataprivacy_ctxlst_ctx Table timecreated BIGINT 19 0
badge Table notification BIT 0 1

Message when badge is awarded

quiz_attempts Table id BIGINT 19 null

Standard Moodle primary key.

mnetservice_enrol_courses Table fullname VARCHAR 254
question_truefalse Table falseanswer BIGINT 19 0

Foreign key references question_answers.id. The 'False' choice.

tool_dataprivacy_category Table name VARCHAR 100
grade_grades_history Table informationformat BIGINT 19 0

format of information text

wiki_pages Table cachedcontent LONGTEXT 2147483647 null

Cache wiki content

block_community Table coursedescription LONGTEXT 2147483647 null
qtype_ddmarker Table shownumcorrect TINYINT 3 0
modules Table name VARCHAR 20
competency_template Table description LONGTEXT 2147483647 null

Description of this learning plan template

block_zoola_reports_schedule Table courseid BIGINT 19 null

Course ID

tool_usertours_steps Table content LONGTEXT 2147483647 null

Content of the user tour - allow for multilang tags

oauth2_system_account Table timecreated BIGINT 19 null

Time this record was created.

tool_dataprivacy_purpose Table id BIGINT 19 null
comments Table contextid BIGINT 19 null
feedback_item Table options VARCHAR 255
course Table summaryformat TINYINT 3 0
badge_criteria Table badgeid BIGINT 19 0
scorm_aicc_session Table hacpsession VARCHAR 255

sessionid used to authenticate AICC HACP communication

tool_dataprivacy_purpose Table retentionperiod VARCHAR 255
mnetservice_enrol_courses Table rolename VARCHAR 255

The name of the role at the remote server that our users will get when we enrol them there

enrol_lti_tools Table timemodified BIGINT 19 null
competency_templatecohort Table timecreated BIGINT 19 null
tool_policy_versions Table summary LONGTEXT 2147483647 null

Policy text summary

tag Table timemodified BIGINT 19 null
feedback_template Table course BIGINT 19 0
lesson_branch Table pageid BIGINT 19 0
lesson Table displayleftif SMALLINT 5 0
task_scheduled Table hour VARCHAR 25
analytics_models_log Table dir LONGTEXT 2147483647 null
scorm_seq_rolluprule Table id BIGINT 19 null
mnet_service2rpc Table serviceid BIGINT 19 0

Unique service ID

workshopform_numerrors Table grade1 VARCHAR 50 null

A word for possitive evaluation (like Good, Present, OK etc). If NULL, it defaults to a translated string True

gradingform_rubric_fillings Table remarkformat TINYINT 3 null

The format of the remark field

assignfeedback_comments Table assignment BIGINT 19 0
event Table groupid BIGINT 19 0
tool_monitor_events Table link VARCHAR 254

Link to the event location

block Table lastcron BIGINT 19 0
tool_customlang Table lang VARCHAR 20

The code of the language this string belongs to. Like en, cs or es

lesson_pages Table contents LONGTEXT 2147483647 null
auth_oauth2_linked_login Table id BIGINT 19 null
tool_monitor_rules Table template LONGTEXT 2147483647 null

Message template

messages Table fullmessagehtml LONGTEXT 2147483647 null
scorm Table completionstatusrequired BIT 0 null
grade_grades Table aggregationweight DECIMAL 10 null

If the aggregationstatus == 'included', then this is the percent this item contributed to the aggregation.

question_response_analysis Table credit DECIMAL 15 null
tool_recyclebin_course Table id BIGINT 19 null
badge_criteria_param Table name VARCHAR 255
badge_backpack Table password VARCHAR 50 null
assignfeedback_comments Table commentformat SMALLINT 5 0

The feedback text format

qtype_match_subquestions Table answertext VARCHAR 255
lesson_pages Table qtype SMALLINT 5 0
wiki_versions Table id BIGINT 19 null
assign_submission Table userid BIGINT 19 0
mnet_host2service Table subscribe BIT 0 0
glossary Table usedynalink TINYINT 3 1
local_ld_import_logs_status Table id BIGINT 19 null
notifications Table subject LONGTEXT 2147483647 null

The message subject

question_dataset_definitions Table type BIGINT 19 0
data_fields Table param3 LONGTEXT 2147483647 null
workshop_submissions Table timecreated BIGINT 19 null

Timestamp when the work was submitted for the first time

question_attempts Table timemodified BIGINT 19 null

The time this record was last changed.

gradingform_guide_fillings Table criterionid BIGINT 19 null

The ID of the criterion (row) in the guide

user_devices Table model VARCHAR 32

the device model, Nexus 4 or iPad 1,1

license Table source VARCHAR 255 null
assign Table markingallocation TINYINT 3 0

If enabled, marking allocation features will be used in this assignment

enrol Table customint2 BIGINT 19 null

Custom - general int

groups_members Table groupid BIGINT 19 0
question_usages Table id BIGINT 19 null
question_dataset_definitions Table name VARCHAR 255
grade_grades_history Table itemid BIGINT 19 null

The item this grade belongs to

competency_modulecomp Table id BIGINT 19 null
question_numerical Table tolerance VARCHAR 255 0.0

Allowed error when matching a response to this answer. I don't know why this is stored as a string.

course_modules_completion Table viewed BIT 0 null

Tracks whether or not this activity has been viewed. NULL = we are not tracking viewed for this activity 0 = not viewed 1 = viewed

grade_categories Table timecreated BIGINT 19 null
enrol_lti_lti2_consumer Table id BIGINT 19 null
grading_definitions Table timecreated BIGINT 19 null

The timestamp of when the form definition was created initially

ltiservice_gradebookservices Table gradeitemid BIGINT 19 null

ID of the gradeItem related.

question_numerical_units Table multiplier DECIMAL 38 1.0000000000000000000

The multiplier for this unit. For example, if the first unit is (1.0, 'cm'), another unit might be (0.1, 'mm') or (100.0, 'm').

competency_plan Table timemodified BIGINT 19 0
qtype_randomsamatch_options Table id BIGINT 19 null
local_ld_course_day Table day VARCHAR 10

Day formatted as 'YYYY-MM-DD'

scorm_seq_ruleconds Table conditioncombination VARCHAR 3 all
question_response_analysis Table hashcode VARCHAR 40

sha1 hash of serialized qubaids_condition class. Unique for every combination of class name and property.

data_fields Table param8 LONGTEXT 2147483647 null
tool_policy_acceptances Table userid BIGINT 19 null

ID of the user this acceptance is relevant to

enrol_paypal Table receiver_id VARCHAR 255
chat Table introformat SMALLINT 5 0

text format of intro field

course_completion_crit_compl Table course BIGINT 19 0
message_user_actions Table timecreated BIGINT 19 null
gradingform_rubric_criteria Table sortorder BIGINT 19 null

Defines the order of the criterion in the rubric

enrol Table notifyall BIT 0 0

Custom - Notify both participant and person responsible for enrolments

lti_submission Table originalgrade DECIMAL 10 null
tool_dataprivacy_request Table userid BIGINT 19 0

The user ID the request is being made for

workshopform_rubric_config Table id BIGINT 19 null
lti_types Table description LONGTEXT 2147483647 null

A description of what this LTI module is.

backup_controllers Table operation VARCHAR 20 backup

Type of operation (backup/restore)

badge Table courseid BIGINT 19 null
course_completion_crit_compl Table timecompleted BIGINT 19 null
user_info_field Table param3 LONGTEXT 2147483647 null

General parameter field

workshopeval_best_settings Table workshopid BIGINT 19 null
enrol Table customint5 BIGINT 19 null

Custom - general int

logstore_standard_log Table target VARCHAR 100
tool_dataprivacy_ctxexpired Table id BIGINT 19 null
competency_userevidencecomp Table id BIGINT 19 null
question_ddwtos Table id BIGINT 19 null
competency_plan Table status BIT 0 null
role_sortorder Table sortoder BIGINT 19 null
scorm Table grademethod TINYINT 3 0
qtype_essay_options Table id BIGINT 19 null
grade_items Table locktime BIGINT 19 0

lock all final grades after this date

scorm Table displayattemptstatus BIT 0 1
search_simpledb_index Table userid BIGINT 19 null
wiki_versions Table pageid BIGINT 19 0

Page id

enrol Table id BIGINT 19 null
lesson_answers Table flags SMALLINT 5 0
grade_categories Table aggregateoutcomes BIT 0 0

Aggregate outcomes

qtype_ddimageortext Table incorrectfeedbackformat TINYINT 3 0
feedback_completedtmp Table courseid BIGINT 19 0
grade_items_history Table sortorder BIGINT 19 0

Sorting order of the columns

grade_items_history Table gradepass DECIMAL 10 0.00000

What grade is needed to pass? grademin < gradepass <= grademax

user Table mnethostid BIGINT 19 0
grade_items_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

role_context_levels Table roleid BIGINT 19 null
role Table sortorder BIGINT 19 0
question_multianswer Table sequence LONGTEXT 2147483647 null
question_calculated_options Table single SMALLINT 5 0

If 0 it multiple response (checkboxes). Otherwise it is radio buttons.

capabilities Table riskbitmask BIGINT 19 0
enrol_lti_lti2_consumer Table profile LONGTEXT 2147483647 null
workshop_submissions Table timemodified BIGINT 19 null

Timestamp when the submission has been updated

log Table userid BIGINT 19 0
scale Table name VARCHAR 255
block_zoola_reports_user Table blockinstanceid BIGINT 19 null

Block instance ID

user Table lang VARCHAR 30 en
files Table sortorder BIGINT 19 0

order of files

course_completions Table timestarted BIGINT 19 0
repository Table id BIGINT 19 null
tool_policy_versions Table usermodified BIGINT 19 null

ID of the user who last edited this policy document version.

imscp Table name VARCHAR 255
search_index_requests Table timerequested BIGINT 19 null

Time at which this index update was requested.

choice_options Table text LONGTEXT 2147483647 null
cohort_members Table id BIGINT 19 null
filter_config Table contextid BIGINT 19 null

References context.id.

scorm_scoes_track Table attempt BIGINT 19 1
lesson_grades Table late SMALLINT 5 0
grade_outcomes Table timecreated BIGINT 19 null

the time this outcome was first created

user Table confirmed BIT 0 0
qtype_randomsamatch_options Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

feedback Table anonymous BIT 0 1
data Table asearchtemplate LONGTEXT 2147483647 null
assignment Table assignmenttype VARCHAR 50
my_pages Table id BIGINT 19 null
block_zoola_reports_schedule Table reporturi VARCHAR 1333

Zoola report URI

tool_customlang Table master LONGTEXT 2147483647 null

Master translation of the string as is distributed in the official lang pack, null if not translated

assignfeedback_editpdf_annot Table endx BIGINT 19 0

x-position of the end of the annotation

url Table timemodified BIGINT 19 0
event Table timestart BIGINT 19 0
backup_courses Table laststatus VARCHAR 1 5
forum_discussions Table firstpost BIGINT 19 0
choice Table course BIGINT 19 0
config Table id BIGINT 19 null
grade_grades Table hidden BIGINT 19 0

show 0, hide 1 or hide until date

grade_grades Table aggregationstatus VARCHAR 10 unknown

One of several values describing how this grade_grade was used when calculating the aggregation. Possible values are "unknown", "dropped", "novalue", "used"

choice Table allowupdate TINYINT 3 0
question Table questiontextformat TINYINT 3 0
modules Table cron BIGINT 19 0
analytics_predictions Table contextid BIGINT 19 null
resource Table id BIGINT 19 null
assignfeedback_editpdf_queue Table submissionattempt BIGINT 19 null
assignsubmission_onlinetext Table submission BIGINT 19 0
feedback_completedtmp Table guestid VARCHAR 255
lti_types Table baseurl LONGTEXT 2147483647 null
block_zoola_reports_schedule Table emails VARCHAR 1333 null

Comma separated list of emails

data_fields Table type VARCHAR 255
mnet_service2rpc Table rpcid BIGINT 19 0

Unique Function ID

message Table eventtype VARCHAR 100 null
notifications Table fullmessage LONGTEXT 2147483647 null
tag_coll Table component VARCHAR 100 null
grade_outcomes Table shortname VARCHAR 255

The short name or code for this outcome statement

tool_dataprivacy_ctxlst_ctx Table contextlistid BIGINT 19 null
course_sections Table availability LONGTEXT 2147483647 null

Availability restrictions for viewing this section, in JSON format. Null if no restrictions.

question_attempts Table minfraction DECIMAL 12 null

Some questions can award negative marks. This indicates the most negative mark that can be awarded, on the faction scale where the maximum positive mark is 1.

enrol_lti_lti2_resource_link Table primaryresourcelinkid BIGINT 19 null
role Table archetype VARCHAR 30

Role archetype is used during install and role reset, marks admin role and helps in site settings

workshop Table name VARCHAR 255

Name of the activity

tool_monitor_events Table eventname VARCHAR 254

Event name

registration_hubs Table confirmed BIT 0 0
search_simpledb_index Table description1 LONGTEXT 2147483647 null
notifications Table id BIGINT 19 null
badge_issued Table issuernotified BIGINT 19 null
imscp Table introformat SMALLINT 5 0
question_response_analysis Table aid VARCHAR 100 null
ltiservice_gradebookservices Table baseurl LONGTEXT 2147483647 null

Lineitem URL that will be returned to the Tool provider

messages Table useridfrom BIGINT 19 null
quiz Table showuserpicture SMALLINT 5 0

Option to show the user's picture during the attempt and on the review page.

feedback_item Table position SMALLINT 5 0
assignment Table var1 BIGINT 19 0
chat_messages_current Table timestamp BIGINT 19 0
external_tokens Table tokentype SMALLINT 5 null

type of token: 0=permanent, no session; 1=linked to current browser session via sid; 2=permanent, with emulated session

block_instances Table parentcontextid BIGINT 19 null

The context within which this block appears. Foreign key, references context.id.

chat_users Table lastmessageping BIGINT 19 0
file_conversion Table usermodified BIGINT 19 null
scale_history Table action BIGINT 19 0

created/modified/deleted constants

lesson Table review SMALLINT 5 0
competency_plan Table templateid BIGINT 19 null
mnet_log Table time BIGINT 19 0
quiz_overview_regrades Table slot BIGINT 19 null

Foreign key, references question_attempts.slot

oauth2_endpoint Table issuerid BIGINT 19 null

The identity provider this service belongs to.

lesson Table course BIGINT 19 0
role Table description LONGTEXT 2147483647 null

Empty descriptions may be automatically localised

course_modules Table score SMALLINT 5 0
glossary Table id BIGINT 19 null
user Table suspended BIT 0 0

suspended flag prevents users to log in

message_processors Table name VARCHAR 166

Name of the message processor

competency_usercompcourse Table timecreated BIGINT 19 null
chat_users Table sid VARCHAR 32
glossary Table allowcomments TINYINT 3 0
tool_dataprivacy_ctxlevel Table contextlevel SMALLINT 5 null
block_instances Table subpagepattern VARCHAR 16 null

Further restrictions on where this block appears. In some places, e.g. during a quiz or lesson attempt, different pages have different subpage ids. If this field is not null, the block only appears on that particular subpage.

blog_external Table timefetched BIGINT 19 0
scorm Table scormtype VARCHAR 50 local

local, external or repository

analytics_predictions Table predictionscore DECIMAL 10 null
feedback_item Table id BIGINT 19 null
scorm_seq_mapinfo Table writesatisfiedstatus BIT 0 0
course_completion_criteria Table gradepass DECIMAL 10 null

The minimum grade needed to pass the course (if passing grade criteria enabled)

profiling Table totalmemory BIGINT 19 null

Total memory used byt the run

lti Table launchcontainer TINYINT 3 1

Launch external tool in a pop-up

tool_policy_versions Table timemodified BIGINT 19 null

Timestamp of when the policy version was last modified.

cache_flags Table flagtype VARCHAR 255
question_gapselect Table id BIGINT 19 null
tool_recyclebin_course Table section BIGINT 19 null
course Table timecreated BIGINT 19 0
user Table currentlogin BIGINT 19 0
grade_items_history Table needsupdate BIGINT 19 0

If this flag is set, then the whole column will be recalculated

auth_oauth2_linked_login Table timecreated BIGINT 19 null
message_conversations Table timecreated BIGINT 19 null
grade_categories Table timemodified BIGINT 19 null
user_enrolments Table status BIGINT 19 0

0..9 are system constants, 0 means active participation, see ENROL_PARTICIPATION_* constants, plugins may define own status greater than 10

event Table priority BIGINT 19 null

The event's display priority. For multiple events with the same module name, instance and eventtype (e.g. for group overrides), the one with the higher priority will be displayed.

question_calculated_options Table correctfeedbackformat TINYINT 3 0
mnetservice_enrol_enrolments Table id BIGINT 19 null

Unique enrollment ID

file_conversion Table timemodified BIGINT 19 null
grading_areas Table activemethod VARCHAR 100 null

The default grading method (plugin) that should be used for this area

lesson Table maxpages SMALLINT 5 0
quiz Table questiondecimalpoints SMALLINT 5 -1

Number of decimal points to use when displaying question grades. (-1 means use decimalpoints.)

quiz_slot_tags Table tagid BIGINT 19 null
workshop_assessments Table feedbackauthorattachment SMALLINT 5 0

Are there some files attached to the feedbackauthor field? Sets to 1 by file_postupdate_standard_filemanager().

assignment Table introformat SMALLINT 5 0
rating Table contextid BIGINT 19 null
data_content Table recordid BIGINT 19 0
block_instances Table blockname VARCHAR 40

The type of block this is. Foreign key, references block.name.

chat Table name VARCHAR 255
repository_instances Table id BIGINT 19 null
scale_history Table description LONGTEXT 2147483647 null
choice Table timemodified BIGINT 19 0
question Table length BIGINT 19 1
course Table groupmodeforce SMALLINT 5 0
notifications Table timeread BIGINT 19 null
tool_recyclebin_course Table timecreated BIGINT 19 0
enrol_paypal Table parent_txn_id VARCHAR 255
user_enrolments Table id BIGINT 19 null
grade_categories_history Table keephigh BIGINT 19 0

Keep only the X highest items

forum Table lockdiscussionafter BIGINT 19 0
chat_messages_current Table groupid BIGINT 19 0
log_queries Table exectime DECIMAL 10 null

query execution time in seconds as float

lti Table resourcekey VARCHAR 255 null
grade_items Table weightoverride BIT 0 0
tool_dataprivacy_ctxinstance Table categoryid BIGINT 19 null
question_calculated_options Table incorrectfeedbackformat TINYINT 3 0
question_calculated Table answer BIGINT 19 0
stats_user_monthly Table id BIGINT 19 null
badge_manual_award Table recipientid BIGINT 19 null
workshopform_accumulative Table id BIGINT 19 null
workshop_submissions Table published TINYINT 3 0

Shall the submission be available to other when the workshop is closed

message Table fullmessageformat SMALLINT 5 0

The format of the full message

tool_dataprivacy_category Table descriptionformat BIT 0 null
scale Table courseid BIGINT 19 0
course_completion_criteria Table criteriatype BIGINT 19 0

Type of criteria

scorm_scoes_data Table value LONGTEXT 2147483647 null
tool_monitor_history Table timesent BIGINT 19 null

Timestamp of when the message was sent.

forum_discussions Table assessed BIT 0 1
choice Table introformat SMALLINT 5 0
enrol_lti_lti2_share_key Table sharekey VARCHAR 32
mnet_session Table confirm_timeout BIGINT 19 0

UNIX timestamp for expiry of session

quiz_overrides Table attempts MEDIUMINT 7 null
mnet_sso_access_control Table accessctrl VARCHAR 20 allow

Whether or not this user/host can login

lesson Table practice SMALLINT 5 0
grade_items Table itemname VARCHAR 255 null

The name of this item (pushed in by the module)

my_pages Table userid BIGINT 19 0

The user who owns this page or 0 for system defaults

upgrade_log Table timemodified BIGINT 19 null
wiki_locks Table userid BIGINT 19 0

Locking user

enrol_lti_lti2_context Table settings LONGTEXT 2147483647 null
scorm_seq_ruleconds Table id BIGINT 19 null
resource Table course BIGINT 19 0
tool_dataprivacy_rqst_ctxlst Table id BIGINT 19 null
resource Table legacyfileslast BIGINT 19 null
tool_dataprivacy_request Table usermodified BIGINT 19 0

The user who created/modified this request object

search_index_requests Table searcharea VARCHAR 255

Set (e.g. 'forum-post') if a specific area is to be reindexed. Blank indicates all areas.

grading_instances Table definitionid BIGINT 19 null

The ID of the form definition this is instance of

quiz_overrides Table quiz BIGINT 19 0

Foreign key references quiz.id

competency_usercompcourse Table timemodified BIGINT 19 null
course Table visibleold BIT 0 1

the state of visible field when hiding parent category, this helps us to recover hidden states when unhiding the parent category later

forum_discussions Table usermodified BIGINT 19 0
course_published Table timechecked BIGINT 19 null

the last time the status has been checked

course_completions Table course BIGINT 19 0
analytics_predictions Table modelid BIGINT 19 null
badge_criteria Table descriptionformat TINYINT 3 0
oauth2_user_field_mapping Table timecreated BIGINT 19 null

The time this record was created.

tool_dataprivacy_purpose Table sensitivedatareasons LONGTEXT 2147483647 null

Comma-separated IDs matching records in tool_dataprivacy_sensitive

competency_evidence Table usermodified BIGINT 19 null
enrol_lti_lti2_user_result Table ltiresultsourcedid VARCHAR 1024
choice_answers Table choiceid BIGINT 19 0
lti_types Table createdby BIGINT 19 null
data Table rssarticles SMALLINT 5 0
book_chapters Table title VARCHAR 255
wiki_synonyms Table pagesynonym VARCHAR 255 Pagesynonym

Page name synonym

editor_atto_autosave Table elementid VARCHAR 255

The unique id for the text editor in the form.

upgrade_log Table targetversion VARCHAR 100 null

version of plugin or core specified in version.php at the time of upgrade loggging

mnet_host Table last_connect_time BIGINT 19 0
tool_dataprivacy_request Table timecreated BIGINT 19 0

The time this data request was created

enrol_lti_lti2_context Table lticontextkey VARCHAR 255
lesson_pages Table nextpageid BIGINT 19 0
grade_letters Table letter VARCHAR 255

The display value of the letter. Can be any character or string of characters (OK, A, 10% etc..)

tool_customlang Table id BIGINT 19 null
workshopallocation_scheduled Table resultstatus BIGINT 19 null

The resulting status of the most recent execution

workshop_assessments Table submissionid BIGINT 19 null

The id of the assessed submission

competency_evidence Table descidentifier VARCHAR 255
lesson_branch Table retry BIGINT 19 0
portfolio_instance_config Table name VARCHAR 255

config field

forum_digests Table forum BIGINT 19 null
log_queries Table backtrace LONGTEXT 2147483647 null

php execution trace

user_password_resets Table timerequested BIGINT 19 null

The time that the user first requested this password reset

assignfeedback_comments Table grade BIGINT 19 0
competency_coursecomp Table ruleoutcome TINYINT 3 null

The rule that applies to the competency when the course is completed.

tool_policy Table currentversionid BIGINT 19 null

ID of the current policy version that applies on the site, NULL if the policy does not apply

badge Table expiredate BIGINT 19 null
qtype_ddimageortext_drags Table infinite SMALLINT 5 0
grade_outcomes Table id BIGINT 19 null

id of the table

enrol_paypal Table item_name VARCHAR 255
lesson_pages Table layout SMALLINT 5 1
quiz Table reviewattempt MEDIUMINT 7 0

Whether users are allowed to review their quiz attempts at various times. This is a bit field, decoded by the mod_quiz_display_options class. It is formed by ORing together the constants defined there.

tag Table tagcollid BIGINT 19 null
qtype_ddimageortext_drags Table id BIGINT 19 null
lesson_attempts Table pageid BIGINT 19 0
workshop Table overallfeedbackfiletypes VARCHAR 255 null

comma separated list of file extensions

wiki Table editbegin BIGINT 19 0

editbegin

block_zoola_reports Table blockinstanceid BIGINT 19 null

Block instance ID

log Table action VARCHAR 40
workshopform_comments Table sort BIGINT 19 0

Defines the dimension order within the assessment form

competency Table path VARCHAR 255

Used to speed up queries that use an entire branch of the tree. Looks like /5/34/54.

lesson Table allowofflineattempts BIT 0 0

Whether to allow the lesson to be attempted offline in the mobile app

grade_categories_history Table hidden BIT 0 0
data Table manageapproved SMALLINT 5 1
assignment_upgrade Table newcmid BIGINT 19 0
files Table component VARCHAR 100

Full name of the component owning the area

user Table firstaccess BIGINT 19 0
competency_evidence Table actionuserid BIGINT 19 null
competency_usercompcourse Table userid BIGINT 19 null

User associated to the competency.

scorm_seq_rulecond Table scoid BIGINT 19 0
mnetservice_enrol_courses Table hostid BIGINT 19 null

The id of the remote MNet host

question_categories Table stamp VARCHAR 255
qtype_essay_options Table responseformat VARCHAR 16 editor

The type of input area students should be given for their response.

chat_users Table lastping BIGINT 19 0
oauth2_issuer Table clientsecret LONGTEXT 2147483647 null

The secret used to connect to this oauth2 service.

user Table msn VARCHAR 50
grade_import_values Table id BIGINT 19 null
oauth2_endpoint Table usermodified BIGINT 19 null

The user who modified this record.

wiki_subwikis Table id BIGINT 19 null
competency_usercompcourse Table proficiency TINYINT 3 null

Indicate if the competency is proficient not.

groups_members Table id BIGINT 19 null
choice Table id BIGINT 19 null
tool_recyclebin_category Table fullname VARCHAR 255
choice Table showpreview TINYINT 3 0
assign Table timemodified BIGINT 19 0

The time the settings for this assign module instance were last modified.

user Table city VARCHAR 120
scorm_seq_mapinfo Table readnormalizedmeasure BIT 0 1
mnet_remote_rpc Table enabled BIT 0 null
glossary_entries_categories Table id BIGINT 19 null
competency_usercomp Table proficiency TINYINT 3 null

Indicate if the competency is proficient not.

enrol_paypal Table txn_id VARCHAR 255
course_modules_completion Table coursemoduleid BIGINT 19 null

Activity that has been completed (or not).

workshop_assessments Table timemodified BIGINT 19 0

If 0 then the assessment was allocated but the reviewer has not assessed yet. If greater than 0 then the timestamp of when the reviewer assessed for the last time

mnetservice_enrol_courses Table shortname VARCHAR 100
question_datasets Table question BIGINT 19 0
question_dataset_definitions Table id BIGINT 19 null
qtype_match_subquestions Table questionid BIGINT 19 0

Foreign key link to question.id.

user_preferences Table id BIGINT 19 null
mnet_host Table name VARCHAR 80
competency_modulecomp Table timecreated BIGINT 19 null

The time this record was created.

workshopallocation_scheduled Table id BIGINT 19 null
quiz_statistics Table errorratio DECIMAL 15 null
question_calculated Table correctanswerlength BIGINT 19 2
grade_items Table multfactor DECIMAL 10 1.00000

Multiply all grades by this

forum_queue Table timemodified BIGINT 19 0

The modified time of the original post

search_index_requests Table partialtime BIGINT 19 null

If processing partially completed, set to the timestamp within the next area where processing should start. 0 indicates not processed yet.

competency_usercomp Table timecreated BIGINT 19 null
forum_posts Table modified BIGINT 19 0
tag_instance Table itemid BIGINT 19 null
notifications Table useridfrom BIGINT 19 null
assignment_submissions Table grade BIGINT 19 0
workshop_submissions Table content LONGTEXT 2147483647 null

Submission text

qtype_ddimageortext_drags Table label LONGTEXT 2147483647 null

Alt text label for drag-able image.

badge_criteria_met Table datemet BIGINT 19 null
lti_tool_proxies Table id BIGINT 19 null
grade_grades Table locktime BIGINT 19 0

automatic locking of final grade, 0 means none, date otherwise

course_completion_criteria Table module VARCHAR 100 null

Type of module (if using module criteria type)

badge Table name VARCHAR 255
resource_old Table cmid BIGINT 19 null
enrol_lti_lti2_consumer Table toolproxy LONGTEXT 2147483647 null
folder Table id BIGINT 19 null
tool_monitor_subscriptions Table id BIGINT 19 null
user_enrolments Table timemodified BIGINT 19 0
course_format_options Table id BIGINT 19 null
feedback_valuetmp Table item BIGINT 19 0
block_zoola_reports_schedule Table userid BIGINT 19 null

User ID

grade_categories_history Table aggregateoutcomes BIT 0 0

Aggregate outcomes

gradingform_guide_criteria Table sortorder BIGINT 19 null

Defines the order of the criterion in the guide

forum Table maxattachments BIGINT 19 1

Number of attachments allowed per post

grading_definitions Table status BIGINT 19 0

Status of the form definition, by default in the under-construction state

groups_members Table itemid BIGINT 19 0

If the 'component' field is set, this can be used to define the instance of the component that created the entry. Otherwise should be left as default (0).

user_private_key Table instance BIGINT 19 null

optional instance id

scorm_seq_mapinfo Table writenormalizedmeasure BIT 0 0
grade_items_history Table oldid BIGINT 19 null
message_processors Table id BIGINT 19 null
question_response_analysis Table whichtries VARCHAR 255
enrol Table customint4 BIGINT 19 null

Custom - general int

data Table assesstimestart BIGINT 19 0
context Table id BIGINT 19 null
quiz_feedback Table mingrade DECIMAL 10 0.00000

The lower limit of this grade band. Inclusive.

assignsubmission_file Table assignment BIGINT 19 0
quiz_statistics Table highestattemptsavg DECIMAL 15 null
tool_dataprivacy_rqst_ctxlst Table requestid BIGINT 19 null
gradingform_rubric_fillings Table id BIGINT 19 null
analytics_indicator_calc Table id BIGINT 19 null
workshopform_rubric Table description LONGTEXT 2147483647 null

The description of the dimension

grade_import_values Table importcode BIGINT 19 null

similar to backup_code, a unique batch code for identifying one batch of imports

feedback_value Table id BIGINT 19 null
course_completions Table id BIGINT 19 null
tool_usertours_tours Table description LONGTEXT 2147483647 null
badge Table attachment BIT 0 1

Attach baked badge for download

competency_usercompcourse Table grade BIGINT 19 null

The course grade assigned for the competency.

forum_posts Table mailnow BIGINT 19 0
editor_atto_autosave Table draftid BIGINT 19 null

Optional draft area id containing draft files.

mnet_log Table remoteid BIGINT 19 0
lesson Table name VARCHAR 255
question_attempt_steps Table fraction DECIMAL 12 null

The grade for this question, when graded out of 1. Needs to be multiplied by question_attempt.maxmark to get the actual mark for the question.

badge_backpack Table email VARCHAR 100
tool_customlang Table outdated SMALLINT 5 0

Either the English original or the master translation changed and the customization may be outdated

analytics_used_analysables Table timeanalysed BIGINT 19 null
forum_track_prefs Table id BIGINT 19 null
grade_items_history Table scaleid BIGINT 19 null

If this grade is based on a scale, which one is it?

assign Table nosubmissions TINYINT 3 0

This field is a cache for is_any_submission_plugin_enabled() which allows Moodle pages to distinguish offline assignment types without loading the assignment class.

role_context_levels Table id BIGINT 19 null
portfolio_log Table portfolio BIGINT 19 null

fk to portfolio_instance

local_ld_course_day Table daytime BIGINT 19 null

Timestamp of the beginning of the day

quiz Table introformat SMALLINT 5 0

Quiz intro text format.

config_plugins Table id BIGINT 19 null
forum_subscriptions Table forum BIGINT 19 0
data_fields Table param4 LONGTEXT 2147483647 null
question_statistics Table facility DECIMAL 15 null
grade_items Table plusfactor DECIMAL 10 0.00000

Add this to all grades

user_info_field Table param2 LONGTEXT 2147483647 null

General parameter field

forum Table rssarticles TINYINT 3 0
analytics_used_files Table action VARCHAR 50
groups_members Table userid BIGINT 19 0
question_answers Table fraction DECIMAL 12 0.0000000
post Table attachment VARCHAR 100 null

attachment

lti_tool_settings Table timecreated BIGINT 19 null

Date/time at which the record was created

quiz_reports Table name VARCHAR 255 null

name of the report, same as the directory name

forum_read Table id BIGINT 19 null
analytics_predict_samples Table analysableid BIGINT 19 null
auth_oauth2_linked_login Table issuerid BIGINT 19 null
data Table timeavailablefrom BIGINT 19 0
assignment_submissions Table numfiles BIGINT 19 0
survey Table questions VARCHAR 255
files Table filesize BIGINT 19 null
sessions Table userid BIGINT 19 null
workshop Table overallfeedbackfiles SMALLINT 5 0

Number of allowed attachments to the overall feedback.

feedback_completed Table userid BIGINT 19 0
scorm Table nav BIT 0 1
block_recent_activity Table userid BIGINT 19 null

User performing the action

cohort Table visible BIT 0 1

Visibility to teachers

messages Table fullmessageformat BIT 0 0
url Table parameters LONGTEXT 2147483647 null
data_fields Table name VARCHAR 255
files_reference Table lastsync BIGINT 19 null

Last time the proxy file was synced with repository

user_info_field Table required TINYINT 3 0

Field required

tool_usertours_steps Table sortorder BIGINT 19 0
course_modules_completion Table timemodified BIGINT 19 null

Time at which the completion state last changed.

local_ld_module Table totaldedication BIGINT 19 0

Total time spent on this module, in seconds

enrol_lti_tool_consumer_map Table id BIGINT 19 null
assign_user_mapping Table assignment BIGINT 19 0
lti Table instructorchoiceallowroster BIT 0 null

Allow the roster to be retrieved

quiz Table completionattemptsexhausted BIT 0 0
lesson Table introformat SMALLINT 5 0
analytics_indicator_calc Table indicator VARCHAR 255
gradingform_rubric_criteria Table definitionid BIGINT 19 null

The ID of the form definition this criterion is part of

competency_plancomp Table timemodified BIGINT 19 null
event Table repeatid BIGINT 19 0
qtype_ddimageortext Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

data_fields Table param2 LONGTEXT 2147483647 null
events_queue_handlers Table queuedeventid BIGINT 19 null

foreign key id corresponding to the id of the event_queues table

tool_dataprivacy_ctxinstance Table contextid BIGINT 19 null
chat_users Table course BIGINT 19 0
forum Table intro LONGTEXT 2147483647 null
course_modules_completion Table userid BIGINT 19 null

ID of user who has (or hasn't) completed the activity.

question Table id BIGINT 19 null
forum Table timemodified BIGINT 19 0
enrol_lti_lti2_share_key Table resourcelinkid BIGINT 19 null
chat Table keepdays BIGINT 19 0
enrol_lti_lti2_tool_proxy Table consumerid BIGINT 19 null
lesson Table progressbar SMALLINT 5 0
cohort_members Table timeadded BIGINT 19 0
question_categories Table sortorder BIGINT 19 999
stats_user_weekly Table statswrites BIGINT 19 0
grade_outcomes_history Table id BIGINT 19 null
workshop_aggregations Table workshopid BIGINT 19 null

the id of the workshop instance

filter_active Table active SMALLINT 5 null

Whether this filter is active in this context. +1 = On, -1 = Off, no row with this contextid = inherit. As a special case, when contextid points to the system context, -9999 means this filter is completely disabled.

ltiservice_gradebookservices Table tag VARCHAR 255 null

Tag type specified for the line item

quiz_statistics Table id BIGINT 19 null
survey_questions Table multi VARCHAR 100
page Table content LONGTEXT 2147483647 null
registration_hubs Table hubname VARCHAR 255
competency Table idnumber VARCHAR 100 null
question Table name VARCHAR 255
data_records Table groupid BIGINT 19 0
forum Table trackingtype TINYINT 3 1
feedback Table page_after_submit LONGTEXT 2147483647 null
question_statistics Table effectiveweight DECIMAL 15 null
quiz_statistics Table standarderror DECIMAL 15 null
glossary Table showspecial TINYINT 3 1
mnetservice_enrol_courses Table startdate BIGINT 19 null
quiz_statistics Table firstattemptsavg DECIMAL 15 null
resource Table timemodified BIGINT 19 0
tag_correlation Table correlatedtags LONGTEXT 2147483647 null
workshop_submissions Table attachment TINYINT 3 0

Used by File API file_postupdate_standard_filemanager

events_handlers Table handlerfile VARCHAR 255

path to the file of the function, eg /grade/export/lib.php

user_password_resets Table id BIGINT 19 null
grade_items Table itemnumber BIGINT 19 null

Can be used to distinguish multiple grades for an activity

repository_instances Table timemodified BIGINT 19 null
forum Table id BIGINT 19 null
grade_grades Table timecreated BIGINT 19 null

the time this grade was first created

lesson Table custom SMALLINT 5 0
feedback Table timeopen BIGINT 19 0
user Table descriptionformat TINYINT 3 1
grade_import_newitem Table importer BIGINT 19 null

user importing the data

tool_dataprivacy_ctxexpired Table usermodified BIGINT 19 null
role_sortorder Table roleid BIGINT 19 null
grade_items Table itemtype VARCHAR 30

'mod', 'blocks', 'import', 'calculated' etc

message_read Table timecreated BIGINT 19 0
files_reference Table id BIGINT 19 null
course_modules Table completion BIT 0 0

Whether the completion-tracking facilities are enabled for this activity. 0 = not enabled (database default) 1 = manual tracking, user can tick this activity off (UI default for most activity types) 2 = automatic tracking, system should mark completion according to rules specified in course_moduleS_completion

assign_grades Table assignment BIGINT 19 0
forum_discussion_subs Table id BIGINT 19 null
book_chapters Table importsrc VARCHAR 255
enrol_lti_lti2_consumer Table consumerguid VARCHAR 1024 null
tag_instance Table timemodified BIGINT 19 0

timemodified

question_categories Table infoformat TINYINT 3 0
comments Table id BIGINT 19 null
survey_analysis Table id BIGINT 19 null
scorm_seq_rulecond Table operator VARCHAR 5 noOp
question_attempts Table id BIGINT 19 null
quiz_grades Table quiz BIGINT 19 0

Foreign key references quiz.id.

grade_categories Table id BIGINT 19 null
enrol_lti_lti2_context Table updated BIGINT 19 null
license Table version BIGINT 19 0
enrol_lti_tools Table maildisplay TINYINT 3 2
glossary Table allowduplicatedentries TINYINT 3 0
enrol_lti_lti2_resource_link Table settings LONGTEXT 2147483647 null
imscp Table timemodified BIGINT 19 0
course_modules Table visibleold BIT 0 1
enrol_lti_lti2_context Table id BIGINT 19 null
chat Table intro LONGTEXT 2147483647 null
comments Table format TINYINT 3 0
quiz_statistics Table lastattemptscount BIGINT 19 null
mnet_rpc Table enabled BIT 0 0
data Table defaultsortdir SMALLINT 5 0
role_allow_view Table allowview BIGINT 19 null

The id of a role that the user is allowed to view to as a result of having this role.

scorm_aicc_session Table timecreated BIGINT 19 0

time this session was created

question Table qtype VARCHAR 20
tool_dataprivacy_request Table id BIGINT 19 null
quiz Table reviewmarks MEDIUMINT 7 0

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

qtype_ddmarker_drops Table coords LONGTEXT 2147483647 null
folder Table name VARCHAR 255
course_request Table summary LONGTEXT 2147483647 null
grade_grades Table information LONGTEXT 2147483647 null

optiona information

ltiservice_gradebookservices Table toolproxyid BIGINT 19 null

ID of the Tool Proxy instance.

wiki_pages Table timecreated BIGINT 19 0

Wiki page creation timestamp

post Table rating BIGINT 19 0
capabilities Table component VARCHAR 100
grade_categories_history Table droplow BIGINT 19 0

Drop the X lowest items

portfolio_mahara_queue Table token VARCHAR 50

the token mahara sent us to use for this transfer.

block_zoola_reports_schedule Table body LONGTEXT 2147483647 null

Email body

quiz Table shuffleanswers SMALLINT 5 0

Whether the parts of the question should be shuffled, in those question types that support it.

competency_plancomp Table timecreated BIGINT 19 null
post Table publishstate VARCHAR 20 draft
data_records Table userid BIGINT 19 0
user_private_key Table userid BIGINT 19 null

owner

forum_digests Table maildigest BIT 0 -1
question_numerical Table answer BIGINT 19 0

Foreign key references question_answers.id.

course Table enddate BIGINT 19 0
logstore_standard_log Table contextinstanceid BIGINT 19 null
logstore_standard_log Table id BIGINT 19 null
user_info_category Table sortorder BIGINT 19 0

Display order

question_dataset_items Table id BIGINT 19 null
course_completion_defaults Table completion BIT 0 0
cohort Table idnumber VARCHAR 100 null

Unique identifier of a cohort, useful especially for mapping to external entities

question_gapselect Table incorrectfeedbackformat TINYINT 3 0
oauth2_issuer Table scopessupported LONGTEXT 2147483647 null

The list of scopes this service supports.

scorm Table autocommit BIT 0 0
lti_submission Table ltiid BIGINT 19 null

ID of the LTI tool instance

assignment Table maxbytes BIGINT 19 100000
ltiservice_gradebookservices Table ltilinkid BIGINT 19 null

ID of the LTI element related with this lineitem.

page Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

logstore_standard_log Table component VARCHAR 100
local_ld_module Table ldcourseid BIGINT 19 null

Foreign key to the local_ld_course table

block_rss_client Table title LONGTEXT 2147483647 null
enrol_flatfile Table action VARCHAR 30
lti Table timecreated BIGINT 19 0
user Table phone2 VARCHAR 20
competency_userevidencecomp Table competencyid BIGINT 19 null
analytics_used_files Table fileid BIGINT 19 0
user Table skype VARCHAR 50
question_calculated_options Table answernumbering VARCHAR 10 abc

Indicates how and whether the choices should be numbered.

course_categories Table description LONGTEXT 2147483647 null
tool_policy_versions Table audience SMALLINT 5 0

Who is this policy targeted at: 0 - all users, 1 - logged in users only, 2 - guests only

assignfeedback_editpdf_cmnt Table rawtext LONGTEXT 2147483647 null

Raw text of the comment

role_allow_assign Table id BIGINT 19 null
quiz_overview_regrades Table questionusageid BIGINT 19 null

Foreign key references question_usages.id, or equivalently quiz_attempt.uniqueid.

competency_template Table descriptionformat SMALLINT 5 0

The format of the description field

lti Table id BIGINT 19 null
enrol_lti_lti2_user_result Table created BIGINT 19 null
badge_manual_award Table issuerid BIGINT 19 null
analytics_models Table usermodified BIGINT 19 null
forum Table maxbytes BIGINT 19 0
tool_dataprivacy_category Table usermodified BIGINT 19 null
course_published Table id BIGINT 19 null
user_devices Table id BIGINT 19 null
badge_backpack Table id BIGINT 19 null
question_numerical Table id BIGINT 19 null
question_numerical Table question BIGINT 19 0

Redundant, because of the answer field. Foreign key references question.id.

assignfeedback_editpdf_annot Table pageno BIGINT 19 0

The page in the PDF that this annotation appears on

external_services_functions Table functionname VARCHAR 200
ltiservice_gradebookservices Table courseid BIGINT 19 null

ID of the course related.

lti Table name VARCHAR 255

name field for moodle instances

assignment Table name VARCHAR 255
assign Table sendstudentnotifications TINYINT 3 1

Default for send student notifications checkbox when grading.

competency_evidence Table note LONGTEXT 2147483647 null

A non-localised text to attach to the evidence.

resource_old Table alltext LONGTEXT 2147483647 null
grade_items_history Table multfactor DECIMAL 10 1.00000

Multiply all grades by this

tool_policy_versions Table name VARCHAR 1333

Name of the policy document

course_completions Table timecompleted BIGINT 19 null
enrol_lti_lti2_consumer Table settings LONGTEXT 2147483647 null
course_request Table shortname VARCHAR 100
forum Table rsstype TINYINT 3 0
filter_config Table id BIGINT 19 null
quiz_attempts Table state VARCHAR 16 inprogress

The current state of the attempts. 'inprogress', 'overdue', 'finished' or 'abandoned'.

analytics_models Table version BIGINT 19 null
local_ld_import_logs_status Table timemodified BIGINT 19 null

Time of last status update. Used to predict remaining time left.

forum_posts Table attachment VARCHAR 100
block_zoola_module_name Table name VARCHAR 255

Module name

workshop Table intro LONGTEXT 2147483647 null

The introduction or description of the activity

competency_framework Table timemodified BIGINT 19 null

The time this competency framework was last modified.

question_hints Table clearwrong BIT 0 null

Whether any wrong choices should be cleared before the next try. Whether this is applicable, and what it means, depends on the question type, as with the shownumright option.

workshopeval_best_settings Table comparison SMALLINT 5 5

Here we store the recently set factor of comparison of assessment in the given workshop. Reasonable values are from 1 to 10 or so. Default to 5.

tool_dataprivacy_request Table commentsformat TINYINT 3 0
tool_usertours_steps Table configdata LONGTEXT 2147483647 null
mnet_log Table module VARCHAR 20
blog_association Table id BIGINT 19 null
assignfeedback_editpdf_annot Table draft TINYINT 3 1

Is this a draft annotation?

portfolio_log Table caller_component VARCHAR 255 null

the component name responsible for exporting

profiling Table totalcalls BIGINT 19 null

Total number of calls performed by the run

qtype_multichoice_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

enrol_paypal Table userid BIGINT 19 0
question_categories Table info LONGTEXT 2147483647 null
workshop Table submissionstart BIGINT 19 0

0 = will be started manually, greater than 0 the timestamp of the start of the submission phase

oauth2_endpoint Table timemodified BIGINT 19 null

The time this record was modified.

feedback Table autonumbering BIT 0 1
oauth2_endpoint Table timecreated BIGINT 19 null

The time this record was created.

message_conversation_members Table timecreated BIGINT 19 null
question_response_analysis Table variant BIGINT 19 null
wiki Table timecreated BIGINT 19 0
competency_userevidence Table name VARCHAR 100
grade_grades_history Table information LONGTEXT 2147483647 null

optiona information

block_positions Table region VARCHAR 16

Which block region on this page this block should appear in.

quiz Table canredoquestions SMALLINT 5 0

Allows students to redo any completed question within a quiz attempt.

scorm_seq_objective Table primaryobj BIT 0 0
course_completion_defaults Table id BIGINT 19 null
enrol_lti_users Table consumersecret LONGTEXT 2147483647 null
role_capabilities Table timemodified BIGINT 19 0
forum_discussions Table timemodified BIGINT 19 0
question Table timemodified BIGINT 19 0

time that question was last modified

page Table name VARCHAR 255
mnetservice_enrol_courses Table sortorder BIGINT 19 0
workshop Table latesubmissions TINYINT 3 0

Allow submitting the work after the deadline

workshop_submissions Table contenttrust SMALLINT 5 0

The trust mode of the data

question_attempt_step_data Table name VARCHAR 32

The name of this bit of data.

mnet_rpc Table xmlrpcpath VARCHAR 80
enrol_lti_lti2_tool_proxy Table updated BIGINT 19 null
forum_posts Table mailed TINYINT 3 0
mnet_host Table sslverification BIT 0 0
config Table value LONGTEXT 2147483647 null
course Table legacyfiles SMALLINT 5 0

course files are not necessary any more: 0 no legacy files, 1 legacy files disabled, 2 legacy files enabled

glossary Table rssarticles TINYINT 3 0
lti_tool_settings Table timemodified BIGINT 19 null

Date/time at which the record was last modified

quiz Table grade DECIMAL 10 0.00000

The total that the quiz overall grade is scaled to be out of.

portfolio_instance Table plugin VARCHAR 50

fk to plugin

message_user_actions Table messageid BIGINT 19 null
mnetservice_enrol_courses Table summaryformat SMALLINT 5 0

Format of the summary field

enrol_paypal Table tax VARCHAR 255
scorm_aicc_session Table scormmode VARCHAR 50 null
scorm Table timeclose BIGINT 19 0
quiz_overview_regrades Table id BIGINT 19 null
profiling Table runcomment VARCHAR 255

Brief comment for this run

rating Table timecreated BIGINT 19 null
mnetservice_enrol_courses Table idnumber VARCHAR 100
competency_usercompplan Table userid BIGINT 19 null

User associated to the competency.

choice Table intro LONGTEXT 2147483647 null
enrol_lti_lti2_share_key Table expires BIGINT 19 null
tool_policy_acceptances Table status BIT 0 null

Acceptance status: 1 - accepted, 0 - not accepted

course Table timemodified BIGINT 19 0
scorm_seq_rolluprule Table childactivityset VARCHAR 15
lesson_attempts Table correct BIGINT 19 0
user_info_data Table userid BIGINT 19 0

id from the user table

user_info_field Table descriptionformat TINYINT 3 0
config_log Table name VARCHAR 100
feedback_completed Table feedback BIGINT 19 0
tool_monitor_subscriptions Table timecreated BIGINT 19 null

Timestamp of when this subscription was created

block Table cron BIGINT 19 0
competency_framework Table id BIGINT 19 null
backup_controllers Table interactive SMALLINT 5 null

is the backup interactive (1-yes/0-no)

user Table timezone VARCHAR 100 99
competency_usercompcourse Table courseid BIGINT 19 null

The course this competency is linked to.

user Table auth VARCHAR 20 manual
feedback_item Table feedback BIGINT 19 0
qtype_essay_options Table graderinfo LONGTEXT 2147483647 null

Information shown to people with permission to manually grade the question, when they are grading.

course Table groupmode SMALLINT 5 0
portfolio_tempdata Table expirytime BIGINT 19 null

time this record will expire (used for cron cleanups) - the start of export + 24 hours

oauth2_system_account Table usermodified BIGINT 19 null

The user who modified this record.

assign_overrides Table cutoffdate BIGINT 19 null

Time by which students must have completed their attempt. Can be null, in which case the assign default is used.

lesson_branch Table userid BIGINT 19 0
messages Table timecreated BIGINT 19 null
lesson Table mediaheight BIGINT 19 100
user_preferences Table value VARCHAR 1333
mnet_log Table info VARCHAR 255
tool_cohortroles Table cohortid BIGINT 19 null

The cohort to sync

block_zoola_reports_schedule Table retry BIGINT 19 null

How many times scheduling failed

question_attempt_step_data Table attemptstepid BIGINT 19 null

Foreign key, references question_attempt_steps.id

grade_items_history Table aggregationcoef2 DECIMAL 10 0.00000

Aggregation coefficient used for category weights or other aggregation types

message_read Table contexturlname LONGTEXT 2147483647 null

Display text for the contexturl

tool_policy_versions Table contentformat SMALLINT 5 null

Format of the content field

scorm_seq_rolluprule Table action VARCHAR 15
lti_types_config Table name VARCHAR 100

Basic LTI param

book_chapters Table subchapter BIGINT 19 0
assignfeedback_editpdf_annot Table type VARCHAR 10 line

line, oval, rect, etc.

quiz_attempts Table preview SMALLINT 5 0
message_airnotifier_devices Table id BIGINT 19 null
enrol_lti_lti2_consumer Table enablefrom BIGINT 19 null
tag Table rawname VARCHAR 255

The raw, unnormalised name for the tag as entered by users

search_simpledb_index Table courseid BIGINT 19 null
files Table author VARCHAR 255 null

The original author of the file

tag_coll Table name VARCHAR 255 null
backup_courses Table nextstarttime BIGINT 19 0
enrol_lti_lti2_resource_link Table ltiresourcelinkkey VARCHAR 255
external_tokens Table id BIGINT 19 null
mnetservice_enrol_courses Table categoryname VARCHAR 255
profiling Table timecreated BIGINT 19 null

unix timestap of the creation of this run

lti Table instructorchoiceacceptgrades BIT 0 null

Accept grades from tool

role_allow_switch Table id BIGINT 19 null
tool_monitor_history Table id BIGINT 19 null
block_community Table courseurl VARCHAR 255
workshop Table instructreviewers LONGTEXT 2147483647 null

Instructions for the assessment phase

mnet_session Table mnethostid BIGINT 19 0

Unique remote host ID

user Table trackforums BIT 0 0
url Table externalurl LONGTEXT 2147483647 null
competency Table shortname VARCHAR 100 null

Shortname of a competency

question_answers Table answerformat TINYINT 3 0
competency_modulecomp Table competencyid BIGINT 19 null

The course competency this activity is linked to.

competency_userevidencecomp Table timecreated BIGINT 19 null
assignfeedback_editpdf_quick Table id BIGINT 19 null
qtype_ddimageortext Table partiallycorrectfeedbackformat TINYINT 3 0
quiz Table attemptonlast SMALLINT 5 0

Whether subsequent attempts start from teh answer to the previous attempt (1) or start blank (0).

portfolio_instance_user Table name VARCHAR 255

name of config item

block_rss_client Table skipuntil BIGINT 19 0

Do not query this RSS feed again until this time

assign_user_flags Table mailed SMALLINT 5 0

Has the student been sent a notification about this grade update?

user_info_field Table visible SMALLINT 5 0

Visibility: private, public, hidden

registration_hubs Table timemodified BIGINT 19 0
course_modules Table deletioninprogress BIT 0 0
events_queue Table eventdata LONGTEXT 2147483647 null

serialized version of the data object passed to the event handler.

task_scheduled Table id BIGINT 19 null
question_statistics Table maxmark DECIMAL 12 null
message_processors Table enabled BIT 0 1

Defines if processor is enabled

choice_options Table timemodified BIGINT 19 0
tool_dataprivacy_ctxexpired Table timecreated BIGINT 19 null
tool_cohortroles Table usermodified BIGINT 19 null

Who last modified this record?

course_request Table password VARCHAR 50
external_tokens Table privatetoken VARCHAR 64 null

private token, generated at the same time that the token, must be stored safely by the ws client, to be transmitted only via https

groups Table descriptionformat TINYINT 3 0
question_response_count Table try BIGINT 19 null
tool_cohortroles Table timecreated BIGINT 19 null

The time this record was created

mnet_host Table public_key_expires BIGINT 19 0
assign Table blindmarking TINYINT 3 0

Hide student/grader identities until the reveal identities action is performed

workshopform_numerrors Table descriptionformat SMALLINT 5 0

The format of the description field

message Table useridfrom BIGINT 19 0
course_format_options Table name VARCHAR 100

Name of the format option

context Table instanceid BIGINT 19 0
competency_userevidence Table descriptionformat BIT 0 null
gradingform_rubric_fillings Table criterionid BIGINT 19 null

The ID of the criterion (row) in the rubric

qtype_randomsamatch_options Table questionid BIGINT 19 0

Foreign key references question.id.

choice Table publish TINYINT 3 0
wiki_versions Table contentformat VARCHAR 20 creole

Markup used to write content

lesson_attempts Table id BIGINT 19 null
grading_instances Table rawgrade DECIMAL 10 null

The raw normalized grade 0.00000 - 100.00000 as a result of the most recent assessment

enrol_lti_tools Table roleinstructor BIGINT 19 null
feedback_item Table name VARCHAR 255
quiz Table delay1 BIGINT 19 0

Delay that must be left between the first and second attempt, in seconds.

lti_types Table enabledcapability LONGTEXT 2147483647 null

Enabled capabilities, one per line (null for LTI 1 tools)

profiling Table url VARCHAR 255

the url this profiling record is about (without wwwroot nor query params)

qtype_ddmarker Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

profiling Table runreference TINYINT 3 0

Is this run a reference one

message Table subject LONGTEXT 2147483647 null

The message subject

local_ld_import_logs_status Table timestarted BIGINT 19 null

When the import logs task started

question_statistics Table questionid BIGINT 19 null
forum_track_prefs Table userid BIGINT 19 0
logstore_standard_log Table ip VARCHAR 45 null

IP address

cohort_members Table userid BIGINT 19 0
tool_customlang_components Table id BIGINT 19 null
workshop Table overallfeedbackmaxbytes BIGINT 19 100000

Maximum size of one file attached to the overall feedback.

user Table description LONGTEXT 2147483647 null
lti_tool_proxies Table regurl LONGTEXT 2147483647 null
workshop_aggregations Table timegraded BIGINT 19 null

The timestamp of when the participant's gradinggrade was recently aggregated.

quiz_sections Table heading VARCHAR 1333 null

The text of the heading. May be an empty string/null. Multilang format.

course_format_options Table value LONGTEXT 2147483647 null

Value of the format option

grade_import_values Table itemid BIGINT 19 null

if set, this points to existing grade_items id

label Table name VARCHAR 255
book_chapters Table timemodified BIGINT 19 0
workshop Table timemodified BIGINT 19 null

The timestamp when the module was modified

stats_user_daily Table statsreads BIGINT 19 0
assign Table name VARCHAR 255

The name of the instance of the assignment. Displayed at the top of each page.

stats_monthly Table stat1 BIGINT 19 0

stat1. usually used for reads

tag_coll Table customurl VARCHAR 255 null

Custom URL for the tag page instead of /tag/index.php

badge Table description LONGTEXT 2147483647 null
lesson Table password VARCHAR 32
block_zoola_module_name Table moduletype VARCHAR 20

Module type (lesson, quiz, ...)

workshop_assessments Table reviewerid BIGINT 19 null

The id of the reviewer who makes this assessment

chat_messages Table issystem BIT 0 0
cache_flags Table id BIGINT 19 null
quiz Table navmethod VARCHAR 16 free

Any constraints on how the user is allowed to navigate around the quiz. Currently recognised values are 'free' and 'seq'.

data Table requiredentries INT 10 0
oauth2_issuer Table timemodified BIGINT 19 null

Time this record was modified.

resource_old Table timemodified BIGINT 19 0
glossary Table defaultapproval TINYINT 3 1
book_chapters Table id BIGINT 19 null
forum_discussions Table id BIGINT 19 null
scorm_seq_rolluprulecond Table operator VARCHAR 5 noOp
quiz_sections Table quizid BIGINT 19 null

Foreign key references quiz.id.

workshop_grades Table id BIGINT 19 null
grading_areas Table areaname VARCHAR 100

The name of gradable area

forum_queue Table userid BIGINT 19 0
post Table format BIGINT 19 0
grade_grades_history Table locked BIGINT 19 0

not locked 0, locked from date

qtype_match_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

course_modules Table completionexpected BIGINT 19 0

Date at which students are expected to complete this activity. This field is used when displaying student progress.

message_providers Table component VARCHAR 200

The name of the component that produces these messages

wiki_pages Table title VARCHAR 255 title

Page name

wiki_subwikis Table wikiid BIGINT 19 0

Wiki activity

task_adhoc Table userid BIGINT 19 null
blog_external Table description LONGTEXT 2147483647 null
stats_user_weekly Table userid BIGINT 19 0
question_response_analysis Table questionid BIGINT 19 null
scorm_seq_rolluprulecond Table id BIGINT 19 null
cache_filters Table md5key VARCHAR 32
wiki_synonyms Table id BIGINT 19 null
enrol Table password VARCHAR 50 null

Custom - enrolment or access password

assignfeedback_editpdf_annot Table gradeid BIGINT 19 0
feedback_value Table tmp_completed BIGINT 19 0
course_completion_aggr_methd Table method BIT 0 0

1 = all, 2 = any, 3 = fraction, 4 = unit

wiki_links Table id BIGINT 19 null
forum_posts Table parent BIGINT 19 0
question_response_analysis Table id BIGINT 19 null
assignfeedback_editpdf_cmnt Table x BIGINT 19 0

x-position of the top-left corner of the comment (in pixels - image resolution is set to 100 pixels per inch)

feedback Table publish_stats BIT 0 0
qtype_ddmarker_drags Table id BIGINT 19 null
log Table id BIGINT 19 null
workshop_submissions Table example TINYINT 3 0

Is this submission an example from teacher

rating Table id BIGINT 19 null
feedback_value Table value LONGTEXT 2147483647 null
course_request Table requester BIGINT 19 0
scorm_scoes_data Table id BIGINT 19 null
grade_items_history Table outcomeid BIGINT 19 null

If this grade is related to an outcome, which one is it?

survey_questions Table type SMALLINT 5 0
chat_users Table lang VARCHAR 30
event Table sequence BIGINT 19 1
scorm_seq_mapinfo Table id BIGINT 19 null
course_categories Table visible BIT 0 1
data Table listtemplateheader LONGTEXT 2147483647 null
stats_user_daily Table roleid BIGINT 19 0
chat Table timemodified BIGINT 19 0
survey Table days MEDIUMINT 7 0
tag_instance Table ordering BIGINT 19 null

Maintains the order of the tag instances of an item

enrol_flatfile Table roleid BIGINT 19 null
user_info_field Table param4 LONGTEXT 2147483647 null

General parameter field

log_queries Table timelogged BIGINT 19 null

timestamp when log info stored into db

competency_relatedcomp Table timemodified BIGINT 19 null
lti Table securetoolurl LONGTEXT 2147483647 null
stats_user_weekly Table roleid BIGINT 19 0
competency_plancomp Table usermodified BIGINT 19 null
lock_db Table expires BIGINT 19 null

Expiry time for an active lock.

glossary_entries Table sourceglossaryid BIGINT 19 0
quiz_overrides Table password VARCHAR 255 null

Quiz password. Can be null, in which case the quiz default is used.

data_fields Table param1 LONGTEXT 2147483647 null
competency_framework Table visible TINYINT 3 1

Used to show/hide this competency framework.

chat_messages Table message LONGTEXT 2147483647 null
cohort Table descriptionformat TINYINT 3 null
groups_members Table component VARCHAR 100

Defines the Moodle component which added this group membership (e.g. 'auth_myplugin'), or blank if it was added manually. (Entries which are created by a Moodle component cannot be removed in the normal user interface.)

scale_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

quiz Table sumgrades DECIMAL 10 0.00000

The total of all the question instance maxmarks.

qtype_ddmarker Table id BIGINT 19 null
book_chapters Table timecreated BIGINT 19 0
local_ld_module Table id BIGINT 19 null
glossary Table editalways TINYINT 3 0
profiling Table data LONGTEXT 2147483647 null

the raw data gathered by xhprof

enrol Table status BIGINT 19 0

0..9 are system constants, 0 means active enrolment, see ENROL_STATUS_* constants, plugins may define own status greater than 10

grade_items_history Table locktime BIGINT 19 0

lock all final grades after this date

capabilities Table captype VARCHAR 50
quiz_statistics Table whichattempts SMALLINT 5 null

bool used to indicate whether these stats are for all attempts or just for the first.

workshopform_rubric_levels Table definition LONGTEXT 2147483647 null

The definition of this level

gradingform_guide_comments Table sortorder BIGINT 19 null

Defines the order of the comments

qtype_ddmarker Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

feedback_item Table label VARCHAR 255
user_enrolments Table enrolid BIGINT 19 null
user Table timemodified BIGINT 19 0
competency_templatecomp Table competencyid BIGINT 19 null

The competency that is linked to this course.

book Table name VARCHAR 255
workshop Table nattachments SMALLINT 5 0

Number of required submission attachments

cohort Table name VARCHAR 254

Short human readable name for the cohort, does not have to be unique

question_ddwtos Table partiallycorrectfeedbackformat TINYINT 3 0
tool_monitor_rules Table courseid BIGINT 19 null

Id of course to which this rule belongs.

glossary_formats Table id BIGINT 19 null
repository_onedrive_access Table permissionid VARCHAR 255

The permission id in OneDrive.

grade_grades_history Table action BIGINT 19 0

created/modified/deleted constants

course_completion_criteria Table role BIGINT 19 null
assignfeedback_editpdf_annot Table endy BIGINT 19 0

y-position of the end of the annotation

event_subscriptions Table lastupdated BIGINT 19 null
competency_templatecomp Table id BIGINT 19 null
enrol Table timecreated BIGINT 19 0
competency_evidence Table grade BIGINT 19 null
enrol_lti_tools Table enrolid BIGINT 19 null
lti_tool_settings Table coursemoduleid BIGINT 19 null

Primary key of course module - tool link added to course (null for system-wide and context-wide settings)

groups Table idnumber VARCHAR 100
survey_analysis Table notes LONGTEXT 2147483647 null
tag_area Table itemtype VARCHAR 100
mnetservice_enrol_courses Table summary LONGTEXT 2147483647 null
survey_questions Table options LONGTEXT 2147483647 null
block_instances Table timecreated BIGINT 19 null

Time at which this block instance was originally created

lti Table debuglaunch BIT 0 0

Enable the debug-style launch which pauses before auto-submit

resource_old Table newid BIGINT 19 null
quiz Table course BIGINT 19 0

Foreign key reference to the course this quiz is part of.

user_info_field Table id BIGINT 19 null
mnet_service2rpc Table id BIGINT 19 null

Required ID field

lesson_grades Table completed BIGINT 19 0
notifications Table useridto BIGINT 19 null
stats_user_daily Table statswrites BIGINT 19 0
chat_messages Table timestamp BIGINT 19 0
quiz_sections Table id BIGINT 19 null
mnet_host2service Table id BIGINT 19 null
comments Table content LONGTEXT 2147483647 null
block_zoola_reports_user Table id BIGINT 19 null
grade_items_history Table weightoverride BIT 0 0
user_devices Table userid BIGINT 19 0
messageinbound_handlers Table id BIGINT 19 null
glossary Table showall TINYINT 3 1
course_modules Table indent MEDIUMINT 7 0
feedback_completed Table anonymous_response BIT 0 0
competency_userevidence Table usermodified BIGINT 19 null
course_published Table courseid BIGINT 19 null

the id of the published course

oauth2_user_field_mapping Table timemodified BIGINT 19 null

The time this record was modified

user Table trustbitmask BIGINT 19 0
events_handlers Table schedule VARCHAR 255 null

'cron' or 'instant'.

log_display Table component VARCHAR 100

owner of the log action

block_rss_client Table preferredtitle VARCHAR 64
role_allow_switch Table roleid BIGINT 19 null

The role the user has.

lti_types_config Table value LONGTEXT 2147483647 null

Param value

lesson Table available BIGINT 19 0
workshopform_rubric Table workshopid BIGINT 19 null

Workshop ID

assign_overrides Table groupid BIGINT 19 null

Foreign key references groups.id. Can be null if this is a per-user override.

stats_user_daily Table timeend BIGINT 19 0
cohort Table timemodified BIGINT 19 null
assign_submission Table assignment BIGINT 19 0
assign_user_mapping Table id BIGINT 19 null
assign Table intro LONGTEXT 2147483647 null

The description of the assignment. This field is used by feature MOD_INTRO.

competency_usercomp Table competencyid BIGINT 19 null

Competency associated to the user.

question_dataset_items Table itemnumber BIGINT 19 0
feedback Table course BIGINT 19 0
competency_plancomp Table id BIGINT 19 null
lesson_pages Table contentsformat TINYINT 3 0
task_scheduled Table day VARCHAR 25
oauth2_issuer Table name VARCHAR 255

The name of this identity issuer

quiz_reports Table id BIGINT 19 null
competency Table timemodified BIGINT 19 null

The time this competency was last modified.

question_attempts Table rightanswer LONGTEXT 2147483647 null

This is a human-readable textual summary of the right answer to this question. Might be used, for example on the quiz preview, to help people who are testing the question. Or might be used in reports.

portfolio_instance_user Table instance BIGINT 19 null

fk to instance table

user_password_history Table timecreated BIGINT 19 null
lesson_overrides Table id BIGINT 19 null
survey Table template BIGINT 19 0
forum_digests Table id BIGINT 19 null
lesson_pages Table title VARCHAR 255
data_fields Table param6 LONGTEXT 2147483647 null
assign_submission Table timecreated BIGINT 19 0

The time of the first student submission to this assignment.

workshopform_accumulative Table descriptionformat SMALLINT 5 0

The format of the description field

scorm_seq_objective Table id BIGINT 19 null
external_services Table name VARCHAR 200
quiz_attempts Table quiz BIGINT 19 0

Foreign key reference to the quiz that was attempted.

groupings Table idnumber VARCHAR 100
grade_import_newitem Table id BIGINT 19 null
enrol_lti_users Table lastgrade DECIMAL 10 null

The last grade that was sent

search_simpledb_index Table content LONGTEXT 2147483647 null
wiki_versions Table content LONGTEXT 2147483647 null

Not parsed wiki content

log Table time BIGINT 19 0
forum Table assessed BIGINT 19 0
tag_coll Table id BIGINT 19 null
message_read Table smallmessage LONGTEXT 2147483647 null

Smal version of message (eg sms)

stats_user_weekly Table courseid BIGINT 19 0
question_ddwtos Table shuffleanswers SMALLINT 5 1
qtype_ddmarker_drops Table questionid BIGINT 19 0
lesson Table displayleft SMALLINT 5 0
question_statistics Table hashcode VARCHAR 40

sha1 hash of serialized qubaids_condition class. Unique for every combination of class name and property.

lti_types Table timemodified BIGINT 19 null
mnetservice_enrol_enrolments Table enroltime BIGINT 19 0
user_info_field Table shortname VARCHAR 255 shortname

short name for each field

course_sections Table sequence LONGTEXT 2147483647 null
files Table contextid BIGINT 19 null

The context id defined in context table - identifies the instance of plugin owning the file

question_attempt_step_data Table value LONGTEXT 2147483647 null

The corresponding value

course Table maxbytes BIGINT 19 0
glossary_entries Table casesensitive TINYINT 3 0
forum_posts Table subject VARCHAR 255
qtype_multichoice_options Table shownumcorrect TINYINT 3 0

If true, then when the user gets a multiple-response question partially correct, tell them how many choices they got correct alongside the feedback.

wiki_links Table tomissingpage VARCHAR 255 null

link to a nonexistent page

qtype_randomsamatch_options Table subcats TINYINT 3 1

Whether to include or not the subcategories.

resource Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

grade_grades_history Table overridden BIGINT 19 0

indicates grade overridden from gradebook, 0 means none, date means overridden

gradingform_guide_criteria Table shortname VARCHAR 255

shortname of this criterion

glossary_entries_categories Table categoryid BIGINT 19 0
assign_overrides Table assignid BIGINT 19 0

Foreign key references assign.id

course_sections Table visible BIT 0 1
tool_policy_acceptances Table timecreated BIGINT 19 null

Timestamp of when the acceptance record was created

enrol Table timemodified BIGINT 19 0
local_ld_import_logs_status Table timefinished BIGINT 19 null

When the import logs tash finished

analytics_indicator_calc Table sampleid BIGINT 19 null
scorm_seq_rulecond Table ruleconditionsid BIGINT 19 0
event Table type SMALLINT 5 0
messageinbound_datakeys Table datakey VARCHAR 64 null

The secret key for this data item.

user Table aim VARCHAR 50
feedback_completed Table timemodified BIGINT 19 0
gradingform_rubric_fillings Table levelid BIGINT 19 null

If a particular level was selected during the assessment, its ID is stored here

enrol_lti_lti2_consumer Table name VARCHAR 50
quiz Table allowofflineattempts BIT 0 0

Whether to allow the quiz to be attempted offline in the mobile app

competency_templatecohort Table cohortid BIGINT 19 null
grade_items_history Table iteminfo LONGTEXT 2147483647 null

Info and notes about this item XXX

search_simpledb_index Table type BIT 0 null
grade_settings Table id BIGINT 19 null
feedback_completedtmp Table random_response BIGINT 19 0
competency_usercompplan Table timecreated BIGINT 19 null
log Table module VARCHAR 20
wiki_versions Table userid BIGINT 19 0

Edition autor

enrol_lti_users Table sourceid LONGTEXT 2147483647 null
survey_questions Table shorttext VARCHAR 30
forum Table blockafter BIGINT 19 0
competency_usercomp Table userid BIGINT 19 null

User associated to the competency.

tool_dataprivacy_ctxinstance Table id BIGINT 19 null
tool_monitor_rules Table timemodified BIGINT 19 null

Timestamp when this rule was last modified

events_queue_handlers Table timemodified BIGINT 19 null

time stamp of the last attempt to run this from the queue

quiz_feedback Table feedbacktext LONGTEXT 2147483647 null

The feedback to show for a attempt where mingrade <= attempt grade < maxgrade. See function quiz_feedback_for_grade in mod/quiz/locallib.php.

grade_items Table itemmodule VARCHAR 30 null

'forum', 'quiz', 'csv', etc

message_read Table notification BIT 0 0
message Table contexturl LONGTEXT 2147483647 null

If this message is a notification of an event contexturl should contain a link to view this event. For example if its a notification of a forum post contexturl should contain a link to the forum post.

groupings Table courseid BIGINT 19 0
feedback_item Table dependitem BIGINT 19 0
quiz_statistics Table hashcode VARCHAR 40

sha1 hash of serialized qubaids_condition class. Unique for every combination of class name and property.

enrol_lti_tools Table gradesynccompletion BIT 0 0
grade_import_newitem Table importcode BIGINT 19 null

import batch code for identification

enrol_lti_users Table membershipsurl LONGTEXT 2147483647 null
assign Table cutoffdate BIGINT 19 0

The final date after which submissions will no longer be accepted for this assignment without an extensions.

analytics_predict_samples Table id BIGINT 19 null
tool_dataprivacy_contextlist Table id BIGINT 19 null
oauth2_issuer Table requireconfirmation TINYINT 3 1
portfolio_log Table caller_sha1 VARCHAR 255

sha1 of exported content as far as the caller is concerned (before the portfolio plugin gets a hold of it)

competency Table ruleconfig LONGTEXT 2147483647 null
gradingform_guide_comments Table description LONGTEXT 2147483647 null

The comment description

comments Table component VARCHAR 255 null

The plugin this comment belongs to.

lesson Table activitylink BIGINT 19 0
mnet_session Table userid BIGINT 19 0

Unique user ID

scorm_aicc_session Table id BIGINT 19 null
chat_users Table id BIGINT 19 null
assignfeedback_editpdf_cmnt Table width BIGINT 19 120

width, in pixels, of the comment box

competency_coursecomp Table sortorder BIGINT 19 null

The display order for this link.

user Table imagealt VARCHAR 255 null

alt tag for user uploaded image

blog_association Table blogid BIGINT 19 null
data_fields Table description LONGTEXT 2147483647 null
oauth2_issuer Table loginscopesoffline LONGTEXT 2147483647 null

The scopes requested for a login attempt to generate a refresh token.

tool_recyclebin_category Table id BIGINT 19 null
lesson_branch Table lessonid BIGINT 19 0
user_devices Table version VARCHAR 32

The device version, 6.1.2, 4.2.2 etc..

question_calculated_options Table synchronize TINYINT 3 0
external_services_functions Table externalserviceid BIGINT 19 null
backup_logs Table message LONGTEXT 2147483647 null

text logged

rating Table timemodified BIGINT 19 null
mnet_host Table id BIGINT 19 null

Unique Host ID

course_sections Table course BIGINT 19 0
analytics_predict_samples Table timesplitting VARCHAR 255
lesson_branch Table nextpageid BIGINT 19 0
enrol_lti_lti2_user_result Table id BIGINT 19 null
local_ld_module_day Table dedication BIGINT 19 0

Time spent on module within this day

stats_user_daily Table userid BIGINT 19 0
assign_overrides Table allowsubmissionsfromdate BIGINT 19 null

Time at which students may start attempting this assign. Can be null, in which case the assign default is used.

question_usages Table component VARCHAR 255

The plugin this attempt belongs to, e.g. 'mod_quiz', 'block_questionoftheday', 'filter_embedquestion'.

enrol_lti_lti2_nonce Table expires BIGINT 19 null
data Table approval SMALLINT 5 0
lesson Table modattempts SMALLINT 5 0
forum_read Table firstread BIGINT 19 0
resource_old Table migrated BIGINT 19 0
grade_grades Table rawgrademin DECIMAL 10 0.00000

The minimum allowable grade when this was created

tag_area Table tagcollid BIGINT 19 null
mnet_rpc Table filename VARCHAR 100
qtype_ddimageortext_drops Table no BIGINT 19 0

drop number

user_info_field Table forceunique TINYINT 3 0

should the field contain unique data

page Table displayoptions LONGTEXT 2147483647 null
stats_user_monthly Table statswrites BIGINT 19 0
quiz Table timecreated BIGINT 19 0

The time when the quiz was added to the course.

assignment Table resubmit TINYINT 3 0
question_ddwtos Table incorrectfeedbackformat TINYINT 3 0
book Table timecreated BIGINT 19 0
badge_manual_award Table issuerrole BIGINT 19 null
tool_policy_acceptances Table timemodified BIGINT 19 null

Timestamp of when the acceptance record was last modified

badge_criteria Table description LONGTEXT 2147483647 null
workshopform_rubric_levels Table definitionformat SMALLINT 5 0

The format of the definition field

chat_messages Table groupid BIGINT 19 0
question Table questiontext LONGTEXT 2147483647 null
glossary_entries Table fullmatch TINYINT 3 1
assignfeedback_file Table id BIGINT 19 null
role_names Table contextid BIGINT 19 0
lesson Table width BIGINT 19 640
auth_oauth2_linked_login Table timemodified BIGINT 19 null
external_tokens Table contextid BIGINT 19 null

context id where in token valid

competency_framework Table scaleid BIGINT 19 null

Scale used to define competency.

scorm Table options VARCHAR 255
forum_discussions Table forum BIGINT 19 0
lesson_overrides Table password VARCHAR 32 null

Lesson password. Can be null, in which case the lesson default is used.

question_attempt_steps Table id BIGINT 19 null
portfolio_log Table tempdataid BIGINT 19 0

old id from portfolio_tempdata. This is so that we can gracefully catch a race condition between an external system requesting a file and causing the tempdata to be deleted, before the user gets the "your transfer is requested" page

quiz_overrides Table userid BIGINT 19 null

Foreign key references user.id. Can be null if this is a per-group override.

grade_outcomes_history Table oldid BIGINT 19 null
glossary_entries Table usedynalink TINYINT 3 1
tool_customlang Table modified SMALLINT 5 0

Has the string been modified via the translator?

tool_customlang_components Table version VARCHAR 255 null

The checked out version of the plugin, null if the version is unknown

competency_evidence Table desca LONGTEXT 2147483647 null
question_statistics Table slot BIGINT 19 null

The position in the quiz where this question appears

message_read Table fullmessageformat SMALLINT 5 0

The format of the full message

enrol_lti_tools Table country VARCHAR 2
role_context_levels Table contextlevel BIGINT 19 null
assign_overrides Table duedate BIGINT 19 null

Time by which students must have completed their attempt. Can be null, in which case the assign default is used.

lesson_overrides Table retake SMALLINT 5 null
portfolio_instance Table id BIGINT 19 null
chat_messages_current Table userid BIGINT 19 0
assignment_submissions Table format SMALLINT 5 0
scorm_scoes_track Table scormid BIGINT 19 0
book Table navstyle SMALLINT 5 1
blog_association Table contextid BIGINT 19 null
scorm_aicc_session Table lessonstatus VARCHAR 255 null
tool_usertours_tours Table sortorder BIGINT 19 0
message_user_actions Table action BIGINT 19 null
competency_coursecompsetting Table id BIGINT 19 null
tool_policy_versions Table timecreated BIGINT 19 null

Timestamp of when the policy version was created.

backup_controllers Table userid BIGINT 19 null

user that owns/performs the backup

qtype_multichoice_options Table questionid BIGINT 19 0

Foreign key references question.id

choice_answers Table timemodified BIGINT 19 0
assign Table introformat SMALLINT 5 0

The format of the description field of the assignment. This field is used by feature MOD_INTRO.

resource_old Table newmodule VARCHAR 50 null
qtype_ddimageortext Table correctfeedbackformat TINYINT 3 0
search_index_requests Table indexpriority BIGINT 19 null

Priority value so that important requests can be dealt with first; higher numbers are processed first

portfolio_mahara_queue Table transferid BIGINT 19 null

fk to portfolio_tempdata.id

question_numerical_options Table question BIGINT 19 0
forum_discussions Table userid BIGINT 19 0
gradingform_guide_criteria Table descriptionmarkersformat TINYINT 3 null
analytics_train_samples Table analysableid BIGINT 19 null
wiki Table editend BIGINT 19 0

editend

wiki_locks Table id BIGINT 19 null
portfolio_instance_user Table userid BIGINT 19 null

fk to user table

course_format_options Table sectionid BIGINT 19 0

Null if this is a course option, otherwise id of the section this option is for

quiz_grades Table timemodified BIGINT 19 0

The last time this grade changed.

file_conversion Table statusmessage LONGTEXT 2147483647 null
grade_grades Table id BIGINT 19 null
license Table fullname LONGTEXT 2147483647 null
data_content Table content3 LONGTEXT 2147483647 null
competency Table descriptionformat SMALLINT 5 0

The format of the description field

qtype_match_options Table partiallycorrectfeedbackformat TINYINT 3 0
tool_dataprivacy_ctxlevel Table timemodified BIGINT 19 null
url Table name VARCHAR 255
grade_items_history Table idnumber VARCHAR 255 null

Arbitrary idnumber provided by the module responsible

search_index_requests Table id BIGINT 19 null
workshop_submissions Table id BIGINT 19 null
course_categories Table timemodified BIGINT 19 0
config_log Table id BIGINT 19 null
editor_atto_autosave Table pageinstance VARCHAR 64

The browser tab instance that last saved the draft text. This is to prevent multiple tabs from the same user saving different text alternately.

course Table id BIGINT 19 null
glossary_alias Table entryid BIGINT 19 0
workshop Table phaseswitchassessment TINYINT 3 0

Automatically switch to the assessment phase after the submissions deadline

message_read Table subject LONGTEXT 2147483647 null

The message subject

assignfeedback_editpdf_queue Table submissionid BIGINT 19 null
message_read Table contexturl LONGTEXT 2147483647 null

If this message is a notification of an event contexturl should contain a link to view this event. For example if its a notification of a forum post contexturl should contain a link to the forum post.

scorm Table forcenewattempt BIT 0 0
assignment Table var4 BIGINT 19 0
data Table name VARCHAR 255
user_info_field Table description LONGTEXT 2147483647 null

Description of field

external_tokens Table lastaccess BIGINT 19 null

last access timestamp

scorm Table sha1hash VARCHAR 40 null

package content or ext path hash

question_attempt_steps Table questionattemptid BIGINT 19 null

Foreign key, references question_attempt.id

enrol_lti_lti2_nonce Table value VARCHAR 64
profiling Table totalcputime BIGINT 19 null

time (in microseconds) spent by the CPU in this run

rating Table ratingarea VARCHAR 50
user Table email VARCHAR 100
question_attempt_steps Table userid BIGINT 19 null

The user whose action lead to this state being created.

enrol_flatfile Table userid BIGINT 19 null
grade_items Table gradepass DECIMAL 10 0.00000

What grade is needed to pass? grademin < gradepass <= grademax

course_published Table status BIT 0 0

is the publication published or not

grade_categories_history Table aggregatesubcats BIT 0 0

This setting was removed from grade_categories. It is kept here only to preserve history.

grade_grades Table itemid BIGINT 19 null

The item this grade belongs to

events_queue Table id BIGINT 19 null
mnet_host Table public_key LONGTEXT 2147483647 null
forum_discussion_subs Table discussion BIGINT 19 null
enrol Table expirythreshold BIGINT 19 0

Custom - when should be the participants notified

survey_answers Table userid BIGINT 19 0
editor_atto_autosave Table contextid BIGINT 19 null

The contextid that the form was loaded with.

quiz_sections Table firstslot BIGINT 19 null

Number of the first slot in the section. The section runs from here to the start of the next section, or the end of the quiz.

feedback_completed Table id BIGINT 19 null
course_modules Table completionview BIT 0 0

Controls whether a page view is part of the automatic completion requirements for this activity. 0 = view not required 1 = view required

mnet_log Table coursename VARCHAR 40
cache_filters Table version BIGINT 19 0
tool_monitor_rules Table descriptionformat BIT 0 null

Description format

events_queue_handlers Table handlerid BIGINT 19 null

foreign key id corresponding to the id of the event_handlers table

stats_weekly Table stat1 BIGINT 19 0

stat1. usually used for reads

grade_grades Table feedback LONGTEXT 2147483647 null

grading feedback

user Table lastname VARCHAR 100
task_adhoc Table component VARCHAR 255

The component that triggered this adhoc task.

forum_posts Table deleted BIT 0 0
upgrade_log Table backtrace LONGTEXT 2147483647 null
tool_dataprivacy_request Table requestedby BIGINT 19 0

The user ID of the one making the request

enrol_lti_tools Table lang VARCHAR 30 en
gradingform_rubric_levels Table criterionid BIGINT 19 null

The rubric criterion we are level of

course_request Table category BIGINT 19 0
enrol Table customint8 BIGINT 19 null

Custom - general int

quiz_statistics Table timemodified BIGINT 19 null
local_ld_lastactivity Table userid BIGINT 19 null

Foreign key to the user table

qtype_ddimageortext Table questionid BIGINT 19 0
scorm Table hidetoc BIT 0 0
events_handlers Table status BIGINT 19 0

number of failed attempts to process this handler

data Table timeviewfrom BIGINT 19 0
grade_items_history Table aggregationcoef DECIMAL 10 0.00000

Aggregation coefficient used for category weights or other aggregation types

url Table displayoptions LONGTEXT 2147483647 null
enrol Table customint7 BIGINT 19 null

Custom - general int

grade_categories_history Table aggregation BIGINT 19 0

A constant pointing to one of the predefined aggregation strategies (none, mean,median,sum, etc)

scale_history Table courseid BIGINT 19 0
oauth2_issuer Table loginparams LONGTEXT 2147483647 null

Additional parameters sent for a login attempt.

message_contacts Table contactid BIGINT 19 0
tool_dataprivacy_ctxinstance Table usermodified BIGINT 19 null
enrol_lti_lti2_consumer Table enabled BIT 0 null
question_statistics Table discriminativeefficiency DECIMAL 15 null
question_attempts Table variant BIGINT 19 1

The variant of the qusetion being used.

lock_db Table id BIGINT 19 null
enrol Table customtext1 LONGTEXT 2147483647 null

Custom - general text

survey_analysis Table survey BIGINT 19 0
events_handlers Table eventname VARCHAR 166

name of the event, e.g. 'grade_updated'

event_subscriptions Table id BIGINT 19 null
quiz_slots Table questioncategoryid BIGINT 19 null

The question category that the random question will be picked from. Will be null if and only if the question is not a random question.

scorm_seq_rolluprule Table minimumcount BIGINT 19 0
user_lastaccess Table userid BIGINT 19 0
oauth2_system_account Table refreshtoken LONGTEXT 2147483647 null

The refresh token used to request access tokens.

task_scheduled Table disabled BIT 0 0

1 means do not run from cron

enrol_paypal Table timeupdated BIGINT 19 0
grading_definitions Table timecopied BIGINT 19 0

The timestamp of when this form was most recently copied into another area

block_zoola_reports_schedule Table sendtouser BIT 0 null

Add related user's email to recipient list

assignsubmission_onlinetext Table id BIGINT 19 null
quiz_grades Table grade DECIMAL 10 0.00000

The overall grade from the quiz. Not affected by overrides in the gradebook.

competency_usercomp Table status TINYINT 3 0

Competency status.

competency_templatecomp Table timemodified BIGINT 19 null

The time this link was modified.

analytics_models_log Table score DECIMAL 10 0.00000
grade_import_values Table newgradeitem BIGINT 19 null

if set, points to the id of grade_import_newitem

question_numerical_units Table id BIGINT 19 null
files Table pathnamehash VARCHAR 40

complete file path sha1 hash - unique for each file

question Table createdby BIGINT 19 null

userid of person who created this question

analytics_indicator_calc Table endtime BIGINT 19 null
feedback Table site_after_submit VARCHAR 255
stats_daily Table stattype VARCHAR 20 activity

type of stat

cohort Table contextid BIGINT 19 null

Context is usually ignored in sync operations so that the cohorts may be moved freely around in the context tree without any side affects.

repository_instances Table typeid BIGINT 19 null
feedback_valuetmp Table id BIGINT 19 null
message_read Table useridfrom BIGINT 19 0
assignfeedback_editpdf_annot Table colour VARCHAR 10 black

Can be red, yellow, green, blue, white, black

enrol Table expirynotify BIT 0 0

Custom - notify users before expiration

oauth2_issuer Table alloweddomains LONGTEXT 2147483647 null

Allowed domains for this issuer.

mnet_session Table username VARCHAR 100

Unique username

quiz_reports Table capability VARCHAR 255 null

Capability required to see this report. May be blank which means use the default of mod/quiz:viewreport. This is used when deciding which tabs to render.

question_hints Table options VARCHAR 255 null

A space for any other question-type specific options.

lti_tool_proxies Table guid VARCHAR 255 null
enrol_flatfile Table id BIGINT 19 null
tag_area Table callback VARCHAR 100 null
repository Table visible BIT 0 1
assign Table id BIGINT 19 null
qtype_shortanswer_options Table usecase TINYINT 3 0

Whether answers are matched case-sensitively.

imscp Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

quiz_attempts Table attempt MEDIUMINT 7 0

Sequentially numbers this student's attempts at this quiz.

notifications Table timecreated BIGINT 19 null
event Table name LONGTEXT 2147483647 null
qtype_match_options Table id BIGINT 19 null
assignment_upgrade Table id BIGINT 19 null
resource Table display SMALLINT 5 0
event Table subscriptionid BIGINT 19 null

The event_subscription id this event is associated with.

tool_dataprivacy_contextlist Table component VARCHAR 255

Frankenstyle component name

chat_messages_current Table message LONGTEXT 2147483647 null
scorm_scoes_data Table name VARCHAR 255
mnet_host Table theme VARCHAR 100 null
user_enrolments Table timestart BIGINT 19 0
events_queue_handlers Table errormessage LONGTEXT 2147483647 null

if an error happened last time we tried to process this event, record it here.

local_ld_module_day Table ldmoduleid BIGINT 19 null

Foreign key to the local_ld_module table

lesson_answers Table jumpto BIGINT 19 0
role Table name VARCHAR 255

Empty names are automatically localised

lti_tool_proxies Table serviceoffered LONGTEXT 2147483647 null

List of services offered, one per line

question_answers Table feedbackformat TINYINT 3 0
competency_userevidence Table id BIGINT 19 null
question_attempts Table questionsummary LONGTEXT 2147483647 null

If this question uses randomisation, it should set this field to summarise what random version the student actually saw. This is a human-readable textual summary of the student's response which might, for example, be used in a report.

lesson_overrides Table maxattempts SMALLINT 5 null
grade_grades_history Table rawscaleid BIGINT 19 null

If this grade is based on a scale, which one was it?

user_devices Table timemodified BIGINT 19 null
scorm_seq_rolluprule Table conditioncombination VARCHAR 3 all
tool_monitor_history Table sid BIGINT 19 null

Subscription id

question_hints Table id BIGINT 19 null
block Table name VARCHAR 40
data Table timeavailableto BIGINT 19 0
question_usages Table preferredbehaviour VARCHAR 32

The archetypal behaviour that should be used for question attempts in this usage.

grade_items Table iteminstance BIGINT 19 null

id of the item module

backup_courses Table lastendtime BIGINT 19 0
workshopform_rubric_config Table workshopid BIGINT 19 null

The id of workshop this configuartion applies for

tag Table id BIGINT 19 null
ltiservice_gradebookservices Table id BIGINT 19 null
scorm_seq_rolluprule Table scoid BIGINT 19 0
enrol_paypal Table memo VARCHAR 255
course Table completionnotify BIT 0 0

Notify users when they complete this course

lesson Table mediaclose SMALLINT 5 0
analytics_predictions Table sampleid BIGINT 19 null
assignfeedback_comments Table id BIGINT 19 null
survey_answers Table time BIGINT 19 0
tool_monitor_rules Table plugin VARCHAR 254

Frankenstlye name of the plguin

competency_plan Table usermodified BIGINT 19 null
quiz_statistics Table allattemptscount BIGINT 19 null
course_modules Table module BIGINT 19 0
block_instances Table configdata LONGTEXT 2147483647 null

A serialized blob of configuration data for this block instance.

config_log Table timemodified BIGINT 19 null
message_providers Table name VARCHAR 100

The full name of the message provider in standard form

post Table created BIGINT 19 0
qtype_ddmarker_drags Table label LONGTEXT 2147483647 null

Alt text label for drag-able image.

workshop_submissions Table feedbackauthor LONGTEXT 2147483647 null

Teacher comment/feedback for the author of the submission, for example describing the reasons for the grade overriding

question_attempts Table questionid BIGINT 19 null

The id of the question being attempted. Foreign key references question.id.

enrol_lti_lti2_user_result Table resourcelinkid BIGINT 19 null
stats_user_monthly Table userid BIGINT 19 0
quiz_overrides Table id BIGINT 19 null
groups Table timemodified BIGINT 19 0
modules Table lastcron BIGINT 19 0
grade_categories Table hidden BIT 0 0
course_completion_aggr_methd Table value DECIMAL 10 null

NULL = all/any, 0..1 for method 'fraction', > 0 for method 'unit'

tool_usertours_steps Table title LONGTEXT 2147483647 null

Title of the step

tool_monitor_rules Table frequency SMALLINT 5 null

Frequency

gradingform_guide_criteria Table description LONGTEXT 2147483647 null

The criterion description for students

external_services Table restrictedusers BIT 0 null
analytics_used_files Table id BIGINT 19 null
glossary_entries Table concept VARCHAR 255
repository_instances Table username VARCHAR 255 null
lesson Table mediafile VARCHAR 255

Local file path or full external URL

files_reference Table repositoryid BIGINT 19 null
messageinbound_datakeys Table id BIGINT 19 null
grade_categories Table path VARCHAR 255 null

shows the path as /1/2/3 (like course_categories)

qtype_multichoice_options Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

user Table timecreated BIGINT 19 0
lti_tool_proxies Table toolproxy LONGTEXT 2147483647 null

JSON string representing tool proxy returned by tool provider

scorm Table reference VARCHAR 255
workshopform_comments Table id BIGINT 19 null
quiz Table showblocks SMALLINT 5 0

Whether blocks should be shown on the attempt.php and review.php pages.

competency_plancomp Table planid BIGINT 19 null
search_index_requests Table contextid BIGINT 19 null

Context ID that has been requested for reindexing.

question_dataset_items Table value VARCHAR 255
stats_monthly Table timeend BIGINT 19 0
competency_templatecomp Table sortorder BIGINT 19 null

Relative sort order

block_recent_activity Table id BIGINT 19 null
tool_customlang Table timemodified BIGINT 19 null

The timestamp of when the original or master was recently modified

tag Table isstandard BIT 0 0

Whether this tag is standard

files Table filepath VARCHAR 255

Optional - relative path to file from module content root, useful in Scorm and Resource mod - most of the mods do not need this

course Table summary LONGTEXT 2147483647 null
groupings Table descriptionformat TINYINT 3 0
qtype_ddimageortext Table id BIGINT 19 null
assign_plugin_config Table name VARCHAR 28
user_enrolments Table timeend BIGINT 19 2147483647
quiz_feedback Table feedbacktextformat TINYINT 3 0
forum_queue Table id BIGINT 19 null
lti_tool_proxies Table name VARCHAR 255 Tool Provider

Tool Provider name

rating Table scaleid BIGINT 19 null
mnet_remote_rpc Table xmlrpcpath VARCHAR 80
event_subscriptions Table courseid BIGINT 19 0
quiz_statistics Table cic DECIMAL 15 null
user Table password VARCHAR 255
event_subscriptions Table eventtype VARCHAR 20

The type of the event

quiz_slots Table maxmark DECIMAL 12 0.0000000

How many marks this question contributes to quiz.sumgrades.

assign_overrides Table userid BIGINT 19 null

Foreign key references user.id. Can be null if this is a per-group override.

mnet_application Table id BIGINT 19 null
messageinbound_datakeys Table handler BIGINT 19 null

The handler that this key belongs to.

mnetservice_enrol_enrolments Table enroltype VARCHAR 20

The name of the enrol plugin at the remote server that was used to enrol our student into their course

chat Table schedule SMALLINT 5 0
logstore_standard_log Table action VARCHAR 100
grade_categories Table aggregation BIGINT 19 0

A constant pointing to one of the predefined aggregation strategies (none, mean,median,sum, etc)

block_positions Table subpage VARCHAR 16

With contextid and pagetype, defines the page we are setting the position for.

course Table showreports SMALLINT 5 0
workshopform_accumulative Table workshopid BIGINT 19 null

Workshop ID

user_private_key Table id BIGINT 19 null
scorm_seq_objective Table minnormalizedmeasure FLOAT 11 0.0000
grade_import_newitem Table itemname VARCHAR 255

new grade item name

editor_atto_autosave Table drafttext LONGTEXT 2147483647 null

The draft text

lti_types Table coursevisible BIT 0 0
quiz_slot_tags Table tagname VARCHAR 255 null

The tag name is to be stored as well, so we won't lose data if the tag is removed from Moodle (A tag with the same name might be added in future).

tool_recyclebin_course Table module BIGINT 19 null
external_services_users Table id BIGINT 19 null
mnet_rpc Table profile LONGTEXT 2147483647 null

Method signature

quiz_attempts Table uniqueid BIGINT 19 0

Foreign key reference to the question_usage that holds the details of the the question_attempts that make up this quiz attempt.

enrol_flatfile Table courseid BIGINT 19 null
question_statistics Table positions LONGTEXT 2147483647 null

positions in which this item appears. Only used for random questions.

assign Table requireallteammemberssubmit TINYINT 3 0

If enabled, a submission will not be accepted until all team members have submitted it.

repository_instance_config Table instanceid BIGINT 19 null
role_allow_assign Table allowassign BIGINT 19 0
data_content Table fieldid BIGINT 19 0
url Table id BIGINT 19 null
stats_weekly Table stattype VARCHAR 20 activity

type of stat

competency_coursecomp Table competencyid BIGINT 19 null

The competency that is linked to this course.

assignment Table course BIGINT 19 0
analytics_train_samples Table sampleids LONGTEXT 2147483647 null
tool_recyclebin_category Table shortname VARCHAR 255
wiki_locks Table sectionname VARCHAR 255 null

locked page section

question_response_count Table id BIGINT 19 null
lesson_pages Table display SMALLINT 5 1
gradingform_rubric_criteria Table description LONGTEXT 2147483647 null

The criterion description

files Table timemodified BIGINT 19 null
registration_hubs Table token VARCHAR 255

the token to communicate with the hub by web service

resource_old Table intro LONGTEXT 2147483647 null
wiki_pages Table userid BIGINT 19 0

Edition author

external_services Table shortname VARCHAR 255 null

a unique shortname

external_functions Table capabilities VARCHAR 255 null

all capabilities that are required to be run by the function (separated by comma)

quiz_overrides Table timeopen BIGINT 19 null

Time at which students may start attempting this quiz. Can be null, in which case the quiz default is used.

competency Table scaleid BIGINT 19 null
block_instances Table pagetypepattern VARCHAR 64

The types of page this block appears on. Either an exact page type like mod-quiz-view, or a pattern like mod-quiz-* or course-view-*. Note that course-view-* will match course-view.

course_modules Table idnumber VARCHAR 100 null

customizable idnumber

grade_outcomes Table descriptionformat TINYINT 3 0
mnet_session Table id BIGINT 19 null

Required ID field

question_response_analysis Table response LONGTEXT 2147483647 null
workshopallocation_scheduled Table settings LONGTEXT 2147483647 null

The pre-defined settings for the underlying random allocation to run it with

wiki Table intro LONGTEXT 2147483647 null

General introduction of the wiki activity

groupings_groups Table id BIGINT 19 null
choice_options Table maxanswers BIGINT 19 0
grade_grades_history Table locktime BIGINT 19 0

automatic locking of final grade, 0 means none, date otherwise

workshop Table gradedecimals SMALLINT 5 0

Number of digits that should be shown after the decimal point when displaying grades

user_password_resets Table timererequested BIGINT 19 0

The time the user re-requested the password reset.

external_services Table component VARCHAR 100 null
glossary Table assessed BIGINT 19 0
user Table yahoo VARCHAR 50
feedback_valuetmp Table value LONGTEXT 2147483647 null
quiz_slots Table id BIGINT 19 null
assign_grades Table userid BIGINT 19 0
event Table modulename VARCHAR 20
course_completion_aggr_methd Table criteriatype BIGINT 19 null

The criteria type we are aggregating, or NULL if complete course aggregation

mnet_service Table description VARCHAR 40
competency_modulecomp Table usermodified BIGINT 19 null

The user who last modified this field.

scorm Table hidebrowse BIT 0 0
tool_monitor_rules Table timewindow MEDIUMINT 7 null

Time window in seconds

badge_manual_award Table id BIGINT 19 null
lesson Table dependency BIGINT 19 0
scorm Table completionscorerequired BIGINT 19 null
messageinbound_handlers Table enabled BIT 0 0

Whether this handler is currently enabled.

enrol Table sortorder BIGINT 19 0

order of enrol plugins in each course

enrol_lti_lti2_consumer Table consumerversion VARCHAR 255 null
analytics_models_log Table usermodified BIGINT 19 null
message_popup_notifications Table notificationid BIGINT 19 null
workshop Table submissionfiletypes VARCHAR 255 null

comma separated list of file extensions

workshopform_rubric Table descriptionformat SMALLINT 5 0

The format of the description field

competency_usercomp Table reviewerid BIGINT 19 null

User that reviewed the competency.

grading_definitions Table timemodified BIGINT 19 null

The time stamp of when the form definition was modified recently

gradingform_rubric_levels Table id BIGINT 19 null
course Table enablecompletion BIT 0 0

1 = allow use of 'completion' progress-tracking on this course. 0 = disable completion tracking on this course.

enrol_lti_lti2_share_key Table autoapprove BIT 0 null
analytics_models_log Table indicators LONGTEXT 2147483647 null
analytics_models Table enabled BIT 0 0
analytics_models Table indicators LONGTEXT 2147483647 null
oauth2_issuer Table enabled TINYINT 3 1
course_modules Table visibleoncoursepage BIT 0 1

If stealth visibility is allowed for the course, this controls whether activity is visible on course page

glossary_entries Table definition LONGTEXT 2147483647 null
message_airnotifier_devices Table userdeviceid BIGINT 19 null

The user device id in the user_devices table

quiz Table reviewgeneralfeedback MEDIUMINT 7 0

Whether users are allowed to review their quiz attempts at various times. A bit field, like reviewattempt.

qtype_randomsamatch_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

mnet_sso_access_control Table username VARCHAR 100

Username

assignment Table emailteachers TINYINT 3 0
lti_submission Table state TINYINT 3 null
course_modules Table completiongradeitemnumber BIGINT 19 null

Grade-item number used to track automatic completion, if applicable.

stats_user_daily Table stattype VARCHAR 30
enrol_paypal Table pending_reason VARCHAR 255
event Table instance BIGINT 19 0
block_zoola_reports Table label VARCHAR 255

Report label

question_multianswer Table id BIGINT 19 null
question_dataset_definitions Table options VARCHAR 255
scorm_seq_ruleconds Table scoid BIGINT 19 0
quiz_feedback Table id BIGINT 19 null
user_info_field Table defaultdataformat TINYINT 3 0
mnet_session Table useragent VARCHAR 40

SHA1 hash of User Agent

wiki Table defaultformat VARCHAR 20 creole

Wiki's default editor

quiz_overrides Table timelimit BIGINT 19 null

Time limit in seconds. Can be null, in which case the quiz default is used.

file_conversion Table targetformat VARCHAR 100
folder Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

qtype_multichoice_options Table partiallycorrectfeedbackformat TINYINT 3 0
messageinbound_handlers Table defaultexpiration BIGINT 19 86400

The default expiration period to use when creating a new key

data Table listtemplate LONGTEXT 2147483647 null
glossary_entries Table id BIGINT 19 null
log Table ip VARCHAR 45
wiki_versions Table timecreated BIGINT 19 0

Page edition timestamp

data_fields Table param7 LONGTEXT 2147483647 null
portfolio_tempdata Table queued BIT 0 0

Value 1 means the entry should be processed in cron.

gradingform_guide_fillings Table remark LONGTEXT 2147483647 null

Side note feedback regarding this particular criterion

qtype_randomsamatch_options Table shownumcorrect TINYINT 3 0

If true, then when the user gets the question partially correct, tell them how many choices they got correct alongside the feedback.

workshop_submissions Table gradeover DECIMAL 10 null

Grade for the submission manually overridden by a teacher. Grade is always from interval 0..100. If NULL then the grade is not overriden.

badge Table status BIT 0 0

Badge status: 0 = inactive, 1 = active, 2 = active+locked, 3 = inactive+locked, 4 = archived

modules Table visible BIT 0 1
message_read Table timeusertodeleted BIGINT 19 0
wiki_links Table frompageid BIGINT 19 0

Page id with a link

block_positions Table contextid BIGINT 19 null

With pagetype and subpage, defines the page we are setting the position for.

competency_usercompplan Table sortorder BIGINT 19 null

Relative sort order

filter_config Table name VARCHAR 255

The config variable name.

question_truefalse Table trueanswer BIGINT 19 0

Foreign key references question_answers.id. The 'True' choice.

grading_instances Table status BIGINT 19 0

The status of the assessment. By default the instance is under-assessment state

feedback_sitecourse_map Table courseid BIGINT 19 0
log Table course BIGINT 19 0
glossary Table assesstimestart BIGINT 19 0
lesson_timer Table id BIGINT 19 null
chat_messages_current Table id BIGINT 19 null
tool_policy_acceptances Table note LONGTEXT 2147483647 null

Plain text note describing how the actual consent has been obtained if the policy has been accepted on other user's behalf.

enrol_paypal Table business VARCHAR 255
repository_instance_config Table id BIGINT 19 null
lesson_grades Table lessonid BIGINT 19 0
data_fields Table required BIT 0 0

Required fields must have a value when inserted by a user

course Table cacherev BIGINT 19 0

Incrementing revision for validating the course content cache

enrol_lti_lti2_resource_link Table shareapproved BIT 0 null
tool_policy_versions Table policyid BIGINT 19 null

ID of the policy document we are version of.

forum Table completionposts INT 10 0

Nonzero if a certain number of posts or replies (total) are required to mark this forum complete for a user.

role_names Table roleid BIGINT 19 0
badge_issued Table userid BIGINT 19 0
lesson_overrides Table deadline BIGINT 19 null

Time by which students must have completed their attempt. Can be null, in which case the lesson default is used.

groups Table id BIGINT 19 null
workshop Table strategy VARCHAR 30

The type of the current grading strategy used in this workshop

question_response_count Table analysisid BIGINT 19 null
scorm_scoes_track Table userid BIGINT 19 0
message_popup Table messageid BIGINT 19 null
gradingform_guide_criteria Table descriptionmarkers LONGTEXT 2147483647 null

Description for Markers

assign Table completionsubmit TINYINT 3 0

If this field is set to 1, then the activity will be automatically marked as 'complete' once the user submits their assignment.

analytics_prediction_actions Table userid BIGINT 19 null
workshop_assessments Table gradinggradeoverby BIGINT 19 null

The id of the user who has overridden the grade for submission.

tool_dataprivacy_ctxlst_ctx Table status TINYINT 3 0

Approval status of the context item

enrol_lti_lti2_consumer Table consumername VARCHAR 255 null
feedback_item Table hasvalue BIT 0 0
mnet_session Table token VARCHAR 40

Unique SHA1 Token

tool_dataprivacy_ctxlst_ctx Table timemodified BIGINT 19 0
feedback_completed Table random_response BIGINT 19 0
data Table addtemplate LONGTEXT 2147483647 null
grade_items_history Table calculation LONGTEXT 2147483647 null

Formula describing how to derive this grade from other items, referring to them using giXXX where XXX is grade item id ... eg something like: =sin(square(#gi20#)) + #gi30#

assign Table alwaysshowdescription TINYINT 3 0

If false the assignment intro will only be displayed after the allowsubmissionsfrom date. If true it will always be displayed.

my_pages Table private BIT 0 1

Whether or not the page is private (dashboard) or public (profile)

grading_definitions Table usermodified BIGINT 19 null

The ID of the user who did the most recent modification

grade_categories_history Table parent BIGINT 19 null

Categories can be hierarchical

data_content Table content LONGTEXT 2147483647 null
assignfeedback_editpdf_quick Table rawtext LONGTEXT 2147483647 null
sessions Table lastip VARCHAR 45 null
lti_tool_settings Table settings LONGTEXT 2147483647 null

Setting values as JSON

assign_plugin_config Table plugin VARCHAR 28
assign Table requiresubmissionstatement TINYINT 3 0

Forces the student to accept a submission statement when submitting an assignment

tool_monitor_events Table contextinstanceid BIGINT 19 null

Context instance id

competency_framework Table scaleconfiguration LONGTEXT 2147483647 null

Scale information.

cache_flags Table value LONGTEXT 2147483647 null
groups Table enrolmentkey VARCHAR 50 null
glossary_formats Table popupformatname VARCHAR 50
stats_user_weekly Table timeend BIGINT 19 0
user_enrolments Table timecreated BIGINT 19 0
mnet_host Table portno MEDIUMINT 7 0
grade_items Table aggregationcoef2 DECIMAL 10 0.00000

Aggregation coefficient used for weights in aggregation types with both extra credit and weight

grade_grades_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

repository_instances Table contextid BIGINT 19 null
qtype_ddmarker_drops Table id BIGINT 19 null
badge_criteria_met Table issuedid BIGINT 19 null
user Table address VARCHAR 255
competency_templatecomp Table timecreated BIGINT 19 null

The time this link was created.

scorm_seq_rolluprulecond Table scoid BIGINT 19 0
user Table institution VARCHAR 255
glossary_categories Table glossaryid BIGINT 19 0
tool_usertours_tours Table configdata LONGTEXT 2147483647 null
question_calculated Table question BIGINT 19 0
lesson_branch Table flag SMALLINT 5 0
enrol_lti_tools Table rolelearner BIGINT 19 null
assign_grades Table timecreated BIGINT 19 0

The time the assignment submission was first modified by a grader.

grade_grades_history Table hidden BIGINT 19 0

show 0, hide 1 or hide until date

assign_user_flags Table allocatedmarker BIGINT 19 0

The allocated marker to this submission

assign Table gradingduedate BIGINT 19 0

The expected date for marking the submissions.

tag Table name VARCHAR 255
qtype_ddmarker_drags Table no BIGINT 19 0

drag no

user_devices Table uuid VARCHAR 255

The device vendor UUID

question_ddwtos Table questionid BIGINT 19 0
lti_tool_proxies Table capabilityoffered LONGTEXT 2147483647 null

List of capabilities offered, one per line

lesson_pages Table prevpageid BIGINT 19 0
grade_items_history Table itemmodule VARCHAR 30 null

'forum', 'quiz', 'csv', etc

question_categories Table id BIGINT 19 null
assignment_submissions Table data2 LONGTEXT 2147483647 null
post Table usermodified BIGINT 19 null
tool_dataprivacy_purpose Table name VARCHAR 100
grade_categories_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

tool_monitor_rules Table description LONGTEXT 2147483647 null

Description of the rule

message Table contexturlname LONGTEXT 2147483647 null

Display text for the contexturl

tag_instance Table timecreated BIGINT 19 0
course_completion_criteria Table timeend BIGINT 19 null

Timestamp of the date for course completion (if using date criteria type)

mnet_service Table apiversion VARCHAR 10
analytics_used_analysables Table modelid BIGINT 19 null
tool_monitor_rules Table timecreated BIGINT 19 null

Time stamp of when this rule was created

workshopform_numerrors_map Table workshopid BIGINT 19 null

The id of the workshop

scorm_seq_objective Table scoid BIGINT 19 0
question_categories Table contextid BIGINT 19 0

context that this category is shared in

grading_areas Table component VARCHAR 100

Frankenstyle name of the component holding this area

tool_policy Table sortorder MEDIUMINT 7 999

Defines the order in which policies should be presented to users

mnetservice_enrol_enrolments Table remotecourseid BIGINT 19 null

ID of the course at the remote server. Note that this may and may not be cached in our mnetservice_enrol_courses table, depends of whether the course is opened for remote enrolments or our student is the enrolled there via other plugin

quiz_attempts Table timecheckstate BIGINT 19 0

Next time quiz cron should check attempt for state changes. NULL means never check.

external_services_users Table externalserviceid BIGINT 19 null
grade_outcomes Table timemodified BIGINT 19 null

the time this outcome was last updated

assign_overrides Table id BIGINT 19 null
data Table scale BIGINT 19 0
tool_dataprivacy_request Table dpocomment LONGTEXT 2147483647 null

DPO's comments (e.g. reason for rejecting the request, etc.)

analytics_indicator_calc Table sampleorigin VARCHAR 255
competency_template Table shortname VARCHAR 100 null

Short name for the learning plan template.

forum_posts Table created BIGINT 19 0
competency_userevidencecomp Table userevidenceid BIGINT 19 null
grade_outcomes_courses Table id BIGINT 19 null
message Table timecreated BIGINT 19 0
question_statistics Table s BIGINT 19 0
assign_grades Table id BIGINT 19 null
qtype_essay_options Table filetypeslist LONGTEXT 2147483647 null

What attachment file type a student is allowed to include with their response. * or empty means unlimited.

repository_instances Table timecreated BIGINT 19 null
logstore_standard_log Table anonymous BIT 0 0

Was this event anonymous at the time of triggering?

workshop Table usepeerassessment TINYINT 3 0

optional feature: students perform peer assessment of others' work

enrol_lti_tools Table membersyncmode BIT 0 0
resource_old Table course BIGINT 19 0
enrol_paypal Table option_name1 VARCHAR 255
event Table categoryid BIGINT 19 0
grade_items_history Table source VARCHAR 255 null

What caused the modification? manual/module/import/...

course_completion_criteria Table moduleinstance BIGINT 19 null

Module instance id (if using module criteria type)

lesson Table id BIGINT 19 null
competency_evidence Table timemodified BIGINT 19 null
scorm_scoes Table scorm BIGINT 19 0
analytics_models Table timecreated BIGINT 19 null
registration_hubs Table id BIGINT 19 null
tool_dataprivacy_purpose Table lawfulbases LONGTEXT 2147483647 null

Comma-separated IDs matching records in tool_dataprivacy_lawfulbasis

glossary_entries Table definitionformat TINYINT 3 0
quiz_statistics Table lastattemptsavg DECIMAL 15 null
scorm Table course BIGINT 19 0
grade_categories Table keephigh BIGINT 19 0

Keep only the X highest items

forum_discussions Table pinned BIT 0 0
question_numerical_options Table unitpenalty DECIMAL 12 0.1000000

Penalty for getting the unit wrong, when they are being graded.

analytics_models Table trained BIT 0 0
events_handlers Table component VARCHAR 166

e.g. moodle, mod_forum, block_rss_client

message_conversation_members Table conversationid BIGINT 19 null
forum_track_prefs Table forumid BIGINT 19 0
qtype_multichoice_options Table single SMALLINT 5 0

If 0 it multiple response (checkboxes). Otherwise it is radio buttons.

enrol_lti_tools Table secret LONGTEXT 2147483647 null
analytics_train_samples Table timecreated BIGINT 19 0
grading_definitions Table descriptionformat TINYINT 3 null

Format of the description field

grade_categories Table depth BIGINT 19 0

How many parents does this category have?

block_rss_client Table url VARCHAR 255
qtype_match_options Table incorrectfeedbackformat TINYINT 3 0
backup_controllers Table type VARCHAR 10

Type of the backup (activity/section/course)

sessions Table id BIGINT 19 null
grade_grades_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

scorm_aicc_session Table scormstatus VARCHAR 255 null
role_allow_assign Table roleid BIGINT 19 0
local_ld_course_day Table id BIGINT 19 null
assign_user_flags Table assignment BIGINT 19 0

The assignment these flags apply to.

lesson_answers Table timecreated BIGINT 19 0
enrol_lti_lti2_consumer Table consumerkey256 VARCHAR 255
task_adhoc Table classname VARCHAR 255

The name of the class extending adhoc_task to run when this task is executed.

blog_external Table userid BIGINT 19 null
analytics_prediction_actions Table timecreated BIGINT 19 null
course_modules Table groupmode SMALLINT 5 0
workshop Table instructauthorsformat SMALLINT 5 0
workshop_submissions Table feedbackauthorformat SMALLINT 5 0
assignsubmission_onlinetext Table onlinetext LONGTEXT 2147483647 null

The text for this online text submission.

grade_items_history Table grademin DECIMAL 10 0.00000

What is the minimum allowable grade?

lesson Table timelimit BIGINT 19 0
qtype_ddmarker Table partiallycorrectfeedbackformat TINYINT 3 0
user_info_field Table categoryid BIGINT 19 0

id from category table

enrol_lti_tools Table contextid BIGINT 19 null
course_sections Table section BIGINT 19 0
enrol Table customdec2 DECIMAL 12 null

Custom - general decimal

enrol_lti_lti2_tool_proxy Table created BIGINT 19 null
qtype_multichoice_options Table incorrectfeedbackformat TINYINT 3 0
stats_daily Table stat2 BIGINT 19 0

stat2. usually used for writes.

glossary_formats Table showgroup TINYINT 3 1
chat_messages_current Table issystem BIT 0 0
mnet_remote_rpc Table id BIGINT 19 null
tag Table description LONGTEXT 2147483647 null
workshopform_numerrors Table workshopid BIGINT 19 null

Workshop ID

lesson Table retake SMALLINT 5 1
course_published Table hubcourseid BIGINT 19 null

the course id on the hub server

role_allow_view Table roleid BIGINT 19 null

The role the user has.

external_functions Table component VARCHAR 100
lesson Table usepassword SMALLINT 5 0
resource Table intro LONGTEXT 2147483647 null
lesson_attempts Table retry SMALLINT 5 0
workshop_submissions Table timegraded BIGINT 19 null

The timestamp when grade or gradeover was recently modified

question_statistics Table sd DECIMAL 15 null
message_airnotifier_devices Table enable BIT 0 1

The user can enable/disable his devices

choice_answers Table userid BIGINT 19 0
question_response_analysis Table timemodified BIGINT 19 null
scorm_scoes_data Table scoid BIGINT 19 0
mnet_remote_rpc Table functionname VARCHAR 40
scale Table description LONGTEXT 2147483647 null
log_queries Table sqlparams LONGTEXT 2147483647 null

query parameters

forum Table warnafter BIGINT 19 0
enrol_lti_lti2_user_result Table updated BIGINT 19 null
local_ld_lastactivity Table id BIGINT 19 null
competency Table description LONGTEXT 2147483647 null

Description of a single competency

assignfeedback_editpdf_annot Table path LONGTEXT 2147483647 null

SVG path describing the freehand line

user Table theme VARCHAR 50
task_adhoc Table nextruntime BIGINT 19 null
data Table rsstemplate LONGTEXT 2147483647 null
enrol_lti_lti2_nonce Table consumerid BIGINT 19 null
workshop Table gradinggrade DECIMAL 10 20.00000

The maximum grade for assessment

grading_definitions Table usercreated BIGINT 19 null

The ID of the user who created this definition and is considered as its owner for access control purposes

competency_userevidence Table userid BIGINT 19 null
grade_items_history Table grademax DECIMAL 10 100.00000

What is the maximum allowable grade?

quiz_grades Table userid BIGINT 19 0

Foreign key references user.id.

grading_instances Table id BIGINT 19 null
block_community Table coursename VARCHAR 255
external_services_users Table timecreated BIGINT 19 null

created timestamp

profiling Table id BIGINT 19 null
oauth2_system_account Table timemodified BIGINT 19 null

Time this record was modified.

lesson_timer Table completed BIT 0 0
lock_db Table resourcekey VARCHAR 255

String identifying the resource to be locked. Should use frankenstyle format.

repository_onedrive_access Table id BIGINT 19 null
wiki Table wikimode VARCHAR 20 collaborative

Wiki mode (individual, collaborative)

book Table numbering SMALLINT 5 0
question Table hidden BIT 0 0
data_content Table id BIGINT 19 null
tag_coll Table searchable TINYINT 3 1

Whether the tag collection is searchable

survey Table course BIGINT 19 0
user_password_history Table hash VARCHAR 255
analytics_used_analysables Table analysableid BIGINT 19 null
competency_usercompplan Table grade BIGINT 19 null

Grade assigned to the competency.

glossary Table introformat SMALLINT 5 0
chat_users Table version VARCHAR 16
data Table jstemplate LONGTEXT 2147483647 null
user Table emailstop BIT 0 0
oauth2_system_account Table issuerid BIGINT 19 null

The id of the oauth 2 identity issuer

external_functions Table methodname VARCHAR 100
grade_grades_history Table rawgrade DECIMAL 10 null

If the grade is a float value (or has been converted to one)

enrol Table customint6 BIGINT 19 null

Custom - general int

grade_categories_history Table path VARCHAR 255 null

shows the path as /1/2/3 (like course_categories)

enrol Table currency VARCHAR 3 null

Custom - cost currency

qtype_multichoice_options Table shuffleanswers SMALLINT 5 1

Whether the choices can be randomly shuffled.

tool_dataprivacy_request Table comments LONGTEXT 2147483647 null

More details about the request

assignfeedback_editpdf_quick Table colour VARCHAR 10 yellow
gradingform_rubric_criteria Table descriptionformat TINYINT 3 null

The format of the description field

gradingform_guide_criteria Table descriptionformat TINYINT 3 null

The format of the description field

enrol_paypal Table instanceid BIGINT 19 0
scorm_scoes Table launch LONGTEXT 2147483647 null
scorm_scoes Table sortorder BIGINT 19 0

order of scoes

tag Table flag SMALLINT 5 0

a tag can be 'flagged' as inappropriate

file_conversion Table status BIGINT 19 0
lti Table instructorchoiceallowsetting BIT 0 null

Allow a tool to store a setting

assignment Table id BIGINT 19 null
role Table shortname VARCHAR 100
question_statistics Table variant BIGINT 19 null
question_hints Table questionid BIGINT 19 null
mnet_remote_service2rpc Table serviceid BIGINT 19 0

Unique service ID

assign Table sendnotifications TINYINT 3 0

Allows the disabling of email notifications in the assign module.

lti_tool_proxies Table createdby BIGINT 19 null

ID of user which initiated the registration process

book Table timemodified BIGINT 19 0
chat_users Table ip VARCHAR 45
resource_old Table options VARCHAR 255
grade_settings Table name VARCHAR 255
badge Table id BIGINT 19 null
competency_evidence Table id BIGINT 19 null
grade_grades Table rawscaleid BIGINT 19 null

If this grade is based on a scale, which one was it?

grading_definitions Table copiedfromid BIGINT 19 null

The id of the original definition that this was initially copied from or null if it was from scratch

event Table userid BIGINT 19 0
course_completion_crit_compl Table userid BIGINT 19 0
messageinbound_handlers Table validateaddress BIT 0 1

Whether to validate the sender address against the user record.

question_statistics Table subquestions LONGTEXT 2147483647 null
user_info_data Table dataformat TINYINT 3 0
workshopform_comments Table description LONGTEXT 2147483647 null

The description of the dimension

grade_items_history Table gradetype SMALLINT 5 1

0 = none, 1 = value, 2 = scale, 3 = text

workshopform_accumulative Table weight MEDIUMINT 7 1

The weigh of the dimension

workshop Table submissionend BIGINT 19 0

0 = will be closed manually, greater than 0 the timestamp of the end of the submission phase

assign Table markingworkflow TINYINT 3 0

If enabled, marking workflow features will be used in this assignment.

competency_templatecohort Table id BIGINT 19 null
lock_db Table owner VARCHAR 36 null

uuid indicating the owner of the lock.

search_simpledb_index Table description2 LONGTEXT 2147483647 null
capabilities Table name VARCHAR 255
enrol_lti_lti2_tool_proxy Table toolproxykey VARCHAR 32
workshopform_accumulative Table description LONGTEXT 2147483647 null

The description of the dimension

comments Table itemid BIGINT 19 null
logstore_standard_log Table userid BIGINT 19 null
mnetservice_enrol_courses Table roleid BIGINT 19 null

The ID of the role at the remote server that our users will get when we enrol them there

my_pages Table sortorder MEDIUMINT 7 0

The order of the pages for a user

workshop Table useexamples TINYINT 3 0

optional feature: students practise evaluating on example submissions from teacher

lesson_pages Table timemodified BIGINT 19 0
choice Table completionsubmit BIT 0 0

If this field is set to 1, then the activity will be automatically marked as 'complete' once the user submits their choice.

qtype_match_subquestions Table questiontext LONGTEXT 2147483647 null
competency_usercompplan Table competencyid BIGINT 19 null

Competency associated to the user.

course_categories Table id BIGINT 19 null
events_queue_handlers Table id BIGINT 19 null
scorm Table displaycoursestructure BIT 0 0
analytics_models Table target VARCHAR 255
feedback_value Table course_id BIGINT 19 0
course_categories Table idnumber VARCHAR 100 null
feedback_template Table id BIGINT 19 null
stats_user_monthly Table courseid BIGINT 19 0
grade_grades_history Table source VARCHAR 255 null

What caused the modification? manual/module/import/...

lti_tool_proxies Table secret VARCHAR 255 null
assign_submission Table attemptnumber BIGINT 19 0

Used to track attempts for an assignment

course Table defaultgroupingid BIGINT 19 0

default grouping used in course modules, does not have key intentionally

tag_instance Table itemtype VARCHAR 100
external_services_functions Table id BIGINT 19 null
assign_user_flags Table id BIGINT 19 null
badge_criteria_param Table critid BIGINT 19 null
grade_items Table calculation LONGTEXT 2147483647 null

Formula describing how to derive this grade from other items, referring to them using giXXX where XXX is grade item id ... eg something like: =sin(square(#gi20#)) + #gi30#

external_functions Table id BIGINT 19 null
tool_cohortroles Table id BIGINT 19 null
filter_active Table id BIGINT 19 null
modules Table search VARCHAR 255
context Table contextlevel BIGINT 19 0
scale Table id BIGINT 19 null
external_services Table downloadfiles BIT 0 0

1 if the service allow people to download file from webservice/plugins.php - 0 if not

tool_dataprivacy_request Table timemodified BIGINT 19 0

The last time this data request was updated

scorm_aicc_session Table sessiontime VARCHAR 255 null
user Table policyagreed BIT 0 0
local_ld_course_day Table dedication BIGINT 19 0

Time spent on course within this day

user_password_resets Table userid BIGINT 19 null

id of the user account which requester claimed to be

quiz_slots Table questionid BIGINT 19 0

Foreign key references question.id.

lesson Table mediawidth BIGINT 19 650
oauth2_issuer Table basicauth TINYINT 3 0

Use HTTP Basic authentication scheme when sending client ID and password

workshop_submissions Table title VARCHAR 255

The submission title

scorm_scoes Table id BIGINT 19 null
sessions Table sid VARCHAR 128

Session id

feedback Table page_after_submitformat TINYINT 3 0
lesson_answers Table answerformat TINYINT 3 0
task_scheduled Table faildelay BIGINT 19 null
grade_items Table display BIGINT 19 0

Display as real grades, percentages (in reference to the minimum and maximum grades) or letters (A, B, C etc..), or course default (0)

question_calculated_options Table id BIGINT 19 null
course_completion_defaults Table course BIGINT 19 null
course_completions Table reaggregate BIGINT 19 0
enrol Table customtext3 LONGTEXT 2147483647 null

Custom - general text

user Table lastip VARCHAR 45
qtype_ddimageortext Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

stats_monthly Table stattype VARCHAR 20 activity

type of stat

tool_dataprivacy_purpose Table protected BIT 0 null
data_content Table content4 LONGTEXT 2147483647 null
quiz_statistics Table skewness DECIMAL 15 null
assignfeedback_editpdf_annot Table id BIGINT 19 null
block_zoola_reports_cohort Table id BIGINT 19 null
oauth2_issuer Table baseurl LONGTEXT 2147483647 null

The base url to the issuer

assign Table submissiondrafts TINYINT 3 0

If true, assignment submissions will be considered drafts until the student clicks on the submit assignmnet button.

external_tokens Table iprestriction VARCHAR 255 null

ip restriction

course_sections Table id BIGINT 19 null
user Table firstname VARCHAR 100
glossary_entries Table timemodified BIGINT 19 0
forum_posts Table totalscore SMALLINT 5 0
enrol Table enrolenddate BIGINT 19 0

Custom - end of enrolment

glossary_entries Table definitiontrust TINYINT 3 0
task_adhoc Table faildelay BIGINT 19 null
assign Table preventsubmissionnotingroup TINYINT 3 0

If enabled a user will be unable to make a submission unless they are a member of a group.

tag_instance Table tiuserid BIGINT 19 0
assignfeedback_editpdf_annot Table y BIGINT 19 0

y-position of the start of the annotation (in pixels - image resolution is set to 100 pixels per inch)

local_ld_module Table coursemoduleid BIGINT 19 null

Foreign key to the course_modules table

glossary_categories Table name VARCHAR 255
tool_monitor_subscriptions Table userid BIGINT 19 null

User id of the subscriber

qtype_ddmarker Table showmisplaced SMALLINT 5 0
question_hints Table hint LONGTEXT 2147483647 null

The text of the feedback to be given.

competency_framework Table timecreated BIGINT 19 null

The time this competency framework was created.

grade_grades_history Table feedbackformat BIGINT 19 0

format of feedback text

analytics_models_log Table modelid BIGINT 19 null
data_fields Table param5 LONGTEXT 2147483647 null
analytics_predict_samples Table timemodified BIGINT 19 0
badge_issued Table visible BIT 0 0
quiz_statistics Table firstattemptscount BIGINT 19 null
grade_outcomes Table description LONGTEXT 2147483647 null

outcome description

grade_grades Table exported BIGINT 19 0

date of last grade export, 0 if none

competency_userevidencecomp Table timemodified BIGINT 19 null
block_positions Table visible SMALLINT 5 null

Whether this block instance is visible on this page.

user Table department VARCHAR 255
files Table source LONGTEXT 2147483647 null

contains the reference if the file is imported from external sites

course Table theme VARCHAR 50
backup_controllers Table id BIGINT 19 null
question_answers Table feedback LONGTEXT 2147483647 null
analytics_models_log Table info LONGTEXT 2147483647 null
qtype_essay_options Table responsetemplate LONGTEXT 2147483647 null

The template to pre-populate student's response field during attempt.

workshop_assessments Table gradinggradeover DECIMAL 10 null

Grade for the assessment manually overridden by a teacher. Grade is always from interval 0..100. If NULL then the grade is not overriden.

competency Table sortorder BIGINT 19 null

Relative sort order within the branch

badge Table nextcron BIGINT 19 null
external_services_users Table iprestriction VARCHAR 255 null

ip restriction

stats_weekly Table stat2 BIGINT 19 0

stat2. usually used for writes.

grade_outcomes_history Table scaleid BIGINT 19 null

The recommended scale for this outcome.

license Table enabled BIT 0 1
message_contacts Table id BIGINT 19 null
glossary Table intro LONGTEXT 2147483647 null
grade_items Table gradetype SMALLINT 5 1

0 = none, 1 = value, 2 = scale, 3 = text

folder Table intro LONGTEXT 2147483647 null
grade_items Table scaleid BIGINT 19 null

If this grade is based on a scale, which one is it?

forum_discussions Table timeend BIGINT 19 0
qtype_match_options Table shuffleanswers SMALLINT 5 1
grade_categories_history Table courseid BIGINT 19 null

The course this grade category is part of

event Table description LONGTEXT 2147483647 null
stats_daily Table courseid BIGINT 19 0
assign_submission Table groupid BIGINT 19 0

The group id for team submissions

assignsubmission_file Table id BIGINT 19 null
message_user_actions Table userid BIGINT 19 null
grade_grades_history Table feedback LONGTEXT 2147483647 null

grading feedback

message_read Table fullmessage LONGTEXT 2147483647 null
tag_coll Table isdefault TINYINT 3 0
course_format_options Table format VARCHAR 21

Format this option is for

tool_customlang Table stringid VARCHAR 255

The identifier of the string

lesson_overrides Table lessonid BIGINT 19 0

Foreign key references lesson.id

question_dataset_items Table definition BIGINT 19 0
role_capabilities Table permission BIGINT 19 0
competency_template Table usermodified BIGINT 19 null

The user who last modified this learning plan template

scale_history Table id BIGINT 19 null
oauth2_system_account Table email LONGTEXT 2147483647 null

The email that was connected to this issuer.

gradingform_guide_fillings Table score DECIMAL 10 null

The score assigned

competency_plan Table reviewerid BIGINT 19 null
lti Table grade BIGINT 19 100

Grade scale

grade_import_values Table finalgrade DECIMAL 10 null

raw grade value

notifications Table component VARCHAR 100 null
user_devices Table pushid VARCHAR 255

the device PUSH token/key/identifier/registration id

assignfeedback_editpdf_cmnt Table pageno BIGINT 19 0

The page in the PDF that this comment appears on

question Table generalfeedback LONGTEXT 2147483647 null

to store the question feedback

choice_answers Table id BIGINT 19 null
scorm Table skipview BIT 0 1
competency_templatecomp Table usermodified BIGINT 19 null

The user who modified this link.

portfolio_instance_config Table id BIGINT 19 null
log_queries Table error MEDIUMINT 7 0

is error

wiki_links Table subwikiid BIGINT 19 0

Subwiki instance

lesson Table feedback SMALLINT 5 1
chat_messages_current Table chatid BIGINT 19 0
quiz_feedback Table quizid BIGINT 19 0

Foreign key references quiz.id.

grade_outcomes Table scaleid BIGINT 19 null

The recommended scale for this outcome.

feedback Table timemodified BIGINT 19 0
assignment Table intro LONGTEXT 2147483647 null
stats_weekly Table timeend BIGINT 19 0
question_gapselect Table questionid BIGINT 19 0
enrol_lti_lti2_share_key Table id BIGINT 19 null
glossary Table globalglossary TINYINT 3 0
log Table cmid BIGINT 19 0
config_log Table userid BIGINT 19 null
sessions Table timecreated BIGINT 19 null
course_modules Table added BIGINT 19 0
role_assignments Table roleid BIGINT 19 0
glossary_entries Table attachment VARCHAR 100
choice Table name VARCHAR 255
assignment Table var2 BIGINT 19 0