Columns

Columns

<
Table Type Column Type Size Nulls Auto Default Comments
task_scheduled Table lastruntime BIGINT 19 null
file_conversion Table converter VARCHAR 255 null
backup_courses Table laststarttime BIGINT 19 0
totara_userdata_export Table exporttypeid BIGINT 19 null
course_request Table reason LONGTEXT 2147483647 null
comp_template Table usermodified BIGINT 19 null
facetoface Table reservecanceldays INT 10 1

Number days before the session when all unconfirmed reservations are deleted

mnet_log Table action VARCHAR 40
filter_active Table filter VARCHAR 32

The filter internal name, like 'tex'.

chat_messages_current Table message LONGTEXT 2147483647 null
workshopallocation_scheduled Table settings LONGTEXT 2147483647 null

The pre-defined settings for the underlying random allocation to run it with

context_map Table parentid BIGINT 19 null

ID of parent context

totara_compl_import_cert Table customfields LONGTEXT 2147483647 null

Any custom field data

qtype_essay_options Table attachmentsrequired SMALLINT 5 0

The number of attachments that should be required

groupings_groups Table id BIGINT 19 null
question_answers Table feedback LONGTEXT 2147483647 null
course_completion_criteria Table courseinstance BIGINT 19 null

Course instance id (if using course criteria type)

pos_type_info_data_param Table id BIGINT 19 null
gradingform_rubric_fillings Table remark LONGTEXT 2147483647 null

Side note feedback regarding this particular criterion

goal_framework Table visible TINYINT 3 null
block_positions Table weight BIGINT 19 null

Used to order the blocks within a block region.

message_read Table id BIGINT 19 null
certificate Table printseal VARCHAR 255 0
totara_connect_sso_sessions Table sid VARCHAR 128

Session id of the user session on the TC server

events_queue_handlers Table handlerid BIGINT 19 null

foreign key id corresponding to the id of the event_handlers table

question_numerical_units Table unit VARCHAR 50

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

user Table timemodified BIGINT 19 0
profiling Table totalmemory BIGINT 19 null

Total memory used byt the run

rating Table userid BIGINT 19 null
facetoface_session_info_field Table hidden TINYINT 3 null
event Table modulename VARCHAR 20
data Table rssarticles SMALLINT 5 0
event_subscriptions Table pollinterval BIGINT 19 0

Frequency of checks for new/changed events

scorm Table id BIGINT 19 null
scorm_scoes Table parent VARCHAR 255
dp_plan_evidence_info_field Table defaultdata LONGTEXT 2147483647 null
quiz_statistics Table firstattemptsavg DECIMAL 15 null
feedback_completed_history Table anonymous_response BIT 1 0
grade_grades Table finalgrade DECIMAL 10 null

The final grade (cached) after all calculations are made

repository_opensesame_bps Table packageid BIGINT 19 null
repository_opensesame_pkgs Table visible BIT 1 1

Is this course package visible?

block_totara_featured_links_tiles Table parentid BIGINT 19 0

The tile that is the parent of this tile

block_totara_featured_links_tiles Table timecreated BIGINT 19 0

The tile that the tile was created

prog Table visible BIT 1 1
competency_coursecomp Table competencyid BIGINT 19 null

The competency that is linked to this course.

quiz Table timelimit BIGINT 19 0

The time limit for quiz attempts, in seconds.

facetoface_asset_info_field Table hidden TINYINT 3 null
dp_plan_course_assign Table completionstatus BIGINT 19 null

Stores the course completion status at the moment the plan is marked as complete. Set to null before the plan is complete.

course_modules Table course BIGINT 19 0
tool_monitor_events Table courseid BIGINT 19 null

course id

grade_outcomes_history Table descriptionformat TINYINT 3 0
block_zoola_reports Table type VARCHAR 20

Resource type: reportUnit or reportOptions

oauth2_system_account Table id BIGINT 19 null
mnet_host Table transport TINYINT 3 0
lesson_grades Table grade DOUBLE 22 0
comp_type_info_data Table id BIGINT 19 null
pos_competencies Table timecreated BIGINT 19 null
assignfeedback_editpdf_queue Table submissionid BIGINT 19 null
user Table msn VARCHAR 50
enrol_lti_users Table timecreated BIGINT 19 null

The time the user was created

lti_submission_history Table userid BIGINT 19 null
glossary_categories Table name VARCHAR 255
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

goal_grp_org Table goalid BIGINT 19 null
grade_grades_history Table itemid BIGINT 19 null

The item this grade belongs to

qtype_match_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

appraisal_user_assignment Table appraisalid BIGINT 19 null
scorm_seq_objective Table id BIGINT 19 null
auth_connect_ids Table timecreated BIGINT 19 null
tool_monitor_rules Table frequency SMALLINT 5 null

Frequency

course_categories Table path VARCHAR 255
user Table policyagreed BIT 1 0
dp_priority_scale_value Table sortorder BIGINT 19 null

Identifies the order scale values appear in

label Table introformat SMALLINT 5 0
mnet_session Table token VARCHAR 40

Unique SHA1 Token

reportbuilder_grp_org_user Table id BIGINT 19 null
qtype_ddimageortext Table questionid BIGINT 19 0
questionnaire_survey Table info LONGTEXT 2147483647 null
scorm Table scormtype VARCHAR 50 local

local, external or repository

dp_priority_scale_value Table timemodified BIGINT 19 null

Identifies the last time a scale value was modified

facetoface_notification Table scheduleamount BIT 1 null
pos Table shortname VARCHAR 100 null
competency Table timemodified BIGINT 19 null

The time this competency was last modified.

org_framework Table timemodified BIGINT 19 null
errorlog Table hash VARCHAR 32 null
local_ld_lastactivity Table id BIGINT 19 null
feedback360_scale_data Table feedback360questfieldid BIGINT 19 null
forum_read Table lastread BIGINT 19 0
gradingform_guide_criteria Table description LONGTEXT 2147483647 null

The criterion description for students

mnet_remote_rpc Table pluginname VARCHAR 20
qtype_essay_options Table responsetemplate LONGTEXT 2147483647 null

The template to pre-populate student's response field during attempt.

goal_scale Table usermodified BIGINT 19 null
event_subscriptions Table groupid BIGINT 19 0
cohort Table draftcollectionid BIGINT 19 null

Totara draft collection id from totara_cohort

goal_type_info_data Table data LONGTEXT 2147483647 null
auth_approved_request Table extradata LONGTEXT 2147483647 null
lesson_pages Table layout SMALLINT 5 1
course_info_data_param Table value VARCHAR 32
filter_config Table filter VARCHAR 32

The filter internal name, like 'tex'.

cohort Table calculationstatus TINYINT 3 1

Totara calculatio nstatus flag from totara_cohort

dp_plan_evidence_relation Table itemid BIGINT 19 null

Component ID

chat Table course BIGINT 19 0
competency_templatecohort Table usermodified BIGINT 19 null
block_community Table imageurl VARCHAR 255
feedback360_resp_assignment Table id BIGINT 19 null
post Table summary LONGTEXT 2147483647 null
appraisal_stage_role_setting Table locked BIT 1 0
grade_categories_history Table source VARCHAR 255 null

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

post Table attachment VARCHAR 100 null

attachment

report_builder Table embedded SMALLINT 5 0

Indicates whether the report is an embedded report. Set to 1 for embedded, 0 otherwise.

enrol Table customchar1 VARCHAR 255 null

Custom - general short name

totara_connect_clients Table clientcomment LONGTEXT 2147483647 null

Comment related to this client system

assignment_upgrade Table newcmid BIGINT 19 0
feedback360_grp_org Table feedback360id BIGINT 19 null
facetoface_signup_info_field Table datatype VARCHAR 255 null
facetoface_asset_info_data_param Table dataid BIGINT 19 null
lesson_pages Table qtype SMALLINT 5 0
totara_userdata_purge Table usercontextid BIGINT 19 null

User context id, we need the value here because user deletion removes user context record

wiki Table editbegin BIGINT 19 0

editbegin

grade_grades Table timecreated BIGINT 19 null

the time this grade was first created

page Table intro LONGTEXT 2147483647 null
course_completion_crit_compl Table id BIGINT 19 null
enrol_lti_users Table consumersecret LONGTEXT 2147483647 null
workshopform_numerrors Table descriptionformat SMALLINT 5 0

The format of the description field

course_modules Table indent MEDIUMINT 7 0
badge_backpack Table password VARCHAR 50 null
survey_answers Table question BIGINT 19 0
workshop Table maxbytes BIGINT 19 100000

Maximum size of the one attached file

dp_plan_evidence Table name VARCHAR 255

Name for this item of evidence

files Table license VARCHAR 255 null

license of the file to guide reuse

grade_grades_history Table rawscaleid BIGINT 19 null

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

scorm Table md5hash VARCHAR 32

MD5 Hash of package file

prog_info_data Table data LONGTEXT 2147483647 null
workshopform_numerrors_map Table nonegative BIGINT 19 null

Number of negative responses given by the reviewer

facetoface_cancellation_info_field Table hidden TINYINT 3 null
glossary_formats Table showtabs VARCHAR 100 null
user Table calendartype VARCHAR 30 gregorian
reminder_sent Table timesent BIGINT 19 null
assign Table duedate BIGINT 19 0

The due date for the assignment. Displayed to students.

grade_items_history Table outcomeid BIGINT 19 null

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

competency_usercompplan Table proficiency TINYINT 3 null

Indicate if the competency is proficient not.

auth_approved_request Table firstnamephonetic VARCHAR 255 null

First name phonetic

portfolio_log Table returnurl VARCHAR 255

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

role_capabilities Table capability VARCHAR 255
lti_submission Table state TINYINT 3 null
questionnaire_quest_choice Table content LONGTEXT 2147483647 null
mnet_service2rpc Table id BIGINT 19 null

Required ID field

block_quicklinks Table displaypos SMALLINT 5 0
tool_recyclebin_course Table timecreated BIGINT 19 0
grade_items Table plusfactor DECIMAL 10 0.00000

Add this to all grades

lti Table servicesalt VARCHAR 40 null
tool_sitepolicy_consent_options Table id BIGINT 19 null
qtype_randomsamatch_options Table correctfeedbackformat TINYINT 3 0
qtype_shortanswer_options Table id BIGINT 19 null
badge Table issuercontact VARCHAR 255 null
log Table id BIGINT 19 null
forum_discussions Table timeend BIGINT 19 0
grade_items_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

lesson_attempts Table correct BIGINT 19 0
glossary_entries Table definition LONGTEXT 2147483647 null
facetoface_signup_info_field Table id BIGINT 19 null
page Table displayoptions LONGTEXT 2147483647 null
wiki_versions Table timecreated BIGINT 19 0

Page edition timestamp

assignfeedback_editpdf_queue Table submissionattempt BIGINT 19 null
tool_monitor_subscriptions Table id BIGINT 19 null
block_totara_featured_links_tiles Table visibility SMALLINT 5 0

What the base visibility option is

org_type_info_field Table param5 LONGTEXT 2147483647 null
workshopallocation_scheduled Table timeallocated BIGINT 19 null

When was the last scheduled allocation executed

grade_grades Table timemodified BIGINT 19 null

the time this grade was last modified

scorm_seq_mapinfo Table writenormalizedmeasure BIT 1 0
comp Table usermodified BIGINT 19 null
oauth2_issuer Table basicauth TINYINT 3 0

Use HTTP Basic authentication scheme when sending client ID and password

appraisal_scale_data Table appraisalroleassignmentid BIGINT 19 null
lesson_overrides Table lessonid BIGINT 19 0

Foreign key references lesson.id

question_ddwtos Table partiallycorrectfeedbackformat TINYINT 3 0
messageinbound_handlers Table validateaddress BIT 1 1

Whether to validate the sender address against the user record.

course Table coursetype SMALLINT 5 0

Totara course type from totara_core

question_calculated Table correctanswerformat BIGINT 19 2
competency_coursecompsetting Table timemodified BIGINT 19 null

The time this setting was last modified.

appraisal_event Table triggered BIT 1 0
glossary Table allowcomments TINYINT 3 0
wiki_versions Table version MEDIUMINT 7 0

Wiki page version

dp_plan_program_assign Table id BIGINT 19 null
competency_modulecomp Table sortorder BIGINT 19 null

The field used to naturally sort this link.

grade_items_history Table multfactor DECIMAL 10 1.00000

Multiply all grades by this

choice Table showunanswered TINYINT 3 0
org Table shortname VARCHAR 100 null
facetoface_sessioncancel_info_field Table locked TINYINT 3 null
mnet_session Table session_id VARCHAR 40

The PHP Session ID

workshopform_numerrors Table sort BIGINT 19 0

Defines the dimension order within the assessment form

totara_userdata_purge_type Table description LONGTEXT 2147483647 null

HTML text with description of purging type

goal_item_history Table timemodified BIGINT 19 null
tool_monitor_events Table id BIGINT 19 null
feedback_completedtmp Table userid BIGINT 19 0
lti Table intro LONGTEXT 2147483647 null

General introduction of the basiclti activity

my_pages Table sortorder MEDIUMINT 7 0

The order of the pages for a user

feedback360_quest_field Table defaultdata LONGTEXT 2147483647 null
event Table subscriptionid BIGINT 19 null

The event_subscription id this event is associated with.

lti_tool_settings Table timemodified BIGINT 19 null

Date/time at which the record was last modified

question_calculated_options Table question BIGINT 19 0
scorm_seq_rulecond Table ruleconditionsid BIGINT 19 0
competency_userevidencecomp Table competencyid BIGINT 19 null
questionnaire_question_type Table response_table VARCHAR 32 null
wiki_versions Table userid BIGINT 19 0

Edition autor

comp_scale_values Table sortorder BIGINT 19 null
totara_userdata_purge_type_item Table purgedata BIT 1 null

0 means item skipped during purging, 1 means data to be purged

competency_usercomp Table competencyid BIGINT 19 null

Competency associated to the user.

course_categories Table theme VARCHAR 50 null

Theme for the category

course_info_field Table hidden BIT 1 null
report_builder_graph Table timemodified BIGINT 19 0

udpated when graph changes

totara_compl_import_cert Table importerrormsg LONGTEXT 2147483647 null

Any error messages for this record

prog_exception Table programid BIGINT 19 0
enrol_lti_lti2_share_key Table autoapprove BIT 1 null
badge_criteria Table id BIGINT 19 null
assignfeedback_editpdf_annot Table type VARCHAR 10 line

line, oval, rect, etc.

comp_criteria Table competencyid BIGINT 19 null
lti_tool_proxies Table serviceoffered LONGTEXT 2147483647 null

List of services offered, one per line

workshop Table overallfeedbackmaxbytes BIGINT 19 100000

Maximum size of one file attached to the overall feedback.

files Table filesize BIGINT 19 null
block_zoola_reports_schedule Table id BIGINT 19 null
enrol_lti_lti2_consumer Table protected BIT 1 null
question_attempts Table timemodified BIGINT 19 null

The time this record was last changed.

events_handlers Table status BIGINT 19 0

number of failed attempts to process this handler

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 id BIGINT 19 null
lti_tool_proxies Table id BIGINT 19 null
repository Table visible BIT 1 1
prog_courseset Table nextsetoperator SMALLINT 5 0
mnet_host2service Table serviceid BIGINT 19 0
facetoface_notification_tpl Table id BIGINT 19 null
cache_filters Table filter VARCHAR 32
grade_categories Table aggregation BIGINT 19 0

A constant pointing to one of the predefined aggregation strategies (none, mean,median,sum, etc)

dp_plan_history Table timemodified BIGINT 19 null

Modification time

quiz_statistics Table standarddeviation DECIMAL 15 null
questionnaire_survey Table courseid BIGINT 19 null
wiki Table forceformat BIT 1 1

Forces the default editor

dp_objective_scale_value Table sortorder BIGINT 19 null

Defines the order of the priority scale values

dp_plan Table id BIGINT 19 null
repository_opensesame_pkgs Table id BIGINT 19 null
course_categories Table programcount BIGINT 19 0

Totara program count from totara_program

certificate_issues_history Table timecreated BIGINT 19 0
facetoface_signups Table notificationtype BIGINT 19 null
report_builder_global_restriction Table timemodified BIGINT 19 null
cache_flags Table flagtype VARCHAR 255
dp_competency_settings Table autoassignpos SMALLINT 5 0
workshop Table nattachments SMALLINT 5 0

Number of required submission attachments

report_builder_filters Table advanced SMALLINT 5 0

If none zero then the filter is an advanced option

course_sections Table summaryformat TINYINT 3 0
choice Table allowupdate TINYINT 3 0
questionnaire_question Table length BIGINT 19 0
totara_userdata_user Table timesuspended BIGINT 19 null

Best guess when user was actually deleted

local_activityvisibility_que Table id BIGINT 19 null
totara_connect_client_pos_frameworks Table timecreated BIGINT 19 null
badge_backpack Table userid BIGINT 19 0
events_queue_handlers Table id BIGINT 19 null
enrol_lti_lti2_resource_link Table updated BIGINT 19 null
certificate Table gradefmt BIGINT 19 0
goal_record Table userid BIGINT 19 null
logstore_standard_log Table objectid BIGINT 19 null
course_request Table fullname VARCHAR 1333
questionnaire_fb_sections Table scorecalculation LONGTEXT 2147483647 null
workshop_submissions Table content LONGTEXT 2147483647 null

Submission text

facetoface_room_info_data_param Table id BIGINT 19 null
quiz_slots Table maxmark DECIMAL 12 0.0000000

How many marks this question contributes to quiz.sumgrades.

org Table usermodified BIGINT 19 null
competency_userevidencecomp Table timecreated BIGINT 19 null
modules Table id BIGINT 19 null
questionnaire_response_other Table response LONGTEXT 2147483647 null
feedback Table page_after_submitformat TINYINT 3 0
cohort_plan_history Table auto BIT 1 0
data Table notification BIGINT 19 0

Notify people when things change

dp_objective_settings Table priorityscale BIGINT 19 null
tool_monitor_subscriptions Table ruleid BIGINT 19 null

Rule id

capabilities Table captype VARCHAR 50
tool_sitepolicy_policy_version Table publisherid BIGINT 19 null

Who published the policy

course_completion_criteria Table criteriatype BIGINT 19 0

Type of criteria

dp_plan_objective Table timemodified BIGINT 19 null
mnet_remote_rpc Table id BIGINT 19 null
report_builder_cache Table frequency BIGINT 19 null
portfolio_instance_config Table id BIGINT 19 null
user_info_field Table param4 LONGTEXT 2147483647 null

General parameter field

facetoface_interest Table userid BIGINT 19 0
goal_grp_org Table id BIGINT 19 null
appraisal_stage Table timedue BIGINT 19 null
dp_plan_course_assign Table courseid BIGINT 19 null

Identifies the course being assigned

block_community Table coursename VARCHAR 255
forum Table rssarticles TINYINT 3 0
grading_instances Table feedbackformat TINYINT 3 null

The format of the feedback field

wiki_pages Table timecreated BIGINT 19 0

Wiki page creation timestamp

grade_categories Table hidden BIT 1 0
course_completions Table timestarted BIGINT 19 0
forum Table assessed BIGINT 19 0
tool_customlang Table lang VARCHAR 20

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

dp_plan_course_assign Table manual BIT 1 0

Was this assignment made manually

scorm_scoes Table organization VARCHAR 255
wiki_subwikis Table userid BIGINT 19 0

Owner of that subwiki

block_instances Table id BIGINT 19 null
wiki_locks Table userid BIGINT 19 0

Locking user

gap_aspirational Table timecreated BIGINT 19 null
grade_grades_history Table usermodified BIGINT 19 null

the userid of the person who last modified this grade

enrol_lti_lti2_tool_proxy Table toolproxy LONGTEXT 2147483647 null
task_scheduled Table hour VARCHAR 25
goal_type Table shortname VARCHAR 100 null
goal_scale Table defaultid BIGINT 19 null
org_type_info_data Table organisationid BIGINT 19 null
prog_message Table id BIGINT 19 null
workshop_assessments Table feedbackreviewerformat SMALLINT 5 0
grade_items_history Table iteminstance BIGINT 19 null

id of the item module

user_devices Table pushid VARCHAR 255

the device PUSH token/key/identifier/registration id

message_metadata Table onreject LONGTEXT 2147483647 null

serialised action on message rejection

course Table fullname VARCHAR 1333
questionnaire_question Table precise BIGINT 19 0
workshopeval_best_settings Table workshopid BIGINT 19 null
question Table length BIGINT 19 1
report_builder_global_restriction Table active BIT 1 0
questionnaire_response_date Table response LONGTEXT 2147483647 null
competency Table shortname VARCHAR 100 null

Shortname of a competency

grade_grades_history Table userid BIGINT 19 null

The user who this grade is for

grade_grades_history Table feedbackformat BIGINT 19 0

format of feedback text

report_builder_settings Table reportid BIGINT 19 null

ID of the report the setting belongs to

facetoface_session_info_data_param Table dataid BIGINT 19 null
course_modules_completion Table userid BIGINT 19 null

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

assignment Table name VARCHAR 255
report_builder_settings Table name VARCHAR 100

Name of the setting

user_info_field Table param5 LONGTEXT 2147483647 null

General parameter field

question Table version VARCHAR 255
comp_record Table proficiency BIGINT 19 null
reportbuilder_grp_user_user Table userid BIGINT 19 null
sessions Table userid BIGINT 19 null
logstore_standard_log Table timecreated BIGINT 19 null
qtype_ddimageortext_drops Table label LONGTEXT 2147483647 null

Alt label for drop box

org_framework Table idnumber VARCHAR 100 null
tool_monitor_subscriptions Table lastnotificationsent BIGINT 19 0

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

reportbuilder_grp_org_user Table orgid BIGINT 19 null
org Table sortthread VARCHAR 255 null
enrol_lti_lti2_consumer Table enabled BIT 1 null
enrol Table customchar2 VARCHAR 255 null

Custom - general short name

external_tokens Table timecreated BIGINT 19 null

created timestamp

badge_issued Table userid BIGINT 19 0
course Table category BIGINT 19 0
goal_grp_pos Table posid BIGINT 19 null
local_ld_module_day Table dedication BIGINT 19 0

Time spent on module within this day

totara_compl_import_cert Table completiondate VARCHAR 10 null

completiondate

assign Table name VARCHAR 255

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

external_tokens Table userid BIGINT 19 null

owner of the token

book Table timemodified BIGINT 19 0
certificate Table course BIGINT 19 0
role_allow_assign Table allowassign BIGINT 19 0
report_builder_schedule Table schedule BIGINT 19 null
workshop Table overallfeedbackfiletypes VARCHAR 255 null

comma separated liat of file extensions

tag_instance Table tagid BIGINT 19 null
competency_coursecomp Table timemodified BIGINT 19 null

The time this link was modified.

auth_oauth2_linked_login Table timecreated BIGINT 19 null
lesson_pages Table nextpageid BIGINT 19 0
facetoface_sessions Table allowcancellations BIT 1 1
choice_options Table id BIGINT 19 null
message_popup Table id BIGINT 19 null
lti Table timecreated BIGINT 19 0
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.

goal_grp_pos Table goalid BIGINT 19 null
grade_outcomes Table id BIGINT 19 null

id of the table

stats_monthly Table roleid BIGINT 19 0

id of role for the aggregates

question_statistics Table s BIGINT 19 0
competency_relatedcomp Table usermodified BIGINT 19 null
job_assignment Table idnumber VARCHAR 100

Unique within each user's set of job assignments, required for all job assignments.

block_positions Table contextid BIGINT 19 null

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

survey_answers Table id BIGINT 19 null
cohort_msg_queue Table userid BIGINT 19 null
upgrade_log Table info VARCHAR 255
message_contacts Table blocked BIT 1 0
block_zoola_module_name Table name VARCHAR 1333

Module name

cohort_rulesets Table id BIGINT 19 null
block_zoola_schedule_rcp Table id BIGINT 19 null
goal_personal Table scalevalueid BIGINT 19 null
enrol Table enrol VARCHAR 20
message_read Table contexturlname LONGTEXT 2147483647 null

Display text for the contexturl

workshopform_numerrors Table workshopid BIGINT 19 null

Workshop ID

grade_items Table itemmodule VARCHAR 30 null

'forum', 'quiz', 'csv', etc

course_info_data_param Table dataid BIGINT 19 null
totara_userdata_export_item Table timestarted BIGINT 19 null

Start time of purging method

question_categories Table id BIGINT 19 null
messageinbound_datakeys Table datakey VARCHAR 64 null

The secret key for this data item.

course Table lang VARCHAR 30
user Table firstname VARCHAR 100
totara_userdata_export_type_item Table exporttypeid BIGINT 19 null
course_completion_aggr_methd Table value DECIMAL 10 null

NULL = all/any, 0..1 for method 'fraction', > 0 for method 'unit'

grade_grades_history Table locktime BIGINT 19 0

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

pos_type_info_data Table positionid BIGINT 19 null
course_sections Table name VARCHAR 255 null
facetoface_room_info_field Table datatype VARCHAR 255 null
workshopform_rubric_config Table layout VARCHAR 30 list

How should the rubric be displayed for reviewers

qtype_multichoice_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

mnet_host2service Table hostid BIGINT 19 0
assignment_submissions Table format SMALLINT 5 0
data_fields Table name VARCHAR 255
files Table timemodified BIGINT 19 null
facetoface_room Table description LONGTEXT 2147483647 null
totara_sync_log Table info VARCHAR 255 null

log entry info message

block_rss_client Table skipuntil BIGINT 19 0

Do not query this RSS feed again until this time

enrol_lti_tools Table institution VARCHAR 40
course_info_field Table fullname LONGTEXT 2147483647 null
question_dataset_items Table definition BIGINT 19 0
course_published Table huburl VARCHAR 255 null

the url of the "registered on" hub

prog_info_data Table id BIGINT 19 null
course_completion_defaults Table customrules LONGTEXT 2147483647 null
competency_usercomp Table reviewerid BIGINT 19 null

User that reviewed the competency.

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.

feedback360_grp_pos Table feedback360id BIGINT 19 null
grade_categories_history Table oldid BIGINT 19 null
glossary_entries_categories Table categoryid BIGINT 19 0
external_tokens Table lastaccess BIGINT 19 null

last access timestamp

user Table yahoo VARCHAR 50
appraisal_review_data Table content LONGTEXT 2147483647 null
auth_connect_sso_requests Table id BIGINT 19 null
cohort_members Table timeadded BIGINT 19 0
facetoface_signup_info_field Table defaultdata LONGTEXT 2147483647 null
gradingform_guide_criteria Table descriptionmarkersformat TINYINT 3 null
blog_external Table timemodified BIGINT 19 null
questionnaire_survey Table title VARCHAR 255
prog_completion_log Table description LONGTEXT 2147483647 null

Description of what changed, English only

cohort_msg_queue Table action VARCHAR 255
feedback360_scale_value Table score BIGINT 19 null
external_services Table timemodified BIGINT 19 null
assign_submission Table attemptnumber BIGINT 19 0

Used to track attempts for an assignment

workshopallocation_scheduled Table submissionend BIGINT 19 null

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

gradingform_rubric_criteria Table description LONGTEXT 2147483647 null

The criterion description

workshopform_rubric Table description LONGTEXT 2147483647 null

The description of the dimension

message_contacts Table contactid BIGINT 19 0
question_dataset_definitions Table type BIGINT 19 0
grade_grades Table excluded BIGINT 19 0

grade excluded from aggregation functions, date means when excluded

enrol_lti_tool_consumer_map Table toolid BIGINT 19 null

The tool ID.

user Table skype VARCHAR 50
course_modules Table visible BIT 1 1
comments Table timecreated BIGINT 19 null
assignment_submissions Table assignment BIGINT 19 0
config Table name VARCHAR 255
org_type_info_field Table id BIGINT 19 null
grade_items_history Table gradetype SMALLINT 5 1

0 = none, 1 = value, 2 = scale, 3 = text

facetoface_notification Table body LONGTEXT 2147483647 null
workshop_submissions Table late TINYINT 3 0

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

quiz_statistics Table errorratio DECIMAL 15 null
feedback360_scale_data Table feedback360respassignmentid BIGINT 19 null
comp_scale_values Table idnumber VARCHAR 100 null
certificate_issues Table timecreated BIGINT 19 0
grade_outcomes_history Table shortname VARCHAR 255

The short name or code for this outcome statement

files Table filearea VARCHAR 50

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

lti_tool_proxies Table state TINYINT 3 1

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

oauth2_issuer Table timemodified BIGINT 19 null

Time this record was modified.

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.

comp_framework Table visible TINYINT 3 null
role_capabilities Table timemodified BIGINT 19 0
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)

quiz Table introformat SMALLINT 5 0

Quiz intro text format.

facetoface_sessions Table cancelledstatus BIT 1 0

Session cancelled status

local_activityvisibility_que Table courseid BIGINT 19 null
question_calculated_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

quiz_feedback Table id BIGINT 19 null
questionnaire_attempts Table userid BIGINT 19 0
comp_record Table timecreated BIGINT 19 null
totara_userdata_export Table result BIGINT 19 null

null means not finished, -1 completed ok, -2 means error, -3 means skipped, -4 cancelled, -5 timed out

feedback Table course BIGINT 19 0
wiki_versions Table id BIGINT 19 null
assignment Table var1 BIGINT 19 0
facetoface Table display BIGINT 19 0
competency_plan Table name VARCHAR 100
role_allow_switch Table id BIGINT 19 null
question_calculated_options Table shuffleanswers SMALLINT 5 0

Whether the choices can be randomly shuffled.

qtype_ddimageortext_drags Table label LONGTEXT 2147483647 null

Alt text label for drag-able image.

questionnaire_feedback Table feedbacktext LONGTEXT 2147483647 null
pos_type_info_field Table defaultdata LONGTEXT 2147483647 null
feedback_completedtmp Table guestid VARCHAR 255
course Table groupmodeforce SMALLINT 5 0
data Table timeviewfrom BIGINT 19 0
competency_usercompplan Table timecreated BIGINT 19 null
prog_info_field Table param5 LONGTEXT 2147483647 null
dp_plan_evidence_info_field Table param5 LONGTEXT 2147483647 null
feedback_item Table hasvalue BIT 1 0
enrol_paypal Table business VARCHAR 255
question_attempt_step_data Table attemptstepid BIGINT 19 null

Foreign key, references question_attempt_steps.id

lesson Table introformat SMALLINT 5 0
tag_area Table tagcollid BIGINT 19 null
catalog Table sorttext LONGTEXT 2147483647 null

Field used for alphabetical sorting

mnet_log Table coursename VARCHAR 40
qtype_ddimageortext Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

facetoface_asset_info_field Table required TINYINT 3 null
question Table id BIGINT 19 null
assignfeedback_comments Table commentformat SMALLINT 5 0

The feedback text format

dp_course_settings Table priorityscale BIGINT 19 null

Identifies the scale used by this component

qtype_match_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.

data Table defaultsortdir SMALLINT 5 0
grade_import_values Table importcode BIGINT 19 null

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

question_calculated_options Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

enrol_paypal Table option_selection1_x VARCHAR 255
user_password_resets Table token VARCHAR 32

secret set and emailed to user

badge_criteria_met Table issuedid BIGINT 19 null
local_ld_course Table id BIGINT 19 null
block_zoola_reports_schreps Table thiscourse TINYINT 3 0

if 1 reports will be filtered course in which block is placed in

course Table showgrades TINYINT 3 1
facetoface_room Table allowconflicts BIT 1 0
wiki_synonyms Table subwikiid BIGINT 19 0

Subwiki instance

badge_backpack Table autosync BIT 1 0
assign_user_flags Table assignment BIGINT 19 0

The assignment these flags apply to.

tool_monitor_rules Table template LONGTEXT 2147483647 null

Message template

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

totara_connect_clients Table syncjobs BIT 1 0

Send job assignments data to clients

pos Table depthlevel BIGINT 19 null
competency_usercomp Table usermodified BIGINT 19 null
assignfeedback_editpdf_annot Table path LONGTEXT 2147483647 null

SVG path describing the freehand line

prog Table allowextensionrequests BIT 1 1

Indicates if the program allows extension requests

comp_type_info_field Table sortorder BIGINT 19 null
user_preferences Table userid BIGINT 19 0
appraisal_review_data Table appraisalscalevalueid BIGINT 19 null
reminder Table modifierid BIGINT 19 null
certif_completion Table baselinetimeexpires BIGINT 19 null
page Table legacyfileslast BIGINT 19 null
event Table visible SMALLINT 5 1
enrol_lti_users Table userid BIGINT 19 null
goal_type_info_field Table hidden TINYINT 3 null
lesson Table ongoing SMALLINT 5 0
question_response_analysis Table credit DECIMAL 15 null
log Table url VARCHAR 100
mnet_remote_service2rpc Table serviceid BIGINT 19 0

Unique service ID

groupings Table courseid BIGINT 19 0
glossary_alias Table alias VARCHAR 255
totara_connect_clients Table clientsecret VARCHAR 64

Shared secret, used in client requests

grading_instances Table status BIGINT 19 0

The status of the assessment. By default the instance is under-assessment state

logstore_standard_log Table other LONGTEXT 2147483647 null
folder Table showdownloadfolder BIT 1 1

1 = show download folder button

appraisal_scale_value Table score BIGINT 19 null
appraisal_event_rcpt Table appraisalrole SMALLINT 5 null
enrol_lti_users Table lastaccess BIGINT 19 null

The time the user last accessed

questionnaire_resp_single Table id BIGINT 19 null
course_sections Table summary LONGTEXT 2147483647 null
prog_user_assignment Table userid BIGINT 19 0
quiz_sections Table shufflequestions SMALLINT 5 0

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

rating Table id BIGINT 19 null
goal_type Table timemodified BIGINT 19 null
grade_grades_history Table rawgrade DECIMAL 10 null

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

auth_connect_ids Table serverid BIGINT 19 null
tool_recyclebin_category Table fullname VARCHAR 255
questionnaire_survey Table email VARCHAR 255 null
enrol_lti_lti2_tool_proxy Table toolproxykey VARCHAR 32
block_community Table id BIGINT 19 null
tag_area Table callback VARCHAR 100 null
scorm Table displaycoursestructure BIT 1 0
question_calculated_options Table answernumbering VARCHAR 10 abc

Indicates how and whether the choices should be numbered.

facetoface_sessions Table id BIGINT 19 null
course_request Table summaryformat TINYINT 3 0
certificate Table timemodified BIGINT 19 0
prog_message Table notifymanager BIT 1 0
block_recent_activity Table timecreated BIGINT 19 null
block_zoola_reports_eventcfg Table sendtoteacher BIT 1 0

Add course teachers email to recipient list

user_info_field Table param1 LONGTEXT 2147483647 null

General parameter field

message_read Table fullmessage LONGTEXT 2147483647 null
questionnaire_feedback Table section_id BIGINT 19 0
comp_record Table userid BIGINT 19 null
org_relations Table description LONGTEXT 2147483647 null
certificate_issues_history Table outcome VARCHAR 300 null

Outcome at time of archive

dp_plan Table templateid BIGINT 19 null

Identifies the template used by this plan.

report_builder_graph Table stacked BIT 1 0

Stack data series? Only some types support this.

questionnaire_quest_choice Table id BIGINT 19 null
data_content Table content3 LONGTEXT 2147483647 null
question_response_analysis Table variant BIGINT 19 null
pos_relations Table description LONGTEXT 2147483647 null
user Table phone2 VARCHAR 20
workshop Table latesubmissions TINYINT 3 0

Allow submitting the work after the deadline

block_quicklinks Table block_instance_id BIGINT 19 null
lti_tool_proxies Table capabilityoffered LONGTEXT 2147483647 null

List of capabilities offered, one per line

grade_items Table idnumber VARCHAR 255 null

Arbitrary idnumber provided by the module responsible

auth_connect_users Table timecreated BIGINT 19 null
tool_recyclebin_category Table timecreated BIGINT 19 null
facetoface_session_info_field Table param5 LONGTEXT 2147483647 null
survey Table id BIGINT 19 null
message Table useridfrom BIGINT 19 0
tool_usertours_tours Table enabled BIT 1 0
workshopform_rubric_config Table workshopid BIGINT 19 null

The id of workshop this configuartion applies for

user Table secret VARCHAR 15
questionnaire_feedback Table feedbacktextformat TINYINT 3 1
user Table totarasync BIT 1 0

Totara sync flag from totara_sync

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).

assign_user_flags Table locked BIGINT 19 0

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

enrol Table password VARCHAR 50 null

Custom - enrolment or access password

task_adhoc Table id BIGINT 19 null
appraisal_quest_field Table appraisalscaleid 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

comments Table itemid BIGINT 19 null
resource_old Table intro LONGTEXT 2147483647 null
lti Table toolurl LONGTEXT 2147483647 null

Remote tool url

auth_connect_sso_sessions Table userid BIGINT 19 null
assignfeedback_editpdf_cmnt Table colour VARCHAR 10 black

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

prog_completion Table status SMALLINT 5 0
my_pages Table private BIT 1 1

Whether or not the page is private (dashboard) or public (profile)

quiz_sections Table heading VARCHAR 1333 null

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

resource_old Table alltext LONGTEXT 2147483647 null
pos_competencies Table id BIGINT 19 null
reportbuilder_grp_cohort_user Table timecreated BIGINT 19 0
scale Table description LONGTEXT 2147483647 null
quiz Table browsersecurity VARCHAR 32

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

course Table timemodified BIGINT 19 0
facetoface_room Table timecreated BIGINT 19 0
assign_grades Table userid BIGINT 19 0
totara_userdata_export_type Table timecreated BIGINT 19 null

When was this type added

dp_priority_scale Table defaultid BIGINT 19 null

Identifies the id of the default scale value

enrol Table customint1 BIGINT 19 null

Custom - general int

competency_usercompplan Table grade BIGINT 19 null

Grade assigned to the competency.

lesson_overrides Table groupid BIGINT 19 null

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

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

totara_connect_clients Table clientname VARCHAR 255

Name of the client system

feedback360 Table description LONGTEXT 2147483647 null
auth_approved_request Table lang VARCHAR 30

User language during signup, we need to send them emails in this same language

choice Table completionsubmit BIT 1 0

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

report_builder Table defaultsortcolumn VARCHAR 255 null

Name of the column (type_value) to use to initially sort the report

tool_usertours_steps Table title LONGTEXT 2147483647 null

Title of the step

feedback_sitecourse_map Table id BIGINT 19 null
question_dataset_definitions Table id BIGINT 19 null
reportbuilder_grp_user_record Table id BIGINT 19 null
appraisal_scale_data Table appraisalquestfieldid BIGINT 19 null
question_statistics Table sd DECIMAL 15 null
rating Table rating BIGINT 19 null
goal_type_info_data Table goalid BIGINT 19 null
tool_sitepolicy_policy_version Table id BIGINT 19 null
tag_correlation Table tagid BIGINT 19 null
forum_posts Table attachment VARCHAR 100
glossary_entries_categories Table entryid BIGINT 19 0
goal_grp_cohort Table usermodified BIGINT 19 null
tag Table userid BIGINT 19 null
assignment Table var2 BIGINT 19 0
user Table descriptionformat TINYINT 3 1
auth_approved_request Table id BIGINT 19 null
grade_items Table aggregationcoef2 DECIMAL 10 0.00000

Aggregation coefficient used for weights in aggregation types with both extra credit and weight

comp_relations Table id1 BIGINT 19 null
forum_discussions Table userid BIGINT 19 0
gradingform_rubric_fillings Table criterionid BIGINT 19 null

The ID of the criterion (row) in the rubric

certif_completion_history Table certifid BIGINT 19 null

Certification ID

org Table path VARCHAR 255
scorm_seq_rolluprule Table minimumpercent FLOAT 11 0.0000
backup_controllers Table format VARCHAR 20

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

events_handlers Table handlerfunction LONGTEXT 2147483647 null

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

facetoface_room_info_field Table forceunique TINYINT 3 null
org_type_info_field Table param1 LONGTEXT 2147483647 null
message Table useridto BIGINT 19 0
message Table subject LONGTEXT 2147483647 null

The message subject

facetoface_signups_status Table grade DECIMAL 10 null
questionnaire_fb_sections Table sectionheading LONGTEXT 2147483647 null
job_assignment Table organisationid BIGINT 19 null

The ID of the organisation the user belongs to as part of this job assignment

cohort_rulesets Table sortorder BIGINT 19 null
cohort Table visible BIT 1 1

Visibility to teachers - Totara may be using different logic

competency Table ruletype VARCHAR 100 null
block_zoola_reports_user Table userid BIGINT 19 null

User ID

certificate Table requiredtime BIGINT 19 0
totara_core_course_vis_map Table id BIGINT 19 null
prog_recurrence Table nextcourseid BIGINT 19 0
goal_scale_assignments Table id BIGINT 19 null
comp_template_assignment Table timecreated BIGINT 19 null
grading_instances Table raterid BIGINT 19 null

The ID of the user who did the assessment

facetoface_notification_hist Table notificationid BIGINT 19 null

FK of notification

totara_userdata_export Table usercreated BIGINT 19 null

Usually the user that request the export

backup_controllers Table controller LONGTEXT 2147483647 null

serialised backup_controller object

facetoface_asset Table id BIGINT 19 null
auth_approved_request_snapshots Table organisationid BIGINT 19 null
prog_completion Table timecreated BIGINT 19 0
scorm_seq_mapinfo Table id BIGINT 19 null
glossary_formats Table id BIGINT 19 null
grade_outcomes_history Table id BIGINT 19 null
prog Table endnote LONGTEXT 2147483647 null
log_queries Table sqltext LONGTEXT 2147483647 null

query sql

portfolio_instance_user Table id BIGINT 19 null
enrol_lti_lti2_user_result Table ltiuserkey VARCHAR 255
facetoface_sessions Table waitlisteveryone BIT 1 0

Will everyone be added to the waiting list

glossary Table displayformat VARCHAR 50 dictionary
prog_user_assignment Table assignmentid BIGINT 19 0
questionnaire_response_other Table response_id BIGINT 19 0
files Table filename VARCHAR 255

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

config_log Table name VARCHAR 100
question_gapselect Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

grade_grades_history Table rawgrademax DECIMAL 10 100.00000

The maximum allowable grade when this was created

data Table id BIGINT 19 null
questionnaire_resp_multiple Table choice_id BIGINT 19 0
competency_templatecohort Table timecreated BIGINT 19 null
forum Table assesstimestart BIGINT 19 0
enrol Table customtext2 LONGTEXT 2147483647 null

Custom - general text

facetoface_sessioncancel_info_field Table datatype VARCHAR 255 null
course_modules_completion Table timemodified BIGINT 19 null

Time at which the completion state last changed.

badge_issued Table dateissued BIGINT 19 0
oauth2_issuer Table loginparamsoffline LONGTEXT 2147483647 null

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

forum Table rsstype TINYINT 3 0
reminder Table timemodified BIGINT 19 null
qtype_multichoice_options Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

glossary Table timemodified BIGINT 19 0
portfolio_mahara_queue Table id BIGINT 19 null
auth_approved_request_snapshots Table email VARCHAR 100 null
file_conversion Table data LONGTEXT 2147483647 null
certificate Table printdate BIGINT 19 0
user_lastaccess Table courseid BIGINT 19 0
scale_history Table id BIGINT 19 null
report_builder Table defaultsortorder BIGINT 19 4

Integer representing the direction that default sorting should be done

dp_competency_settings Table id BIGINT 19 null
quiz Table timecreated BIGINT 19 0

The time when the quiz was added to the course.

repository_instance_config Table name VARCHAR 255
question_truefalse Table id BIGINT 19 null
scale_history Table scale LONGTEXT 2147483647 null
cohort_rule_collections Table id BIGINT 19 null
block_zoola_reports_eventcfg Table bodyformat SMALLINT 5 0
totara_compl_import_course Table evidenceid BIGINT 19 null

The evidence table id

goal_grp_pos Table usermodified BIGINT 19 null
goal_record Table goalid BIGINT 19 null
grade_import_newitem Table id BIGINT 19 null
forum Table forcesubscribe BIT 1 0
competency_usercompplan Table usermodified BIGINT 19 null
facetoface_room_info_data_param Table value VARCHAR 32
facetoface_room_info_field Table description LONGTEXT 2147483647 null
workshop Table useexamples TINYINT 3 0

optional feature: students practise evaluating on example submissions from teacher

mnetservice_enrol_enrolments Table id BIGINT 19 null

Unique enrollment ID

auth_approved_request_snapshots Table timemodified BIGINT 19 null
external_services_functions Table functionname VARCHAR 200
comp_record_history Table competencyid BIGINT 19 null
folder Table course BIGINT 19 0
facetoface_signup_info_field Table required TINYINT 3 null
messageinbound_messagelist Table messageid LONGTEXT 2147483647 null
enrol_flatfile Table timeend BIGINT 19 0
post Table content LONGTEXT 2147483647 null
enrol_lti_tools Table rolelearner BIGINT 19 null
groups Table courseid BIGINT 19 null
lti_tool_proxies Table toolproxy LONGTEXT 2147483647 null

JSON string representing tool proxy returned by tool provider

appraisal_stage_data Table id BIGINT 19 null
message_airnotifier_devices Table id BIGINT 19 null
block_zoola_reports_schreps Table emails VARCHAR 1333

Comma separated list of emails to send the report to.

oauth2_issuer Table enabled TINYINT 3 1
tool_usertours_steps Table targettype TINYINT 3 null

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

certif_completion_history Table userid BIGINT 19 null

Users id

registration_hubs Table confirmed BIT 1 0
enrol_paypal Table option_selection2_x VARCHAR 255
quiz_sections Table quizid BIGINT 19 null

Foreign key references quiz.id.

oauth2_issuer Table image LONGTEXT 2147483647 null
files Table source LONGTEXT 2147483647 null

contains the reference if the file is imported from external sites

competency_evidence Table action TINYINT 3 null
catalog Table sorttime BIGINT 19 0

Field used for 'Latest' sorting

auth_approved_request Table profilefields LONGTEXT 2147483647 null

The JSON encoded string containing all custom profile fields data

auth_approved_request Table password VARCHAR 255

Hashed user password

badge Table usercreated 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)

feedback360_scale_value Table name VARCHAR 255 null
oauth2_issuer Table loginscopesoffline LONGTEXT 2147483647 null

The scopes requested for a login attempt to generate a refresh token.

block_positions Table blockinstanceid BIGINT 19 null

The block_instance this position relates to.

workshopform_rubric_levels Table definitionformat SMALLINT 5 0

The format of the definition field

goal Table targetdate BIGINT 19 null
appraisal Table timefinished BIGINT 19 null

timestamp

prog_info_field Table forceunique TINYINT 3 null
scale_history Table courseid BIGINT 19 0
tool_sitepolicy_user_consent Table hasconsented BIT 1 null

Has the user consented to this option

blog_external Table name VARCHAR 255
oauth2_issuer Table alloweddomains LONGTEXT 2147483647 null

Allowed domains for this issuer.

goal_personal Table timemodified BIGINT 19 null
block_zoola_reports_schreps Table filters LONGTEXT 2147483647 null

Filter values used to run the report, in JSON format

data_content 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.

assignsubmission_onlinetext Table submission BIGINT 19 0
groups Table id BIGINT 19 null
cohort_role Table cohortid BIGINT 19 0
grade_grades Table overridden BIGINT 19 0

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

role_assignments Table component VARCHAR 100

plugin responsible responsible for role assignment, empty when manually assigned

qtype_match_subquestions Table questionid BIGINT 19 0

Foreign key link to question.id.

block_totara_stats Table timestamp BIGINT 19 null
repository_instances Table password VARCHAR 255 null
course_modules Table score SMALLINT 5 0
competency_evidence Table desca LONGTEXT 2147483647 null
facetoface_asset Table timemodified BIGINT 19 0
totara_connect_client_cohorts Table cohortid BIGINT 19 null
competency_userevidencecomp Table usermodified BIGINT 19 null
cohort Table timemodified BIGINT 19 null
prog_completion Table timedue BIGINT 19 0
chat_messages Table message LONGTEXT 2147483647 null
facetoface_session_info_field Table description LONGTEXT 2147483647 null
data_records Table id BIGINT 19 null
pos_framework Table sortorder BIGINT 19 null
grade_categories_history Table aggregatesubcats BIT 1 0

This setting was removed from grade_categories. It is kept here only to preserve history.

competency_plan Table usermodified BIGINT 19 null
comp_scale_values Table name LONGTEXT 2147483647 null
comp_scale Table id BIGINT 19 null
badge Table expiredate BIGINT 19 null
grade_categories_history Table path VARCHAR 255 null

shows the path as /1/2/3 (like course_categories)

facetoface_sessioncancel_info_field Table forceunique TINYINT 3 null
org_type_info_field Table datatype VARCHAR 255 null
survey Table course BIGINT 19 0
quiz Table timeopen BIGINT 19 0

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

user_info_field Table sortorder BIGINT 19 0

order within the category

block_zoola_reports_cohort Table cohortid BIGINT 19 null

Cohort ID

prog_message Table mainmessage LONGTEXT 2147483647 null
sessions Table id 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)

external_services Table shortname VARCHAR 255 null

a unique shortname

groups_members Table userid BIGINT 19 0
workshop Table useselfassessment TINYINT 3 0

optional feature: students perform self assessment of their own work

totara_dashboard Table published BIT 1 0
totara_navigation Table depth BIT 1 1

Deprecated since Totara 12.0

course_format_options Table id BIGINT 19 null
cache_flags Table expiry BIGINT 19 null
dp_evidence_type Table sortorder BIGINT 19 null
scorm_aicc_session Table scormstatus VARCHAR 255 null
comp_type_info_field Table param5 LONGTEXT 2147483647 null
grade_grades Table feedbackformat BIGINT 19 0

format of feedback text

mnet_remote_rpc Table enabled BIT 1 null
lesson_answers Table jumpto BIGINT 19 0
course_completion_defaults Table completion BIT 1 0
feedback_valuetmp Table id BIGINT 19 null
stats_user_daily Table timeend BIGINT 19 0
mnet_rpc Table enabled BIT 1 0
mnet_rpc Table functionname VARCHAR 40
quiz_grades Table quiz BIGINT 19 0

Foreign key references quiz.id.

comments Table userid BIGINT 19 null
question_numerical_options Table unitpenalty DECIMAL 12 0.1000000

Penalty for getting the unit wrong, when they are being graded.

repository_opensesame_bdls Table id BIGINT 19 null
portfolio_mahara_queue Table token VARCHAR 50

the token mahara sent us to use for this transfer.

dp_priority_scale Table description LONGTEXT 2147483647 null

Description of the priority scale

url Table id BIGINT 19 null
prog_extension Table extensiondate BIGINT 19 0
competency_usercomp Table proficiency TINYINT 3 null

Indicate if the competency is proficient not.

totara_navigation Table customtitle BIT 1 1
certif_completion Table certifpath TINYINT 3 null

CERT/RECET

external_services Table timecreated BIGINT 19 null
page Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

goal_user_type Table idnumber VARCHAR 100 null
groups Table name VARCHAR 254

Short human readable unique name for the group.

questionnaire Table navigate TINYINT 3 0

Questionnaire can have page branching.

feedback Table multiple_submit BIT 1 1
feedback_item Table template BIGINT 19 0
feedback360 Table name VARCHAR 255
competency_plancomp Table competencyid BIGINT 19 null
facetoface_room_info_field Table locked TINYINT 3 null
report_builder_global_restriction Table id BIGINT 19 null
config Table value LONGTEXT 2147483647 null
facetoface_asset_info_field Table datatype VARCHAR 255 null
grade_grades Table rawgrademin DECIMAL 10 0.00000

The minimum allowable grade when this was created

assign_plugin_config Table plugin VARCHAR 28
book_chapters Table id BIGINT 19 null
lesson_branch Table pageid BIGINT 19 0
competency_templatecomp Table usermodified BIGINT 19 null

The user who modified this link.

wiki Table defaultformat VARCHAR 20 creole

Wiki's default editor

feedback_item Table required BIT 1 0
cohort_plan_config Table planstatus BIGINT 19 null

Learning plan status

resource Table legacyfileslast BIGINT 19 null
auth_approved_request_snapshots Table password VARCHAR 255 null
quiz_overrides Table password VARCHAR 255 null

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

upgrade_log Table targetversion VARCHAR 100 null

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

comp_record Table timeproficient BIGINT 19 null
course_completions Table status TINYINT 3 0

Totara status from totara_core

oauth2_endpoint Table url LONGTEXT 2147483647 null

The url to the endpoint

questionnaire_fb_sections Table sectionlabel VARCHAR 50 null
role_assignments Table userid BIGINT 19 0
facetoface_asset_info_data Table data LONGTEXT 2147483647 null
auth_approved_request_snapshots Table city VARCHAR 120 null
questionnaire_response_rank Table choice_id BIGINT 19 0
grading_definitions Table status BIGINT 19 0

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

dp_plan_evidence_info_field Table sortorder BIGINT 19 null
user Table department VARCHAR 255
cohort_rule_params Table id BIGINT 19 null
dp_plan_evidence Table evidencetypeid BIGINT 19 null

Integer representing the type of this evidence item

prog_message Table messagesubject VARCHAR 255
gradingform_guide_comments Table descriptionformat TINYINT 3 null

The format of the description field

question_ddwtos Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

course_completion_crit_compl Table userid BIGINT 19 0
enrol Table timemodified BIGINT 19 0
enrol_paypal Table payment_status VARCHAR 255
scorm Table height BIGINT 19 600
totara_navigation Table parentid BIGINT 19 0
facetoface Table timecreated BIGINT 19 0
tool_sitepolicy_localised_policy Table language VARCHAR 30

Language of the policy

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.

dp_objective_settings Table templateid BIGINT 19 null
prog_courseset Table coursesumfield BIGINT 19 0
qtype_multichoice_options Table id BIGINT 19 null
workshop Table evaluation VARCHAR 30

The recently used grading evaluation method

totara_dashboard Table name VARCHAR 1333
report_builder_settings Table type VARCHAR 100

Component of report builder that the setting is for

report_builder_columns Table customheading SMALLINT 5 0

Indicates whether the user has customised a heading or if they are still using the default column heading value

goal_grp_org Table usermodified BIGINT 19 null
message_read Table timecreated BIGINT 19 0
files_reference Table lastsync BIGINT 19 null

Last time the proxy file was synced with repository

goal_user_assignment Table timemodified BIGINT 19 null
facetoface_sessions Table sendcapacityemail BIT 1 0

Notification flag for minimum bookings capactiy email.

question_hints Table id BIGINT 19 null
dp_plan_objective Table id BIGINT 19 null
imscp Table structure LONGTEXT 2147483647 null
cohort_plan_history Table id BIGINT 19 null
scorm Table forcenewattempt BIT 1 0
facetoface_sessioncancel_info_data_param Table dataid BIGINT 19 null
certif_completion Table timemodified BIGINT 19 null
assignment Table introformat SMALLINT 5 0
goal_scale_assignments Table timemodified BIGINT 19 null
grade_outcomes Table usermodified BIGINT 19 null

the userid of the person who last modified this outcome

dp_plan_evidence_relation Table component VARCHAR 255

component name - competency, objective, course

qtype_ddimageortext Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

resource_old Table cmid BIGINT 19 null
message Table eventtype VARCHAR 100 null
facetoface_signups_status Table id BIGINT 19 null
appraisal_grp_cohort Table cohortid BIGINT 19 null
course_completion_defaults Table course BIGINT 19 null
enrol Table customdec2 DECIMAL 12 null

Custom - general decimal

scorm Table completionscorerequired BIGINT 19 null
external_tokens Table token VARCHAR 128

security token, aka private access key

facetoface_notification_hist Table userid BIGINT 19 null

FK of user

facetoface_sessioncancel_info_data_param Table value VARCHAR 32
feedback360_grp_org Table id BIGINT 19 null
org_type Table idnumber VARCHAR 100 null
repository_opensesame_pkgs Table expirationdate VARCHAR 20

Date the license is valid until as text

goal_type Table timecreated BIGINT 19 null
dp_evidence_type Table id BIGINT 19 null
pos_competencies Table competencyid BIGINT 19 null
facetoface Table approvaltype BIGINT 19 0
wiki_versions Table pageid BIGINT 19 0

Page id

workshopform_rubric_levels Table definition LONGTEXT 2147483647 null

The definition of this level

comp_framework Table timecreated BIGINT 19 null
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.

backup_controllers Table timemodified BIGINT 19 null

last time the controller was modified

mnetservice_enrol_enrolments Table enroltime BIGINT 19 0
goal_scale Table timemodified BIGINT 19 null
course_categories Table parent BIGINT 19 0
competency_templatecohort Table id BIGINT 19 null
goal_framework Table id BIGINT 19 null
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

messageinbound_datakeys Table id BIGINT 19 null
badge Table usermodified BIGINT 19 null
report_builder_graph Table category VARCHAR 255

none,reversed or name of one column

dp_permissions Table action VARCHAR 255 null

Shortname of the permission to be set

course_info_field Table id BIGINT 19 null
facetoface_asset_dates Table sessionsdateid BIGINT 19 null
grade_categories_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

question_categories Table parent BIGINT 19 0
grade_grades Table rawscaleid BIGINT 19 null

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

competency_plan Table timemodified BIGINT 19 0
assign_submission Table latest TINYINT 3 0

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

tool_sitepolicy_user_consent Table timeconsented BIGINT 19 null

Timestamp of when the user answered

course_modules Table showdescription BIT 1 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

messageinbound_datakeys Table expires BIGINT 19 null

The expiry time of this key.

scale Table descriptionformat TINYINT 3 0
lti Table course BIGINT 19 0

Course basiclti activity belongs to

config_log Table id BIGINT 19 null
tool_monitor_subscriptions Table inactivedate BIGINT 19 0
course_sections Table section BIGINT 19 0
grade_categories_history Table parent BIGINT 19 null

Categories can be hierarchical

question_hints Table questionid BIGINT 19 null
mnet_log Table hostid BIGINT 19 0

Unique host ID

workshop_assessments Table feedbackauthor LONGTEXT 2147483647 null

The comment/feedback from the reviewer for the author.

facetoface_cancellation_info_field Table id BIGINT 19 null
config_plugins Table value LONGTEXT 2147483647 null
facetoface_notification Table usermodified BIGINT 19 null
enrol Table sortorder BIGINT 19 0

order of enrol plugins in each course

tool_recyclebin_course Table id BIGINT 19 null
dp_priority_scale Table name VARCHAR 255 null

Defines the name of the priority scale

messageinbound_handlers Table defaultexpiration BIGINT 19 86400

The default expiration period to use when creating a new key

appraisal_scale_value Table id BIGINT 19 null
facetoface_notification Table scheduleunit BIT 1 null
course_categories Table id BIGINT 19 null
user_devices Table model VARCHAR 32

the device model, Nexus 4 or iPad 1,1

totara_connect_client_pos_frameworks Table id BIGINT 19 null
comp_type_info_data_param Table dataid BIGINT 19 null
facetoface_room Table id BIGINT 19 null
prog Table fullname VARCHAR 254
quiz_statistics Table allattemptsavg DECIMAL 15 null
feedback360_scale Table userid BIGINT 19 null
feedback_value Table tmp_completed BIGINT 19 0
course_categories Table visible BIT 1 1
block_zoola_reports_eventcfg Table body LONGTEXT 2147483647 null

Email body

reminder Table id BIGINT 19 null
dp_plan_objective Table manual BIT 1 0

Was this assignment made manually

folder Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

auth_approved_request_snapshots Table confirmed BIT 1 null
lesson Table grade BIGINT 19 0
question_ddwtos Table id BIGINT 19 null
tool_monitor_history Table sid BIGINT 19 null

Subscription id

oauth2_issuer Table id BIGINT 19 null
forum_track_prefs Table userid BIGINT 19 0
enrol_lti_lti2_nonce Table expires BIGINT 19 null
facetoface_notification Table issent BIT 1 0
goal_user_info_field Table param1 LONGTEXT 2147483647 null
competency_coursecomp Table sortorder BIGINT 19 null

The display order for this link.

qtype_ddmarker Table partiallycorrectfeedbackformat TINYINT 3 0
message_providers Table name VARCHAR 100

The full name of the message provider in standard form

lesson_overrides Table retake SMALLINT 5 null
totara_compl_import_cert Table certificationidnumber VARCHAR 100 null

certification id number

totara_userdata_purge_type Table timecreated BIGINT 19 null

When was this type added

feedback360_quest_field Table sortorder BIGINT 19 null
auth_approved_request_snapshots Table positionid BIGINT 19 null
gradingform_rubric_criteria Table id BIGINT 19 null
grade_outcomes_history Table action BIGINT 19 0

created/modified/deleted constants

repository_opensesame_pkgs Table title VARCHAR 1333

OpenSesame course title

comp_type_info_field Table param2 LONGTEXT 2147483647 null
assign_submission Table userid BIGINT 19 0
grade_items Table needsupdate BIGINT 19 0

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

comp_criteria Table usermodified BIGINT 19 null
questionnaire_response Table submitted BIGINT 19 0
competency_evidence Table grade BIGINT 19 null
competency_relatedcomp Table id BIGINT 19 null
mnet_remote_rpc Table xmlrpcpath VARCHAR 80
assignment_submissions Table numfiles BIGINT 19 0
workshop Table instructauthors LONGTEXT 2147483647 null

Instructions for the submission phase

lesson Table id BIGINT 19 null
comp_record_history Table proficiency BIGINT 19 null
backup_logs Table timecreated BIGINT 19 null

timestamp this log entry was created

data Table intro LONGTEXT 2147483647 null
modules Table lastcron BIGINT 19 0
comp_scale_values Table id BIGINT 19 null
cohort_members Table cohortid BIGINT 19 0
enrol_lti_tools Table maildisplay TINYINT 3 2
auth_connect_sso_requests Table serverid BIGINT 19 null
block_totara_featured_links_tiles Table sortorder BIGINT 19 1

The order which the tile will be displayed in the block uses blockid-sortorder

report_builder_cache Table changed BIT 1 null
grade_grades Table locked BIGINT 19 0

not locked 0, locked from date

scorm Table displayattemptstatus BIT 1 1
goal_framework Table timemodified BIGINT 19 null
scorm_scoes_track Table scormid BIGINT 19 0
grade_categories_history Table droplow BIGINT 19 0

Drop the X lowest items

block_zoola_schedule_rcp Table schrepsid BIGINT 19 null

schedule id

feedback Table id BIGINT 19 null
assignfeedback_editpdf_annot Table draft TINYINT 3 1

Is this a draft annotation?

tool_monitor_rules Table templateformat BIT 1 null

Template format

persistent_login Table id BIGINT 19 null
goal_user_assignment Table assigntype TINYINT 3 null
lesson_answers Table answer LONGTEXT 2147483647 null
goal_framework Table usermodified BIGINT 19 null
question_numerical Table id BIGINT 19 null
comp_record_history Table timeproficient BIGINT 19 null
facetoface_sessioncancel_info_field Table defaultdata LONGTEXT 2147483647 null
facetoface_signups Table sessionid BIGINT 19 null
oauth2_user_field_mapping Table usermodified BIGINT 19 null

The user who modified this record.

totara_dashboard_user Table userid BIGINT 19 null
blog_external Table url LONGTEXT 2147483647 null
tool_sitepolicy_policy_version Table versionnumber BIGINT 19 null

Version number of the policy

facetoface_sessioncancel_info_field Table required TINYINT 3 null
grade_settings Table name VARCHAR 255
enrol_paypal Table receiver_email VARCHAR 255
block_zoola_reports_schreps Table individualreports TINYINT 3 0

if 1 reports will be filtered for individual students

resource Table name VARCHAR 255
totara_userdata_export_type Table fullname VARCHAR 1333

Human readable name, mutlilang supported

questionnaire_survey Table feedbacknotes LONGTEXT 2147483647 null
questionnaire_question Table result_id BIGINT 19 null
cohort_msg_queue Table timemodified BIGINT 19 null
logstore_standard_log Table contextlevel BIGINT 19 null
enrol_paypal Table option_name1 VARCHAR 255
scorm Table course BIGINT 19 0
appraisal_role_changes Table timecreated BIGINT 19 0
report_builder_cache Table schedule BIGINT 19 null
tool_sitepolicy_consent_options Table idnumber VARCHAR 255 null

Custom identification of consent option

lesson Table maxpages SMALLINT 5 0
tool_monitor_events Table contextlevel BIGINT 19 null

Context level

qtype_randomsamatch_options Table incorrectfeedbackformat TINYINT 3 0
comp Table proficiencyexpected BIGINT 19 null
auth_approved_request Table country VARCHAR 2
quiz Table password VARCHAR 255

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

question_truefalse Table falseanswer BIGINT 19 0

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

grade_items Table aggregationcoef DECIMAL 10 0.00000

Aggregation coefficient used for category weights or other aggregation types

quiz Table course BIGINT 19 0

Foreign key reference to the course this quiz is part of.

glossary_alias Table id BIGINT 19 null
enrol_lti_tools Table membersyncmode BIT 1 0
goal_user_type Table description LONGTEXT 2147483647 null
assignment_submissions Table mailed BIT 1 0
org_competencies Table id BIGINT 19 null
user_devices Table platform VARCHAR 32

the device platform, Android or iOS etc

comp_type_info_data_param Table id BIGINT 19 null
dp_program_settings Table id BIGINT 19 null
question_ddwtos Table shuffleanswers SMALLINT 5 1
feedback_item Table position SMALLINT 5 0
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.

mnet_rpc Table pluginname VARCHAR 20
log_display Table action VARCHAR 40
prog_courseset Table certifpath TINYINT 3 1

1=standard program path or certify path, 2=recertify path

reportbuilder_grp_cohort_record Table id BIGINT 19 null
comp Table sortthread VARCHAR 255 null
tool_sitepolicy_user_consent Table language VARCHAR 30

Language used when user consented

totara_userdata_user Table usercontextid BIGINT 19 null

User context id, we need the value here because user deletion removes user context record

totara_userdata_export_type_item Table timechanged BIGINT 19 null

Last time when the export field was changed

feedback360_user_assignment Table userid BIGINT 19 null
scorm_aicc_session Table scormmode VARCHAR 50 null
course_modules Table added BIGINT 19 0
forum_read Table forumid BIGINT 19 0
qtype_match_subquestions Table answertext VARCHAR 255
message_read Table eventtype VARCHAR 100 null
qtype_match_subquestions Table questiontext LONGTEXT 2147483647 null
dp_template Table isdefault BIT 1 0

To indicate if this is the default template

auth_approved_request_snapshots Table confirmtoken VARCHAR 100 null
cohort_visibility Table usermodified BIGINT 19 null
appraisal_grp_pos Table appraisalid BIGINT 19 null
chat_messages_current Table chatid BIGINT 19 0
facetoface_signups Table jobassignmentid BIGINT 19 null

If required, the job the user is doing the training for

scale_history Table source VARCHAR 255 null

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

prog Table available BIGINT 19 0
external_functions Table services VARCHAR 1333 null

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

report_builder_columns Table reportid BIGINT 19 null

ID of the report this column belongs to

question Table qtype VARCHAR 20
facetoface Table maxmanagerreserves INT 10 1

How many reservations can each manager make

survey Table introformat SMALLINT 5 0

intro text field format

feedback_completedtmp Table timemodified BIGINT 19 0
competency_userevidence Table description LONGTEXT 2147483647 null
question_response_analysis Table timemodified BIGINT 19 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)

survey_answers Table answer2 LONGTEXT 2147483647 null
assignfeedback_file Table id BIGINT 19 null
assign Table allowsubmissionsfromdate BIGINT 19 0

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

question_attempt_steps Table state VARCHAR 13

One of the constants defined by the question_state class, giving the state of the question at the end of this step.

external_services Table downloadfiles BIT 1 0

1 if the service allow people to download file from webservice/plugins.php - 0 if not

goal_grp_cohort Table cohortid BIGINT 19 null
facetoface_notification_hist Table id BIGINT 19 null
data Table timeviewto BIGINT 19 0
totara_userdata_export Table id BIGINT 19 null
assignsubmission_file Table numfiles BIGINT 19 0

The number of files the student submitted.

report_builder Table shortname VARCHAR 255

Unique shortname used internally as a unique way of identifying a report

block_rss_client Table preferredtitle VARCHAR 64
data_content Table content2 LONGTEXT 2147483647 null
wiki_subwikis Table wikiid BIGINT 19 0

Wiki activity

comp_template_assignment Table id BIGINT 19 null
workshopform_rubric_levels Table grade DECIMAL 10 null

Grade representing this level.

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)

portfolio_instance_config Table value LONGTEXT 2147483647 null

config value

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.

pos_type_info_field Table param3 LONGTEXT 2147483647 null
profiling Table totalcputime BIGINT 19 null

time (in microseconds) spent by the CPU in this run

questionnaire_survey Table feedbacksections TINYINT 3 0
facetoface_cancellation_info_field Table description LONGTEXT 2147483647 null
comp_record Table id BIGINT 19 null
groupings Table name VARCHAR 255

Short human readable unique name for group.

prog_completion Table timestarted BIGINT 19 0
totara_connect_sso_sessions Table timecreated BIGINT 19 null
prog_user_assignment Table exceptionstatus BIGINT 19 0
cohort_rule_collections Table modifierid BIGINT 19 null
competency_evidence Table note LONGTEXT 2147483647 null

A non-localised text to attach to the evidence.

facetoface_session_info_field Table required TINYINT 3 null
reminder_sent Table reminderid BIGINT 19 null
appraisal_stage_role_setting Table appraisalrole SMALLINT 5 null
course_completions Table invalidatecache BIT 1 0

Deprecated since Totara 10, please do not use

facetoface_room Table custom BIT 1 0

1 means room is created secifically for one session only and cannot be reused

lesson Table deadline BIGINT 19 0
auth_approved_request_snapshots Table middlename VARCHAR 255 null
data_fields Table param6 LONGTEXT 2147483647 null
block_quicklinks Table url VARCHAR 255
reminder_sent Table messageid BIGINT 19 null
book_chapters Table pagenum BIGINT 19 0
resource_old Table newmodule VARCHAR 50 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.

assign_grades Table timemodified BIGINT 19 0

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

quiz Table name VARCHAR 255

Quiz name.

auth_connect_user_collections Table cohortid BIGINT 19 null
goal_type_info_data Table fieldid BIGINT 19 null
scale_history Table userid BIGINT 19 0
prog_messagelog Table coursesetid BIGINT 19 0
assignment_submissions Table timemodified BIGINT 19 0
goal_user_info_data Table goal_userid BIGINT 19 null
message Table timecreated BIGINT 19 0
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.

dp_plan_program_assign Table planid BIGINT 19 null

Identifies the plan this program is attached to

facetoface_signup_info_field Table shortname VARCHAR 100 null
enrol_lti_lti2_share_key Table resourcelinkid BIGINT 19 null
user_enrolments Table userid BIGINT 19 null
mnetservice_enrol_courses Table fullname VARCHAR 254
wiki_links Table topageid BIGINT 19 0

Page id that recives a link

reportbuilder_grp_user_record Table reportbuilderrecordid BIGINT 19 null
grade_outcomes Table descriptionformat TINYINT 3 0
files Table referencefileid BIGINT 19 null

Use to indicate file is a proxy for repository file

questionnaire_survey Table theme VARCHAR 64 null
appraisal_history Table timecreated BIGINT 19 null
wiki Table id BIGINT 19 null
dp_plan_component_relation Table itemid1 BIGINT 19 null

Identifier for the first component in the relation

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#

appraisal_scale_data Table appraisalscalevalueid BIGINT 19 null
tool_sitepolicy_user_consent Table consentoptionid BIGINT 19 null

Which option the user consented to

grade_grades_history Table action BIGINT 19 0

created/modified/deleted constants

portfolio_log Table continueurl VARCHAR 255

the url the external system has set to view the transfer

message_metadata Table urgency SMALLINT 5 null

The message urgency

prog_info_field Table defaultdata LONGTEXT 2147483647 null
dp_plan_evidence_info_field Table id BIGINT 19 null
url Table introformat SMALLINT 5 0
comp_criteria_record Table id BIGINT 19 null
course_modules Table completion BIT 1 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

quiz_attempts Table currentpage BIGINT 19 0
task_scheduled Table disabled BIT 1 0

1 means do not run from cron

backup_logs Table backupid VARCHAR 32

backupid the log record belongs to

prog_info_field Table param1 LONGTEXT 2147483647 null
errorlog Table build VARCHAR 255 null
enrol_flatfile Table id BIGINT 19 null
dp_objective_scale Table defaultid BIGINT 19 null

Identifies the id of the default scale value

chat_users Table sid VARCHAR 32
assign_grades Table attemptnumber BIGINT 19 0

The attempt number that this grade relates to

totara_compl_import_cert Table certificationshortname VARCHAR 255 null

certification shortname

appraisal_grp_cohort Table appraisalid BIGINT 19 null
log_queries Table info LONGTEXT 2147483647 null

detailed info such as error text

tool_customlang_components Table id BIGINT 19 null
scorm_scoes Table id BIGINT 19 null
course_modules Table deletioninprogress BIT 1 0
comp_criteria_record Table itemid BIGINT 19 null
chat_users Table ip VARCHAR 45
course_categories Table certifcount BIGINT 19 0

Totara certification count from totara_program

stats_user_monthly Table stattype VARCHAR 30
gradingform_guide_comments Table description LONGTEXT 2147483647 null

The comment description

glossary_entries Table fullmatch TINYINT 3 1
task_scheduled Table day VARCHAR 25
grade_grades Table userid BIGINT 19 null

The user who this grade is for

data Table assesstimestart BIGINT 19 0
dp_plan_competency_assign Table competencyid BIGINT 19 null

Identifies the competency being assigned

goal Table visible TINYINT 3 null
qtype_match_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

totara_connect_clients Table status BIT 1 null

0 means ok, anything else means do not talk with the client system

org_relations Table id1 BIGINT 19 null
reportbuilder_grp_org_user Table reportbuilderuserid BIGINT 19 null
competency_modulecomp Table competencyid BIGINT 19 null

The course competency this activity is linked to.

lesson_branch Table retry BIGINT 19 0
workshopallocation_scheduled Table workshopid BIGINT 19 null

workshop id we are part of

facetoface_cancellation_info_data Table data LONGTEXT 2147483647 null
message Table timeusertodeleted BIGINT 19 0
lti_tool_settings Table toolproxyid BIGINT 19 null

Primary key of related tool proxy

grade_items_history Table itemmodule VARCHAR 30 null

'forum', 'quiz', 'csv', etc

reminder_message Table copyto LONGTEXT 2147483647 null
data_content Table content1 LONGTEXT 2147483647 null
profiling Table totalexecutiontime BIGINT 19 null

time (in microseconds) spent by the run

forum Table timemodified BIGINT 19 0
mnet_remote_rpc Table plugintype VARCHAR 20
facetoface_sessions Table timemodified BIGINT 19 0
choice Table allowmultiple TINYINT 3 0
facetoface Table reservedays INT 10 2

Number days before the session when reservations are closed

scorm_scoes_data Table name VARCHAR 255
competency_templatecomp Table id BIGINT 19 null
assignfeedback_comments Table assignment BIGINT 19 0
course Table summary LONGTEXT 2147483647 null
cohort_role Table timecreated BIGINT 19 null
assignsubmission_onlinetext Table onlineformat SMALLINT 5 0

The format for this online text submission.

log_queries Table exectime DECIMAL 10 null

query execution time in seconds as float

appraisal Table description LONGTEXT 2147483647 null
reportbuilder_grp_user_record Table userid BIGINT 19 null
forum_discussion_subs Table forum BIGINT 19 null
goal_type_info_field Table defaultdata LONGTEXT 2147483647 null
competency_userevidence Table id BIGINT 19 null
competency_framework Table visible TINYINT 3 1

Used to show/hide this competency framework.

question_response_analysis Table whichtries VARCHAR 255
totara_connect_client_courses Table clientid BIGINT 19 null
reminder Table deleted BIT 1 null
competency_usercompcourse Table competencyid BIGINT 19 null

Competency associated to the user.

course_published Table timechecked BIGINT 19 null

the last time the status has been checked

enrol_lti_tools Table city VARCHAR 120
wiki Table editend BIGINT 19 0

editend

forum Table blockperiod BIGINT 19 0
qtype_multichoice_options Table incorrectfeedbackformat TINYINT 3 0
role_sortorder Table userid BIGINT 19 null
totara_userdata_purge_type Table usercreated BIGINT 19 null

Who added this type

goal_personal Table assigntype TINYINT 3 null
questionnaire_response Table complete VARCHAR 1 n
event Table type SMALLINT 5 0

Totara: Not used as a part of Moodle's new Course Overview Block (MDL-55611)

local_ld_import_logs_status Table adhoctaskid BIGINT 19 null

Import logs task id

glossary Table entbypage SMALLINT 5 10
enrol Table customint6 BIGINT 19 null

Custom - general int

report_builder_filters Table sortorder BIGINT 19 null

Determines the order that the filters appear in the report

scorm_scoes_track Table id BIGINT 19 null
user Table trustbitmask BIGINT 19 0
course_completion_crit_compl Table unenroled BIGINT 19 null

Timestamp when the user was unenroled

messageinbound_messagelist Table address LONGTEXT 2147483647 null

The Inbound Message address that the message was originally sent to

tag_area Table component VARCHAR 100
report_builder_global_restriction Table allrecords BIT 1 0

True means no restrictions

cohort_rule_params Table modifierid BIGINT 19 null
auth_connect_user_collections Table collectionid BIGINT 19 null

server id of cohort, course

oauth2_endpoint Table timemodified BIGINT 19 null

The time this record was modified.

gradingform_guide_criteria Table descriptionformat TINYINT 3 null

The format of the description field

certificate Table timecreated BIGINT 19 0
appraisal_quest_field Table param4 LONGTEXT 2147483647 null
competency_templatecomp Table timemodified BIGINT 19 null

The time this link was modified.

org_framework Table sortorder BIGINT 19 null
course_completion_log Table description LONGTEXT 2147483647 null

Description of what changed, English only

certificate_issues Table certificateid BIGINT 19 0
job_assignment Table description LONGTEXT 2147483647 null
facetoface_cancellation_info_data Table id BIGINT 19 null
pos_framework Table description LONGTEXT 2147483647 null
comp_record Table positionid BIGINT 19 null
quiz Table decimalpoints SMALLINT 5 2

Number of decimal points to use when displaying grades.

editor_atto_autosave Table draftid BIGINT 19 null

Optional draft area id containing draft files.

cohort_rulesets Table modifierid BIGINT 19 null
user Table phone1 VARCHAR 20
course_published Table hubcourseid BIGINT 19 null

the course id on the hub server

pos_type Table timecreated BIGINT 19 null
course_info_field Table sortorder BIGINT 19 null
question_ddwtos Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

grade_items Table hidden BIGINT 19 0

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

grading_definitions Table descriptionformat TINYINT 3 null

Format of the description field

wiki_synonyms Table pagesynonym VARCHAR 255 Pagesynonym

Page name synonym

prog_completion Table programid BIGINT 19 0
lti_types Table timecreated BIGINT 19 null
pos_framework Table id BIGINT 19 null
facetoface_session_info_field Table forceunique TINYINT 3 null
quiz_attempts Table quiz BIGINT 19 0

Foreign key reference to the quiz that was attempted.

feedback_completed Table timemodified BIGINT 19 0
scorm Table skipview BIT 1 1
comp_type_info_field Table locked TINYINT 3 null
mnet_session Table useragent VARCHAR 40

SHA1 hash of User Agent

block_zoola_reports_schreps Table bodyformat SMALLINT 5 0
cohort Table active BIT 1 0

Totara active flag from totara_cohort

certificate_issues_history Table timearchived BIGINT 19 null
report_builder_settings Table id BIGINT 19 null
grade_grades_history Table information LONGTEXT 2147483647 null

optiona information

questionnaire_quest_choice Table question_id BIGINT 19 0
editor_atto_autosave Table id BIGINT 19 null
user_info_field Table visible SMALLINT 5 0

Visibility: private, public, hidden

event Table eventtype VARCHAR 20
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

auth_connect_servers Table clientidnumber VARCHAR 64

World unique client ID, server is using it in client requests

quiz Table showblocks SMALLINT 5 0

Whether blocks should be shown on the attempt.php and review.php pages.

external_services_users Table externalserviceid BIGINT 19 null
stats_monthly Table stat1 BIGINT 19 0

stat1. usually used for reads

course_sections Table availability LONGTEXT 2147483647 null

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

log_display Table component VARCHAR 100

owner of the log action

badge_criteria_param Table id BIGINT 19 null
tool_monitor_rules Table name VARCHAR 254

Name of the rule

question_statistics Table negcovar TINYINT 3 0
prog_assignment Table id BIGINT 19 null
grade_items Table gradepass DECIMAL 10 0.00000

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

page Table timemodified BIGINT 19 0
glossary Table assesstimestart BIGINT 19 0
goal_item_history Table itemid BIGINT 19 null
competency_template Table id BIGINT 19 null
gap_aspirational Table usermodified BIGINT 19 null
grade_grades_history Table feedback LONGTEXT 2147483647 null

grading feedback

lesson Table displayleftif SMALLINT 5 0
competency_template Table timemodified BIGINT 19 null

The time this learning plan template was last modified.

tool_recyclebin_category Table shortname VARCHAR 255
user_devices Table timemodified BIGINT 19 null
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_answers Table id BIGINT 19 null
quiz_sections Table id BIGINT 19 null
reportbuilder_grp_user_user Table id BIGINT 19 null
grade_items_history Table grademax DECIMAL 10 100.00000

What is the maximum allowable grade?

enrol_lti_lti2_resource_link Table shareapproved BIT 1 null
tool_monitor_rules Table eventname VARCHAR 254

Fully qualified name of the event

qtype_match_options Table incorrectfeedbackformat TINYINT 3 0
glossary Table rssarticles TINYINT 3 0
course_info_field Table param1 LONGTEXT 2147483647 null
workshop_assessments Table weight BIGINT 19 1

The weight of the assessment for the purposes of aggregation

competency_usercompcourse Table userid BIGINT 19 null

User associated to the competency.

groups Table descriptionformat TINYINT 3 0
appraisal_role_assignment Table userid BIGINT 19 null
grade_categories_history Table id BIGINT 19 null
grade_grades Table hidden BIGINT 19 0

show 0, hide 1 or hide until date

data_fields Table param5 LONGTEXT 2147483647 null
user_password_resets Table id BIGINT 19 null
competency_coursecompsetting Table timecreated BIGINT 19 null

The time this setting was created.

report_builder_graph Table type VARCHAR 20

Type of graph, empty means none

enrol Table roleid BIGINT 19 0

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

cohort_msg_queue Table cohortid BIGINT 19 null
dp_priority_scale_value Table numericscore DECIMAL 10 null
scorm_scoes_data Table id BIGINT 19 null
feedback Table timemodified BIGINT 19 0
totara_connect_sso_sessions Table clientid BIGINT 19 null
repository_instance_config Table value LONGTEXT 2147483647 null
lti_tool_proxies Table timecreated BIGINT 19 null

Date/time at which the record was created

report_builder Table hidden SMALLINT 5 0

If set to 1, report not shown on My Reports page but still accessible at URL

tool_sitepolicy_policy_version Table timecreated BIGINT 19 null

Timestamp of when the policy version was created

qtype_ddmarker Table shownumcorrect TINYINT 3 0
feedback_template Table name VARCHAR 255
enrol_lti_users Table sourceid LONGTEXT 2147483647 null
user Table institution VARCHAR 255
enrol_paypal Table memo VARCHAR 255
certificate Table printoutcome BIGINT 19 0
comp_criteria_record Table timecreated BIGINT 19 null
dp_plan_settings Table templateid BIGINT 19 null

Identifies the template these settings should be applied to

enrol_lti_tools Table timemodified BIGINT 19 null
block_totara_featured_links_tiles Table presetshowing BIT 1 0

This field holds whether the preset rules are to be applied

chat_users Table userid BIGINT 19 0
forum_posts Table userid BIGINT 19 0
facetoface_notification Table booked BIT 1 0
block_zoola_reports Table uri VARCHAR 1333

Report URI

scorm_seq_ruleconds Table action VARCHAR 25
gradingform_guide_criteria Table sortorder BIGINT 19 null

Defines the order of the criterion in the guide

files Table contenthash VARCHAR 40

sha1 hash of file content

totara_userdata_purge Table userid BIGINT 19 null

The target user

user Table suspended BIT 1 0

suspended flag prevents users to log in

feedback_template Table course BIGINT 19 0
label Table intro LONGTEXT 2147483647 null
certificate Table emailteachers BIT 1 0
chat_messages_current Table issystem BIT 1 0
assignment_submissions Table userid BIGINT 19 0
cohort_plan_config Table excludecreatedmanual BIT 1 1

Exclude auto plan creation for users who have an existing, manually created plan based on the template id

auth_approved_request_snapshots Table resolvedby BIGINT 19 null
workshop Table introformat SMALLINT 5 0

The format of the intro field

totara_connect_sso_sessions Table userid BIGINT 19 null
appraisal_stage_data Table realusercompleted BIGINT 19 null
message_read Table component VARCHAR 100 null
prog_info_data Table fieldid BIGINT 19 null
questionnaire_question Table position BIGINT 19 0
assignment_submissions Table timemarked BIGINT 19 0
survey_questions Table intro VARCHAR 50
logstore_standard_log Table eventname VARCHAR 255
facetoface_notification Table courseid BIGINT 19 null
mnet_host2service Table subscribe BIT 1 0
enrol_lti_lti2_resource_link Table ltiresourcelinkkey VARCHAR 255
facetoface_session_info_field Table datatype VARCHAR 255 null
totara_compl_import_course Table importevidence BIT 1 0

imported into evidence

external_functions Table classname VARCHAR 100
facetoface_cancellation_info_field Table defaultdata LONGTEXT 2147483647 null
survey_analysis Table userid BIGINT 19 0
qtype_ddmarker Table id BIGINT 19 null
questionnaire_response_bool Table response_id BIGINT 19 0
scale_history Table description LONGTEXT 2147483647 null
tool_sitepolicy_localised_consent Table id BIGINT 19 null
block_zoola_reports_eventcfg Table enabled BIT 1 1

Is this schedule enabled

competency_plan Table templateid BIGINT 19 null
reportbuilder_grp_org_record Table id BIGINT 19 null
messageinbound_handlers Table component VARCHAR 100

The component this handler belongs to.

user Table address VARCHAR 255
lti Table secureicon LONGTEXT 2147483647 null
backup_controllers Table type VARCHAR 10

Type of the backup (activity/section/course)

totara_connect_client_courses Table timecreated BIGINT 19 null
appraisal_user_event Table timescheduled BIGINT 19 null
facetoface Table thirdpartywaitlist BIT 1 0

Set to 1 if the third party wants to receive signups/cancellations about wait-listed sessions, 0 otherwise.

grade_outcomes_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

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.

role_allow_switch Table roleid BIGINT 19 null

The role the user has.

repository_instances Table username VARCHAR 255 null
question_ddwtos Table shownumcorrect TINYINT 3 0
course Table timecreated BIGINT 19 0
mnet_application Table sso_jump_url VARCHAR 255
enrol_lti_users Table lastgrade DECIMAL 10 null

The last grade that was sent

assignfeedback_editpdf_annot Table id BIGINT 19 null
goal_user_info_field Table id BIGINT 19 null
prog_completion Table id BIGINT 19 null
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.

comp_type_info_field Table param3 LONGTEXT 2147483647 null
report_builder_filters Table type VARCHAR 255

Type of filter, used with value to identify the filter option

catalog Table ftsmedium LONGTEXT 2147483647 null
question_usages Table preferredbehaviour VARCHAR 32

The archetypal behaviour that should be used for question attempts in this usage.

cohort Table cohorttype BIGINT 19 1

Totara cohort type from totara_cohort, 1 is static 2 is dynamic

enrol_lti_lti2_consumer Table id BIGINT 19 null
scorm_seq_rulecond Table refrencedobjective VARCHAR 255
comp_framework Table fullname VARCHAR 1024
prog_info_field Table hidden TINYINT 3 null
goal_type_info_field Table shortname VARCHAR 100 null
mnet_service Table name VARCHAR 40
goal_scale_values Table scaleid BIGINT 19 null
totara_userdata_purge_type Table idnumber VARCHAR 255

Unique plain text identifier

report_builder Table description LONGTEXT 2147483647 null

Description of the report

lti_types Table enabledcapability LONGTEXT 2147483647 null

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

dp_plan Table timecompleted BIGINT 19 null

Timestamp of the completed date plan

appraisal_event_message Table appraisaleventid BIGINT 19 null
tag_instance Table itemid BIGINT 19 null
user_devices Table appid VARCHAR 128

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

pos Table timevalidfrom BIGINT 19 null
lock_db Table owner VARCHAR 36 null

uuid indicating the owner of the lock.

certif_completion_history Table id BIGINT 19 null
tag_coll Table isdefault TINYINT 3 0
report_builder_schedule Table reportid BIGINT 19 null
workshop Table intro LONGTEXT 2147483647 null

The introduction or description of the activity

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

tool_sitepolicy_user_consent Table userid BIGINT 19 null

The user whose answered this is

post Table created BIGINT 19 0
dp_objective_scale Table id BIGINT 19 null
feedback Table completionsubmit BIT 1 0

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

forum Table scale BIGINT 19 0
competency_userevidence Table userid BIGINT 19 null
mnet_service Table id BIGINT 19 null

Unique Service ID

auth_connect_servers Table clientsecret VARCHAR 64

Secret the server is using in client requests

upgrade_log Table timemodified BIGINT 19 null
forum Table course BIGINT 19 0
assign_user_flags Table userid BIGINT 19 0

The id of the user these flags apply to.

external_functions Table id BIGINT 19 null
stats_daily Table courseid BIGINT 19 0
messageinbound_handlers Table id BIGINT 19 null
external_services Table enabled BIT 1 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.

reportbuilder_grp_pos_record Table timecreated BIGINT 19 0
badge Table issuerurl VARCHAR 255
appraisal Table id BIGINT 19 null
cohort Table name VARCHAR 254

Short human readable name for the cohort, does not have to be unique

enrol_lti_lti2_user_result Table updated BIGINT 19 null
course_format_options Table format VARCHAR 21

Format this option is for

cohort_rulesets Table rulecollectionid BIGINT 19 null
enrol_lti_lti2_consumer Table toolproxy LONGTEXT 2147483647 null
post Table courseid BIGINT 19 0
totara_userdata_purge_item Table component VARCHAR 100

Plugin name or subsystem, e.g. mod_glossary, core_user

mnetservice_enrol_courses Table hostid BIGINT 19 null

The id of the remote MNet host

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.

scorm_seq_rolluprule Table conditioncombination VARCHAR 3 all
goal_user_type_cohort Table usermodified BIGINT 19 null
logstore_standard_log Table ip VARCHAR 45 null

IP address

assignfeedback_editpdf_annot Table endx BIGINT 19 0

x-position of the end of the annotation

prog_courseset Table coursesumfieldtotal SMALLINT 5 0
quiz_statistics Table lastattemptscount BIGINT 19 null
grade_items Table gradetype SMALLINT 5 1

0 = none, 1 = value, 2 = scale, 3 = text

feedback360_user_assignment Table timedue BIGINT 19 0
comp_type_info_field Table forceunique TINYINT 3 null
appraisal_event Table appraisalid BIGINT 19 null
prog Table assignmentsdeferred BIT 1 0

Indicates that user assignments need to be updated

certificate_issues_history Table userid BIGINT 19 0
block_recent_activity Table id BIGINT 19 null
comp_type Table usermodified BIGINT 19 null
report_builder_columns Table aggregate VARCHAR 30 null

Aggregation type, null means none

goal_user_type Table usermodified BIGINT 19 null
dp_permissions Table id BIGINT 19 null
survey Table questions VARCHAR 255
question_calculated_options Table correctfeedbackformat TINYINT 3 0
user Table lastlogin BIGINT 19 0
question_ddwtos Table incorrectfeedbackformat TINYINT 3 0
cohort_rules Table ruletype VARCHAR 255
totara_connect_client_org_frameworks Table clientid BIGINT 19 null
portfolio_tempdata Table instance BIGINT 19 0

which portfolio plugin instance is being used

assign Table markingallocation TINYINT 3 0

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

data Table approval SMALLINT 5 0
certificate Table customtext LONGTEXT 2147483647 null
events_queue Table timecreated BIGINT 19 null

time stamp of the first time this was added

role_capabilities Table permission BIGINT 19 0
report_builder_cache Table id BIGINT 19 null
prog_info_field Table param2 LONGTEXT 2147483647 null
block_positions Table region VARCHAR 16

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

quiz_attempts Table layout LONGTEXT 2147483647 null
lesson_pages Table timecreated BIGINT 19 0
lti_tool_settings Table course BIGINT 19 null

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

comp Table aggregationmethod TINYINT 3 null
competency_framework Table id BIGINT 19 null
mnet_host Table last_connect_time BIGINT 19 0
message Table id BIGINT 19 null
gradingform_guide_criteria Table id BIGINT 19 null
backup_controllers Table itemid BIGINT 19 null

id of the module/section/activity being backup

role_assignments Table sortorder BIGINT 19 0
prog Table timecreated BIGINT 19 0
report_builder_schedule Table frequency BIGINT 19 null
certificate_issues_history Table code VARCHAR 40 null

Copy of the 10-digit code that can be printed on the certificate

block_positions Table id BIGINT 19 null
page Table id BIGINT 19 null
lesson Table modattempts SMALLINT 5 0
course_completion_crit_compl Table criteriaid BIGINT 19 0

Completion criteria this references

goal_record Table scalevalueid BIGINT 19 null
mnet_session Table mnethostid BIGINT 19 0

Unique remote host ID

local_ld_module Table coursemoduleid BIGINT 19 null

Foreign key to the course_modules table

quiz_statistics Table hashcode VARCHAR 40

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

event Table priority BIGINT 19 null

Totara: Not used as a part of Moodle's new Course Overview Block (MDL-55611). 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_multianswer Table id BIGINT 19 null
gradingform_guide_criteria Table descriptionmarkers LONGTEXT 2147483647 null

Description for Markers

totara_compl_import_cert Table rownumber BIGINT 19 null

Row number in the csv file

chat_messages Table timestamp BIGINT 19 0
dp_plan Table createdby BIT 1 0

Integer to identify if the plan has been create by an automatic process

gradingform_rubric_criteria Table descriptionformat TINYINT 3 null

The format of the description field

course_modules_completion Table viewed BIT 1 null

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

report_builder_columns Table id BIGINT 19 null
badge Table courseid BIGINT 19 null
report_builder_columns Table hidden SMALLINT 5 0

If non zero then column is hidden from users by default

competency_userevidence Table timemodified BIGINT 19 null
course_info_field Table locked BIT 1 null
stats_user_weekly Table courseid BIGINT 19 0
auth_approved_request_snapshots Table firstname VARCHAR 100 null
comp Table fullname VARCHAR 1024 null
feedback_value Table completed BIGINT 19 0
data_fields Table param1 LONGTEXT 2147483647 null
data Table comments SMALLINT 5 0
assignfeedback_editpdf_annot Table gradeid BIGINT 19 0
scorm_scoes_data Table scoid BIGINT 19 0
workshop Table instructreviewersformat SMALLINT 5 0
certificate_issues_history Table timecompleted BIGINT 19 null

Date/Time completed at the time the certificate was archived.

log Table userid BIGINT 19 0
report_builder_graph Table series LONGTEXT 2147483647 null

Series info encoded in json format

book Table name VARCHAR 255
qtype_randomsamatch_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

feedback Table introformat SMALLINT 5 0
goal_user_type Table timemodified BIGINT 19 null
appraisal_user_assignment Table activestageid BIGINT 19 null
tag Table tagcollid BIGINT 19 null
course_completions Table userid BIGINT 19 0
competency_framework Table scaleid BIGINT 19 null

Scale used to define competency.

assignfeedback_editpdf_annot Table colour VARCHAR 10 black

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

capabilities Table id BIGINT 19 null
competency_userevidence Table usermodified BIGINT 19 null
questionnaire_question Table type_id BIGINT 19 0
questionnaire_survey Table thanks_page VARCHAR 255 null
role_assignments Table modifierid BIGINT 19 0
block_recent_activity Table cmid BIGINT 19 null

Course module id

events_queue_handlers Table errormessage LONGTEXT 2147483647 null

if an error happened last time we tried to process this event, record it here.

wiki_pages Table timemodified BIGINT 19 0

page edition timestamp

course_completion_criteria Table timeend BIGINT 19 null

Timestamp of the date for course completion (if using date criteria type)

enrol_lti_lti2_consumer Table consumerguid VARCHAR 1024 null
choice Table display SMALLINT 5 0
block_totara_featured_links_tiles Table timemodified BIGINT 19 0

The last time that the tile was modified

workshopeval_best_settings Table id BIGINT 19 null
facetoface_cancellation_info_field Table param3 LONGTEXT 2147483647 null
user Table lastip VARCHAR 45
role_capabilities Table id 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.

tool_usertours_tours Table id BIGINT 19 null
event Table id BIGINT 19 null
competency_relatedcomp Table timecreated BIGINT 19 null
data Table timemodified BIGINT 19 0

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

local_ld_course_day Table id BIGINT 19 null
local_ld_import_logs_status Table progress DECIMAL 10 0.00

Percentage of work done (0 - 100)

survey_questions Table text VARCHAR 255
data Table timeavailableto BIGINT 19 0
forum Table type VARCHAR 20 general
questionnaire_resp_single Table response_id BIGINT 19 0
post Table summaryformat TINYINT 3 0
facetoface_session_info_field Table param1 LONGTEXT 2147483647 null
mnet_service Table description VARCHAR 40
totara_userdata_purge_type_item Table timechanged BIGINT 19 null

Last time when the purge field was changed

user_devices Table uuid VARCHAR 255

The device vendor UUID

scorm_seq_mapinfo Table writesatisfiedstatus BIT 1 0
questionnaire Table sid BIGINT 19 0

The id entry in the questionnaire_survey field.

facetoface_room_info_field Table param2 LONGTEXT 2147483647 null
gradingform_rubric_criteria Table sortorder BIGINT 19 null

Defines the order of the criterion in the rubric

totara_userdata_purge Table result BIGINT 19 null

null means not finished, -1 completed ok, -2 means error, -3 means skipped, -4 cancelled, -5 timed out

prog_recurrence Table id BIGINT 19 null
questionnaire Table qtype BIGINT 19 0

Questionnaire type code.

assign_user_mapping Table userid BIGINT 19 0
workshop_submissions Table workshopid BIGINT 19 null

the id of the workshop instance

qtype_ddimageortext_drags Table infinite SMALLINT 5 0
local_ld_module_day Table daytime BIGINT 19 null

Timestamp of the beginning of the day

scale_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

prog_info_data_param Table value VARCHAR 32
portfolio_instance_config Table name VARCHAR 255

config field

grade_import_values Table newgradeitem BIGINT 19 null

if set, points to the id of grade_import_newitem

facetoface_sessions Table capacity BIGINT 19 0

Number of students who can enroll in this session. A value of 0 means unlimited.

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

feedback360_quest_field Table feedback360id BIGINT 19 null
totara_userdata_user Table timedeletedpurged BIGINT 19 null

Last time the user was purged with the selected type, resets to null after type change

badge_issued Table id BIGINT 19 null
block_zoola_reports_schreps Table starttime BIGINT 19 null

Time when the report should run for the first time. 0 means run immediately.

dp_objective_settings Table duedatemode SMALLINT 5 0
resource Table legacyfiles SMALLINT 5 0
forum_digests Table id BIGINT 19 null
user_password_resets Table timererequested BIGINT 19 0

The time the user re-requested the password reset.

facetoface_session_info_field Table id BIGINT 19 null
lesson_timer Table id BIGINT 19 null
dp_objective_scale_value Table objscaleid BIGINT 19 null

Identifies the objective scale id this value belongs to

external_tokens Table sid VARCHAR 128 null

link to browser or emulated session

lesson Table intro LONGTEXT 2147483647 null
facetoface Table waitlistautoclean BIT 1 0
quiz_attempts Table timemodifiedoffline BIGINT 19 0

Last modified time via web services.

forum_posts Table parent BIGINT 19 0
grade_categories_history Table depth BIGINT 19 0

How many parents does this category have?

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.

feedback_sitecourse_map Table courseid BIGINT 19 0
questionnaire_question Table deleted VARCHAR 1 n
totara_sync_log Table time BIGINT 19 null

unix time

scorm_seq_objective Table scoid BIGINT 19 0
question_multianswer Table question BIGINT 19 0
quiz Table id BIGINT 19 null

Standard Moodle primary key.

scale_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

badge_backpack Table backpackuid BIGINT 19 null
message_read Table fullmessageformat SMALLINT 5 0

The format of the full message

question_hints Table options VARCHAR 255 null

A space for any other question-type specific options.

job_assignment Table sortorder BIGINT 19 null
scorm_seq_rolluprulecond Table cond VARCHAR 25
quiz Table delay2 BIGINT 19 0

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

badge_backpack Table id BIGINT 19 null
blog_external Table timefetched BIGINT 19 0
facetoface Table selectjobassignmentonsignup BIT 1 0

Users with multiple job assignments will select one on signup

comp_type_info_field Table typeid BIGINT 19 null
assign_user_flags Table mailed SMALLINT 5 0

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

facetoface_sessioncancel_info_field Table param4 LONGTEXT 2147483647 null
goal_scale Table id BIGINT 19 null
totara_connect_clients Table clienturl VARCHAR 255

Web address of the client system

badge_criteria Table badgeid BIGINT 19 0
dp_objective_scale_value Table description LONGTEXT 2147483647 null

The description of the scale value

question_categories Table name VARCHAR 255
questionnaire_question Table name VARCHAR 30 null
files Table id BIGINT 19 null
tool_customlang Table original LONGTEXT 2147483647 null

English original of the string

appraisal_quest_field Table appraisalstagepageid BIGINT 19 null
chat_messages Table groupid BIGINT 19 0
tool_recyclebin_course Table name VARCHAR 255 null
lti Table id BIGINT 19 null
facetoface Table declareinterest BIT 1 0

Allow users to declare interest in the facetoface

lesson_branch Table userid BIGINT 19 0
logstore_standard_log Table origin VARCHAR 10 null

cli, cron, ws, etc.

question_calculated_options Table synchronize TINYINT 3 0
goal_user_type_cohort Table id BIGINT 19 null
prog_assignment Table includechildren BIT 1 0
prog_completion_history Table organisationid BIGINT 19 null
catalog_search_metadata Table timecreated BIGINT 19 null
grade_categories_history Table hidden BIT 1 0
reportbuilder_grp_user_user Table reportbuilderuserid BIGINT 19 null
workshopform_numerrors Table description LONGTEXT 2147483647 null

The description of the dimension

repository_instances Table userid BIGINT 19 0
prog_exception Table id BIGINT 19 null
prog Table certifid BIGINT 19 null

FK to certification table

user_preferences Table name VARCHAR 255
portfolio_tempdata Table expirytime BIGINT 19 null

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

totara_connect_clients Table apiversion BIGINT 19 null

The API version used for communication with this client

lesson_pages Table timemodified BIGINT 19 0
config_plugins Table name VARCHAR 100
totara_userdata_user Table suspendedpurgetypeid BIGINT 19 null
certif_completion Table status TINYINT 3 null

Certification status

scorm_seq_objective Table satisfiedbymeasure BIT 1 1
enrol_lti_lti2_consumer Table profile LONGTEXT 2147483647 null
question Table name VARCHAR 255
feedback_completed Table anonymous_response BIT 1 0
competency_plan Table descriptionformat SMALLINT 5 0
certif Table recertifydatetype BIT 1 null

Indicator for which date is used for the recertification, either the completion date or the certificate expiry date

dp_priority_scale Table id BIGINT 19 null
facetoface_signup_info_field Table forceunique TINYINT 3 null
facetoface_interest Table facetoface BIGINT 19 0
facetoface_sessions_dates Table roomid BIGINT 19 null

Foreign key to facetoface_room

facetoface_asset Table name VARCHAR 100 null
totara_compl_import_course Table rownumber BIGINT 19 null

Row number in the csv file

oauth2_issuer Table loginparams LONGTEXT 2147483647 null

Additional parameters sent for a login attempt.

certificate Table printhours VARCHAR 255 null
folder Table timemodified BIGINT 19 0
facetoface_sessioncancel_info_field Table description LONGTEXT 2147483647 null
enrol_lti_tools Table membersync BIT 1 0
question_attempt_steps Table sequencenumber BIGINT 19 null

Numbers the steps in a question attempt sequentially.

quiz Table grademethod SMALLINT 5 1

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

data Table requiredentriestoview INT 10 0
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

qtype_ddmarker_drags Table noofdrags BIGINT 19 1

No of drag items, ignored if drag is infinite.

scorm Table popup BIT 1 0
feedback360_quest_field Table defaultdataformat BIT 1 null
enrol_lti_tools Table timezone VARCHAR 100 99
course_completion_history Table courseid BIGINT 19 null
enrol_lti_lti2_consumer Table name VARCHAR 50
report_builder_schedule Table nextreport BIGINT 19 null
dp_component_settings Table enabled SMALLINT 5 1

Controls if this component is available or not

assign Table introformat SMALLINT 5 0

The format of the description field of the assignment. This field is used by feature MOD_INTRO.

certificate_issues_history Table idarchived BIGINT 19 null
totara_userdata_user Table id BIGINT 19 null
lti Table introformat SMALLINT 5 0

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

resource_old Table migrated BIGINT 19 0
oauth2_issuer Table scopessupported LONGTEXT 2147483647 null

The list of scopes this service supports.

tool_customlang Table stringid VARCHAR 255

The identifier of the string

question_hints Table hintformat SMALLINT 5 0

The format of the hint.

prog Table timemodified BIGINT 19 0
filter_config Table id BIGINT 19 null
wiki_locks Table lockedat BIGINT 19 0

timestamp

prog_assignment Table assignmenttypeid BIGINT 19 0
org_framework Table description LONGTEXT 2147483647 null
wiki Table wikimode VARCHAR 20 collaborative

Wiki mode (individual, collaborative)

facetoface_signup_info_data Table data LONGTEXT 2147483647 null
forum Table assesstimefinish BIGINT 19 0
block Table name VARCHAR 40
workshop Table id BIGINT 19 null
workshopform_numerrors_map Table workshopid BIGINT 19 null

The id of the workshop

task_adhoc Table faildelay BIGINT 19 null
quiz_attempts Table preview SMALLINT 5 0
survey_answers Table userid BIGINT 19 0
assignsubmission_file Table assignment BIGINT 19 0
questionnaire_response_date Table response_id BIGINT 19 0
facetoface_sessions Table selfapproval BIT 1 0

Allow self approval

lesson Table feedback SMALLINT 5 1
goal_scale Table description LONGTEXT 2147483647 null
grade_categories Table timemodified BIGINT 19 null
grading_definitions Table description LONGTEXT 2147483647 null

More detailed description of the form

assignfeedback_editpdf_quick Table id BIGINT 19 null
report_builder_filters Table filtername VARCHAR 1024 null

Visible name describing the filter to report users

grade_outcomes Table fullname LONGTEXT 2147483647 null

The full description of the outcome (usually 1 sentence)

lti Table launchcontainer TINYINT 3 1

Launch external tool in a pop-up

enrol_paypal Table userid BIGINT 19 0
questionnaire_response_bool Table choice_id VARCHAR 1 y
enrol_lti_users Table membershipsurl LONGTEXT 2147483647 null
mnetservice_enrol_courses Table categoryid BIGINT 19 null

The id of the category on the remote server

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

facetoface_session_info_field Table showinsummary BIT 1 1

Whether or not to show this field in attendance exports and lists of sessions

event Table uuid VARCHAR 255
enrol_flatfile Table action VARCHAR 30
report_builder_saved Table reportid BIGINT 19 null

ID of the report this saved search belongs to

course Table cacherev BIGINT 19 0

Incrementing revision for validating the course content cache

course_completions Table course BIGINT 19 0
feedback360_quest_field Table param1 LONGTEXT 2147483647 null
facetoface_session_info_field Table param4 LONGTEXT 2147483647 null
reportbuilder_grp_pos_user Table id BIGINT 19 null
glossary_formats Table defaultmode VARCHAR 50
question_statistics Table positions LONGTEXT 2147483647 null

positions in which this item appears. Only used for random questions.

backup_courses Table lastendtime BIGINT 19 0
course Table visible BIT 1 1
org_competencies Table templateid BIGINT 19 null
repository Table type VARCHAR 255
course_request Table summary LONGTEXT 2147483647 null
block_instances Table common_config LONGTEXT 2147483647 null

Json encoded common block configuration data

sessions Table sessdata LONGTEXT 2147483647 null

session content

competency_plancomp Table usermodified BIGINT 19 null
cohort_plan_history Table completed BIT 1 null
quiz Table attemptonlast SMALLINT 5 0

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

grade_grades Table aggregationweight DECIMAL 10 null

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

facetoface_asset_info_field Table defaultdata LONGTEXT 2147483647 null
choice Table timemodified BIGINT 19 0
enrol_lti_tool_consumer_map Table consumerid BIGINT 19 null

The consumer ID.

report_builder_columns Table type VARCHAR 255

Type of column, used with value to identify the column option

prog Table sortorder BIGINT 19 0
appraisal_grp_pos Table includechildren BIT 1 null
goal_user_info_field Table shortname VARCHAR 100 null
resource_old Table timemodified BIGINT 19 0
reportbuilder_grp_org_record Table includechildren BIT 1 0
org Table id BIGINT 19 null
prog_courseset_course Table coursesetid BIGINT 19 0
prog_completion_history Table recurringcourseid BIGINT 19 0
course_completions Table id BIGINT 19 null
lti_types Table timemodified BIGINT 19 null
modules Table cron BIGINT 19 0
dp_priority_scale_value Table description LONGTEXT 2147483647 null

Description of the scale value

facetoface_session_info_field Table param2 LONGTEXT 2147483647 null
groups Table enrolmentkey VARCHAR 50 null
scorm Table width BIGINT 19 100
goal Table sortthread VARCHAR 255 null
facetoface_notification_sent Table userid BIGINT 19 0
cohort Table timecreated BIGINT 19 null
totara_dashboard_user Table dashboardid BIGINT 19 null
totara_compl_import_cert Table importuserid BIGINT 19 null

ID of user running the import

goal_user_info_field Table description LONGTEXT 2147483647 null
external_functions Table methodname VARCHAR 100
goal_type_info_field Table fullname VARCHAR 1024 null
forum Table displaywordcount BIT 1 0
dp_template Table startdate BIGINT 19 null

Timestamp for when plans based on this template start by default

comments Table component VARCHAR 255 null

The plugin this comment belongs to.

course_completions Table rpl VARCHAR 255 null

Totara recognition of prior learning from totara_core

appraisal_quest_field_role Table appraisalrole SMALLINT 5 null
pos Table sortthread VARCHAR 255 null
report_builder_saved Table name VARCHAR 255

A name describing the saved search

feedback360_grp_org Table orgid BIGINT 19 null
feedback360_scale Table scaletype TINYINT 3 null
org_competencies Table linktype TINYINT 3 0
appraisal_user_assignment Table jobassignmentlastmodified BIGINT 19 null
cohort_role Table timemodified BIGINT 19 null
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.

pos_framework Table usermodified BIGINT 19 null
auth_connect_servers Table id BIGINT 19 null
scorm_scoes Table manifest VARCHAR 255
feedback_completedtmp Table feedback BIGINT 19 0
report_builder_schedule_email_systemuser Table scheduleid BIGINT 19 null
org_type_info_field Table locked TINYINT 3 null
badge_criteria Table criteriatype BIGINT 19 null

The criteria type we are aggregating

appraisal_quest_field_role Table rights SMALLINT 5 null
tool_sitepolicy_localised_policy Table isprimary BIT 1 null

If the localised policy is the Admin's primary version

dp_plan_competency_assign Table duedate BIGINT 19 null

Timestamp of the date this competency is due to be completed.

facetoface_sessioncancel_info_data Table facetofacesessioncancelid BIGINT 19 null

WARNING - this points to session id

workshop_submissions Table example TINYINT 3 0

Is this submission an example from teacher

comp Table description LONGTEXT 2147483647 null
block_totara_featured_links_tiles Table dataraw LONGTEXT 2147483647 null

The raw Json encoded data about how to display the tile

tag Table name VARCHAR 255
grading_definitions Table id BIGINT 19 null
log_queries Table qtype MEDIUMINT 7 null

query type constant

facetoface_sessioncancel_info_data Table fieldid BIGINT 19 null
prog_completion_log Table userid BIGINT 19 null

Users id

forum Table blockafter BIGINT 19 0
message_airnotifier_devices Table userdeviceid BIGINT 19 null

The user device id in the user_devices table

appraisal_quest_field Table datatype VARCHAR 255
glossary_entries Table id BIGINT 19 null
message Table component VARCHAR 100 null
mnetservice_enrol_courses Table sortorder BIGINT 19 0
facetoface_signup_info_field Table param3 LONGTEXT 2147483647 null
enrol_lti_users Table consumerkey LONGTEXT 2147483647 null
course Table enablecompletion BIT 1 0

1 = allow use of 'completion' progress-tracking on this course. 0 = disable completion tracking on this course.

prog_courseset_course Table id BIGINT 19 null
post Table rating BIGINT 19 0
comp_framework Table timemodified BIGINT 19 null
grade_items_history Table aggregationcoef DECIMAL 10 0.00000

Aggregation coefficient used for category weights or other aggregation types

qtype_ddmarker Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

appraisal_event Table id BIGINT 19 null
auth_connect_sso_sessions Table ssotoken VARCHAR 64

Token used for identification of SSO session, this needs to be used together with client or server secret because it may end up in web server logs

mnetservice_enrol_courses Table idnumber VARCHAR 100
grade_items_history Table categoryid BIGINT 19 null

(optional) the category group this item belongs to

imscp Table course BIGINT 19 0
question_numerical_options Table question BIGINT 19 0
feedback360_quest_field Table datatype VARCHAR 255 null
qtype_randomsamatch_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

course_completion_crit_compl Table timecompleted BIGINT 19 null
dp_permissions Table templateid BIGINT 19 null

ID of the template that this permission setting is for

user Table url VARCHAR 255
cohort_role Table id BIGINT 19 null
quiz_grades Table id BIGINT 19 null
report_builder_schedule_email_external Table email VARCHAR 255
comp_framework Table idnumber VARCHAR 100 null
appraisal_grp_org Table includechildren BIT 1 null
appraisal_review_data Table itemid BIGINT 19 null
sessions Table timecreated BIGINT 19 null
competency_templatecomp Table timecreated BIGINT 19 null

The time this link was created.

competency_userevidencecomp Table userevidenceid BIGINT 19 null
grade_settings Table courseid BIGINT 19 null
assignsubmission_onlinetext Table assignment BIGINT 19 0
dp_evidence_type Table usermodified BIGINT 19 null
dp_template Table workflow VARCHAR 255 null

Current workflow for this template

course_completion_log Table changeuserid BIGINT 19 null

User id of the person who caused the change

facetoface_notification_tpl Table title LONGTEXT 2147483647 null
feedback_value_history Table course_id BIGINT 19 0

Doesn't seem to be used, the course id is in the feedback table

course Table icon VARCHAR 255 null

Totara course icon from totara_core

glossary Table usedynalink TINYINT 3 1
goal_framework Table hidecustomfields TINYINT 3 null
tool_monitor_history Table userid BIGINT 19 null

User to whom this notification was sent

pos_type Table description LONGTEXT 2147483647 null
question_calculated_options Table id BIGINT 19 null
mnet_host Table public_key LONGTEXT 2147483647 null
enrol_lti_tools Table contextid BIGINT 19 null
badge Table attachment BIT 1 1

Attach baked badge for download

errorlog Table version VARCHAR 255 null
scorm_aicc_session Table timemodified BIGINT 19 0

time this session was last used

question_hints Table clearwrong BIT 1 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.

folder Table id BIGINT 19 null
prog_completion_log Table changeuserid BIGINT 19 null

User id of the person who caused the change

gradingform_guide_fillings Table score DECIMAL 10 null

The score assigned

assign_overrides Table sortorder BIGINT 19 null

Rank for sorting overrides.

goal_framework Table sortorder BIGINT 19 null
config_log Table userid BIGINT 19 null
dp_plan_settings Table autobyitems SMALLINT 5 0

Flag to identify if a plan should autocomplete when all items have been completed

competency_template Table description LONGTEXT 2147483647 null

Description of this learning plan template

scorm Table timemodified BIGINT 19 0
certificate Table printteacher BIGINT 19 0
dp_evidence_type Table description LONGTEXT 2147483647 null
external_tokens Table id BIGINT 19 null
dp_competency_settings Table autoadddefaultevidence SMALLINT 5 0
license Table enabled BIT 1 1
lesson Table width BIGINT 19 640
profiling Table url VARCHAR 255

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

qtype_ddmarker_drops Table id BIGINT 19 null
appraisal_role_changes Table id BIGINT 19 null
appraisal_stage_role_setting Table id BIGINT 19 null
prog_extension Table programid BIGINT 19 0
scorm_seq_objective Table minnormalizedmeasure FLOAT 11 0.0000
competency Table competencyframeworkid BIGINT 19 null

The framework this competency relates to.

lti_submission Table originalgrade DECIMAL 10 null
facetoface_notification_tpl Table managerprefix LONGTEXT 2147483647 null
tool_sitepolicy_localised_policy Table id BIGINT 19 null
cohort_visibility Table instanceid BIGINT 19 0
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.

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

A description of what this LTI module is.

pos_type_info_data_param Table value VARCHAR 32
blog_association Table blogid BIGINT 19 null
modules Table visible BIT 1 1
glossary Table mainglossary TINYINT 3 0
tag_coll Table sortorder MEDIUMINT 7 0
portfolio_instance_user Table instance BIGINT 19 null

fk to instance table

question_response_count Table rcount BIGINT 19 null
external_services_users Table id BIGINT 19 null
pos Table path VARCHAR 255 null
assignfeedback_editpdf_annot Table pageno BIGINT 19 0

The page in the PDF that this annotation appears on

task_scheduled Table customised TINYINT 3 0

Used on upgrades to prevent overwriting custom schedules.

tool_sitepolicy_localised_consent Table consentoption VARCHAR 1333

The option the user selects to consent

local_activityvisibility Table instance BIGINT 19 0

The instance ID as defined in the course_module table.

gradingform_guide_fillings Table instanceid BIGINT 19 null

The ID of the grading form instance

prog_info_data_param Table id BIGINT 19 null
enrol_lti_lti2_context Table type VARCHAR 100 null
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.

assign Table markingworkflow TINYINT 3 0

If enabled, marking workflow features will be used in this assignment.

url Table display SMALLINT 5 0
feedback360_grp_pos Table posid BIGINT 19 null
appraisal Table status BIT 1 0
user Table lastname VARCHAR 100
workshop_grades Table grade DECIMAL 10 null

Given grade in the referenced assessment dimension.

editor_atto_autosave Table pagehash VARCHAR 64

The HTML DOM id of the page that loaded the form.

goal_scale_values Table sortorder BIGINT 19 null
prog_courseset Table label VARCHAR 255
portfolio_instance Table visible BIT 1 1

whether this instance is visible or not

job_assignment Table id BIGINT 19 null
survey_questions Table type SMALLINT 5 0
lesson Table practice SMALLINT 5 0
questionnaire_response_text Table response LONGTEXT 2147483647 null
comp_type_info_data Table data LONGTEXT 2147483647 null
assign_submission Table id BIGINT 19 null
tool_monitor_subscriptions Table userid BIGINT 19 null

User id of the subscriber

course_completion_log Table userid BIGINT 19 null

Users id

glossary_entries Table definitionformat TINYINT 3 0
quiz_slots Table quizid BIGINT 19 0

Foreign key references quiz.id.

question_datasets Table question BIGINT 19 0
tag Table descriptionformat TINYINT 3 0
cohort_plan_config Table id BIGINT 19 null
appraisal_quest_field Table param2 LONGTEXT 2147483647 null
block_zoola_reports Table label VARCHAR 255

Report label

questionnaire Table resp_view TINYINT 3 0

Questionnaire viewed?

wiki_pages Table id BIGINT 19 null
block_zoola_notifications Table id BIGINT 19 null
badge Table issuername VARCHAR 255
oauth2_issuer Table requireconfirmation TINYINT 3 1

Authentication requires email confirmation

comp_template_assignment Table instanceid BIGINT 19 null
facetoface Table completionstatusrequired VARCHAR 255 null
dp_objective_settings Table prioritymode SMALLINT 5 0
scorm_aicc_session Table hacpsession VARCHAR 255

sessionid used to authenticate AICC HACP communication

assign_overrides Table assignid BIGINT 19 0

Foreign key references assign.id

data Table completionentries BIGINT 19 0

Totara: Not used because feature is not taken yet (TL-15462). Number of entries required for completion

backup_controllers Table timecreated BIGINT 19 null

time the controller was created

question_response_count Table id BIGINT 19 null
block_rss_client Table userid BIGINT 19 0
certificate_issues Table code VARCHAR 40 null
facetoface_room_info_field Table param4 LONGTEXT 2147483647 null
dp_objective_scale Table sortorder BIGINT 19 null
assign_overrides Table userid BIGINT 19 null

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

forum_discussion_subs Table id BIGINT 19 null
totara_connect_clients Table serversecret VARCHAR 64

Shared secret, used by the client in each server request

user Table confirmed BIT 1 0
org_framework Table shortname VARCHAR 100 null
dp_plan_history Table id BIGINT 19 null
forum Table trackingtype TINYINT 3 1
question_ddwtos Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

comp_scale Table name VARCHAR 255 null
local_ld_course_day Table day VARCHAR 10

Day formatted as 'YYYY-MM-DD'

appraisal Table name VARCHAR 255
mnet_host2service Table id BIGINT 19 null
block_totara_featured_links_tiles Table presetsraw LONGTEXT 2147483647 null

The comma separated strings that refer to the preset rules that apply to the tile

appraisal_scale Table scaletype BIGINT 19 null
assignment_submissions Table teacher BIGINT 19 0
totara_compl_import_course Table username VARCHAR 100 null

username

comp_scale_values Table timemodified BIGINT 19 null
question_response_analysis Table response LONGTEXT 2147483647 null
appraisal_user_assignment Table userid BIGINT 19 null
profiling Table data LONGTEXT 2147483647 null

the raw data gathered by xhprof

enrol Table customtext3 LONGTEXT 2147483647 null

Custom - general text

question_gapselect Table questionid BIGINT 19 0
auth_connect_ids Table id BIGINT 19 null
lti_submission Table id BIGINT 19 null
questionnaire Table course BIGINT 19 0

Id of course

course_completions Table timecompleted BIGINT 19 null
totara_userdata_export_item Table component VARCHAR 100

Plugin name or subsystem, e.g. mod_glossary, core_user

lesson_answers Table responseformat TINYINT 3 0
stats_user_daily Table roleid BIGINT 19 0
facetoface_session_roles Table sessionid BIGINT 19 null
repository Table sortorder BIGINT 19 0
comp Table timecreated BIGINT 19 null
mnet_host Table theme VARCHAR 100 null
course_completion_crit_compl Table gradefinal DECIMAL 10 null

The final grade for the course (included regardless of whether a passing grade was required)

workshopform_accumulative Table workshopid BIGINT 19 null

Workshop ID

forum Table intro LONGTEXT 2147483647 null
facetoface_room Table name VARCHAR 100 null
task_adhoc Table classname VARCHAR 255

The name of the class extending adhoc_task to run when this task is executed.

certificate Table intro LONGTEXT 2147483647 null
course Table defaultgroupingid BIGINT 19 0

default grouping used in course modules, does not have key intentionally

file_conversion Table destfileid BIGINT 19 null
facetoface_signup_info_data Table facetofacesignupid BIGINT 19 null

WARNING - this points to signup id

scorm Table name VARCHAR 255
goal Table path VARCHAR 255 null
cache_filters Table md5key VARCHAR 32
enrol_lti_tools Table lang VARCHAR 30 en
prog_completion Table positionid BIGINT 19 null
role_assignments Table itemid BIGINT 19 0

Id of enrolment/auth instance responsible for this role assignment

cohort_visibility Table id BIGINT 19 null
facetoface_notification_hist Table sessionid BIGINT 19 null

FK of facetoface_sessions

quiz_statistics Table skewness DECIMAL 15 null
appraisal_quest_field Table descriptionformat BIT 1 null
course_modules Table instance BIGINT 19 0
facetoface_asset_info_data Table facetofaceassetid BIGINT 19 null
message_read Table useridfrom BIGINT 19 0
data_content Table content LONGTEXT 2147483647 null
user_info_data Table fieldid BIGINT 19 0

id from the field table

lesson Table completiontimespent BIGINT 19 0
scale Table id BIGINT 19 null
org Table idnumber VARCHAR 100 null
pos_type_info_field Table description LONGTEXT 2147483647 null
grade_items Table grademax DECIMAL 10 100.00000

What is the maximum allowable grade?

report_builder_filters Table region SMALLINT 5 0

Indicates whether filter appears at the top or in the sidebar

enrol_totara_f2f_pending Table userid BIGINT 19 0
pos_type Table id BIGINT 19 null
workshop Table usepeerassessment TINYINT 3 0

optional feature: students perform peer assessment of others' work

enrol_lti_lti2_user_result Table created BIGINT 19 null
totara_dashboard_user Table id BIGINT 19 null
gradingform_guide_criteria Table maxscore DECIMAL 10 null

maximum grade that can be assigned using this criterion

local_ld_import_logs_status Table timefinished BIGINT 19 null

When the import logs tash finished

task_adhoc Table nextruntime BIGINT 19 null
lesson Table conditions LONGTEXT 2147483647 null
totara_navigation Table custom BIT 1 1

Set to 1 for custom items and custom containers only

competency_relatedcomp Table competencyid BIGINT 19 null
goal_scale_values Table description LONGTEXT 2147483647 null
wiki Table name VARCHAR 255 Wiki

name field for moodle instances

assignsubmission_onlinetext Table id BIGINT 19 null
data Table manageapproved SMALLINT 5 1
feedback_item Table feedback BIGINT 19 0
url Table name VARCHAR 255
dp_plan_objective Table fullname VARCHAR 255 null
wiki_locks Table sectionname VARCHAR 255 null

locked page section

prog_completion_history Table programid BIGINT 19 0
goal_framework Table timecreated BIGINT 19 null
question Table generalfeedback LONGTEXT 2147483647 null

to store the question feedback

glossary_entries Table teacherentry TINYINT 3 0
org_framework Table timecreated BIGINT 19 null
workshop Table assessmentstart BIGINT 19 0

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

block_zoola_reports_eventcfg Table sendtomanager BIT 1 0

Add related user manager's email to recipient list

grade_import_values Table importer BIGINT 19 null
pos_type_info_field Table id BIGINT 19 null
certificate Table bordercolor VARCHAR 30 0
scorm_scoes Table title VARCHAR 255
pos_type_info_field Table typeid BIGINT 19 null
qtype_essay_options Table responsefieldlines SMALLINT 5 15

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

workshop_grades Table peercomment LONGTEXT 2147483647 null

Reviewer's comment to the grade value.

course_info_data_param Table id BIGINT 19 null
lti_tool_proxies Table timemodified BIGINT 19 null

Date/time at which the record was last modified

user_devices Table userid BIGINT 19 0
cache_filters Table version BIGINT 19 0
grading_areas Table activemethod VARCHAR 100 null

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

course_published Table status BIT 1 0

is the publication published or not

enrol_paypal Table receiver_id VARCHAR 255
org_framework Table hidecustomfields TINYINT 3 null
feedback_value Table item BIGINT 19 0
backup_courses Table id BIGINT 19 null
stats_user_daily Table statswrites BIGINT 19 0
rating Table contextid BIGINT 19 null
dp_plan_course_assign Table id BIGINT 19 null
wiki_versions Table content LONGTEXT 2147483647 null

Not parsed wiki content

grade_categories Table depth BIGINT 19 0

How many parents does this category have?

enrol_lti_lti2_consumer Table settings LONGTEXT 2147483647 null
tag Table isstandard BIT 1 0

Whether this tag is standard

local_ld_module Table totaldedication BIGINT 19 0

Total time spent on this module, in seconds

qtype_ddimageortext_drops Table questionid BIGINT 19 0
competency Table idnumber VARCHAR 100 null
scale_history Table action BIGINT 19 0

created/modified/deleted constants

choice Table name VARCHAR 255
glossary Table intro LONGTEXT 2147483647 null
dp_objective_settings Table id BIGINT 19 null
comp Table depthlevel BIGINT 19 null
feedback_item Table options VARCHAR 255
grade_import_newitem Table itemname VARCHAR 255

new grade item name

question_numerical_units Table question BIGINT 19 0

Foreign key references question.id

workshopallocation_scheduled Table id BIGINT 19 null
feedback_item Table label VARCHAR 255
appraisal_stage Table description LONGTEXT 2147483647 null
pos_type_info_field Table param5 LONGTEXT 2147483647 null
facetoface Table id BIGINT 19 null
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.

repository_instances Table timecreated BIGINT 19 null
lock_db Table id BIGINT 19 null
dp_plan_settings Table autobyplandate SMALLINT 5 0

Flag to identify if a plan should autocomplete when due date has passed

message_read Table smallmessage LONGTEXT 2147483647 null

Smal version of message (eg sms)

totara_compl_import_course Table courseshortname VARCHAR 255 null

course shortname

totara_userdata_purge_type Table id BIGINT 19 null
pos Table timemodified BIGINT 19 null
facetoface_room_info_field Table shortname VARCHAR 100 null
forum_discussions Table forum BIGINT 19 0
facetoface_sessions Table timecreated BIGINT 19 0
dp_plan_component_relation Table component1 VARCHAR 255 null

The first component in the relation - first alphabetically

totara_userdata_purge_type_item Table id BIGINT 19 null
groupings_groups Table groupid BIGINT 19 0
tool_usertours_steps Table content LONGTEXT 2147483647 null

Content of the user tour - allow for multilang tags

grade_import_values Table itemid BIGINT 19 null

if set, this points to existing grade_items id

scorm_seq_rolluprule Table action VARCHAR 15
comp_scale_values Table scaleid BIGINT 19 null
lesson_answers Table timecreated BIGINT 19 0
questionnaire_question Table dependquestion BIGINT 19 0
grading_areas Table component VARCHAR 100

Frankenstyle name of the component holding this area

cohort Table component VARCHAR 100

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

workshop_submissions Table timemodified BIGINT 19 null

Timestamp when the submission has been updated

tag_instance Table timecreated BIGINT 19 0
job_assignment Table usermodified BIGINT 19 null

The ID of the user who last modified this job assignment

pos_type_info_field Table hidden TINYINT 3 null
report_builder_schedule Table lastmodified BIGINT 19 0

Timestamp when the scheduled report settings was last modified

facetoface_signups Table managerid BIGINT 19 null

Manager can be selected by user (if allowed), which will override other managers settings

totara_navigation_settings Table name VARCHAR 255
reportbuilder_grp_cohort_record Table cohortid BIGINT 19 null
assign Table teamsubmissiongroupingid BIGINT 19 0

A grouping id to get groups for team submissions

question_categories Table info LONGTEXT 2147483647 null
upgrade_log Table plugin VARCHAR 100 null
feedback360 Table id BIGINT 19 null
facetoface_interest Table reason LONGTEXT 2147483647 null
forum_subscriptions Table userid BIGINT 19 0
grade_items_history Table iteminfo LONGTEXT 2147483647 null

Info and notes about this item XXX

assign Table cutoffdate BIGINT 19 0

The final date after which submissions will no longer be accepted for this assignment without an extensions.

auth_connect_user_collections Table collectiontype VARCHAR 30

cohort, course

facetoface_session_info_data Table id BIGINT 19 null
feedback360_scale_value Table id BIGINT 19 null
registration_hubs Table id BIGINT 19 null
questionnaire_attempts Table timemodified BIGINT 19 0
grade_import_newitem Table importcode BIGINT 19 null

import batch code for identification

facetoface_sessions_dates Table id BIGINT 19 null
registration_hubs Table secret VARCHAR 255 null

the unique site identifier for this hub

totara_userdata_purge Table purgetypeid BIGINT 19 null
feedback360_email_assignment Table email VARCHAR 255
lti_types Table toolproxyid BIGINT 19 null

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

user_info_field Table shortname VARCHAR 255 shortname

short name for each field

competency_coursecompsetting Table usermodified BIGINT 19 null

The user who last modified this setting

portfolio_instance Table plugin VARCHAR 50

fk to plugin

grading_definitions Table timecopied BIGINT 19 0

The timestamp of when this form was most recently copied into another area

grade_outcomes_courses Table id BIGINT 19 null
user_info_data Table dataformat TINYINT 3 0
pos_relations Table id2 BIGINT 19 null
scorm_seq_rolluprule Table childactivityset VARCHAR 15
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)

grade_items_history Table locktime BIGINT 19 0

lock all final grades after this date

quiz_grades Table userid BIGINT 19 0

Foreign key references user.id.

comp_type_info_field Table required TINYINT 3 null
reportbuilder_grp_org_record Table orgid BIGINT 19 null
totara_userdata_purge_item Table result BIGINT 19 null

null means not finished, -1 completed ok, -2 means error, -3 means skipped, -4 cancelled, -5 timed out

competency_templatecomp Table templateid BIGINT 19 null

The template this competency is linked to.

lesson Table mediaclose SMALLINT 5 0
prog_message Table managersubject VARCHAR 255
feedback360_grp_cohort Table feedback360id BIGINT 19 null
cohort_rule_collections Table timemodified BIGINT 19 null
groups_members Table groupid BIGINT 19 0
cache_filters Table rawtext LONGTEXT 2147483647 null
course_info_field Table param3 LONGTEXT 2147483647 null
events_queue_handlers Table queuedeventid BIGINT 19 null

foreign key id corresponding to the id of the event_queues table

feedback_value Table course_id BIGINT 19 0
enrol Table customint4 BIGINT 19 null

Custom - general int

auth_connect_ids Table tablename VARCHAR 64

Database table name, maximum is 40, but use more to prevent future problems

question_attempts Table flagged BIT 1 0

Whether this question has been flagged within the attempt.

lesson_pages Table qoption SMALLINT 5 0
lti_submission_history Table ltiid BIGINT 19 null
cohort_rule_collections Table rulesetoperator TINYINT 3 0
question_numerical_options Table id BIGINT 19 null
comp_template Table fullname LONGTEXT 2147483647 null
badge_manual_award Table issuerid BIGINT 19 null
scorm_seq_rulecond Table scoid BIGINT 19 0
pos_competencies Table usermodified BIGINT 19 null
wiki_links Table id BIGINT 19 null
prog_completion Table timecompleted BIGINT 19 0
competency_template Table visible TINYINT 3 1

Used to show/hide this learning plan template.

block_totara_featured_links_tiles Table overallaggregation SMALLINT 5 0

The aggregation for the section ie matches audience and preset

lesson Table bgcolor VARCHAR 7 #FFFFFF
report_builder_schedule Table exporttofilesystem BIGINT 19 0
workshop_aggregations Table userid BIGINT 19 null

The id of the user which aggregated grades are calculated for

badge_criteria_met Table critid BIGINT 19 null
goal Table timemodified BIGINT 19 null
block_recent_activity Table action BIT 1 null

0 created, 1 updated, 2 deleted

persistent_login Table cookie VARCHAR 128

Permanent cookie used for automatic login

assign Table grade BIGINT 19 0

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

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

repository_opensesame_bps Table bundleid BIGINT 19 null
local_ld_module Table id BIGINT 19 null
block_instances Table configdata LONGTEXT 2147483647 null

A serialized blob of configuration data for this block instance.

facetoface_signup_info_field Table fullname VARCHAR 1024 null
pos_relations Table id BIGINT 19 null
scorm Table introformat SMALLINT 5 0
prog_courseset Table timeallowed BIGINT 19 0
block_totara_featured_links_tiles Table id BIGINT 19 null

This is the tileid

auth_connect_servers Table servercomment LONGTEXT 2147483647 null

Comments by client administrator

repository_instance_config Table instanceid BIGINT 19 null
comp Table shortname VARCHAR 100 null
message_metadata Table onaccept LONGTEXT 2147483647 null

serialised action on message acceptance

dp_plan_evidence_info_data Table data LONGTEXT 2147483647 null
course_modules Table idnumber VARCHAR 100 null

customizable idnumber

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

dp_competency_settings Table priorityscale BIGINT 19 null

Identifies the scale used by this component

mnet_rpc Table plugintype VARCHAR 20
groupings_groups Table timeadded BIGINT 19 0
message_processors Table id BIGINT 19 null
book Table course BIGINT 19 0
question_dataset_definitions Table itemcount BIGINT 19 0
portfolio_log Table caller_class VARCHAR 150

the name of the class used to create the transfer

competency_plancomp Table timemodified BIGINT 19 null
messageinbound_messagelist Table id BIGINT 19 null
cohort Table alertmembers BIT 1 0

Totara alert members from totara_cohort

block Table id BIGINT 19 null
facetoface_asset_dates Table id BIGINT 19 null
badge_external Table backpackid BIGINT 19 null

ID of a backpack

grading_areas Table id BIGINT 19 null
stats_user_weekly Table timeend BIGINT 19 0
assign_overrides Table groupid BIGINT 19 null

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

qtype_match_options Table shuffleanswers SMALLINT 5 1
repository_opensesame_bdls Table name VARCHAR 1333

Bundle name, cannot have enforced unique index because it is too long

messageinbound_messagelist Table userid BIGINT 19 null
course_request Table requester BIGINT 19 0
assignfeedback_file Table grade BIGINT 19 0
course_modules Table availability LONGTEXT 2147483647 null

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

facetoface_asset_info_data_param Table value VARCHAR 32
job_assignment Table positionid BIGINT 19 null

The ID of the position the user holds as part of this job assignment

scorm_aicc_session Table scoid BIGINT 19 0

id from scorm_scoes table

lesson Table name VARCHAR 255
chat_users Table version VARCHAR 16
dp_competency_settings Table prioritymode SMALLINT 5 0

Defines how priorities are handled within this component

mnetservice_enrol_courses Table remoteid BIGINT 19 null

ID of course on its home server

dp_objective_scale_value Table numericscore DECIMAL 10 null

Identifies a score that can be assigned to a scale value

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.

mnet_log Table cmid BIGINT 19 0
goal_item_history Table id BIGINT 19 null
data_fields Table param10 LONGTEXT 2147483647 null
dp_objective_scale_value Table id BIGINT 19 null
auth_oauth2_linked_login Table username VARCHAR 255

The external username to map to this moodle account

data_content Table content4 LONGTEXT 2147483647 null
auth_approved_request Table confirmed BIT 1 null

Value 1 if email ownership confirmed, 0 if not

post Table subject VARCHAR 128
prog_completion_log Table programid BIGINT 19 null

Program ID

prog_completion_log Table timemodified BIGINT 19 null
course_completion_crit_compl Table course BIGINT 19 0
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.

enrol_lti_lti2_consumer Table lastaccess BIGINT 19 null
mnet_host Table deleted BIT 1 0
messageinbound_handlers Table classname VARCHAR 255

The class defining the Inbound Message handler to be called.

post Table coursemoduleid BIGINT 19 0
block_zoola_module_name Table instanceid BIGINT 19 null

Instance id

event Table description LONGTEXT 2147483647 null
mnet_host Table id BIGINT 19 null

Unique Host ID

backup_trusted_files Table id BIGINT 19 null
role_assignments Table contextid BIGINT 19 0
pos_type Table usermodified BIGINT 19 null
data Table introformat SMALLINT 5 0
resource_old Table course BIGINT 19 0
enrol_lti_tools Table maxenrolled BIGINT 19 0
quiz_feedback Table maxgrade DECIMAL 10 0.00000

The upper limit of this grade band. Exclusive.

dp_plan_objective Table duedate BIGINT 19 null
totara_userdata_export_item Table exportid BIGINT 19 null
tool_customlang Table local LONGTEXT 2147483647 null

Local customization of the string, null if not customized

user Table maildisplay TINYINT 3 2
quickaccess_preferences Table value LONGTEXT 2147483647 null
facetoface_cancellation_info_data Table facetofacecancellationid BIGINT 19 null

WARNING - this points to signup id

questionnaire_response_other Table question_id BIGINT 19 0
page Table introformat SMALLINT 5 0
task_scheduled Table blocking TINYINT 3 0

Block the entire cron when this task is running.

goal_type Table usermodified BIGINT 19 null
questionnaire_response Table userid BIGINT 19 null
job_assignment Table managerjapath VARCHAR 1024

The job assignment path up the tree until we find the top user

dp_plan_evidence_info_field Table param2 LONGTEXT 2147483647 null
appraisal_role_changes Table originaluserid BIGINT 19 null
portfolio_log Table caller_file VARCHAR 255

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

external_services Table component VARCHAR 100 null
tag Table description LONGTEXT 2147483647 null
cohort Table startdate BIGINT 19 null

Totara start date from totara_cohort

block_totara_featured_links_tiles Table audienceaggregation SMALLINT 5 0

The aggregation of the audience rules ie AND or OR

tag_instance Table timemodified BIGINT 19 0

timemodified

qtype_essay_options Table graderinfoformat SMALLINT 5 0

The text format for graderinfo.

dp_plan_evidence Table id BIGINT 19 null
totara_connect_client_courses Table courseid BIGINT 19 null
comp_criteria Table itemtype VARCHAR 30 null
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

scorm_seq_rulecond Table measurethreshold FLOAT 11 0.0000
dp_plan_evidence_relation Table evidenceid BIGINT 19 null

Evidence ID from dp_plan_evidence

report_builder Table timemodified BIGINT 19 0

Updated when the report, column or setting changes

log_display Table id BIGINT 19 null
competency Table id BIGINT 19 null
block_zoola_reports_schreps Table name VARCHAR 100

Schedule name

dp_plan_history Table status TINYINT 3 null

The plan's status

external_tokens Table validuntil BIGINT 19 null

timestampt - valid until data

pos Table parentid BIGINT 19 null
questionnaire_fb_sections Table id BIGINT 19 null
choice Table showresults TINYINT 3 0
badge Table message LONGTEXT 2147483647 null
backup_controllers Table executiontime BIGINT 19 null

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

forum_discussions Table firstpost BIGINT 19 0
appraisal_event Table timescheduled 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)

questionnaire_resp_single Table question_id BIGINT 19 0
tool_recyclebin_course Table module BIGINT 19 null
question Table timemodified BIGINT 19 0

time that question was last modified

tool_usertours_steps Table id BIGINT 19 null
totara_userdata_purge_type_item Table name VARCHAR 100

Class name without namespace, e.g. comment, post, completion

chat_messages Table chatid BIGINT 19 0
wiki Table intro LONGTEXT 2147483647 null

General introduction of the wiki activity

facetoface_asset_info_field Table fullname VARCHAR 1024 null
comp Table id BIGINT 19 null
competency_plan Table origtemplateid BIGINT 19 null

The template ID this plan was based on originally

job_assignment Table userid BIGINT 19 null

The ID of the user this job assignment belongs to

competency_template Table usermodified BIGINT 19 null

The user who last modified this learning plan template

question_categories Table stamp VARCHAR 255
comp_type_info_field Table datatype VARCHAR 255 null
assign_submission Table groupid BIGINT 19 0

The group id for team submissions

workshopform_rubric Table workshopid BIGINT 19 null

Workshop ID

scale Table userid BIGINT 19 0
wiki_pages Table pageviews BIGINT 19 0

Number of page views

appraisal_grp_cohort Table id BIGINT 19 null
badge_backpack Table backpackurl VARCHAR 255
page Table contentformat SMALLINT 5 0
catalog Table objecttype VARCHAR 100
glossary Table timecreated BIGINT 19 0
auth_approved_request_snapshots Table id BIGINT 19 null
org_competencies Table organisationid BIGINT 19 null
dp_plan_objective Table reasonfordecision LONGTEXT 2147483647 null

The reason for approving/declining the request

facetoface_signups Table archived BIT 1 0

Has this sign up been archived by the archive completion feature.

mnetservice_enrol_courses Table id BIGINT 19 null

Unique remote-course ID

facetoface_room_info_field Table sortorder BIGINT 19 null
cohort_plan_config Table autocreatenew BIT 1 0

Automatically create new plans for new members of the cohort

dp_plan Table userid BIGINT 19 null

ID of the user this plan is for

groups Table hidepicture BIT 1 0
event Table timeduration BIGINT 19 0
survey_analysis Table survey BIGINT 19 0
question_calculated Table tolerance VARCHAR 20 0.0
enrol_paypal Table id BIGINT 19 null
data Table csstemplate LONGTEXT 2147483647 null
prog_courseset_course Table courseid BIGINT 19 0
lti Table instructorchoicesendemailaddr BIT 1 null

Send user's email

question Table generalfeedbackformat TINYINT 3 0
repository Table id BIGINT 19 null
cohort_plan_config Table plantemplateid BIGINT 19 null

Learning plan template id

totara_navigation Table path VARCHAR 50 null

Deprecated sicec Totara 12.0

task_adhoc Table blocking TINYINT 3 0
lesson_grades Table completed BIGINT 19 0
oauth2_user_field_mapping Table timemodified BIGINT 19 null

The time this record was modified

resource Table display SMALLINT 5 0
org_relations Table id2 BIGINT 19 null
workshop Table gradinggrade DECIMAL 10 20.00000

The maximum grade for assessment

role_sortorder Table roleid BIGINT 19 null
auth_approved_request_snapshots Table positionfreetext LONGTEXT 2147483647 null
context Table instanceid BIGINT 19 0
page Table legacyfiles SMALLINT 5 0
cohort_rules Table timecreated BIGINT 19 null
persistent_login Table lastip VARCHAR 45 null

Value is copied from the sessions table at login time and on timeout

course_completion_defaults Table completionusegrade BIT 1 0
book Table intro LONGTEXT 2147483647 null
grading_instances Table feedback LONGTEXT 2147483647 null

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

job_assignment Table synctimemodified BIGINT 19 0
tool_sitepolicy_localised_policy Table whatsnew LONGTEXT 2147483647 null

Field to put what has changed since the previous version

course_completion_defaults Table id BIGINT 19 null
forum Table maxbytes BIGINT 19 0
tool_sitepolicy_localised_policy Table policytextformat TINYINT 3 1

The format of the policytext field

appraisal_event Table deltaperiod BIT 1 0

Period: 0 - hours (not used), 1 - days, 2 - weeks, 3 - months

block_rss_client Table description LONGTEXT 2147483647 null
report_builder Table id BIGINT 19 null

ID of the table

facetoface_sessioncancel_info_field Table fullname VARCHAR 1024 null
report_builder_schedule Table userid BIGINT 19 null
goal_type_info_field Table sortorder BIGINT 19 null
assign Table teamsubmission TINYINT 3 0

Do students submit in teams?

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

feedback_value_history Table timearchived BIGINT 19 null
course_completions Table positionid BIGINT 19 null

Totara position id from totara_hierarchy

grade_categories Table droplow BIGINT 19 0

Drop the X lowest items

user Table currentlogin BIGINT 19 0
block_zoola_reports_eventcfg Table exportformat VARCHAR 10 XLSX

Export format: 'pdf', 'xlsx', 'csv', ...

persistent_login Table timeautologin BIGINT 19 null

Time of the last auto login

prog Table icon VARCHAR 255
workshopallocation_scheduled Table enabled TINYINT 3 0

Is the scheduled allocation enabled

user_password_history Table timecreated BIGINT 19 null
data_fields Table dataid BIGINT 19 0
lesson_branch Table lessonid BIGINT 19 0
badge_criteria Table descriptionformat TINYINT 3 0
dp_plan_objective Table approved SMALLINT 5 0
block_recent_activity Table userid BIGINT 19 null

User performing the action

badge_issued Table dateexpire BIGINT 19 null
qtype_ddmarker Table incorrectfeedbackformat TINYINT 3 0
facetoface_sessioncancel_info_field Table param1 LONGTEXT 2147483647 null
scorm_aicc_session Table userid BIGINT 19 0

id from user table

survey_questions Table shorttext VARCHAR 30
assign_plugin_config Table subtype VARCHAR 28
groupings Table timecreated BIGINT 19 0
qtype_ddimageortext Table shuffleanswers SMALLINT 5 1
upgrade_log Table details LONGTEXT 2147483647 null
report_builder_settings Table value VARCHAR 255 null

Value of the setting

prog_courseset Table recurcreatetime BIGINT 19 0
competency_plan Table id BIGINT 19 null
local_ld_course_day Table ldcourseid BIGINT 19 null

Foreign key to the local_ld_course table

totara_compl_import_cert Table timecreated BIGINT 19 null

Time the record was imported into this table

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.

tool_sitepolicy_localised_consent Table nonconsentoption VARCHAR 1333

The option the user selects to not consent

messageinbound_datakeys Table timecreated BIGINT 19 null

The time that the data key was created.

config_plugins Table id BIGINT 19 null
assignment Table var5 BIGINT 19 0
workshop Table phaseswitchassessment TINYINT 3 0

Automatically switch to the assessment phase after the submissions deadline

certif_completion_history Table renewalstatus TINYINT 3 0
course_completion_criteria Table role BIGINT 19 null
reportbuilder_grp_pos_user Table posid BIGINT 19 null
wiki_locks Table pageid BIGINT 19 0

Locked page

catalog_search_metadata Table instanceid BIGINT 19 null
questionnaire_fb_sections Table section TINYINT 3 null
quiz Table timeclose BIGINT 19 0

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

grade_letters Table id BIGINT 19 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

goal_scale_assignments Table usermodified BIGINT 19 null
qtype_ddimageortext_drops Table xleft BIGINT 19 0
org Table depthlevel BIGINT 19 null
quiz_statistics Table allattemptscount BIGINT 19 null
user_preferences Table value VARCHAR 1333
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

questionnaire_response_date Table question_id BIGINT 19 0
course_modules Table module BIGINT 19 0
mnet_log Table userid BIGINT 19 0
facetoface_sessions Table allowoverbook BIT 1 0

Flag to turn on waitlisting of signups over capacity.

report_builder_global_restriction Table sortorder BIGINT 19 null
profiling Table runcomment VARCHAR 255

Brief comment for this run

quiz_overview_regrades Table slot BIGINT 19 null

Foreign key, references question_attempts.slot

glossary Table allowduplicatedentries TINYINT 3 0
feedback360 Table recipients INT 10 0
appraisal_history Table id BIGINT 19 null
repository_opensesame_bdls Table timecreated BIGINT 19 null

Date when bundle added

goal_personal Table name VARCHAR 1024 null
question_dataset_items Table id BIGINT 19 null
goal_framework Table fullname VARCHAR 1024
prog_info_field Table shortname VARCHAR 100 null
enrol Table customchar3 VARCHAR 1333 null

Custom - general short name

questionnaire_attempts Table qid BIGINT 19 0
role_allow_assign Table roleid BIGINT 19 0
enrol_paypal Table payment_type VARCHAR 30
block_zoola_reports_eventcfg Table event VARCHAR 1333

Name of event that triggers the schedule

course_modules Table groupingid BIGINT 19 0
facetoface_signup_info_field Table locked TINYINT 3 null
questionnaire_fb_sections Table survey_id BIGINT 19 0
blog_association Table contextid BIGINT 19 null
course_sections Table sequence LONGTEXT 2147483647 null
grading_instances Table id BIGINT 19 null
pos Table fullname VARCHAR 1024 null
scorm_seq_mapinfo Table objectiveid BIGINT 19 0
assignfeedback_comments Table commenttext LONGTEXT 2147483647 null

The feedback text

dp_plan_program_assign Table duedate BIGINT 19 null

Timestamp of the date this program is due to be completed.

wiki_subwikis Table groupid BIGINT 19 0

Group that owns this wiki

comp_type Table timecreated BIGINT 19 null
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

facetoface_notification Table type BIT 1 null
question_truefalse Table trueanswer BIGINT 19 0

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

job_assignment Table tempmanagerexpirydate BIGINT 19 null
enrol_lti_lti2_user_result Table resourcelinkid BIGINT 19 null
appraisal_stage Table name VARCHAR 255
grade_items_history Table locked BIGINT 19 0

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

block_quicklinks Table id BIGINT 19 null
backup_controllers Table interactive SMALLINT 5 null

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

org_type Table timemodified BIGINT 19 null
repository_instance_config Table id BIGINT 19 null
dp_plan Table name VARCHAR 255 null

Name of this development plan

course Table format VARCHAR 21 topics
questionnaire_survey Table chart_type VARCHAR 64 null
cohort_role Table contextid BIGINT 19 0
course_info_data Table fieldid BIGINT 19 null
mnet_sso_access_control Table accessctrl VARCHAR 20 allow

Whether or not this user/host can login

choice Table course BIGINT 19 0
comp_type_info_field Table param4 LONGTEXT 2147483647 null
facetoface_asset Table custom BIT 1 0

1 means room is created secifically for one session only and cannot be reused

org_type_info_data Table fieldid BIGINT 19 null
totara_userdata_user Table timedeleted BIGINT 19 null

Best guess when user was actually suspended

external_functions Table component VARCHAR 100
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#

quiz_overrides Table attempts MEDIUMINT 7 null
workshop Table name VARCHAR 255

Name of the activity

label Table timemodified BIGINT 19 0
goal Table depthlevel BIGINT 19 null
question_statistics Table hashcode VARCHAR 40

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

facetoface_asset Table timecreated BIGINT 19 0
data Table addtemplate LONGTEXT 2147483647 null
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.

quiz Table completionpass BIT 1 0
workshopallocation_scheduled Table resultstatus BIGINT 19 null

The resulting status of the most recent execution

competency_usercomp Table id BIGINT 19 null
comp_scale_assignments Table usermodified BIGINT 19 null
assign_submission Table assignment BIGINT 19 0
tool_sitepolicy_localised_policy Table policytext LONGTEXT 2147483647 null

The contents of the policy

tool_monitor_history Table id BIGINT 19 null
assignment_upgrade Table oldcmid BIGINT 19 0
grading_definitions Table areaid BIGINT 19 null
user_password_history Table userid BIGINT 19 null
stats_weekly Table timeend BIGINT 19 0
badge Table expireperiod BIGINT 19 null
enrol_flatfile Table courseid BIGINT 19 null
course_completion_history Table id BIGINT 19 null
forum_discussions Table name VARCHAR 255
chat Table studentlogs SMALLINT 5 0
oauth2_issuer Table baseurl LONGTEXT 2147483647 null

The base url to the issuer

facetoface_notification Table templateid BIGINT 19 0
dp_program_settings Table priorityscale BIGINT 19 null

Identifies the scale used by this component

report_builder_schedule_email_systemuser Table userid BIGINT 19 null
goal_user_info_field Table fullname VARCHAR 1024 null
totara_compl_import_cert Table username VARCHAR 100 null

username

lesson Table mediawidth BIGINT 19 650
auth_connect_servers Table serveridnumber VARCHAR 64

World unique server ID

portfolio_instance Table name VARCHAR 255

name of plugin instance

tag_instance Table tiuserid BIGINT 19 0
auth_approved_request Table timecreated BIGINT 19 null
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.

dp_plan_history Table usermodified BIGINT 19 null

The id of the user who made the modification

quiz_overrides Table timelimit BIGINT 19 null

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

enrol Table cost VARCHAR 20 null

Custom - enrolment cost

post Table moduleid BIGINT 19 0
cohort_plan_history Table templateid BIGINT 19 null
comp_type_info_field Table defaultdata LONGTEXT 2147483647 null
question_attempt_step_data Table value LONGTEXT 2147483647 null

The corresponding value

user Table timezone VARCHAR 100 99
assignfeedback_comments Table grade BIGINT 19 0
mnet_log Table url VARCHAR 100
totara_userdata_purge_type Table allowmanual BIT 1 0

Allow use for manual purging

resource Table tobemigrated SMALLINT 5 0
assignfeedback_editpdf_annot Table endy BIGINT 19 0

y-position of the end of the annotation

message_metadata Table messagereadid BIGINT 19 null

for tracking metadata after message has been read

pos_type Table idnumber VARCHAR 100 null
editor_atto_autosave Table elementid VARCHAR 255

The unique id for the text editor in the form.

assign Table requiresubmissionstatement TINYINT 3 0

Forces the student to accept a submission statement when submitting an assignment

competency Table scaleid BIGINT 19 null
enrol Table id BIGINT 19 null
comp_template Table competencycount BIGINT 19 null
goal_user_assignment Table usermodified BIGINT 19 null
goal_scale_values Table usermodified BIGINT 19 null
page Table content LONGTEXT 2147483647 null
pos Table id BIGINT 19 null
tool_monitor_rules Table timemodified BIGINT 19 null

Timestamp when this rule was last modified

report_builder_search_cols Table value VARCHAR 255
report_builder_cache Table cachetable VARCHAR 255 null

Table name with cached data for report

quiz_statistics Table standarderror DECIMAL 15 null
report_builder_columns Table value VARCHAR 255

Value of column, used with type to identify the column option

tool_customlang Table modified SMALLINT 5 0

Has the string been modified via the translator?

mnet_session Table expires BIGINT 19 0

Expire time of session on peer

external_functions Table name VARCHAR 200
tool_sitepolicy_consent_options Table mandatory BIT 1 null

If the consent option requires consent to use the site

totara_core_program_vis_map Table programid BIGINT 19 null
qtype_essay_options Table questionid BIGINT 19 null

Foreign key linking to the question table.

quiz_slots Table id BIGINT 19 null
choice Table publish TINYINT 3 0
tag_correlation Table id BIGINT 19 null
dp_plan_component_relation Table id BIGINT 19 null
grade_categories Table aggregateoutcomes BIT 1 0

Aggregate outcomes

certificate_issues_history Table id BIGINT 19 null
auth_approved_request_snapshots Table timeresolved BIGINT 19 null
quiz_slots Table requireprevious SMALLINT 5 0

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

tag_instance Table component VARCHAR 100

Defines the Moodle component which the tag was added to

question_attempt_steps Table userid BIGINT 19 null

The user whose action lead to this state being created.

question_answers Table fraction DECIMAL 12 0.0000000
workshop_grades Table dimensionid BIGINT 19 null

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

reportbuilder_grp_pos_record Table posid BIGINT 19 null
facetoface_cancellation_info_field Table sortorder BIGINT 19 null
user_lastaccess Table userid BIGINT 19 0
block_zoola_reports_schreps Table allstudents TINYINT 3 0

if 1 reports will be sent to all students enrolled into course

facetoface_notification_hist Table timecreated BIGINT 19 null

timestamp of record creation

dp_plan_evidence_info_data Table id BIGINT 19 null
block_rss_client Table url VARCHAR 255
goal_grp_cohort Table timemodified BIGINT 19 null
report_builder_schedule Table savedsearchid BIGINT 19 null
goal_framework Table description LONGTEXT 2147483647 null
goal_type_info_field Table typeid BIGINT 19 null
chat_messages_current Table groupid BIGINT 19 0
totara_userdata_purge_type Table allowdeleted BIT 1 0

Allow selection for purging after deletion

question_response_count Table try BIGINT 19 null
facetoface_session_info_field Table locked TINYINT 3 null
comp_type_info_field Table shortname VARCHAR 100 null
local_ld_course Table totaldedication BIGINT 19 null

Total time that user spent within the course, in seconds

comp_framework Table usermodified BIGINT 19 null
facetoface Table multisignupnoshow BIT 1 0
questionnaire_resp_single Table choice_id BIGINT 19 0
feedback360_quest_field Table descriptionformat BIT 1 null
lti_submission Table userid BIGINT 19 null
appraisal_quest_field Table param3 LONGTEXT 2147483647 null
badge_manual_award Table issuerrole BIGINT 19 null
appraisal_role_assignment Table timecreated BIGINT 19 0
mnet_rpc Table classname VARCHAR 150 null
competency_template Table duedate BIGINT 19 null

The default due date for instances of this plan.

appraisal_quest_field Table defaultdata LONGTEXT 2147483647 null
quiz_grades Table timemodified BIGINT 19 0

The last time this grade changed.

goal_personal Table description LONGTEXT 2147483647 null
facetoface Table allowcancellationsdefault BIT 1 1
enrol Table currency VARCHAR 3 null

Custom - cost currency

role_names Table contextid BIGINT 19 0
scorm_seq_ruleconds Table id BIGINT 19 null
tool_customlang_components Table version VARCHAR 255 null

The checked out version of the plugin, null if the version is unknown

questionnaire_question Table survey_id BIGINT 19 0
reminder Table courseid BIGINT 19 null
course_completion_history Table timecompleted BIGINT 19 null
prog_assignment Table programid BIGINT 19 0
feedback Table publish_stats BIT 1 0
glossary_alias Table entryid BIGINT 19 0
oauth2_issuer Table sortorder BIGINT 19 null

The defined sort order.

enrol_totara_f2f_pending Table enrolid BIGINT 19 0
pos_competencies Table templateid BIGINT 19 null
blog_external Table userid BIGINT 19 null
glossary_entries Table userid BIGINT 19 0
logstore_standard_log Table action VARCHAR 100
facetoface_room_info_data Table id BIGINT 19 null
workshop Table submissionstart BIGINT 19 0

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

comp Table frameworkid BIGINT 19 null
gradingform_guide_comments Table definitionid BIGINT 19 null

The ID of the form definition this faq is part of

appraisal_scale_value Table appraisalscaleid BIGINT 19 null
chat_messages_current Table userid BIGINT 19 0
lti Table password VARCHAR 255 null
event_subscriptions Table id BIGINT 19 null
enrol_paypal Table reason_code VARCHAR 30
user_private_key Table value VARCHAR 128

private access key value

log_queries Table error MEDIUMINT 7 0

is error

chat_users Table groupid BIGINT 19 0
quiz Table reviewoverallfeedback MEDIUMINT 7 0

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

groups_members Table id BIGINT 19 null
course_completion_crit_compl Table rpl VARCHAR 255 null

Totara recognition of prior learning from totara_core

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.

comp_template Table timecreated BIGINT 19 null
groupings Table description LONGTEXT 2147483647 null
forum_posts Table message LONGTEXT 2147483647 null
user Table mnethostid BIGINT 19 0
report_builder Table accessmode SMALLINT 5 0

Controls how access to the report is determined

totara_connect_client_org_frameworks Table fid BIGINT 19 null
user Table lang VARCHAR 30 en
facetoface_cancellation_info_field Table fullname VARCHAR 1024 null
totara_compl_import_course Table id BIGINT 19 null

id

user_enrolments Table timestart BIGINT 19 0
competency_usercompcourse Table usermodified BIGINT 19 null
goal_framework Table idnumber VARCHAR 100 null
cohort Table visibility BIT 1 0

Totara cohort visibility from totara_cohort

grade_grades Table locktime BIGINT 19 0

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

files_reference Table id BIGINT 19 null
choice Table timeclose BIGINT 19 0
grade_outcomes_courses Table courseid BIGINT 19 null

id of the course

oauth2_user_field_mapping Table id BIGINT 19 null
grade_import_values Table id BIGINT 19 null
local_ld_module_day Table day VARCHAR 10

Day formatted as 'YYYY-MM-DD'

facetoface_asset Table hidden BIT 1 0

Do not show this asset in add/search asset dialogs

local_ld_import_logs_status Table timestarted BIGINT 19 null

When the import logs task started

events_queue Table stackdump LONGTEXT 2147483647 null

serialized debug_backtrace showing where the event was fired from

cohort_visibility Table cohortid BIGINT 19 0
questionnaire_survey Table status BIGINT 19 0
tool_customlang Table outdated SMALLINT 5 0

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

appraisal_role_changes Table role SMALLINT 5 null
file_conversion Table timecreated BIGINT 19 null
qtype_ddimageortext Table correctfeedbackformat TINYINT 3 0
prog_assignment Table completioninstance BIGINT 19 0
competency_evidence Table usercompetencyid BIGINT 19 null
goal_type_info_data_param Table dataid BIGINT 19 null
prog_completion_history Table timestarted BIGINT 19 0
org_relations Table id BIGINT 19 null
report_builder Table source VARCHAR 255

Data source on which the report is based

dp_template Table enddate BIGINT 19 null

Timestamp for when plans based on this template end by default.

question Table questiontextformat TINYINT 3 0
questionnaire_quest_choice Table value LONGTEXT 2147483647 null
dp_plan_competency_assign Table priority BIGINT 19 null

Identifies the priority of this competency within the current plan.

certificate_issues Table userid BIGINT 19 0
message_popup Table isread BIT 1 0
facetoface_sessions_dates Table timestart BIGINT 19 0
auth_connect_sso_sessions Table serveruserid 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.

grade_categories Table courseid BIGINT 19 null

The course this grade category is part of

org_type_info_field Table hidden TINYINT 3 null
course Table completionprogressonview BIT 1 0
workshop_grades Table peercommentformat SMALLINT 5 0

The format of peercomment field

course_categories Table depth BIGINT 19 0
question_answers Table feedbackformat TINYINT 3 0
competency_usercompcourse Table grade BIGINT 19 null

The course grade assigned for the competency.

competency_usercomp Table timecreated BIGINT 19 null
scorm Table reference VARCHAR 255
facetoface_session_info_field Table shortname VARCHAR 100 null
license Table source VARCHAR 255 null
glossary_entries Table timemodified BIGINT 19 0
grade_outcomes Table description LONGTEXT 2147483647 null

outcome description

user_password_resets Table userid BIGINT 19 null

id of the user account which requester claimed to be

assignfeedback_editpdf_quick Table width BIGINT 19 120
lesson_grades Table id BIGINT 19 null
portfolio_log Table userid BIGINT 19 null

user who exported content

prog_messagelog Table messageid BIGINT 19 0
quiz_overrides Table quiz BIGINT 19 0

Foreign key references quiz.id

report_builder_schedule Table format VARCHAR 50
feedback_valuetmp Table item BIGINT 19 0
backup_trusted_files Table filesize BIGINT 19 null
rating Table scaleid BIGINT 19 null
course_completion_criteria Table id BIGINT 19 null
lesson_answers Table id BIGINT 19 null
competency_usercompcourse Table courseid BIGINT 19 null

The course this competency is linked to.

facetoface_notification_tpl Table status BIT 1 0
config_plugins Table plugin VARCHAR 100 core
reminder Table type VARCHAR 10 null
lesson Table height BIGINT 19 480
question_attempts Table id BIGINT 19 null
quiz_reports Table id BIGINT 19 null
glossary_entries Table attachment VARCHAR 100
resource_old Table oldid BIGINT 19 null
quiz_feedback Table feedbacktextformat TINYINT 3 0
course Table shortname VARCHAR 255
dp_plan_program_assign Table programid BIGINT 19 null

Identifies the program being assigned

stats_weekly Table stattype VARCHAR 20 activity

type of stat

goal_user_info_field Table param5 LONGTEXT 2147483647 null
lti_types Table baseurl LONGTEXT 2147483647 null
reportbuilder_grp_org_user Table includechildren BIT 1 0
grade_items_history Table gradepass DECIMAL 10 0.00000

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

question_statistics Table discriminativeefficiency DECIMAL 15 null
glossary_formats Table defaulthook VARCHAR 50
block_instances Table requiredbytheme SMALLINT 5 0

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

portfolio_instance_config Table instance BIGINT 19 null

instance of plugin we're configurating

competency_modulecomp Table ruleoutcome TINYINT 3 null

The outcome when an activity is completed.

lti_types Table parameter LONGTEXT 2147483647 null

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

appraisal_role_assignment Table appraisaluserassignmentid BIGINT 19 null
feedback_completed Table random_response BIGINT 19 0
totara_sync_log Table logtype VARCHAR 60 null

log type

lti_tool_proxies Table secret VARCHAR 255 null
sessions Table timemodified BIGINT 19 null
grade_outcomes_history Table scaleid BIGINT 19 null

The recommended scale for this outcome.

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.

goal_record Table id BIGINT 19 null
enrol_lti_lti2_nonce Table value VARCHAR 64
report_builder Table globalrestriction BIT 1 0

Enable global restrictions for this report

qtype_ddimageortext_drops Table id BIGINT 19 null
block_recent_activity Table modname VARCHAR 20 null

module type name (for delete action)

forum_posts Table deleted BIT 1 0

Totara: We use this flag to provide userata purge functionality

course Table enddate BIGINT 19 0
mnet_log Table ip VARCHAR 45
lesson_answers Table pageid BIGINT 19 0
lesson_branch Table flag SMALLINT 5 0
block_totara_featured_links_tiles Table tilerulesshowing BIT 1 0

This field holds whether the tile defined rules are to be applied

appraisal_role_changes Table newuserid BIGINT 19 null
stats_monthly Table timeend BIGINT 19 0
quiz_statistics Table median DECIMAL 15 null
qtype_ddmarker Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

repository_opensesame_pkgs Table description LONGTEXT 2147483647 null

OpenSesame course description

block_zoola_reports_schreps Table lastruntime BIGINT 19 null
tag_coll Table component VARCHAR 100 null
dp_plan_objective Table timecreated BIGINT 19 null
goal Table usermodified BIGINT 19 null
appraisal_user_assignment Table id BIGINT 19 null
profiling Table runreference TINYINT 3 0

Is this run a reference one

org_type_info_field Table forceunique TINYINT 3 null
facetoface_asset_dates Table assetid BIGINT 19 null
enrol Table customint3 BIGINT 19 null

Custom - general int

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.

course Table id BIGINT 19 null
my_pages Table name VARCHAR 200

The page name (freeform text)

prog_courseset Table mincourses SMALLINT 5 0
chat_users Table id BIGINT 19 null
org_type_info_data_param Table dataid BIGINT 19 null
lti_submission_history Table launchid BIGINT 19 null
feedback Table timeopen BIGINT 19 0
local_activityvisibility Table lastmodifieddate BIGINT 19 null
question_response_analysis Table id BIGINT 19 null
message_providers Table component VARCHAR 200

The name of the component that produces these messages

pos_framework Table timecreated BIGINT 19 null
assignfeedback_editpdf_cmnt Table draft TINYINT 3 1

Is this a draft comment?

dp_objective_scale Table name VARCHAR 255 null

Name of the objective scale

goal_type_info_field Table param2 LONGTEXT 2147483647 null
mnet_session Table userid BIGINT 19 0

Unique user ID

prog_info_field Table id BIGINT 19 null
grade_settings Table value LONGTEXT 2147483647 null
glossary_categories Table usedynalink TINYINT 3 1
dp_plan_component_relation Table itemid2 BIGINT 19 null

Identifies the second item in the relation

tool_sitepolicy_localised_policy Table timecreated BIGINT 19 null

Timestamp of when the langauge version of the policy was created

goal Table id BIGINT 19 null
lesson_grades Table lessonid BIGINT 19 0
oauth2_issuer Table showonloginpage TINYINT 3 1
enrol Table expirynotify BIT 1 0

Custom - notify users before expiration

block_zoola_reports_user Table blockinstanceid BIGINT 19 null

Block instance ID

quiz_attempts Table state VARCHAR 16 inprogress

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

dp_plan Table status SMALLINT 5 null

Integer code indicating the state of the plan

course_completion_defaults Table module BIGINT 19 null
groups Table idnumber VARCHAR 100
enrol Table customint2 BIGINT 19 null

Custom - general int

gradingform_rubric_levels Table score DECIMAL 10 null

The score for this level

assignsubmission_file Table id BIGINT 19 null
reminder_message Table subject LONGTEXT 2147483647 null
prog_messagelog Table timeissued BIGINT 19 0
reportbuilder_grp_org_record Table reportbuilderrecordid BIGINT 19 null
goal_type_info_field Table param3 LONGTEXT 2147483647 null
goal_user_info_data_param Table id BIGINT 19 null
certif_completion Table renewalstatus TINYINT 3 0
comp_type Table fullname VARCHAR 1024 null
facetoface Table managerreserve SMALLINT 5 0

Can managers make reservations/bookings on behalf of their team

assign_user_mapping Table id BIGINT 19 null
course_format_options Table name VARCHAR 100

Name of the format option

cache_filters Table timemodified BIGINT 19 0
badge_criteria_param Table value VARCHAR 255 null
competency_framework Table timemodified BIGINT 19 null

The time this competency framework was last modified.

goal Table idnumber VARCHAR 100 null
course Table theme VARCHAR 50
competency_userevidence Table name VARCHAR 100
grade_items Table grademin DECIMAL 10 0.00000

What is the minimum allowable grade?

competency_plan Table reviewerid BIGINT 19 null
assign_overrides Table id BIGINT 19 null
auth_connect_ids Table remoteid BIGINT 19 null

Record id in server table

qtype_ddimageortext Table partiallycorrectfeedbackformat TINYINT 3 0
choice_options Table maxanswers BIGINT 19 0
facetoface_asset_info_field Table description LONGTEXT 2147483647 null
logstore_standard_log Table crud VARCHAR 1
auth_approved_request_snapshots Table firstnamephonetic VARCHAR 255 null
pos Table description LONGTEXT 2147483647 null
facetoface_notification Table cancelled BIT 1 0
feedback360_quest_field Table description LONGTEXT 2147483647 null
comments Table format TINYINT 3 0
job_assignment Table appraiserid BIGINT 19 null

The ID of the user who acts as appraiser for the user in this job assignment

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.

enrol_lti_lti2_consumer Table consumerkey256 VARCHAR 255
goal_user_info_data_param Table value VARCHAR 32
message_read Table subject LONGTEXT 2147483647 null

The message subject

user Table middlename VARCHAR 255 null

Middle name

tag_area Table id BIGINT 19 null
external_services_users Table timecreated BIGINT 19 null

created timestamp

role_capabilities Table contextid BIGINT 19 0
competency_templatecomp Table competencyid BIGINT 19 null

The competency that is linked to this course.

question_attempt_steps Table questionattemptid BIGINT 19 null

Foreign key, references question_attempt.id

external_services_users Table userid BIGINT 19 null
questionnaire_survey Table subtitle LONGTEXT 2147483647 null
question_categories Table contextid BIGINT 19 0

context that this category is shared in

report_builder Table contentmode SMALLINT 5 0

Controls how the content of the report is determined

course_completion_criteria Table enrolperiod BIGINT 19 null

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

questionnaire_feedback Table feedbacklabel VARCHAR 50 null
facetoface_room_info_field Table required TINYINT 3 null
user Table maildigest BIT 1 0
appraisal_role_assignment Table appraisalrole SMALLINT 5 null
cohort Table broken BIT 1 0

Totara broken flag from totara_cohort

feedback360_quest_field Table required BIT 1 0
stats_weekly Table stat2 BIGINT 19 0

stat2. usually used for writes.

lti_tool_settings Table id BIGINT 19 null
question_statistics Table randomguessscore DECIMAL 12 null

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

facetoface_signups Table id 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

pos_framework Table fullname VARCHAR 1024 null
dp_template Table fullname VARCHAR 255 null

User readable name for this template

assignfeedback_comments Table id BIGINT 19 null
local_ld_course Table userid BIGINT 19 null

Foreign key to the user

lesson_answers Table flags SMALLINT 5 0
prog_message Table programid BIGINT 19 0
workshopform_numerrors Table descriptiontrust BIGINT 19 null
prog_courseset Table programid BIGINT 19 0
mnetservice_enrol_courses Table summaryformat SMALLINT 5 0

Format of the summary field

course_categories Table coursecount BIGINT 19 0
comp_type Table shortname VARCHAR 100 null
qtype_ddimageortext_drops Table choice BIGINT 19 0
data Table assessed BIGINT 19 0
dp_plan_evidence_info_field Table param3 LONGTEXT 2147483647 null
goal_user_info_data Table data LONGTEXT 2147483647 null
glossary Table course BIGINT 19 0
goal_user_info_field Table forceunique TINYINT 3 null
data_records Table userid BIGINT 19 0
report_builder_cache Table genstart BIGINT 19 null
workshop_submissions Table gradeoverby BIGINT 19 null

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

block_zoola_reports_schedule Table courseid BIGINT 19 null

Course ID

scorm Table nav BIT 1 1
totara_navigation Table title VARCHAR 1024
user Table lastaccess BIGINT 19 0
mnet_log Table module VARCHAR 20
cohort_rule_params Table value VARCHAR 255 null
chat_users Table lastmessageping BIGINT 19 0
repository_opensesame_pkgs Table duration VARCHAR 20

Duration of course

choice_options Table timemodified BIGINT 19 0
scorm Table hidebrowse BIT 1 0
questionnaire_survey Table thank_head VARCHAR 255 null
tag_area Table itemtype VARCHAR 100
facetoface_session_roles Table id BIGINT 19 null

id of the table

enrol Table customdec1 DECIMAL 12 null

Custom - general decimal

tool_monitor_rules Table timecreated BIGINT 19 null

Time stamp of when this rule was created

event_subscriptions Table name VARCHAR 255
questionnaire_question_type Table typeid BIGINT 19 0

The code for the type.

goal Table shortname VARCHAR 100 null
user_info_field Table datatype VARCHAR 255

Type of data held in this field

facetoface_signups_status Table createdby BIGINT 19 null
totara_userdata_purge_type Table fullname VARCHAR 1333

Human readable name, mutlilang supported

grading_instances Table definitionid BIGINT 19 null

The ID of the form definition this is instance of

blog_association Table id BIGINT 19 null
tool_monitor_rules Table descriptionformat BIT 1 null

Description format

forum_read Table userid BIGINT 19 0
qtype_multichoice_options Table partiallycorrectfeedbackformat TINYINT 3 0
backup_logs Table loglevel SMALLINT 5 null

level of the log (debug...error)

glossary Table defaultapproval TINYINT 3 1
goal_user_info_data Table fieldid BIGINT 19 null
assign_user_mapping Table assignment BIGINT 19 0
totara_navigation Table timemodified BIGINT 19 0
certif_completion Table id BIGINT 19 null
quickaccess_preferences Table userid BIGINT 19 0
quiz Table allowofflineattempts BIT 1 0

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

dp_objective_scale Table description LONGTEXT 2147483647 null

Description of the objective scale

feedback_value_history Table tmp_completed BIGINT 19 0
facetoface_sessioncancel_info_data Table id BIGINT 19 null
user_info_field Table required TINYINT 3 0

Field required

log_queries Table backtrace LONGTEXT 2147483647 null

php execution trace

stats_user_weekly Table stattype VARCHAR 30
lti_types Table course BIGINT 19 null
course_modules Table section BIGINT 19 0
feedback Table site_after_submit VARCHAR 255
message_read Table timeread BIGINT 19 0
book_chapters Table importsrc VARCHAR 255
block_zoola_reports_schedule Table retry BIGINT 19 null

How many times scheduling failed

assignfeedback_editpdf_quick Table rawtext LONGTEXT 2147483647 null
qtype_match_options Table correctfeedbackformat TINYINT 3 0
auth_connect_sso_sessions Table timecreated BIGINT 19 null
scale Table name VARCHAR 255
persistent_login Table useragent LONGTEXT 2147483647 null

Browser info detected during initial login

tool_sitepolicy_localised_policy Table authorid BIGINT 19 null

Who wrote the localised policy

questionnaire_fb_sections Table sectionheadingformat TINYINT 3 1
quiz Table canredoquestions SMALLINT 5 0

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

quickaccess_preferences Table name VARCHAR 255 null
dp_plan_course_assign Table duedate BIGINT 19 null

Timestamp of the date this course is due to be completed.

totara_navigation Table visibility BIT 1 0
chat_messages_current Table timestamp BIGINT 19 0
lti_submission Table datesubmitted BIGINT 19 null
questionnaire_response_text Table question_id BIGINT 19 0
competency_framework Table shortname VARCHAR 100 null

Short name for the competency framework.

stats_weekly Table courseid BIGINT 19 0
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_grades_history Table exported BIGINT 19 0

date of last grade export, 0 if none

grade_items_history Table grademin DECIMAL 10 0.00000

What is the minimum allowable grade?

tool_monitor_events Table contextid BIGINT 19 null

Context id

facetoface_asset_info_field Table param4 LONGTEXT 2147483647 null
appraisal_role_changes Table userassignmentid BIGINT 19 null
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

org_type_info_field Table required TINYINT 3 null
report_builder_cache Table nextreport BIGINT 19 null
dp_plan Table description LONGTEXT 2147483647 null

Description of this development plan

assignment Table var3 BIGINT 19 0
data_content Table fieldid BIGINT 19 0
course_published Table timepublished BIGINT 19 null

The time when the publication occurred

filter_active Table contextid BIGINT 19 null

References context.id.

license Table fullname LONGTEXT 2147483647 null
glossary_categories Table glossaryid BIGINT 19 0
auth_approved_request Table username VARCHAR 100

Requested username - also used for duplicate lookups when signing up

choice Table includeinactive TINYINT 3 1
facetoface_sessioncancel_info_field Table shortname VARCHAR 100 null
feedback Table intro LONGTEXT 2147483647 null
dp_component_settings Table templateid BIGINT 19 null

Identifies which template this component setting is for.

job_assignment Table enddate BIGINT 19 null
qtype_ddimageortext_drops Table no BIGINT 19 0

drop number

auth_approved_request Table userid BIGINT 19 null

User that was created for this signup request.

capabilities Table riskbitmask BIGINT 19 0
files Table author VARCHAR 255 null

The original author of the file

competency_plancomp Table id BIGINT 19 null
goal_grp_org Table orgid BIGINT 19 null
message_processors Table name VARCHAR 166

Name of the message processor

grade_outcomes_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

oauth2_system_account Table username LONGTEXT 2147483647 null

The username that was connected as a system account to this issue.

goal Table frameworkid BIGINT 19 null
org_type_info_data Table id BIGINT 19 null
assign Table id BIGINT 19 null
glossary_entries Table definitiontrust TINYINT 3 0
course_info_field Table datatype VARCHAR 255 null
question_gapselect Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

enrol_paypal Table courseid BIGINT 19 0
external_functions Table capabilities VARCHAR 255 null

all capabilities that are required to be run by the function (separated by comma)

config_log Table plugin VARCHAR 100 null
prog_info_field Table datatype VARCHAR 255 null
facetoface_sessions Table usermodified BIGINT 19 null
auth_approved_request_snapshots Table timecreated BIGINT 19 null
feedback_value Table value LONGTEXT 2147483647 null
forum_read Table postid BIGINT 19 0
totara_userdata_export_type Table allowself BIT 1 0

Allow selection for self export

feedback360 Table status BIT 1 0
workshop Table conclusion LONGTEXT 2147483647 null

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

lesson_pages Table contentsformat TINYINT 3 0
forum_discussion_subs Table preference BIGINT 19 1
mnet_application Table id BIGINT 19 null
grade_categories_history Table aggregateoutcomes BIT 1 0

Aggregate outcomes

wiki_links Table tomissingpage VARCHAR 255 null

link to a nonexistent page

user Table username VARCHAR 100
facetoface_signup_info_field Table sortorder BIGINT 19 null
question_usages Table id BIGINT 19 null
stats_user_monthly Table id BIGINT 19 null
prog_message Table triggertime BIGINT 19 0
dp_course_settings Table id BIGINT 19 null
tool_customlang_components Table name VARCHAR 255

The normalized name of the plugin

cohort_visibility Table instancetype SMALLINT 5 null
lesson Table mediaheight BIGINT 19 100
course_info_field Table param5 LONGTEXT 2147483647 null
grade_categories Table parent BIGINT 19 null

Categories can be hierarchical

lti Table name VARCHAR 255

name field for moodle instances

badge_criteria_met Table datemet BIGINT 19 null
workshop Table gradedecimals SMALLINT 5 0

Number of digits that should be shown after the decimal point when displaying grades

dp_component_settings Table sortorder BIGINT 19 null

Controls the ordering of components, used when displaying component tabs.

block_zoola_reports_schreps Table retry BIGINT 19 0

How many times scheduling failed

org_framework Table fullname VARCHAR 1024 null
question Table timecreated BIGINT 19 0

time question was created

pos_framework Table hidecustomfields TINYINT 3 null
grade_items Table weightoverride BIT 1 0
event Table timestart BIGINT 19 0
auth_approved_request Table alternatename VARCHAR 255 null

Alternate name

course_completion_aggr_methd Table criteriatype BIGINT 19 null

The criteria type we are aggregating, or NULL if complete course aggregation

log Table cmid BIGINT 19 0
grade_items Table decimals BIT 1 null

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

glossary Table allowprintview TINYINT 3 1
mnet_host Table last_log_id BIGINT 19 0
facetoface_asset Table usercreated BIGINT 19 null

user id who created the asset

backup_logs Table id BIGINT 19 null
block_zoola_reports_schedule Table eventcfgid BIGINT 19 0

Foreign key to block_zoola_reports_eventcfg

cohort_rulesets Table timecreated BIGINT 19 null
competency_framework Table timecreated BIGINT 19 null

The time this competency framework was created.

comp_criteria_record Table proficiencymeasured BIGINT 19 null
appraisal_role_assignment Table activepageid BIGINT 19 null
qtype_ddmarker_drags Table id BIGINT 19 null
totara_navigation Table sortorder BIGINT 19 null
post Table usermodified BIGINT 19 null
local_activityvisibility_que Table userid BIGINT 19 null
lti Table icon LONGTEXT 2147483647 null
report_builder_saved Table search LONGTEXT 2147483647 null

Serialized data containing the search details

workshop Table overallfeedbackfiles SMALLINT 5 0

Number of allowed attachments to the overall feedback.

grade_settings Table id BIGINT 19 null
block_zoola_reports_schreps Table exportformat VARCHAR 10

Export format: 'pdf', 'xlsx', 'csv', ...

qtype_ddmarker Table correctfeedbackformat TINYINT 3 0
enrol_paypal Table txn_id VARCHAR 255
file_conversion Table statusmessage LONGTEXT 2147483647 null
assignsubmission_file Table submission BIGINT 19 0
auth_connect_sso_sessions Table id BIGINT 19 null
reportbuilder_grp_pos_record Table includechildren BIT 1 0
facetoface_notification Table title LONGTEXT 2147483647 null
gradingform_rubric_levels Table criterionid BIGINT 19 null

The rubric criterion we are level of

question Table defaultmark DECIMAL 12 1.0000000
mnet_application Table sso_land_url VARCHAR 255
question_usages Table component VARCHAR 255

The plugin this attempt belongs to, e.g. 'mod_quiz', 'block_questionoftheday', 'filter_embedquestion'.

appraisal_event Table appraisalstageid BIGINT 19 null
feedback_valuetmp Table tmp_completed BIGINT 19 0
grade_outcomes_history Table oldid BIGINT 19 null
context_map Table id BIGINT 19 null
workshopform_rubric Table id BIGINT 19 null
user_info_field Table locked TINYINT 3 0

Field locked

badge_criteria Table description LONGTEXT 2147483647 null
facetoface_signup_info_field Table hidden TINYINT 3 null
totara_userdata_export Table timestarted BIGINT 19 null

Start of export process, this happens in ad-hoc task

facetoface_cancellation_info_data_param Table value VARCHAR 32
dp_plan_competency_assign Table scalevalueid BIGINT 19 0

The final id of the proficiency scalevalue. This field is used as a snapshot field, for saving the proficiency, after the plan has been completed

events_handlers Table eventname VARCHAR 166

name of the event, e.g. 'grade_updated'

user_devices Table id BIGINT 19 null
org_framework Table usermodified BIGINT 19 null
sessions Table sid VARCHAR 128

Session id

tag Table timemodified BIGINT 19 null
assignfeedback_editpdf_quick Table colour VARCHAR 10 yellow
mnet_log Table id BIGINT 19 null
data_fields Table type VARCHAR 255
feedback360_quest_field Table name VARCHAR 255
feedback360_resp_assignment Table feedback360emailassignmentid BIGINT 19 null

Email assignments

totara_userdata_export_item Table timefinished BIGINT 19 null

End time of purging method or time when marked as timed out

feedback360_user_assignment Table id BIGINT 19 null
facetoface_notification Table requested BIT 1 0
grade_grades Table feedback LONGTEXT 2147483647 null

grading feedback

workshopform_comments Table sort BIGINT 19 0

Defines the dimension order within the assessment form

goal_type_info_field Table param1 LONGTEXT 2147483647 null
auth_oauth2_linked_login Table issuerid BIGINT 19 null
facetoface_signup_info_data_param Table value VARCHAR 32
reportbuilder_grp_cohort_record Table timecreated BIGINT 19 0
tool_sitepolicy_localised_policy Table policyversionid BIGINT 19 null

Which policy the localised policy is related to

task_scheduled Table faildelay BIGINT 19 null
lti_types Table name VARCHAR 255 basiclti Activity

Activity name

competency Table usermodified BIGINT 19 null

The user who last modified this competency

role_assignments Table roleid BIGINT 19 0
local_ld_module_day Table id BIGINT 19 null
competency_plancomp Table timecreated BIGINT 19 null
goal_personal Table id BIGINT 19 null
registration_hubs Table token VARCHAR 255

the token to communicate with the hub by web service

imscp Table keepold BIGINT 19 -1

incremented when after each file changes, solves browser caching issues

question_answers Table question BIGINT 19 0
auth_approved_request Table managerfreetext LONGTEXT 2147483647 null

Free text field for manager - this is a hint for approver so that they can pick the appropriate manager

workshop Table assessmentend BIGINT 19 0

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

prog_courseset Table id BIGINT 19 null
qtype_ddimageortext_drags Table draggroup BIGINT 19 0
facetoface_cancellation_info_data_param Table dataid BIGINT 19 null
message Table fullmessage LONGTEXT 2147483647 null
dp_plan_competency_assign Table planid BIGINT 19 null

Identifies the plan this competency is attached to

chat_messages Table id BIGINT 19 null
groupings Table timemodified BIGINT 19 0
repository_opensesame_pkgs Table timemodified BIGINT 19 null

Date when package last modified

enrol_lti_tools Table id BIGINT 19 null
question_dataset_definitions Table options VARCHAR 255
certificate Table borderstyle VARCHAR 255 0
dp_course_settings Table templateid BIGINT 19 null

Identifies the template these settings should be applied to

lesson Table custom SMALLINT 5 0
cohort_rulesets Table timemodified BIGINT 19 null
facetoface_cancellation_info_field Table shortname VARCHAR 100 null
report_builder Table showtotalcount BIT 1 0

Should a total count of records before filters are applied be shown

user Table description LONGTEXT 2147483647 null
org_type Table timecreated BIGINT 19 null
quiz_overrides Table id BIGINT 19 null
context_map Table childid BIGINT 19 null

ID of child context

org_type_info_field Table description LONGTEXT 2147483647 null
enrol Table courseid BIGINT 19 null
message_working Table id BIGINT 19 null

id of the table, please edit me

cohort_plan_config Table excludecompleted BIT 1 1

Exclude auto plan creation for users who have a completed plan based on the template id

resource_old Table id BIGINT 19 null
grade_categories_history Table fullname VARCHAR 255

The name of this grade category

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.

facetoface Table multisignupmaximum BIGINT 19 0
workshopform_numerrors_map Table id BIGINT 19 null
forum_posts Table subject VARCHAR 255
local_ld_course_day Table daytime BIGINT 19 null

Timestamp of the beginning of the day

appraisal_scale_value Table name VARCHAR 255 null
grade_categories Table path VARCHAR 255 null

shows the path as /1/2/3 (like course_categories)

assign_user_flags Table id BIGINT 19 null
license Table version BIGINT 19 0
comments Table id BIGINT 19 null
enrol_flatfile Table timemodified BIGINT 19 0
prog Table summary LONGTEXT 2147483647 null
mnetservice_enrol_courses Table startdate BIGINT 19 null
facetoface_room_info_field Table param3 LONGTEXT 2147483647 null
feedback_template Table ispublic BIT 1 0
org Table parentid BIGINT 19 null
mnetservice_enrol_courses Table shortname VARCHAR 100
facetoface_signup_info_field Table param2 LONGTEXT 2147483647 null
dp_plan_objective Table shortname VARCHAR 100 null
totara_userdata_purge Table timecreated BIGINT 19 null

The time of creation of this purge, in case of manual purges this is the time when user requested the purge

external_services Table requiredcapability VARCHAR 150 null
goal_framework Table shortname VARCHAR 100 null
competency Table parentid BIGINT 19 0

The parent competency.

backup_trusted_files Table userid BIGINT 19 null

logged in user at the time of registration

grade_letters Table lowerboundary DECIMAL 10 null

The lower boundary of the letter. Its upper boundary is the lower boundary of the next highest letter, unless there is none above, in which case it's grademax for that grade_item.

reportbuilder_grp_cohort_user Table reportbuilderuserid BIGINT 19 null
block_zoola_schedule_rcp Table userid BIGINT 19 null

user that receives report

feedback360_resp_assignment Table userid BIGINT 19 null
assign Table blindmarking TINYINT 3 0

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

scorm_scoes_track Table attempt BIGINT 19 1
glossary Table showspecial TINYINT 3 1
context Table parentid BIGINT 19 null

Used by Totara SQL access code

org_competencies Table competencyid BIGINT 19 null
cohort Table description LONGTEXT 2147483647 null

Standard description text box

survey Table days MEDIUMINT 7 0
resource_old Table newid BIGINT 19 null
question_statistics Table discriminationindex DECIMAL 15 null
block_quicklinks Table userid BIGINT 19 null
stats_daily Table id BIGINT 19 null
lti_tool_proxies Table guid VARCHAR 255 null
auth_approved_request Table organisationid BIGINT 19 null

Organisation id

facetoface_asset Table description LONGTEXT 2147483647 null
appraisal_event Table delta BIGINT 19 0

Event time delta: + - after event, 0 - immediately, - before event

forum_discussions Table timestart BIGINT 19 0
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.

prog_completion_history Table timedue BIGINT 19 0
prog_completion_log Table id BIGINT 19 null
task_scheduled Table id BIGINT 19 null
questionnaire_survey Table feedbackscores BIT 1 0
feedback_completed_history Table timemodified BIGINT 19 0
dp_plan_history Table reasonfordecision LONGTEXT 2147483647 null

The reason for approving/declining the request

local_activityvisibility_que Table updateat BIGINT 19 null

The timestamp after which the update should take place

certif_completion_history Table status TINYINT 3 null

Certification status

facetoface_notification_hist Table ical_uid VARCHAR 255 null

globally unique id of ical event

pos_type_info_field Table required TINYINT 3 null
user Table lastnamephonetic VARCHAR 255 null

Last name phonetic

feedback360_user_assignment Table feedback360id BIGINT 19 null
glossary Table showall TINYINT 3 1
auth_approved_request Table middlename VARCHAR 255 null

Middle name

workshop Table strategy VARCHAR 30

The type of the current grading strategy used in this workshop

dp_evidence_type Table name VARCHAR 255
resource_old Table type VARCHAR 30
capabilities Table component VARCHAR 100
goal Table proficiencyexpected BIGINT 19 null
chat_users Table course BIGINT 19 0
forum Table completionreplies INT 10 0

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

enrol_lti_lti2_resource_link Table settings LONGTEXT 2147483647 null
tag_correlation Table correlatedtags LONGTEXT 2147483647 null
modules Table name VARCHAR 20
appraisal_quest_field Table id BIGINT 19 null
lesson_attempts Table retry SMALLINT 5 0
dp_plan_history Table planid BIGINT 19 null

The related plan's id

repository_opensesame_pkgs Table timecreated BIGINT 19 null

Date when package added

totara_connect_sso_sessions Table id BIGINT 19 null
goal_item_history Table usermodified BIGINT 19 null
prog_extension Table extensionreason LONGTEXT 2147483647 null
wiki Table timemodified BIGINT 19 0
totara_connect_client_cohorts Table timecreated BIGINT 19 null
oauth2_issuer Table timecreated BIGINT 19 null

Time this record was created.

totara_userdata_export_item Table id BIGINT 19 null
user_private_key Table id BIGINT 19 null
prog_exception Table exceptiontype SMALLINT 5 0
totara_connect_clients Table timemodified BIGINT 19 null
appraisal_grp_org Table appraisalid BIGINT 19 null
config Table id BIGINT 19 null
competency_template Table contextid BIGINT 19 null
dp_competency_settings Table autoassigncourses SMALLINT 5 0

Flag to determine if linked courses should also be added when competencies are auto assigned

question_calculated_options Table incorrectfeedbackformat TINYINT 3 0
grade_grades_history Table informationformat BIGINT 19 0

format of information text

comp Table evidencecount BIGINT 19 null
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)

goal_type Table id BIGINT 19 null
block_zoola_reports_user Table id BIGINT 19 null
dp_plan_program_assign Table manual BIT 1 0

Was this assignment made manually

comp_type_info_field Table hidden TINYINT 3 null
comp_scale_values Table proficient TINYINT 3 0
grading_definitions Table options LONGTEXT 2147483647 null

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

lesson Table progressbar SMALLINT 5 0
assignment Table preventlate TINYINT 3 0
imscp Table timemodified BIGINT 19 0
course_completions Table renewalstatus TINYINT 3 0

Totara renewal status from totara_core

role Table description LONGTEXT 2147483647 null

Empty descriptions may be automatically localised

role_context_levels Table contextlevel BIGINT 19 null
qtype_essay_options Table graderinfo LONGTEXT 2147483647 null

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

dp_plan_course_assign Table reasonfordecision LONGTEXT 2147483647 null

The reason for approving/declining the request

user Table deleted BIT 1 0
local_activityvisibility Table userid BIGINT 19 null
backup_courses Table nextstarttime BIGINT 19 0
goal_user_type Table timecreated BIGINT 19 null
comp_relations Table description LONGTEXT 2147483647 null
dp_plan_evidence_info_field Table description LONGTEXT 2147483647 null
data_fields Table param8 LONGTEXT 2147483647 null
resource Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

portfolio_mahara_queue Table transferid BIGINT 19 null

fk to portfolio_tempdata.id

dp_plan_evidence_info_data_param Table id BIGINT 19 null
grade_grades Table id BIGINT 19 null
event Table courseid 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.

tag_coll Table searchable TINYINT 3 1

Whether the tag collection is searchable

certif_completion_history Table baselinetimeexpires BIGINT 19 null
competency_userevidence Table url LONGTEXT 2147483647 null
grading_definitions Table usermodified BIGINT 19 null

The ID of the user who did the most recent modification

assignment_upgrade Table timecreated BIGINT 19 0
grade_import_values Table userid BIGINT 19 null
wiki_pages Table subwikiid BIGINT 19 0

Subwiki instance of this page

comp_record Table reaggregate BIGINT 19 0
question_statistics Table effectiveweight DECIMAL 15 null
cohort_rules Table name VARCHAR 255
goal_user_assignment Table id BIGINT 19 null
facetoface_sessions Table details LONGTEXT 2147483647 null

Extra information about this session

goal_personal Table scaleid BIGINT 19 null
pos Table usermodified BIGINT 19 null
dp_plan_evidence_relation Table id BIGINT 19 null
grade_letters Table letter VARCHAR 255

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

mnetservice_enrol_courses Table categoryname VARCHAR 255
competency_plan Table status BIT 1 null
data_records Table timecreated BIGINT 19 0
cohort_plan_config Table excludecreatedauto BIT 1 1

Exclude auto plan creation for users who have an existing, automatically created plan based on the template id

lesson_branch Table id BIGINT 19 null
forum_queue Table id BIGINT 19 null
enrol_lti_users Table toolid BIGINT 19 null
auth_connect_servers Table status BIT 1 null

0 means ok, anything else means do not use

lesson_branch Table timeseen BIGINT 19 0
assignment_submissions Table submissioncomment LONGTEXT 2147483647 null
cohort_msg_queue Table id BIGINT 19 null
survey_answers Table survey BIGINT 19 0
appraisal_user_assignment Table timecompleted BIGINT 19 null
enrol_lti_lti2_nonce Table consumerid BIGINT 19 null
certificate_issues Table id BIGINT 19 null
role_context_levels Table roleid BIGINT 19 null
question_statistics Table subquestions LONGTEXT 2147483647 null
block_zoola_reports_eventcfg Table sendtouser BIT 1 0

Add related user's email to recipient list

cohort_role Table usermodified BIGINT 19 null
question_attempts Table questionid BIGINT 19 null

The id of the question being attempted. Foreign key references question.id.

facetoface_cancellation_info_field Table locked TINYINT 3 null
appraisal_stage_data Table appraisalroleassignmentid BIGINT 19 null
dp_plan_evidence_info_data Table fieldid BIGINT 19 null
book Table id BIGINT 19 null
role_sortorder Table contextid BIGINT 19 null
workshop_submissions Table timecreated BIGINT 19 null

Timestamp when the work was submitted for the first time

local_ld_module Table ldcourseid BIGINT 19 null

Foreign key to the local_ld_course table

auth_approved_request Table managerjaid BIGINT 19 null

User id of manager

question_gapselect Table shownumcorrect TINYINT 3 0
question_categories Table sortorder BIGINT 19 999
event Table sequence BIGINT 19 1
lti Table showtitlelaunch BIT 1 0
facetoface_cancellation_info_field Table param1 LONGTEXT 2147483647 null
enrol Table customint8 BIGINT 19 null

Custom - general int

workshop Table timemodified BIGINT 19 null

The timestamp when the module was modified

report_builder_search_cols Table type VARCHAR 255
badge Table nextcron BIGINT 19 null
appraisal_review_data Table appraisalroleassignmentid BIGINT 19 null
portfolio_instance_user Table userid BIGINT 19 null

fk to user table

forum Table warnafter BIGINT 19 0
chat Table schedule SMALLINT 5 0
goal_type_info_field Table param4 LONGTEXT 2147483647 null
report_builder_filters Table customname SMALLINT 5 0

Indicates whether the user has customised a name or if they are still using the default filter name value

facetoface_cancellation_info_field Table datatype VARCHAR 255 null
comp_template Table id BIGINT 19 null
org_type_info_data Table data LONGTEXT 2147483647 null
grading_definitions Table name VARCHAR 255

The title of the form that helps users to identify it

grade_items Table multfactor DECIMAL 10 1.00000

Multiply all grades by this

glossary Table id BIGINT 19 null
certif_completion_history Table timecompleted BIGINT 19 null
message_working Table processorid BIGINT 19 null

The processor with processes the message

dp_plan_settings Table id BIGINT 19 null
quiz_statistics Table id BIGINT 19 null
lesson Table completionendreached BIT 1 0
facetoface_session_info_field Table fullname VARCHAR 1024 null
facetoface_cancellation_info_data_param Table id BIGINT 19 null
grade_outcomes Table timemodified BIGINT 19 null

the time this outcome was last updated

totara_userdata_purge_type Table timechanged BIGINT 19 null

Updated only when user indicates that purges should be reapplied.

lti Table typeid BIGINT 19 null

Basic LTI type

user_info_field Table forceunique TINYINT 3 0

should the field contain unique data

feedback360_grp_pos Table includechildren BIT 1 null
message_metadata Table icon VARCHAR 255 null
qtype_multichoice_options Table correctfeedbackformat TINYINT 3 0
local_activityvisibility Table visible BIT 1 null
enrol_lti_lti2_share_key Table expires BIGINT 19 null
enrol_paypal Table timeupdated BIGINT 19 0
mnet_session Table confirm_timeout BIGINT 19 0

UNIX timestamp for expiry of session

certificate Table printgrade BIGINT 19 0
log Table ip VARCHAR 45
block_zoola_reports_eventcfg Table subject VARCHAR 1333

Email subject

data Table scale BIGINT 19 0
context Table contextlevel BIGINT 19 0
scorm_scoes_track Table scoid BIGINT 19 0
mnet_host Table sslverification BIT 1 0
dp_plan_course_assign Table planid BIGINT 19 null

Identifies the plan this course is attached to

certif_completion_history Table timewindowopens BIGINT 19 null

Date the window opens

totara_userdata_export_type_item Table exportdata BIT 1 null

0 means item skipped during export, 1 means data to be exported

user Table firstaccess BIGINT 19 0
report_builder_global_restriction Table timecreated BIGINT 19 null
totara_core_course_vis_map Table roleid BIGINT 19 null
job_assignment Table shortname VARCHAR 100 null
question_attempts Table maxmark DECIMAL 12 null

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

course_modules Table id BIGINT 19 null
lesson_timer Table userid BIGINT 19 0
questionnaire Table introformat SMALLINT 5 0

text format of intro field

data Table name VARCHAR 255
prog_info_field Table locked TINYINT 3 null
report_builder_filters Table reportid BIGINT 19 null

ID of the report this column belongs to

report_builder_filters Table value VARCHAR 255

Value of filter, used with type to identify the filter option

files_reference Table repositoryid BIGINT 19 null
survey_analysis Table id BIGINT 19 null
appraisal_user_event Table id BIGINT 19 null
external_services_users Table iprestriction VARCHAR 255 null

ip restriction

filter_config Table value LONGTEXT 2147483647 null

The correspoding config variable value.

wiki_pages Table title VARCHAR 255 title

Page name

facetoface Table multiplesessions BIT 1 0
glossary Table name VARCHAR 255
lti Table securetoolurl LONGTEXT 2147483647 null
user_info_data Table data LONGTEXT 2147483647 null

Field data

block_totara_stats Table id BIGINT 19 null
survey Table intro LONGTEXT 2147483647 null
questionnaire_response Table id BIGINT 19 null
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.

auth_approved_request_snapshots Table managerjaid BIGINT 19 null
assignment_submissions Table data2 LONGTEXT 2147483647 null
facetoface_room_info_field Table param1 LONGTEXT 2147483647 null
course_completion_aggr_methd Table course BIGINT 19 0
event Table repeatid BIGINT 19 0
grade_categories_history Table action BIGINT 19 0

created/modified/deleted constants

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.

block_zoola_reports_eventcfg Table lastruntime BIGINT 19 null
course Table sortorder BIGINT 19 0
competency Table description LONGTEXT 2147483647 null

Description of a single competency

qtype_ddmarker_drops Table coords LONGTEXT 2147483647 null
facetoface_notification_tpl Table body LONGTEXT 2147483647 null
resource Table introformat SMALLINT 5 0
course_completion_defaults Table completionexpected BIGINT 19 0
course_info_data Table id BIGINT 19 null
goal_user_assignment Table userid BIGINT 19 null
quiz_statistics Table highestattemptscount BIGINT 19 null
scorm_scoes Table launch LONGTEXT 2147483647 null
question_attempt_step_data Table name VARCHAR 32

The name of this bit of data.

task_scheduled Table component VARCHAR 255

The component this scheduled task belongs to.

data_content Table recordid BIGINT 19 0
goal_item_history Table scalevalueid BIGINT 19 null
grade_items Table iteminfo LONGTEXT 2147483647 null

Info and notes about this item XXX

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.

log Table course BIGINT 19 0
comp_template_assignment Table usermodified BIGINT 19 null
report_builder_graph Table reportid BIGINT 19 null

ID of the report this graph belongs to

prog_extension Table id BIGINT 19 null
course Table completionstartonenrol BIT 1 0

1 = allow use of 'activty completion' progress-tracking on this course. 0 = disable activity completion tracking on this course.

backup_controllers Table checksum VARCHAR 32

checksum of the backup_controller object

report_builder_graph Table settings LONGTEXT 2147483647 null

Custom graph configuration in INI format

local_ld_course Table courseid BIGINT 19 null

Foreign key to the course

events_queue Table eventdata LONGTEXT 2147483647 null

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

course_completion_criteria Table module VARCHAR 100 null

Type of module (if using module criteria type)

enrol_lti_lti2_context Table lticontextkey VARCHAR 255
grade_grades Table rawgrademax DECIMAL 10 100.00000

The maximum allowable grade when this was created

stats_user_daily Table userid BIGINT 19 0
assign_grades Table grader BIGINT 19 0
block_rss_client Table shared TINYINT 3 0
modules Table search VARCHAR 255
prog_future_user_assignment Table assignmentid BIGINT 19 null
cache_flags Table value LONGTEXT 2147483647 null
goal_user_info_field Table locked TINYINT 3 null
feedback_completedtmp Table random_response BIGINT 19 0
goal_type Table description LONGTEXT 2147483647 null
oauth2_system_account Table issuerid BIGINT 19 null

The id of the oauth 2 identity issuer

org_competencies Table timecreated BIGINT 19 null
totara_navigation Table classname VARCHAR 255 null
facetoface_sessioncancel_info_field Table param3 LONGTEXT 2147483647 null
facetoface_room_info_data_param Table dataid BIGINT 19 null
gradingform_guide_comments Table id BIGINT 19 null
data Table timeavailablefrom BIGINT 19 0
competency_usercompplan Table planid BIGINT 19 null

Plan associated to the user.

comp_record Table assessorname VARCHAR 100 null
tool_customlang Table id BIGINT 19 null
block_community Table courseurl VARCHAR 255
lesson_answers Table grade SMALLINT 5 0
glossary Table introformat SMALLINT 5 0
question Table createdby BIGINT 19 null

userid of person who created this question

facetoface_signups Table bookedby BIGINT 19 0

The manager who reserved / booked this space

certificate Table id BIGINT 19 null
course_completion_log Table timemodified BIGINT 19 null
blog_external Table description LONGTEXT 2147483647 null
question_gapselect Table incorrectfeedbackformat TINYINT 3 0
survey_answers Table time BIGINT 19 0
facetoface_room_info_data Table facetofaceroomid BIGINT 19 null
mnet_application Table xmlrpc_server_url VARCHAR 255
tool_sitepolicy_site_policy Table id BIGINT 19 null
quiz Table questiondecimalpoints SMALLINT 5 -1

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

config_log Table oldvalue LONGTEXT 2147483647 null
facetoface_notification_tpl Table ccmanager BIT 1 0
questionnaire_question Table content LONGTEXT 2147483647 null
forum_posts Table discussion BIGINT 19 0
forum_queue Table postid BIGINT 19 0
log_display Table module VARCHAR 20
user_private_key Table script VARCHAR 128

plugin, module - unique identifier

comp_template Table timemodified BIGINT 19 null
report_builder_global_restriction Table description LONGTEXT 2147483647 null

Description of the global report restriction

stats_monthly Table stattype VARCHAR 20 activity

type of stat

course_completions Table organisationid BIGINT 19 null

Totara organisation id from totara_hierarchy

question_usages Table contextid BIGINT 19 null

Every question usage must be associated with some context.

role_context_levels Table id BIGINT 19 null
logstore_standard_log Table relateduserid BIGINT 19 null
question_multianswer Table sequence LONGTEXT 2147483647 null
totara_compl_import_course Table timecreated BIGINT 19 null

Time the record was imported into this table

reportbuilder_grp_cohort_user Table id BIGINT 19 null
question_attempts Table variant BIGINT 19 1

The variant of the qusetion being used.

goal_scale Table name VARCHAR 255 null
totara_userdata_export Table timecreated BIGINT 19 null

Time when user requested the export

grade_grades_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

feedback360_grp_cohort Table cohortid BIGINT 19 null
job_assignment Table timecreated BIGINT 19 null
workshop_submissions Table contenttrust SMALLINT 5 0

The trust mode of the data

appraisal_grp_org Table orgid BIGINT 19 null
goal_scale_values Table name LONGTEXT 2147483647 null
stats_monthly Table stat2 BIGINT 19 0

stat2. usually used for writes.

resource_old Table options VARCHAR 255
enrol_lti_tool_consumer_map Table id BIGINT 19 null
competency_evidence Table url VARCHAR 255 null
cohort_members Table id BIGINT 19 null
facetoface_room Table hidden BIT 1 0

Do not show this room in add/search room dialogs

external_services_users Table validuntil BIGINT 19 null

timestampt - valid until data

goal_type_info_data Table id BIGINT 19 null
auth_oauth2_linked_login Table email LONGTEXT 2147483647 null

The external email to map to this moodle account

grade_items Table locktime BIGINT 19 0

lock all final grades after this date

certif Table id BIGINT 19 null
assignment_upgrade Table newinstance BIGINT 19 0
persistent_login Table lastaccess BIGINT 19 null

Value is copied from the sessions table on timeout

block_zoola_reports_schreps Table body LONGTEXT 2147483647 null

Email message body

auth_oauth2_linked_login Table timemodified BIGINT 19 null
totara_connect_clients Table addnewcourses BIT 1 0

Automatically add all new courses

questionnaire_survey Table thank_body LONGTEXT 2147483647 null
tag_instance Table ordering BIGINT 19 null

Maintains the order of the tag instances of an item

external_services_functions Table id BIGINT 19 null
role_allow_override Table id BIGINT 19 null
prog_completion Table coursesetid BIGINT 19 0
user_info_field Table defaultdataformat TINYINT 3 0
local_ld_course_day Table dedication BIGINT 19 0

Time spent on course within this day

tag_instance Table contextid BIGINT 19 null

The context id of the item that was tagged

scorm_seq_objective Table primaryobj BIT 1 0
message_providers Table id BIGINT 19 null

id of the table, please edit me

data_fields Table param4 LONGTEXT 2147483647 null
forum Table introformat SMALLINT 5 0

text format of intro field

scorm_seq_mapinfo Table targetobjectiveid BIGINT 19 0
facetoface_signups_status Table timecreated BIGINT 19 null
certif_completion_history Table certifpath TINYINT 3 null
grade_items_history Table itemname VARCHAR 255 null

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

facetoface_room_info_data Table fieldid BIGINT 19 null
auth_connect_user_collections Table serverid BIGINT 19 null
block_zoola_module_name Table moduletype VARCHAR 20

Module type (lesson, quiz, ...)

grade_items Table categoryid BIGINT 19 null

(optional) the category group this item belongs to

comp_type_info_field Table description LONGTEXT 2147483647 null
facetoface_session_roles Table userid BIGINT 19 null
org_type_info_field Table typeid BIGINT 19 null
enrol_lti_lti2_tool_proxy Table created BIGINT 19 null
user_enrolments Table enrolid BIGINT 19 null
auth_connect_sso_requests Table timecreated BIGINT 19 null
question_numerical_options Table unitgradingtype SMALLINT 5 0

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

appraisal_quest_field_role Table appraisalquestfieldid BIGINT 19 null
event Table timesort BIGINT 19 null

Totara: Not used as a part of Moodle's new Course Overview Block (MDL-55611)

scorm Table sha1hash VARCHAR 40 null

package content or ext path hash

auth_approved_request Table email VARCHAR 100

The user's email address - also used for duplicate lookups when signing up.

lti Table showdescriptionlaunch BIT 1 0
pos_type_info_field Table fullname VARCHAR 1024 null
prog_completion_history Table positionid BIGINT 19 null
forum_discussions Table archived BIT 1 0

If archived, then exclude this from the completion criteria

totara_connect_client_cohorts Table id BIGINT 19 null
scorm_seq_mapinfo Table readnormalizedmeasure BIT 1 1
grade_items Table id BIGINT 19 null
grade_items_history Table courseid BIGINT 19 null

The course this item is part of

qtype_essay_options Table responseformat VARCHAR 16 editor

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

question_gapselect Table id BIGINT 19 null
report_builder Table fullname VARCHAR 1333

Title of report, displayed on page and used to refer to a report instance

tool_sitepolicy_policy_version Table sitepolicyid BIGINT 19 null

The id of the policy

url Table parameters LONGTEXT 2147483647 null
course_categories Table description LONGTEXT 2147483647 null
appraisal_quest_field Table name VARCHAR 255 null
course_completion_criteria Table gradepass DECIMAL 10 null

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

facetoface_asset_info_field Table shortname VARCHAR 100 null
role_names Table id BIGINT 19 null
appraisal_quest_field Table description LONGTEXT 2147483647 null
mnet_sso_access_control Table mnet_host_id BIGINT 19 0

id of mnet host

dp_template Table visible SMALLINT 5 null

To allow templates to be hidden

goal_user_info_field Table required TINYINT 3 null
comp_template Table shortname VARCHAR 100 null
grade_grades Table informationformat BIGINT 19 0

format of information text

goal Table description LONGTEXT 2147483647 null
facetoface_sessioncancel_info_field Table param2 LONGTEXT 2147483647 null
certif_completion_history Table timeexpires BIGINT 19 null

Date the certificate expires

choice_answers Table id BIGINT 19 null
folder Table introformat SMALLINT 5 0
competency_relatedcomp Table timemodified BIGINT 19 null
enrol_paypal Table tax VARCHAR 255
totara_userdata_purge Table id BIGINT 19 null
qtype_shortanswer_options Table usecase TINYINT 3 0

Whether answers are matched case-sensitively.

competency_relatedcomp Table relatedcompetencyid BIGINT 19 null
feedback_completedtmp Table courseid BIGINT 19 0
workshop Table submissionend BIGINT 19 0

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

glossary Table rsstype TINYINT 3 0
block_totara_featured_links_tiles Table tilerules LONGTEXT 2147483647 null

This is where the data for the tile specific rules go in. Can be pretty much anything you want.

comp Table typeid BIGINT 19 0
assignfeedback_editpdf_cmnt Table id BIGINT 19 null
qtype_multichoice_options Table single SMALLINT 5 0

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

scorm_scoes Table identifier VARCHAR 255
external_tokens Table contextid BIGINT 19 null

context id where in token valid

book Table navstyle SMALLINT 5 1
question_response_analysis Table hashcode VARCHAR 40

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

role_assignments Table timemodified BIGINT 19 0
forum_discussions Table id BIGINT 19 null
appraisal_review_data Table scope BIT 1 null
grade_grades_history Table hidden BIGINT 19 0

show 0, hide 1 or hide until date

forum Table id BIGINT 19 null
feedback Table timeclose BIGINT 19 0
repository_instances Table contextid BIGINT 19 null
lesson_attempts Table id BIGINT 19 null
glossary_entries Table usedynalink TINYINT 3 1
dp_objective_scale_value Table idnumber VARCHAR 100 null

Defines a id that can be assigned to a scale value

enrol_lti_lti2_consumer Table ltiversion VARCHAR 10 null
lesson Table retake SMALLINT 5 1
qtype_ddmarker_drops Table shape VARCHAR 255 null

circle, rectangle, polygon

book_chapters Table bookid BIGINT 19 0
competency_framework Table idnumber VARCHAR 100 null

Unique idnumber for this competency framework.

forum_posts Table created BIGINT 19 0
logstore_standard_log Table contextinstanceid BIGINT 19 null
qtype_essay_options Table responsetemplateformat SMALLINT 5 0

The text format for responsetemplate.

competency_template Table shortname VARCHAR 100 null

Short name for the learning plan template.

block_positions Table subpage VARCHAR 16

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

mnet_sso_access_control Table username VARCHAR 100

Username

lti_submission Table gradepercent DECIMAL 10 null
facetoface_session_info_data_param Table value VARCHAR 32
job_assignment Table timemodified BIGINT 19 null
competency_coursecomp Table courseid BIGINT 19 null

The course this competency is linked to.

lesson_pages Table prevpageid BIGINT 19 0
role_allow_override Table allowoverride BIGINT 19 0
question Table category BIGINT 19 0
log_queries Table id BIGINT 19 null
tool_customlang Table componentid BIGINT 19 null

The id of the component

facetoface_signup_info_data_param Table dataid BIGINT 19 null
grade_letters Table contextid BIGINT 19 null

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

choice Table intro LONGTEXT 2147483647 null
prog_completion_history Table coursesetid BIGINT 19 0
facetoface_signup_info_data_param Table id BIGINT 19 null
tag Table flag SMALLINT 5 0

a tag can be 'flagged' as inappropriate

glossary_categories Table id BIGINT 19 null
certificate Table datefmt BIGINT 19 0
post Table format BIGINT 19 0
report_builder_schedule Table usermodified BIGINT 19 0

user who last modified the scheduled report settings

questionnaire_response Table grade BIGINT 19 0

Grade awarded

dp_template Table sortorder BIGINT 19 null

Field to determine the order of the templates when displayed together

dp_permissions Table component VARCHAR 255 null

Shortname of component this permission is related to. Same as folder name in components or plan if related to the whole plan.

cohort_plan_history Table planstatus BIGINT 19 null
goal_scale_values Table timemodified BIGINT 19 null
questionnaire_attempts Table rid BIGINT 19 0
block_totara_stats Table userid BIGINT 19 null
course Table summaryformat TINYINT 3 0
dp_objective_scale_value Table usermodified BIGINT 19 null

Identifies the id of the user who last modified the scale value

message_read Table useridto BIGINT 19 0
dp_template Table shortname VARCHAR 100 null

A shorter name for this template (optional)

scorm Table displayactivityname SMALLINT 5 1
quiz Table reviewrightanswer MEDIUMINT 7 0

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

dp_plan_evidence Table timemodified BIGINT 19 null

Timestamp indicating when this evidence item was last modified

appraisal_quest_field Table param5 LONGTEXT 2147483647 null
forum_discussion_subs Table userid BIGINT 19 null
qtype_multichoice_options Table shuffleanswers SMALLINT 5 1

Whether the choices can be randomly shuffled.

oauth2_system_account Table refreshtoken LONGTEXT 2147483647 null