Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
job_assignment Table fullname LONGTEXT 2147483647 null

Null is allowed and will be displayed using a default string (which includes idnumber).

workshop_grades Table grade DECIMAL 10 null

Given grade in the referenced assessment dimension.

dp_priority_scale Table usermodified BIGINT 19 null

Identifies the id of the user who last modified the priority scale

comp_framework Table fullname VARCHAR 1024
assign_plugin_config Table subtype VARCHAR 28
goal_user_type Table idnumber VARCHAR 100 null
course_completion_log Table courseid BIGINT 19 null

Course ID

choice Table introformat SMALLINT 5 0
workshop_old Table assessmentcomps SMALLINT 5 2
stats_monthly Table stattype VARCHAR 20 activity

type of stat

goal_record Table userid BIGINT 19 null
cohort_rulesets Table timecreated BIGINT 19 null
block_quicklinks Table userid BIGINT 19 null
assignfeedback_editpdf_cmnt Table draft TINYINT 3 1

Is this a draft comment?

goal_scale Table id BIGINT 19 null
question_calculated Table tolerance VARCHAR 20 0.0
stats_weekly Table stattype VARCHAR 20 activity

type of stat

quiz_feedback Table maxgrade DECIMAL 10 0.00000

The upper limit of this grade band. Exclusive.

facetoface_notification Table issent BIT 0 0
files_reference Table repositoryid BIGINT 19 null
quiz Table showuserpicture SMALLINT 5 0

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

workshop_assessments_old Table resubmission SMALLINT 5 0
lti_tool_proxies Table regurl LONGTEXT 2147483647 null
job_assignment Table managerjapath VARCHAR 1024

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

pos_type_info_field Table sortorder BIGINT 19 null
org Table id BIGINT 19 null
scorm Table skipview BIT 0 1
workshop_submissions Table timegraded BIGINT 19 null

The timestamp when grade or gradeover was recently modified

course_modules Table module BIGINT 19 0
lesson_answers Table timecreated BIGINT 19 0
assign_grades Table userid BIGINT 19 0
goal_framework Table usermodified BIGINT 19 null
workshop_old Table nelements SMALLINT 5 1
portfolio_log Table caller_component VARCHAR 255 null

the component name responsible for exporting

enrol_flatfile Table roleid BIGINT 19 null
prog_completion_history Table timecompleted BIGINT 19 0
appraisal_role_assignment Table userid BIGINT 19 null
forum_read Table postid BIGINT 19 0
page Table introformat SMALLINT 5 0
dp_course_settings Table prioritymode SMALLINT 5 0

Defines how priorities are handled within this component

qtype_ddmarker Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

facetoface_session_roles Table sessionid BIGINT 19 null
data Table jstemplate LONGTEXT 2147483647 null
local_ld_course_day Table dedication BIGINT 19 0

Time spent on course within this day

competency Table scaleid BIGINT 19 null
goal_scale_values Table id BIGINT 19 null
question_attempts Table questionsummary LONGTEXT 2147483647 null

If this question uses randomisation, it should set this field to summarise what random version the student actually saw. This is a human-readable textual summary of the student's response which might, for example, be used in a report.

appraisal_quest_field Table defaultdata LONGTEXT 2147483647 null
dp_plan_competency_assign Table duedate BIGINT 19 null

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

feedback_value_history Table completed BIGINT 19 0
message_airnotifier_devices Table userdeviceid BIGINT 19 null

The user device id in the user_devices table

quiz_feedback Table quizid BIGINT 19 0

Foreign key references quiz.id.

feedback_valuetmp Table completed BIGINT 19 0
gradingform_rubric_levels Table criterionid BIGINT 19 null

The rubric criterion we are level of

enrol Table customtext4 LONGTEXT 2147483647 null

Custom - general text

dp_plan_evidence_info_field Table defaultdata LONGTEXT 2147483647 null
grade_items_history Table sortorder BIGINT 19 0

Sorting order of the columns

grade_import_newitem Table itemname VARCHAR 255

new grade item name

goal_type_info_field Table param4 LONGTEXT 2147483647 null
competency_userevidencecomp Table id BIGINT 19 null
editor_atto_autosave Table timemodified BIGINT 19 0

Store the last modified time for the auto save text.

prog_completion Table positionid BIGINT 19 null
block_zoola_reports_user Table blockinstanceid BIGINT 19 null

Block instance ID

org Table usermodified BIGINT 19 null
tool_monitor_events Table contextid BIGINT 19 null

Context id

badge_backpack Table email VARCHAR 100
facetoface_room_info_field Table sortorder BIGINT 19 null
assign Table duedate BIGINT 19 0

The due date for the assignment. Displayed to students.

report_builder_columns Table heading VARCHAR 1024 null

Visible heading describing the column to report users

feedback360_quest_field Table name VARCHAR 255
prog_user_assignment Table programid BIGINT 19 0
competency_userevidence Table timecreated BIGINT 19 null
messageinbound_handlers Table enabled BIT 0 0

Whether this handler is currently enabled.

repository_opensesame_pkgs Table duration VARCHAR 20

Duration of course

license Table fullname LONGTEXT 2147483647 null
report_builder_global_restriction Table name VARCHAR 255
assign Table allowsubmissionsfromdate BIGINT 19 0

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

enrol_lti_lti2_resource_link Table updated BIGINT 19 null
question_calculated_options Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

resource_old Table newmodule VARCHAR 50 null
workshopform_numerrors Table grade1 VARCHAR 50 null

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

dp_plan_evidence_info_field Table param1 LONGTEXT 2147483647 null
report_builder_schedule Table schedule BIGINT 19 null
workshopform_numerrors_map Table grade DECIMAL 10 null

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

quiz Table password VARCHAR 255

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

block_quicklinks Table url VARCHAR 255
feedback Table page_after_submitformat TINYINT 3 0
reportbuilder_grp_pos_user Table timecreated BIGINT 19 0
message_metadata Table id BIGINT 19 null

id of the table, please edit me

dp_plan Table templateid BIGINT 19 null

Identifies the template used by this plan.

cohort Table timecreated BIGINT 19 null
role_assignments Table id BIGINT 19 null
comp Table usermodified BIGINT 19 null
feedback360_quest_field Table param2 LONGTEXT 2147483647 null
repository_opensesame_bps Table packageid BIGINT 19 null
prog_courseset Table coursesumfieldtotal SMALLINT 5 0
quiz_statistics Table highestattemptscount BIGINT 19 null
scorm_aicc_session Table scoid BIGINT 19 0

id from scorm_scoes table

lesson Table displayleftif SMALLINT 5 0
upgrade_log Table type BIGINT 19 null

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

portfolio_instance_config Table instance BIGINT 19 null

instance of plugin we're configurating

comp Table description LONGTEXT 2147483647 null
cohort_plan_config Table cohortid BIGINT 19 null

The cohort id

reportbuilder_grp_org_record Table includechildren BIT 0 0
prog_exception Table userid BIGINT 19 0
workshop_submissions Table id BIGINT 19 null
cohort_plan_history Table planstatus BIGINT 19 null
lesson Table practice SMALLINT 5 0
competency_usercompcourse Table userid BIGINT 19 null

User associated to the competency.

forum Table assesstimefinish BIGINT 19 0
comp Table timecreated BIGINT 19 null
chat Table chattime BIGINT 19 0
enrol_lti_lti2_context Table settings LONGTEXT 2147483647 null
lesson_overrides Table groupid BIGINT 19 null

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

assignfeedback_file Table id BIGINT 19 null
course_categories Table visible BIT 0 1
dp_plan_evidence_info_field Table sortorder BIGINT 19 null
logstore_standard_log Table realuserid BIGINT 19 null

real user id when logged-in-as

qtype_essay_options Table attachmentsrequired SMALLINT 5 0

The number of attachments that should be required

lesson Table grade BIGINT 19 0
goal_scale_values Table timemodified BIGINT 19 null
persistent_login Table id BIGINT 19 null
repository_instance_config Table value LONGTEXT 2147483647 null
workshopform_accumulative Table weight MEDIUMINT 7 1

The weigh of the dimension

tool_monitor_history Table sid BIGINT 19 null

Subscription id

dp_template Table enddate BIGINT 19 null

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

mnet_host2service Table hostid BIGINT 19 0
wiki Table editend BIGINT 19 0

editend

messageinbound_datakeys Table expires BIGINT 19 null

The expiry time of this key.

mnet_application Table display_name VARCHAR 50
auth_approved_request Table id BIGINT 19 null
assignfeedback_editpdf_annot Table type VARCHAR 10 line

line, oval, rect, etc.

user Table institution VARCHAR 255
facetoface_signup_info_data Table fieldid BIGINT 19 null
course Table calendartype VARCHAR 30
quiz_overrides Table userid BIGINT 19 null

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

user_enrolments Table timestart BIGINT 19 0
user Table lastnamephonetic VARCHAR 255 null

Last name phonetic

totara_userdata_purge_item Table component VARCHAR 100

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

competency_evidence Table desccomponent VARCHAR 255
facetoface_notification_hist Table timecreated BIGINT 19 null

timestamp of record creation

enrol_lti_tools Table country VARCHAR 2
rating Table id BIGINT 19 null
event Table courseid BIGINT 19 0
question_answers Table question BIGINT 19 0
auth_approved_request Table userid BIGINT 19 null

User that was created for this signup request.

backup_controllers Table controller LONGTEXT 2147483647 null

serialised backup_controller object

appraisal_event Table timescheduled BIGINT 19 null
grade_letters Table id BIGINT 19 null
choice Table showpreview TINYINT 3 0
blog_external Table timemodified BIGINT 19 null
course Table format VARCHAR 21 topics
org_type_info_data_param Table dataid BIGINT 19 null
report_builder_filters Table region SMALLINT 5 0

Indicates whether filter appears at the top or in the sidebar

post Table summary LONGTEXT 2147483647 null
files Table referencefileid BIGINT 19 null

Use to indicate file is a proxy for repository file

lesson_overrides Table retake SMALLINT 5 null
enrol Table timecreated BIGINT 19 0
grade_categories_history Table aggregateoutcomes BIT 0 0

Aggregate outcomes

external_services Table enabled BIT 0 null
comp_type_info_data Table fieldid BIGINT 19 null
enrol_lti_lti2_context Table created BIGINT 19 null
cohort Table visible BIT 0 1

Visibility to teachers - Totara may be using different logic

lti Table secureicon LONGTEXT 2147483647 null
dp_plan_program_assign Table manual BIT 0 0

Was this assignment made manually

question_numerical_options Table unitgradingtype SMALLINT 5 0

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

auth_approved_request_snapshots Table timemodified BIGINT 19 null
forum Table timemodified BIGINT 19 0
qtype_multichoice_options Table shuffleanswers SMALLINT 5 1

Whether the choices can be randomly shuffled.

prog Table availablefrom BIGINT 19 0
forum_discussions Table pinned BIT 0 0
certif_completion Table timeexpires BIGINT 19 null

Date the certificate expires

groupings Table idnumber VARCHAR 100
appraisal Table description LONGTEXT 2147483647 null
scorm Table timemodified BIGINT 19 0
message_metadata Table onreject LONGTEXT 2147483647 null

serialised action on message rejection

dp_priority_scale Table defaultid BIGINT 19 null

Identifies the id of the default scale value

course Table timecreated BIGINT 19 0
competency_usercompplan Table grade BIGINT 19 null

Grade assigned to the competency.

mnet_session Table id BIGINT 19 null

Required ID field

auth_connect_user_collections Table serverid BIGINT 19 null
editor_atto_autosave Table drafttext LONGTEXT 2147483647 null

The draft text

logstore_standard_log Table origin VARCHAR 10 null

cli, cron, ws, etc.

question_response_analysis Table hashcode VARCHAR 40

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

goal_user_info_field Table shortname VARCHAR 100 null
question_attempts Table questionid BIGINT 19 null

The id of the question being attempted. Foreign key references question.id.

grade_categories Table aggregateoutcomes BIT 0 0

Aggregate outcomes

scorm Table popup BIT 0 0
reminder_message Table copyto LONGTEXT 2147483647 null
facetoface_sessions Table discountcost VARCHAR 255 0

Discounted cost of the event

course_modules Table completion BIT 0 0

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

mnetservice_enrol_courses Table categoryname VARCHAR 255
external_functions Table capabilities VARCHAR 255 null

all capabilities that are required to be run by the function (separated by comma)

task_scheduled Table disabled BIT 0 0

1 means do not run from cron

dp_permissions Table value SMALLINT 5 null

Integer value representing the permission, or null if not set

quiz Table shuffleanswers SMALLINT 5 0

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

stats_user_daily Table userid BIGINT 19 0
scorm_seq_objective Table id BIGINT 19 null
book Table course BIGINT 19 0
facetoface_room_info_field Table hidden TINYINT 3 null
comments Table contextid BIGINT 19 null
grading_definitions Table areaid BIGINT 19 null
user_password_resets Table id BIGINT 19 null
totara_connect_client_org_frameworks Table fid BIGINT 19 null
workshopform_accumulative Table id BIGINT 19 null
course_categories Table sortorder BIGINT 19 0
lesson_pages Table title VARCHAR 255
logstore_standard_log Table objecttable VARCHAR 50 null
workshop_stockcomments_old Table workshopid BIGINT 19 0
competency_modulecomp Table timecreated BIGINT 19 null

The time this record was created.

grade_categories_history Table courseid BIGINT 19 null

The course this grade category is part of

block_totara_featured_links_tiles Table sortorder BIGINT 19 1

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

dp_plan_settings Table templateid BIGINT 19 null

Identifies the template these settings should be applied to

totara_compl_import_course Table importuserid BIGINT 19 null

ID of user running the import

task_scheduled Table nextruntime BIGINT 19 null
course_request Table fullname VARCHAR 254
assignment Table timedue BIGINT 19 0
enrol Table customint4 BIGINT 19 null

Custom - general int

rating Table timemodified BIGINT 19 null
comp Table path VARCHAR 255 null
question_statistics Table timemodified BIGINT 19 null
prog_info_data Table programid BIGINT 19 null
grade_categories_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

report_builder_cache Table nextreport BIGINT 19 null
feedback_completed Table random_response BIGINT 19 0
appraisal_stage_data Table timecompleted BIGINT 19 null
enrol_flatfile Table timemodified BIGINT 19 0
prog_courseset Table recurcreatetime BIGINT 19 0
feedback Table intro LONGTEXT 2147483647 null
forum_read Table firstread BIGINT 19 0
facetoface_cancellation_info_field Table defaultdata LONGTEXT 2147483647 null
facetoface_room_info_field Table locked TINYINT 3 null
scorm_seq_rulecond Table operator VARCHAR 5 noOp
block_zoola_reports_schedule Table id BIGINT 19 null
goal_user_info_data_param Table value VARCHAR 32
persistent_login Table lastaccess BIGINT 19 null

Value is copied from the sessions table on timeout

repository_instance_config Table id BIGINT 19 null
comp_type_info_field Table datatype VARCHAR 255 null
comp_record_history Table timeproficient BIGINT 19 null
survey_analysis Table userid BIGINT 19 0
totara_userdata_purge Table userid BIGINT 19 null

The target user

repository_opensesame_pkgs Table title VARCHAR 1333

OpenSesame course title

data Table timeviewfrom BIGINT 19 0
job_assignment Table organisationid BIGINT 19 null

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

goal_framework Table timemodified BIGINT 19 null
workshop_assessments_old Table timegraded BIGINT 19 0
profiling Table url VARCHAR 255

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

badge_issued Table dateexpire BIGINT 19 null
blog_association Table id BIGINT 19 null
user_private_key Table userid BIGINT 19 null

owner

dp_plan_objective Table fullname VARCHAR 255 null
cohort_rule_params Table ruleid BIGINT 19 null
pos_type_info_field Table param2 LONGTEXT 2147483647 null
gradingform_guide_fillings Table remarkformat TINYINT 3 null

The format of the remark field

facetoface_sessions Table allowcancellations BIT 0 1
comp_type_info_data_param Table id BIGINT 19 null
competency_plancomp Table id BIGINT 19 null
facetoface_signup_info_data Table data LONGTEXT 2147483647 null
quiz_attempts Table sumgrades DECIMAL 10 null

Total marks for this attempt.

prog_info_field Table locked TINYINT 3 null
grade_items Table plusfactor DECIMAL 10 0.00000

Add this to all grades

files Table filearea VARCHAR 50

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

rating Table userid BIGINT 19 null
external_services Table restrictedusers BIT 0 null
grading_definitions Table usercreated BIGINT 19 null

The ID of the user who created this definition and is considered as its owner for access control purposes

stats_weekly Table courseid BIGINT 19 0
question Table version VARCHAR 255
lesson Table dependency BIGINT 19 0
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.

certificate Table requiredtime BIGINT 19 0
tool_usertours_steps Table title LONGTEXT 2147483647 null

Title of the step

job_assignment Table synctimemodified BIGINT 19 0
facetoface_sessions Table allowoverbook BIT 0 0

Flag to turn on waitlisting of signups over capacity.

mnet_log Table hostid BIGINT 19 0

Unique host ID

competency Table path VARCHAR 255

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

lesson Table height BIGINT 19 480
glossary_entries Table definition LONGTEXT 2147483647 null
label Table intro LONGTEXT 2147483647 null
assign_user_flags Table id BIGINT 19 null
course_info_field Table param4 LONGTEXT 2147483647 null
competency_relatedcomp Table usermodified BIGINT 19 null
competency Table timecreated BIGINT 19 null

The time this competency was created.

workshop_old Table wtype SMALLINT 5 0
feedback360_scale_value Table feedback360scaleid BIGINT 19 null
competency_framework Table idnumber VARCHAR 100 null

Unique idnumber for this competency framework.

enrol_paypal Table business VARCHAR 255
grading_areas Table areaname VARCHAR 100

The name of gradable area

dp_template Table sortorder BIGINT 19 null

Field to determine the order of the templates when displayed together

cohort_rules Table rulesetid BIGINT 19 null
job_assignment Table startdate BIGINT 19 null
course_info_field Table fullname LONGTEXT 2147483647 null
feedback Table publish_stats BIT 0 0
user_info_field Table datatype VARCHAR 255

Type of data held in this field

events_queue_handlers Table errormessage LONGTEXT 2147483647 null

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

grade_grades_history Table usermodified BIGINT 19 null

the userid of the person who last modified this grade

course Table maxbytes BIGINT 19 0
forum Table name VARCHAR 255
appraisal_grp_pos Table posid BIGINT 19 null
badge_manual_award Table datemet BIGINT 19 null
survey_analysis Table notes LONGTEXT 2147483647 null
forum_digests Table id BIGINT 19 null
prog_future_user_assignment Table programid BIGINT 19 null
workshopform_rubric Table description LONGTEXT 2147483647 null

The description of the dimension

sessions Table sid VARCHAR 128

Session id

dp_template Table id BIGINT 19 null
pos Table path VARCHAR 255 null
qtype_ddimageortext Table id BIGINT 19 null
auth_approved_request_snapshots Table userid BIGINT 19 null
post Table moduleid BIGINT 19 0
user Table totarasync BIT 0 0

Totara sync flag from totara_sync

lti_tool_proxies Table serviceoffered LONGTEXT 2147483647 null

List of services offered, one per line

qtype_ddimageortext Table shuffleanswers SMALLINT 5 1
tool_usertours_steps Table content LONGTEXT 2147483647 null

Content of the user tour - allow for multilang tags

prog_future_user_assignment Table assignmentid BIGINT 19 null
competency_coursecompsetting Table courseid BIGINT 19 null

The course this setting is linked to.

totara_userdata_user Table suspendedpurgetypeid BIGINT 19 null
competency_plancomp Table usermodified BIGINT 19 null
report_builder_filters Table defaultvalue LONGTEXT 2147483647 null

Serialized data containing the default value for the filter

reminder Table deleted BIT 0 null
enrol_lti_users Table consumersecret LONGTEXT 2147483647 null
resource_old Table alltext LONGTEXT 2147483647 null
external_services Table shortname VARCHAR 255 null

a unique shortname

user_info_data Table userid BIGINT 19 0

id from the user table

org_type_info_field Table typeid BIGINT 19 null
task_scheduled Table blocking TINYINT 3 0

Block the entire cron when this task is running.

facetoface Table timecreated BIGINT 19 0
badge_manual_award Table issuerid BIGINT 19 null
scorm Table autocommit BIT 0 0
competency_plan Table templateid BIGINT 19 null
cohort_rulesets Table sortorder BIGINT 19 null
user Table emailstop BIT 0 0
assignment_upgrade Table newcmid BIGINT 19 0
folder Table display SMALLINT 5 0

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

user_devices Table timemodified BIGINT 19 null
assign_overrides Table duedate BIGINT 19 null

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

block_totara_featured_links_tiles Table type VARCHAR 100

This is the type of tile. Basically a namespace to a class that extends base

repository_instances Table userid BIGINT 19 0
qtype_ddmarker Table incorrectfeedbackformat TINYINT 3 0
enrol_paypal Table reason_code VARCHAR 30
comp Table evidencecount BIGINT 19 null
auth_connect_servers Table clientsecret VARCHAR 64

Secret the server is using in client requests

cohort Table active BIT 0 0

Totara active flag from totara_cohort

user_info_field Table description LONGTEXT 2147483647 null

Description of field

appraisal_event Table triggered BIT 0 0
scorm Table displayactivityname SMALLINT 5 1
totara_connect_sso_sessions Table timecreated BIGINT 19 null
role_capabilities Table id BIGINT 19 null
data_content Table content2 LONGTEXT 2147483647 null
local_ld_course Table userid BIGINT 19 null

Foreign key to the user

portfolio_tempdata Table expirytime BIGINT 19 null

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

event Table sequence BIGINT 19 1
lesson_pages Table qtype SMALLINT 5 0
scorm_seq_rolluprule Table action VARCHAR 15
comp_relations Table id BIGINT 19 null
appraisal_grp_org Table orgid BIGINT 19 null
cohort_msg_queue Table id BIGINT 19 null
forum Table completiondiscussions INT 10 0

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

grade_grades Table userid BIGINT 19 null

The user who this grade is for

question_attempt_steps Table timecreated BIGINT 19 null

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

logstore_standard_log Table timecreated BIGINT 19 null
message_metadata Table messageid BIGINT 19 null

message that still needs some processing (on message table)

auth_approved_request Table password VARCHAR 255

Hashed user password

feedback360_quest_field Table param1 LONGTEXT 2147483647 null
gap_aspirational Table id BIGINT 19 null
tag Table descriptionformat TINYINT 3 0
pos Table id BIGINT 19 null
forum_read Table id BIGINT 19 null
data_records Table timemodified BIGINT 19 0
course_completion_history Table timecompleted BIGINT 19 null
comp_record_history Table competencyid BIGINT 19 null
facetoface_signups Table discountcode LONGTEXT 2147483647 null
stats_daily Table stat2 BIGINT 19 0

stat2. usually used for writes.

events_handlers Table id BIGINT 19 null
facetoface Table forceselectjobassignment BIT 0 0

Error if no suitable job assignment is available when signing up

tool_monitor_history Table timesent BIGINT 19 null

Timestamp of when the message was sent.

tool_usertours_tours Table pathmatch VARCHAR 255 null
message_working Table unreadmessageid BIGINT 19 null

message that still needs some processing (on message table)

workshop_old Table newid BIGINT 19 null
appraisal_scale_data Table id BIGINT 19 null
question_calculated Table correctanswerformat BIGINT 19 2
wiki Table introformat SMALLINT 5 0

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

wiki Table editbegin BIGINT 19 0

editbegin

choice Table timeclose BIGINT 19 0
book Table intro LONGTEXT 2147483647 null
facetoface_room Table custom BIT 0 0

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

cohort_plan_config Table id BIGINT 19 null
goal_type Table usermodified BIGINT 19 null
org_type_info_field Table fullname VARCHAR 1024 null
prog_info_field Table fullname VARCHAR 1024 null
pos_type_info_field Table fullname VARCHAR 1024 null
competency_usercompcourse Table usermodified BIGINT 19 null
quiz Table delay1 BIGINT 19 0

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

block_recent_activity Table timecreated BIGINT 19 null
prog_courseset Table certifpath TINYINT 3 1

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

prog_completion Table userid BIGINT 19 0
lesson_pages Table qoption SMALLINT 5 0
lti_submission Table state TINYINT 3 null
assign Table blindmarking TINYINT 3 0

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

report_builder_group Table baseitem VARCHAR 255 null

Unique reference to the base item for this activity group

scale_history Table action BIGINT 19 0

created/modified/deleted constants

tool_monitor_rules Table userid BIGINT 19 null

Id of user who created the rule

report_builder_group_assign Table itemid VARCHAR 255

ID of the item to assign to the group

scorm_scoes Table parent VARCHAR 255
report_builder_schedule_email_systemuser Table userid BIGINT 19 null
question Table timecreated BIGINT 19 0

time question was created

goal_scale_values Table usermodified BIGINT 19 null
user Table suspended BIT 0 0

suspended flag prevents users to log in

facetoface Table managerreserve SMALLINT 5 0

Can managers make reservations/bookings on behalf of their team

forum_posts Table modified BIGINT 19 0
course Table groupmode SMALLINT 5 0
enrol_lti_tool_consumer_map Table id BIGINT 19 null
totara_connect_clients Table clientsecret VARCHAR 64

Shared secret, used in client requests

feedback_valuetmp Table id BIGINT 19 null
report_builder_schedule Table exporttofilesystem BIGINT 19 0
goal_user_info_data Table id BIGINT 19 null
user Table firstname VARCHAR 100
appraisal_quest_field Table datatype VARCHAR 255
facetoface_notification_tpl Table ccmanager BIT 0 0
my_pages Table name VARCHAR 200

The page name (freeform text)

dp_competency_settings Table autoassignorg SMALLINT 5 0
dp_plan_course_assign Table priority BIGINT 19 null

Identifies the priority of this course within the current plan.

block_positions Table weight BIGINT 19 null

Used to order the blocks within a block region.

qtype_randomsamatch_options Table partiallycorrectfeedbackformat TINYINT 3 0
totara_userdata_purge_item Table timestarted BIGINT 19 null

Start time of purging method

facetoface_notification_tpl Table managerprefix LONGTEXT 2147483647 null
facetoface_asset_info_field Table param5 LONGTEXT 2147483647 null
local_ld_import_logs_status Table adhoctaskid BIGINT 19 null

Import logs task id

quiz_attempts Table preview SMALLINT 5 0
goal_type_info_field Table description LONGTEXT 2147483647 null
repository_opensesame_pkgs Table mobilecompatibility VARCHAR 255

Options are allDevices, ios, android and empty

badge_issued Table id BIGINT 19 null
totara_compl_import_course Table username VARCHAR 100 null

username

auth_approved_request_snapshots Table positionid BIGINT 19 null
competency_coursecompsetting Table timecreated BIGINT 19 null

The time this setting was created.

quiz Table timeopen BIGINT 19 0

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

grade_items Table iteminfo LONGTEXT 2147483647 null

Info and notes about this item XXX

comp_template_assignment Table type TINYINT 3 null
assignsubmission_file Table submission BIGINT 19 0
workshopform_rubric_config Table workshopid BIGINT 19 null

The id of workshop this configuartion applies for

tool_monitor_subscriptions Table timecreated BIGINT 19 null

Timestamp of when this subscription was created

totara_compl_import_course Table courseid BIGINT 19 null

Course id if one exists

competency_plan Table id BIGINT 19 null
grade_categories Table timecreated BIGINT 19 null
tag Table isstandard BIT 0 0

Whether this tag is standard

org_framework Table shortname VARCHAR 100 null
quiz_overrides Table timelimit BIGINT 19 null

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

user_devices Table pushid VARCHAR 255

the device PUSH token/key/identifier/registration id

workshop_comments_old Table id BIGINT 19 null
dp_evidence_type Table sortorder BIGINT 19 null
course_completions Table id BIGINT 19 null
comp_record Table organisationid BIGINT 19 null
goal_grp_cohort Table usermodified BIGINT 19 null
post Table usermodified BIGINT 19 null
goal_personal Table timemodified BIGINT 19 null
goal_scale Table description LONGTEXT 2147483647 null
facetoface_sessioncancel_info_field Table fullname VARCHAR 1024 null
choice Table course BIGINT 19 0
facetoface_notification Table type BIT 0 null
assignment_submissions Table submissioncomment LONGTEXT 2147483647 null
data Table approval SMALLINT 5 0
prog Table available BIGINT 19 0
lesson Table modattempts SMALLINT 5 0
grading_definitions Table status BIGINT 19 0

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

quiz_feedback Table id BIGINT 19 null
dp_plan_evidence_relation Table id BIGINT 19 null
grade_items_history Table idnumber VARCHAR 255 null

Arbitrary idnumber provided by the module responsible

totara_compl_import_course Table courseidnumber VARCHAR 100 null

course idnumber

course_completions Table rplgrade DECIMAL 10 null

Totara recognition of prior learning grade from totara_core

appraisal_stage_page Table name VARCHAR 255
grade_items Table itemname VARCHAR 255 null

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

assignment Table var1 BIGINT 19 0
events_queue Table timecreated BIGINT 19 null

time stamp of the first time this was added

tool_sitepolicy_consent_options Table mandatory BIT 0 null

If the consent option requires consent to use the site

tool_usertours_tours Table description LONGTEXT 2147483647 null
quiz_slots Table id BIGINT 19 null
data Table requiredentriestoview INT 10 0
badge_backpack Table id BIGINT 19 null
user Table imagealt VARCHAR 255 null

alt tag for user uploaded image

workshop_submissions Table title VARCHAR 255

The submission title

scorm Table forcecompleted BIT 0 0
post Table uniquehash VARCHAR 255
book Table revision BIGINT 19 0
logstore_standard_log Table target VARCHAR 100
glossary Table assessed BIGINT 19 0
totara_connect_sso_sessions Table sid VARCHAR 128

Session id of the user session on the TC server

org_type_info_field Table param2 LONGTEXT 2147483647 null
feedback360_email_assignment Table token VARCHAR 40
quiz Table reviewmarks MEDIUMINT 7 0

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

lesson_overrides Table review SMALLINT 5 null
local_ld_course_day Table day VARCHAR 10

Day formatted as 'YYYY-MM-DD'

course_modules Table visible BIT 0 1
dp_plan_evidence_info_field Table id BIGINT 19 null
forum_queue Table timemodified BIGINT 19 0

The modified time of the original post

comp_record Table manual TINYINT 3 0
pos Table totarasync BIT 0 0

Totara sync flag from totara_sync

external_tokens Table token VARCHAR 128

security token, aka private access key

block_instances Table blockname VARCHAR 40

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

question_usages Table contextid BIGINT 19 null

Every question usage must be associated with some context.

question_answers Table fraction DECIMAL 12 0.0000000
grade_import_values Table importonlyfeedback BIT 0 0
reminder Table modifierid BIGINT 19 null
grade_items_history Table oldid BIGINT 19 null
totara_userdata_purge_type Table usercreated BIGINT 19 null

Who added this type

qtype_randomsamatch_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

dp_objective_scale_value Table description LONGTEXT 2147483647 null

The description of the scale value

dp_plan_evidence_info_field Table forceunique BIT 0 null
grade_items_history Table grademax DECIMAL 10 100.00000

What is the maximum allowable grade?

comp_record_history Table proficiency BIGINT 19 null
report_builder_saved Table search LONGTEXT 2147483647 null

Serialized data containing the search details

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)

scorm Table displayattemptstatus BIT 0 1
course_info_field Table description LONGTEXT 2147483647 null
dp_template Table fullname VARCHAR 255 null

User readable name for this template

totara_userdata_purge Table timefinished BIGINT 19 null

End of purge or time when marked as timed out

license Table id BIGINT 19 null
lesson Table slideshow SMALLINT 5 0
goal_personal Table usermodified BIGINT 19 null
report_builder_filters Table value VARCHAR 255

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

goal_user_assignment Table timemodified BIGINT 19 null
facetoface_notification_hist Table sessionid BIGINT 19 null

FK of facetoface_sessions

totara_compl_import_course Table timecreated BIGINT 19 null

Time the record was imported into this table

auth_connect_servers Table id BIGINT 19 null
workshop_assessments_old Table generalcomment LONGTEXT 2147483647 null
facetoface_interest Table reason LONGTEXT 2147483647 null
dp_plan_evidence_info_data Table data LONGTEXT 2147483647 null
goal Table sortthread VARCHAR 255 null
quiz Table allowofflineattempts BIT 0 0

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

dp_plan Table description LONGTEXT 2147483647 null

Description of this development plan

prog_message Table programid BIGINT 19 0
forum_read Table lastread BIGINT 19 0
chat_users Table course BIGINT 19 0
enrol_lti_tools Table maildisplay TINYINT 3 2
page Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

message Table eventtype VARCHAR 100 null
pos Table parentid BIGINT 19 null
tool_sitepolicy_localised_policy Table authorid BIGINT 19 null

Who wrote the localised policy

repository_instance_config Table name VARCHAR 255
event Table name LONGTEXT 2147483647 null
event_subscriptions Table eventtype VARCHAR 20

The type of the event

competency_modulecomp Table cmid BIGINT 19 null

ID of the record in the course_modules table.

auth_approved_request Table confirmed BIT 0 null

Value 1 if email ownership confirmed, 0 if not

logstore_standard_log Table anonymous BIT 0 0

Was this event anonymous at the time of triggering?

dp_plan_history Table usermodified BIGINT 19 null

The id of the user who made the modification

badge_criteria Table description LONGTEXT 2147483647 null
facetoface_session_info_field Table locked TINYINT 3 null
totara_compl_import_cert Table timecreated BIGINT 19 null

Time the record was imported into this table

feedback_value_history Table id BIGINT 19 null
org_type_info_field Table forceunique TINYINT 3 null
data Table maxentries INT 10 0
prog_extension Table programid BIGINT 19 0
event_subscriptions Table id BIGINT 19 null
portfolio_instance Table plugin VARCHAR 50

fk to plugin

user Table auth VARCHAR 20 manual
lesson Table custom SMALLINT 5 0
feedback_completedtmp Table feedback BIGINT 19 0
tool_recyclebin_course Table module BIGINT 19 null
enrol_lti_lti2_consumer Table consumername VARCHAR 255 null
groups_members Table component VARCHAR 100

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

scorm Table auto BIT 0 0
assignfeedback_editpdf_annot Table pageno BIGINT 19 0

The page in the PDF that this annotation appears on

feedback_completedtmp Table guestid VARCHAR 255
enrol_lti_tools Table secret LONGTEXT 2147483647 null
gradingform_guide_criteria Table shortname VARCHAR 255

shortname of this criterion

stats_user_weekly Table userid BIGINT 19 0
totara_navigation Table classname VARCHAR 255 null
prog Table category BIGINT 19 0
mnet_rpc Table static BIT 0 null
question_hints Table questionid BIGINT 19 null
totara_dashboard_cohort Table cohortid BIGINT 19 null
feedback360_resp_assignment Table feedback360emailassignmentid BIGINT 19 null

Email assignments

certif Table minimumactiveperiod VARCHAR 20 null

When using fixed expiry date, calculated expiry dates must be at least this far in the future

auth_connect_sso_requests Table requesttoken VARCHAR 64
quiz_overrides Table timeopen BIGINT 19 null

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

auth_approved_request_snapshots Table timeresolved BIGINT 19 null
workshopallocation_scheduled Table workshopid BIGINT 19 null

workshop id we are part of

grade_outcomes_courses Table outcomeid BIGINT 19 null

id of the outcome

stats_user_monthly Table id BIGINT 19 null
lesson_timer Table userid BIGINT 19 0
lesson Table usemaxgrade SMALLINT 5 0
survey_questions Table type SMALLINT 5 0
prog_exception Table programid BIGINT 19 0
auth_approved_request_snapshots Table alternatename VARCHAR 255 null
question_hints Table hintformat SMALLINT 5 0

The format of the hint.

scorm_scoes Table scorm BIGINT 19 0
appraisal_quest_field Table defaultdataformat BIT 0 null
question_numerical_options Table unitpenalty DECIMAL 12 0.1000000

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

assignfeedback_editpdf_cmnt Table x BIGINT 19 0

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

scorm Table launch BIGINT 19 0
cohort Table cohorttype BIGINT 19 1

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

report_builder_schedule Table usermodified BIGINT 19 0

user who last modified the scheduled report settings

log_queries Table timelogged BIGINT 19 null

timestamp when log info stored into db

dp_objective_scale_value Table timemodified BIGINT 19 null

Identifies the last time this scale value was modified

goal_type Table fullname VARCHAR 1024 null
totara_connect_sso_sessions Table clientid BIGINT 19 null
question_gapselect Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

goal_type_info_data Table fieldid BIGINT 19 null
comp_template_assignment Table instanceid BIGINT 19 null
stats_user_monthly Table statswrites BIGINT 19 0
course_completion_history Table userid BIGINT 19 null
auth_approved_request Table timecreated BIGINT 19 null
event Table repeatid BIGINT 19 0
blog_external Table userid BIGINT 19 null
facetoface_notification Table templateid BIGINT 19 0
comp_type_info_field Table forceunique TINYINT 3 null
competency_usercompplan Table usermodified BIGINT 19 null
goal_grp_cohort Table goalid BIGINT 19 null
competency_templatecomp Table usermodified BIGINT 19 null

The user who modified this link.

prog_assignment Table includechildren BIT 0 0
competency_coursecomp Table courseid BIGINT 19 null

The course this competency is linked to.

resource Table id BIGINT 19 null
facetoface_session_info_field Table required TINYINT 3 null
facetoface_session_info_field Table forceunique TINYINT 3 null
report_builder Table cache SMALLINT 5 0

If set to 1, report will be generated once per scheduled period and cached. Users will see only cached results

user_private_key Table iprestriction VARCHAR 255 null

ip restriction

cohort_msg_queue Table processed BIGINT 19 0
wiki_pages Table timemodified BIGINT 19 0

page edition timestamp

question_calculated_options Table question BIGINT 19 0
badge_criteria_met Table issuedid BIGINT 19 null
question_ddwtos Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

course_completion_aggr_methd Table course BIGINT 19 0
goal_scale_assignments Table id BIGINT 19 null
goal_grp_pos Table includechildren TINYINT 3 0
backup_controllers Table type VARCHAR 10

Type of the backup (activity/section/course)

quiz Table course BIGINT 19 0

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

facetoface_room_info_data_param Table dataid BIGINT 19 null
certificate Table printgrade BIGINT 19 0
appraisal_review_data Table id BIGINT 19 null
lesson_answers Table grade SMALLINT 5 0
question_hints Table options VARCHAR 255 null

A space for any other question-type specific options.

feedback360 Table status BIT 0 0
competency_templatecohort Table cohortid BIGINT 19 null
message_metadata Table msgtype SMALLINT 5 null

The message type

workshop_aggregations Table gradinggrade DECIMAL 10 null

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

enrol_lti_lti2_share_key Table resourcelinkid BIGINT 19 null
chat_users Table userid BIGINT 19 0
course_completion_criteria Table module VARCHAR 100 null

Type of module (if using module criteria type)

auth_connect_servers Table serverurl VARCHAR 255

URL of Totara Connect server - wwwroot

workshop_elements_old Table newplugin VARCHAR 28 null
context Table path VARCHAR 255 null
report_builder_saved Table ispublic SMALLINT 5 0

If none zero, the saved search is visible to all users, not just the creator

prog_info_field Table description LONGTEXT 2147483647 null
facetoface_notification_tpl Table reference VARCHAR 100 null
portfolio_instance_user Table userid BIGINT 19 null

fk to user table

user_lastaccess Table timeaccess BIGINT 19 0
dp_template Table shortname VARCHAR 100 null

A shorter name for this template (optional)

totara_userdata_export Table timefinished BIGINT 19 null

End of export or time when marked as timed out, this is also used to export old files

facetoface_sessioncancel_info_data Table id BIGINT 19 null
url Table display SMALLINT 5 0
facetoface_sessions Table registrationtimestart BIGINT 19 0
appraisal_role_changes Table originaluserid BIGINT 19 null
facetoface Table shortname VARCHAR 32 null
dp_plan_program_assign Table programid BIGINT 19 null

Identifies the program being assigned

glossary_entries Table concept VARCHAR 255
external_tokens Table timecreated BIGINT 19 null

created timestamp

role_names Table name VARCHAR 255
competency_evidence Table desca LONGTEXT 2147483647 null
workshop_grades Table peercommentformat SMALLINT 5 0

The format of peercomment field

cohort_rule_collections Table status BIGINT 19 null
workshop_assessments_old Table workshopid BIGINT 19 0
totara_userdata_export Table userid BIGINT 19 null

The target user

workshop_comments_old Table comments LONGTEXT 2147483647 null
prog_exception Table exceptiontype SMALLINT 5 0
persistent_login Table timeautologin BIGINT 19 null

Time of the last auto login

totara_navigation Table id BIGINT 19 null
block_community Table userid BIGINT 19 null
user_info_field Table locked TINYINT 3 0

Field locked

course_modules_completion Table timecompleted BIGINT 19 null

Time at which the module was completed.

feedback_sitecourse_map Table feedbackid BIGINT 19 0
survey Table timemodified BIGINT 19 0
enrol_lti_tools Table institution VARCHAR 40
course Table sortorder BIGINT 19 0
profiling Table data LONGTEXT 2147483647 null

the raw data gathered by xhprof

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

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

cohort_rule_params Table value VARCHAR 255 null
facetoface_signups Table notificationtype BIGINT 19 null
workshop_submissions_old Table mailed TINYINT 3 0
portfolio_mahara_queue Table id BIGINT 19 null
sessions Table id BIGINT 19 null
message Table timecreated BIGINT 19 0
competency_usercompcourse Table timecreated BIGINT 19 null
scorm_scoes_data Table scoid BIGINT 19 0
scorm_seq_mapinfo Table id BIGINT 19 null
grade_import_values Table userid BIGINT 19 null
portfolio_instance_config Table name VARCHAR 255

config field

report_builder_columns Table type VARCHAR 255

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

lock_db Table id BIGINT 19 null
lesson Table completionendreached BIT 0 0
competency_modulecomp Table timemodified BIGINT 19 null

The time this record was last modified

question Table createdby BIGINT 19 null

userid of person who created this question

message_read Table contexturl LONGTEXT 2147483647 null

If this message is a notification of an event contexturl should contain a link to view this event. For example if its a notification of a forum post contexturl should contain a link to the forum post.

dp_plan_program_assign Table approved SMALLINT 5 0

Indicates if the program has been accepted as part of a plan, or is awaiting approval.

auth_approved_request_snapshots Table password VARCHAR 255 null
comp_type_info_field Table defaultdata LONGTEXT 2147483647 null
certificate_issues_history Table timearchived BIGINT 19 null
mnet_rpc Table enabled BIT 0 0
course_completions Table status TINYINT 3 0

Totara status from totara_core

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

dp_plan_settings Table autobyplandate SMALLINT 5 0

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

scorm_seq_rolluprule Table id BIGINT 19 null
qtype_ddimageortext_drags Table label LONGTEXT 2147483647 null

Alt text label for drag-able image.

user_enrolments Table timemodified BIGINT 19 0
facetoface_notification_sent Table id BIGINT 19 null
user Table maildisplay TINYINT 3 2
lti_submission Table launchid BIGINT 19 null
dp_plan_program_assign Table id BIGINT 19 null
portfolio_tempdata Table data LONGTEXT 2147483647 null

dumping ground for portfolio callers to store their data in.

enrol Table customint8 BIGINT 19 null

Custom - general int

auth_approved_request_snapshots Table id BIGINT 19 null
forum_posts Table attachment VARCHAR 100
user_devices Table userid BIGINT 19 0
course_modules_completion Table completionstate BIT 0 null

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

goal_scale_assignments Table timemodified BIGINT 19 null
dp_plan_program_assign Table priority BIGINT 19 null

Identifies the priority of this program within the current plan.

grade_grades Table rawscaleid BIGINT 19 null

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

message_read Table fullmessagehtml LONGTEXT 2147483647 null

html format of message

page Table content LONGTEXT 2147483647 null
lesson Table mediawidth BIGINT 19 650
dp_priority_scale_value Table usermodified BIGINT 19 null

Identifies the id of the user who last modified the scale value

lesson Table timemodified BIGINT 19 0
feedback_item Table template BIGINT 19 0
report_builder_schedule_email_systemuser Table scheduleid BIGINT 19 null
competency_plan Table usermodified BIGINT 19 null
mnet_log Table url VARCHAR 100
quiz_grades Table userid BIGINT 19 0

Foreign key references user.id.

goal_grp_org Table id BIGINT 19 null
goal_scale_values Table sortorder BIGINT 19 null
certificate Table timemodified BIGINT 19 0
log Table url VARCHAR 100
competency_plancomp Table competencyid BIGINT 19 null
qtype_randomsamatch_options Table incorrectfeedbackformat TINYINT 3 0
wiki_pages Table pageviews BIGINT 19 0

Number of page views

appraisal_review_data Table appraisalquestfieldid BIGINT 19 null
assign Table name VARCHAR 255

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

stats_monthly Table stat1 BIGINT 19 0

stat1. usually used for reads

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

facetoface_sessions Table cancelledstatus BIT 0 0

Session cancelled status

lesson Table id BIGINT 19 null
facetoface_sessioncancel_info_field Table shortname VARCHAR 100 null
block_totara_featured_links_tiles Table visibility SMALLINT 5 0

What the base visibility option is

facetoface_signup_info_field Table locked TINYINT 3 null
post Table id BIGINT 19 null
tool_sitepolicy_policy_version Table publisherid BIGINT 19 null

Who published the policy

tool_sitepolicy_site_policy Table timecreated BIGINT 19 null

Timestamp of when the policy was created

report_builder_graph Table id BIGINT 19 null
quiz_statistics Table median DECIMAL 15 null
grade_letters Table contextid BIGINT 19 null

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

cohort_plan_config Table autocreatenew BIT 0 0

Automatically create new plans for new members of the cohort

mnet_session Table username VARCHAR 100

Unique username

badge_criteria Table descriptionformat TINYINT 3 0
facetoface_asset_info_field Table fullname VARCHAR 1024 null
goal Table targetdate BIGINT 19 null
block_zoola_module_name Table name VARCHAR 255

Module name

facetoface_interest Table timedeclared BIGINT 19 0
competency_plancomp Table sortorder BIGINT 19 null

Relative sort order

mnetservice_enrol_courses Table hostid BIGINT 19 null

The id of the remote MNet host

assign Table revealidentities TINYINT 3 0

Show identities for a blind marking assignment

org_type_info_field Table hidden TINYINT 3 null
facetoface_signup_info_data Table facetofacesignupid BIGINT 19 null

WARNING - this points to signup id

workshop_submissions_old Table gradinggrade SMALLINT 5 0
facetoface_cancellation_info_field Table param5 LONGTEXT 2147483647 null
question_dataset_definitions Table category BIGINT 19 0
org_relations Table id1 BIGINT 19 null
lti Table timemodified BIGINT 19 0
event_subscriptions Table lastupdated BIGINT 19 null
url Table intro LONGTEXT 2147483647 null
report_builder_preproc_track Table id BIGINT 19 null
reportbuilder_grp_user_user Table timecreated BIGINT 19 0
enrol_lti_lti2_context Table consumerid BIGINT 19 null
post Table content LONGTEXT 2147483647 null
lesson_branch Table pageid BIGINT 19 0
choice Table showunanswered TINYINT 3 0
quiz_attempts Table state VARCHAR 16 inprogress

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

totara_connect_clients Table syncjobs BIT 0 0

Send job assignments data to clients

quiz_reports Table displayorder BIGINT 19 null

display order for report tabs

facetoface_cancellation_info_data Table id BIGINT 19 null
qtype_randomsamatch_options Table questionid BIGINT 19 0

Foreign key references question.id.

prog_info_data_param Table dataid BIGINT 19 null
org_competencies Table timecreated BIGINT 19 null
lesson Table mediafile VARCHAR 255

Local file path or full external URL

grade_outcomes Table usermodified BIGINT 19 null

the userid of the person who last modified this outcome

user Table deleted BIT 0 0
enrol Table customchar1 VARCHAR 255 null

Custom - general short name

competency_evidence Table grade BIGINT 19 null
facetoface_sessions Table normalcost VARCHAR 255 0

The normal (non-discounted) cost of the session

org_type Table idnumber VARCHAR 100 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

scale_history Table courseid BIGINT 19 0
book Table introformat SMALLINT 5 0
lti Table course BIGINT 19 0

Course basiclti activity belongs to

quiz Table grademethod SMALLINT 5 1

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

assign Table teamsubmissiongroupingid BIGINT 19 0

A grouping id to get groups for team submissions

facetoface_sessions Table timemodified BIGINT 19 0
lesson_overrides Table password VARCHAR 32 null

Lesson password. Can be null, in which case the lesson default is used.

question_numerical_options Table id BIGINT 19 null
lti_types Table id BIGINT 19 null
dp_objective_scale Table usermodified BIGINT 19 null

Identifies the id of the user who last modified the objective scale

grade_items Table scaleid BIGINT 19 null

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

dp_evidence_type Table id BIGINT 19 null
report_builder_settings Table value VARCHAR 255 null

Value of the setting

facetoface_signups Table managerid BIGINT 19 null

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

dp_objective_scale_value Table numericscore DECIMAL 10 null

Identifies a score that can be assigned to a scale value

forum_posts Table mailed TINYINT 3 0
data Table rsstemplate LONGTEXT 2147483647 null
question_dataset_items Table value VARCHAR 255
facetoface_asset_info_field Table locked TINYINT 3 null
cohort_rules Table name VARCHAR 255
dp_objective_scale_value Table objscaleid BIGINT 19 null

Identifies the objective scale id this value belongs to

totara_compl_import_cert Table username VARCHAR 100 null

username

config_log Table timemodified BIGINT 19 null
glossary Table introformat SMALLINT 5 0
goal_type Table description LONGTEXT 2147483647 null
question_response_count Table analysisid BIGINT 19 null
files Table filesize BIGINT 19 null
cohort_visibility Table instancetype SMALLINT 5 null
post Table courseid BIGINT 19 0
org_framework Table fullname VARCHAR 1024 null
scorm_seq_rolluprule Table conditioncombination VARCHAR 3 all
competency_coursecompsetting Table pushratingstouserplans TINYINT 3 null

Does this course push ratings to user plans?

dp_priority_scale_value Table priorityscaleid BIGINT 19 null

Identifies the priority scale that a value belongs to

dp_permissions Table templateid BIGINT 19 null

ID of the template that this permission setting is for

role Table archetype VARCHAR 30

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

user_private_key Table instance BIGINT 19 null

optional instance id

competency_plan Table reviewerid BIGINT 19 null
goal_user_info_field Table description LONGTEXT 2147483647 null
badge_criteria_param Table name VARCHAR 255
workshopallocation_scheduled Table id BIGINT 19 null
portfolio_log Table userid BIGINT 19 null

user who exported content

tool_sitepolicy_localised_policy Table language VARCHAR 30

Language of the policy

comp_criteria_record Table itemid BIGINT 19 null
facetoface_interest Table userid BIGINT 19 0
question_truefalse Table id BIGINT 19 null
forum Table warnafter BIGINT 19 0
course_categories Table visibleold BIT 0 1

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

course_completions Table renewalstatus TINYINT 3 0

Totara renewal status from totara_core

block_zoola_reports Table type VARCHAR 20

Resource type: reportUnit or reportOptions

qtype_match_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

qtype_essay_options Table responsetemplateformat SMALLINT 5 0

The text format for responsetemplate.

badge Table description LONGTEXT 2147483647 null
goal_user_info_field Table param4 LONGTEXT 2147483647 null
assignsubmission_file Table numfiles BIGINT 19 0

The number of files the student submitted.

comp_type_info_data_param Table value VARCHAR 32
enrol Table enrolperiod BIGINT 19 0

Custom - enrolment duration

competency_framework Table timemodified BIGINT 19 null

The time this competency framework was last modified.

rating Table itemid BIGINT 19 null
question_statistics Table subquestion SMALLINT 5 null
external_tokens Table userid BIGINT 19 null

owner of the token

workshop_submissions_old Table newplugin VARCHAR 28 null
question_gapselect Table partiallycorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any partially correct response.

question_dataset_definitions Table id BIGINT 19 null
qtype_ddimageortext Table questionid BIGINT 19 0
post Table groupid BIGINT 19 0
tool_sitepolicy_localised_consent Table id BIGINT 19 null
question_attempt_steps Table userid BIGINT 19 null

The user whose action lead to this state being created.

totara_userdata_purge_type_item Table purgedata BIT 0 null

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

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.

assign_user_mapping Table id BIGINT 19 null
question Table category BIGINT 19 0
facetoface_signup_info_field Table fullname VARCHAR 1024 null
dp_plan_evidence Table evidencetypeid BIGINT 19 null

Integer representing the type of this evidence item

goal_user_assignment Table assignmentid BIGINT 19 null
workshop_grades_old Table id BIGINT 19 null
quiz Table reviewgeneralfeedback MEDIUMINT 7 0

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

lti_tool_proxies Table createdby BIGINT 19 null

ID of user which initiated the registration process

assignment Table emailteachers TINYINT 3 0
prog_courseset Table coursesumfield BIGINT 19 0
repository_opensesame_pkgs Table timemodified BIGINT 19 null

Date when package last modified

feedback_completed_history Table id BIGINT 19 null
assign_submission Table timecreated BIGINT 19 0

The time of the first student submission to this assignment.

facetoface_room Table usercreated BIGINT 19 null

user id who created the room

report_builder Table fullname VARCHAR 1333

Title of report, displayed on page and used to refer to a report instance

grade_categories Table keephigh BIGINT 19 0

Keep only the X highest items

choice Table allowupdate TINYINT 3 0
qtype_match_options Table incorrectfeedbackformat TINYINT 3 0
backup_controllers Table format VARCHAR 20

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

workshop_grades_old Table workshopid BIGINT 19 0
prog_info_field Table param5 LONGTEXT 2147483647 null
course_info_field Table datatype VARCHAR 255 null
profiling Table totalcalls BIGINT 19 null

Total number of calls performed by the run

enrol_lti_tools Table timemodified BIGINT 19 null
glossary_formats Table visible TINYINT 3 1
enrol Table customint7 BIGINT 19 null

Custom - general int

appraisal_stage Table appraisalid BIGINT 19 null
pos_type_info_field Table forceunique TINYINT 3 null
facetoface_room_info_data_param Table id BIGINT 19 null
competency_userevidencecomp Table competencyid BIGINT 19 null
feedback Table page_after_submit LONGTEXT 2147483647 null
question_datasets Table id BIGINT 19 null
facetoface_notification_sent Table notificationid BIGINT 19 0
facetoface_sessioncancel_info_data_param Table id BIGINT 19 null
goal_user_type Table audience TINYINT 3 null
assign_plugin_config Table id BIGINT 19 null
cohort_plan_config Table planstatus BIGINT 19 null

Learning plan status

gradingform_rubric_criteria Table id BIGINT 19 null
appraisal_role_assignment Table id BIGINT 19 null
tool_sitepolicy_policy_version Table sitepolicyid BIGINT 19 null

The id of the policy

report_builder_group Table assigntype VARCHAR 255

Name of the method for assigning activities to this group

workshop_rubrics_old Table workshopid BIGINT 19 0
stats_user_weekly Table roleid BIGINT 19 0
role_assignments Table itemid BIGINT 19 0

Id of enrolment/auth instance responsible for this role assignment

external_services Table downloadfiles BIT 0 0

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

comp_record_history Table userid BIGINT 19 null
cohort_plan_config Table excludecreatedauto BIT 0 1

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

assign_user_mapping Table assignment BIGINT 19 0
enrol_lti_lti2_tool_proxy Table toolproxykey VARCHAR 32
grade_grades_history Table rawgrade DECIMAL 10 null

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

comp_relations Table description LONGTEXT 2147483647 null
mnet_log Table cmid BIGINT 19 0
backup_logs Table timecreated BIGINT 19 null

timestamp this log entry was created

org_type Table fullname VARCHAR 1024 null
qtype_multichoice_options Table single SMALLINT 5 0

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

competency_coursecomp Table ruleoutcome TINYINT 3 null

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

mnet_rpc Table id BIGINT 19 null

Unique Function ID

goal_grp_pos Table usermodified BIGINT 19 null
quiz_statistics Table whichattempts SMALLINT 5 null

bool used to indicate whether these stats are for all attempts or just for the first.

dp_plan_course_assign Table approved SMALLINT 5 0

Indicates if the course has been accepted as part of a plan, or is awaiting approval.

forum Table id BIGINT 19 null
data Table comments SMALLINT 5 0
lesson Table feedback SMALLINT 5 1
backup_courses Table nextstarttime BIGINT 19 0
enrol_flatfile Table timestart BIGINT 19 0
registration_hubs Table timemodified BIGINT 19 0
role_assignments Table modifierid BIGINT 19 0
facetoface_room_info_field Table id BIGINT 19 null
enrol_lti_tools Table contextid BIGINT 19 null
question Table length BIGINT 19 1
comp_record Table timemodified BIGINT 19 null
forum Table maxbytes BIGINT 19 0
reportbuilder_grp_user_record Table id BIGINT 19 null
dp_competency_settings Table id BIGINT 19 null
local_ld_course_day Table daytime BIGINT 19 null

Timestamp of the beginning of the day

tool_customlang Table local LONGTEXT 2147483647 null

Local customization of the string, null if not customized

qtype_ddmarker Table showmisplaced SMALLINT 5 0
book_chapters Table contentformat SMALLINT 5 0
course_sections Table name VARCHAR 255 null
data_fields Table param1 LONGTEXT 2147483647 null
cohort_rulesets Table operator BIGINT 19 null
question_response_analysis Table subqid VARCHAR 100
reminder_message Table type VARCHAR 10 null
role_context_levels Table roleid BIGINT 19 null
competency_templatecohort Table timecreated BIGINT 19 null
reportbuilder_grp_user_user Table id BIGINT 19 null
enrol_lti_lti2_user_result Table created BIGINT 19 null
feedback_value Table tmp_completed BIGINT 19 0
chat Table course BIGINT 19 0
goal_user_info_field Table forceunique TINYINT 3 null
facetoface Table declareinterest BIT 0 0

Allow users to declare interest in the facetoface

message_popup Table isread BIT 0 0
comp_record Table id BIGINT 19 null
wiki_versions Table pageid BIGINT 19 0

Page id

backup_courses Table laststarttime BIGINT 19 0
tool_sitepolicy_site_policy Table id BIGINT 19 null
pos_type_info_field Table param4 LONGTEXT 2147483647 null
workshopform_rubric_levels Table id BIGINT 19 null
certificate Table id BIGINT 19 null
dp_course_settings Table duedatemode SMALLINT 5 0

Defines how due dates are handled by this component

badge_external Table backpackid BIGINT 19 null

ID of a backpack

appraisal_role_assignment Table activepageid BIGINT 19 null
goal_user_assignment Table extrainfo VARCHAR 255 null
feedback_completed_history Table timearchived BIGINT 19 null
facetoface_signup_info_field Table description LONGTEXT 2147483647 null
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.

grade_items Table itemnumber BIGINT 19 null

Can be used to distinguish multiple grades for an activity

logstore_standard_log Table crud VARCHAR 1
badge_backpack Table userid BIGINT 19 0
course_modules Table completionview BIT 0 0

Controls whether a page view is part of the automatic completion requirements for this activity. 0 = view not required 1 = view required

report_builder_search_cols Table reportid BIGINT 19 null
log Table userid BIGINT 19 0
mnet_session Table token VARCHAR 40

Unique SHA1 Token

question_calculated_options Table incorrectfeedbackformat TINYINT 3 0
enrol_paypal Table option_selection1_x VARCHAR 255
wiki Table course BIGINT 19 0

Course wiki activity belongs to

block_recent_activity Table id BIGINT 19 null
mnet_session Table userid BIGINT 19 0

Unique user ID

block_rss_client Table preferredtitle VARCHAR 64
course_completions Table userid BIGINT 19 0
stats_user_daily Table roleid BIGINT 19 0
events_queue Table userid BIGINT 19 null

$USER->id when the event was fired

block_zoola_reports_schedule Table body LONGTEXT 2147483647 null

Email body

feedback360_resp_assignment Table id BIGINT 19 null
feedback360_scale Table name VARCHAR 255 null
survey_analysis Table survey BIGINT 19 0
lesson_pages Table timecreated BIGINT 19 0
reminder Table courseid BIGINT 19 null
course_completions Table rpl VARCHAR 255 null

Totara recognition of prior learning from totara_core

goal_framework Table fullname VARCHAR 1024
facetoface_signups_status Table statuscode BIGINT 19 null
block_instances Table defaultregion VARCHAR 16

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

workshop Table instructreviewers LONGTEXT 2147483647 null

Instructions for the assessment phase

question_attempts Table minfraction DECIMAL 12 null

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

block_zoola_module_name Table id BIGINT 19 null
lti Table showtitlelaunch BIT 0 0
lesson_timer Table lessonid BIGINT 19 0
totara_navigation Table title VARCHAR 1024
auth_approved_request Table resolvedby BIGINT 19 null

Person with auth/approved:approve capability that resolved this signup request, null in case of automatic approval

facetoface_asset_info_field Table param2 LONGTEXT 2147483647 null
question_answers Table answer LONGTEXT 2147483647 null
repository_opensesame_bdls Table name VARCHAR 1333

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

course_request Table summaryformat TINYINT 3 0
facetoface Table approvalterms LONGTEXT 2147483647 null
facetoface_asset Table timecreated BIGINT 19 0
forum Table course BIGINT 19 0
lesson Table nextpagedefault SMALLINT 5 0
dp_objective_settings Table id BIGINT 19 null
forum Table forcesubscribe BIT 0 0
question_response_count Table id BIGINT 19 null
tag_instance Table tagid BIGINT 19 null
quiz_reports Table name VARCHAR 255 null

name of the report, same as the directory name

comp_criteria Table id BIGINT 19 null
question_statistics Table sd DECIMAL 15 null
question_numerical Table answer BIGINT 19 0

Foreign key references question_answers.id.

mnet_remote_rpc Table plugintype VARCHAR 20
post Table coursemoduleid BIGINT 19 0
totara_userdata_purge Table purgetypeid BIGINT 19 null
scale Table id BIGINT 19 null
goal_scale_values Table numericscore DECIMAL 10 null
feedback360_quest_field Table param5 LONGTEXT 2147483647 null
log Table time BIGINT 19 0
grade_categories_history Table action BIGINT 19 0

created/modified/deleted constants

repository Table id BIGINT 19 null
mnet_log Table info VARCHAR 255
dp_plan_evidence_relation Table evidenceid BIGINT 19 null

Evidence ID from dp_plan_evidence

enrol_lti_lti2_resource_link Table shareapproved BIT 0 null
grade_outcomes Table timecreated BIGINT 19 null

the time this outcome was first created

scorm_seq_ruleconds Table conditioncombination VARCHAR 3 all
external_services_users Table validuntil BIGINT 19 null

timestampt - valid until data

mnetservice_enrol_courses Table fullname VARCHAR 254
workshop_old Table releasegrades BIGINT 19 0
block_zoola_reports_schedule Table sendtouser BIT 0 null

Add related user's email to recipient list

course_modules_completion Table id BIGINT 19 null
totara_dashboard Table name VARCHAR 1333
prog_future_user_assignment Table id BIGINT 19 null
course_completion_log Table id BIGINT 19 null
reminder_sent Table reminderid BIGINT 19 null
choice_options Table id BIGINT 19 null
grade_categories Table timemodified BIGINT 19 null
tool_monitor_events Table courseid BIGINT 19 null

course id

pos Table usermodified BIGINT 19 null
logstore_standard_log Table id BIGINT 19 null
persistent_login Table timecreated BIGINT 19 null
scorm_scoes_track Table id BIGINT 19 null
user Table department VARCHAR 255
course_format_options Table courseid BIGINT 19 null

Id of the course

assign Table attemptreopenmethod VARCHAR 10 none

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

lesson Table intro LONGTEXT 2147483647 null
dp_program_settings Table priorityscale BIGINT 19 null

Identifies the scale used by this component

backup_controllers Table operation VARCHAR 20 backup

Type of operation (backup/restore)

assign_plugin_config Table plugin VARCHAR 28
message Table fullmessageformat SMALLINT 5 0

The format of the full message

prog_extension Table id BIGINT 19 null
pos_competencies Table id BIGINT 19 null
cohort_rules Table id BIGINT 19 null
page Table displayoptions LONGTEXT 2147483647 null
tag_coll Table customurl VARCHAR 255 null

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

competency_modulecomp Table ruleoutcome TINYINT 3 null

The outcome when an activity is completed.

facetoface_cancellation_info_field Table id BIGINT 19 null
enrol Table customint6 BIGINT 19 null

Custom - general int

tag_correlation Table tagid BIGINT 19 null
lesson Table maxanswers SMALLINT 5 4
certificate Table borderstyle VARCHAR 255 0
badge Table issuercontact VARCHAR 255 null
question_gapselect Table shuffleanswers SMALLINT 5 1
facetoface_session_info_field Table param5 LONGTEXT 2147483647 null
facetoface_signups_status Table createdby BIGINT 19 null
choice_answers Table optionid BIGINT 19 0
feedback360_scale Table feedback360questfieldid BIGINT 19 null
mnet_application Table id BIGINT 19 null
quiz_statistics Table firstattemptscount BIGINT 19 null
dp_plan Table name VARCHAR 255 null

Name of this development plan

question_usages Table component VARCHAR 255

The plugin this attempt belongs to, e.g. 'mod_quiz', 'block_questionoftheday', 'filter_embedquestion'.

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

lti_tool_proxies Table secret VARCHAR 255 null
appraisal_event Table id BIGINT 19 null
workshopeval_best_settings Table comparison SMALLINT 5 5

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

workshop_submissions Table late TINYINT 3 0

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

assignfeedback_editpdf_annot Table endx BIGINT 19 0

x-position of the end of the annotation

comp Table shortname VARCHAR 100 null
dp_priority_scale_value Table description LONGTEXT 2147483647 null

Description of the scale value

tool_usertours_tours Table enabled BIT 0 0
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

quiz_overview_regrades Table id BIGINT 19 null
event Table format SMALLINT 5 0
assignfeedback_editpdf_annot Table endy BIGINT 19 0

y-position of the end of the annotation

config_log Table name VARCHAR 100
feedback_completed_history Table feedback BIGINT 19 0
grading_instances Table feedbackformat TINYINT 3 null

The format of the feedback field

dp_plan_course_assign Table planid BIGINT 19 null

Identifies the plan this course is attached to

facetoface_cancellation_info_data Table fieldid BIGINT 19 null
facetoface_asset_info_field Table param3 LONGTEXT 2147483647 null
comp_template Table timemodified BIGINT 19 null
cohort Table timemodified BIGINT 19 null
course_modules_completion Table viewed BIT 0 null

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

enrol_paypal Table userid BIGINT 19 0
facetoface Table reservedays INT 10 2

Number days before the session when reservations are closed

org Table timemodified BIGINT 19 null
facetoface_session_info_field Table showinsummary BIT 0 1

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

facetoface_cancellation_info_data_param Table value VARCHAR 32
appraisal Table status BIT 0 0
competency_usercompcourse Table id BIGINT 19 null
course_categories Table parent BIGINT 19 0
gradingform_rubric_fillings Table instanceid BIGINT 19 null

The ID of the grading form instance

mnetservice_enrol_enrolments Table rolename VARCHAR 255
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.

appraisal_quest_field Table appraisalscaleid BIGINT 19 null
assignment Table assignmenttype VARCHAR 50
competency_usercomp Table userid BIGINT 19 null

User associated to the competency.

license Table source VARCHAR 255 null
prog_message Table managersubject VARCHAR 255
certificate_issues_history Table id BIGINT 19 null
auth_approved_request Table confirmtoken VARCHAR 100

Unique email confirmation token

question_numerical_options Table unitsleft SMALLINT 5 0

display the unit at left as in $1.00

prog_completion Table timestarted BIGINT 19 0
user Table firstnamephonetic VARCHAR 255 null

First name phonetic

lti_tool_settings Table timemodified BIGINT 19 null

Date/time at which the record was last modified

user_devices Table appid VARCHAR 128

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

assign Table markingworkflow TINYINT 3 0

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

auth_connect_ids Table remoteid BIGINT 19 null

Record id in server table

course_published Table timepublished BIGINT 19 null

The time when the publication occurred

lesson_grades Table grade DOUBLE 22 0
report_builder_schedule_email_audience Table cohortid BIGINT 19 null
job_assignment Table positionassignmentdate BIGINT 19 null
org_competencies Table templateid BIGINT 19 null
appraisal_user_assignment Table jobassignmentid BIGINT 19 null
user_devices Table name VARCHAR 32

the device name, occam or iPhone etc..

workshopform_numerrors Table descriptiontrust BIGINT 19 null
scorm_seq_rolluprulecond Table rollupruleid BIGINT 19 0
appraisal_user_event Table id BIGINT 19 null
block_totara_stats Table timestamp BIGINT 19 null
dp_plan_course_assign Table duedate BIGINT 19 null

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

cohort_rulesets Table name VARCHAR 255
grade_categories Table aggregation BIGINT 19 0

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

appraisal_user_assignment Table userid BIGINT 19 null
workshop_old Table course BIGINT 19 0
workshop_rubrics_old Table rubricno SMALLINT 5 0
course_published Table status BIT 0 0

is the publication published or not

totara_userdata_export_type_item Table timecreated BIGINT 19 null

The time when item was added to the export type, this might be interesting for newly introduced items in preexisting types.

assignment_submissions Table timemodified BIGINT 19 0
facetoface_room_info_field Table required TINYINT 3 null
facetoface_session_info_data Table data LONGTEXT 2147483647 null
block_rss_client Table skipuntil BIGINT 19 0

Do not query this RSS feed again until this time

job_assignment Table enddate BIGINT 19 null
question_dataset_items Table id BIGINT 19 null
role_allow_switch Table allowswitch BIGINT 19 null

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

tool_sitepolicy_user_consent Table language VARCHAR 30

Language used when user consented

goal_type_info_field Table param2 LONGTEXT 2147483647 null
grade_import_values Table importcode BIGINT 19 null

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

user_info_data Table id BIGINT 19 null
scorm Table completionstatusrequired BIT 0 null
glossary Table allowduplicatedentries TINYINT 3 0
facetoface_cancellation_info_field Table param1 LONGTEXT 2147483647 null
report_builder_cache Table cachetable VARCHAR 255 null

Table name with cached data for report

upgrade_log Table version VARCHAR 100 null

plugin or main version if known

assign_submission Table assignment BIGINT 19 0
wiki_subwikis Table userid BIGINT 19 0

Owner of that subwiki

course Table marker BIGINT 19 0
page Table display SMALLINT 5 0
choice_answers Table userid BIGINT 19 0
glossary_entries Table definitionformat TINYINT 3 0
auth_connect_servers Table timemodified BIGINT 19 null
course_completion_log Table userid BIGINT 19 null

Users id

cache_flags Table expiry BIGINT 19 null
auth_connect_user_collections Table collectionid BIGINT 19 null

server id of cohort, course

grading_definitions Table name VARCHAR 255

The title of the form that helps users to identify it

feedback360_grp_pos Table posid BIGINT 19 null
course_completion_history Table id BIGINT 19 null
feedback_item Table typ VARCHAR 255
external_services Table name VARCHAR 200
appraisal_user_assignment Table activestageid BIGINT 19 null
forum_posts Table messageformat TINYINT 3 0
appraisal_quest_field Table param1 LONGTEXT 2147483647 null
tag_area Table enabled BIT 0 1
tool_monitor_events Table contextlevel BIGINT 19 null

Context level

assignfeedback_comments Table commentformat SMALLINT 5 0

The feedback text format

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.

pos Table timemodified BIGINT 19 null
local_ld_module Table ldcourseid BIGINT 19 null

Foreign key to the local_ld_course table

competency_usercomp Table proficiency TINYINT 3 null

Indicate if the competency is proficient not.

wiki Table forceformat BIT 0 1

Forces the default editor

workshopform_rubric_levels Table dimensionid BIGINT 19 null

Which criterion this level is part of

glossary_entries Table timecreated BIGINT 19 0
assignment_submissions Table timecreated BIGINT 19 0
course_completion_crit_compl Table id BIGINT 19 null
events_handlers Table eventname VARCHAR 166

name of the event, e.g. 'grade_updated'

cohort Table visibility BIT 0 0

Totara cohort visibility from totara_cohort

question_response_analysis Table variant BIGINT 19 null
grade_grades Table rawgrade DECIMAL 10 null

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

goal_user_info_field Table defaultdata LONGTEXT 2147483647 null
course_modules Table section BIGINT 19 0
report_builder Table recordsperpage BIGINT 19 40

Number of records to show on a single page of results for this report

log_display Table id BIGINT 19 null
comp_type_info_field Table typeid BIGINT 19 null
feedback_completed_history Table random_response BIGINT 19 0
org_framework Table id BIGINT 19 null
course_categories Table theme VARCHAR 50 null

Theme for the category

goal_personal Table assigntype TINYINT 3 null
scorm_seq_ruleconds Table ruletype TINYINT 3 0
tool_sitepolicy_localised_policy Table timecreated BIGINT 19 null

Timestamp of when the langauge version of the policy was created

comp_template Table timecreated BIGINT 19 null
competency_evidence Table timemodified BIGINT 19 null
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.

workshop_assessments_old Table donotuse SMALLINT 5 0
stats_user_daily Table stattype VARCHAR 30
goal_type Table shortname VARCHAR 100 null
resource_old Table options VARCHAR 255
feedback360 Table name VARCHAR 255
user Table password VARCHAR 255
report_builder_cache Table reportid BIGINT 19 null
block_totara_featured_links_tiles Table dataraw LONGTEXT 2147483647 null

The raw Json encoded data about how to display the tile

dp_plan Table enddate BIGINT 19 null

Timestamp of the end date of this plan

grade_settings Table id BIGINT 19 null
facetoface_cancellation_info_data_param Table dataid BIGINT 19 null
cohort_msg_queue Table modifierid BIGINT 19 null
wiki Table wikimode VARCHAR 20 collaborative

Wiki mode (individual, collaborative)

enrol_lti_lti2_consumer Table settings LONGTEXT 2147483647 null
comments Table id BIGINT 19 null
forum Table rssarticles TINYINT 3 0
feedback_value Table course_id BIGINT 19 0
workshop_grades_old Table newid BIGINT 19 null
quiz_slots Table quizid BIGINT 19 0

Foreign key references quiz.id.

groups_members Table groupid BIGINT 19 0
pos_framework Table timemodified BIGINT 19 null
block_totara_featured_links_tiles Table timecreated BIGINT 19 0

The tile that the tile was created

certif_completion_history Table userid BIGINT 19 null

Users id

dp_plan_history Table id BIGINT 19 null
errorlog Table build VARCHAR 255 null
data Table course BIGINT 19 0
local_ld_import_logs_status Table id BIGINT 19 null
mnet_host2service Table subscribe BIT 0 0
glossary Table assesstimefinish BIGINT 19 0
competency_userevidence Table usermodified BIGINT 19 null
message_read Table timeread BIGINT 19 0
repository_opensesame_bps Table bundleid BIGINT 19 null
prog_message Table messagetype SMALLINT 5 0
scorm_scoes_data Table value LONGTEXT 2147483647 null
appraisal_quest_field_role Table rights SMALLINT 5 null
pos Table visible TINYINT 3 null
enrol_lti_tools Table city VARCHAR 120
message Table fullmessage LONGTEXT 2147483647 null
tool_sitepolicy_localised_consent Table statement LONGTEXT 2147483647 null

The question/statement the user can answer

goal Table timemodified BIGINT 19 null
course_modules Table idnumber VARCHAR 100 null

customizable idnumber

tag Table id BIGINT 19 null
comp_type Table usermodified BIGINT 19 null
totara_navigation Table custom BIT 0 1
role_capabilities Table roleid BIGINT 19 0
org_framework Table timecreated BIGINT 19 null
course_completion_aggr_methd Table id BIGINT 19 null
imscp Table id BIGINT 19 null
comp_criteria Table itemmodule VARCHAR 30 null
data_fields Table param6 LONGTEXT 2147483647 null
data_content Table content4 LONGTEXT 2147483647 null
grade_grades Table locktime BIGINT 19 0

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

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

tool_monitor_rules Table id BIGINT 19 null
log_display Table component VARCHAR 100

owner of the log action

question_truefalse Table falseanswer BIGINT 19 0

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

comp_scale_values Table scaleid BIGINT 19 null
role_context_levels Table id BIGINT 19 null
pos Table frameworkid BIGINT 19 null
workshop Table submissionfiletypes VARCHAR 255 null

comma separated list of file extensions

prog_completion_log Table userid BIGINT 19 null

Users id

forum Table assessed BIGINT 19 0
facetoface_session_roles Table userid BIGINT 19 null
wiki_versions Table timecreated BIGINT 19 0

Page edition timestamp

message_providers Table capability VARCHAR 255 null

Optional: permission that is required on the user's setting screen to see this message provider.

totara_userdata_user Table userid BIGINT 19 null
org_framework Table description LONGTEXT 2147483647 null
course Table groupmodeforce SMALLINT 5 0
goal_framework Table hidecustomfields TINYINT 3 null
data_fields Table param10 LONGTEXT 2147483647 null
log_display Table mtable VARCHAR 30
comments Table format TINYINT 3 0
grade_grades_history Table action BIGINT 19 0

created/modified/deleted constants

badge Table status BIT 0 0

Badge status: 0 = inactive, 1 = active, 2 = active+locked, 3 = inactive+locked, 4 = archived

competency_usercomp Table status TINYINT 3 0

Competency status.

lti_types Table baseurl LONGTEXT 2147483647 null
filter_active Table filter VARCHAR 32

The filter internal name, like 'tex'.

cohort_plan_history Table auto BIT 0 0
appraisal_role_assignment Table appraisalrole SMALLINT 5 null
reportbuilder_grp_cohort_user Table cohortid BIGINT 19 null
forum_discussions Table timeend BIGINT 19 0
chat_users Table sid VARCHAR 32
lesson_pages Table nextpageid BIGINT 19 0
assign Table sendlatenotifications TINYINT 3 0

Allows separate enabling of notifications for late assignment submissions.

cache_flags Table timemodified BIGINT 19 0
grade_outcomes Table descriptionformat TINYINT 3 0
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)

lti_tool_proxies Table id BIGINT 19 null
user_info_field Table visible SMALLINT 5 0

Visibility: private, public, hidden

competency_modulecomp Table sortorder BIGINT 19 null

The field used to naturally sort this link.

pos_competencies Table competencyid BIGINT 19 null
quiz_statistics Table standarddeviation DECIMAL 15 null
book_chapters Table timemodified BIGINT 19 0
tag_coll Table sortorder MEDIUMINT 7 0
dp_plan_evidence_info_field Table datatype VARCHAR 255 null
course_completions Table timecompleted BIGINT 19 null
workshop_assessments_old Table timeagreed BIGINT 19 0
prog_info_data Table data LONGTEXT 2147483647 null
goal_scale Table timemodified BIGINT 19 null
grade_outcomes_history Table shortname VARCHAR 255

The short name or code for this outcome statement

lock_db Table owner VARCHAR 36 null

uuid indicating the owner of the lock.

page Table name VARCHAR 255
totara_userdata_export_type_item Table component VARCHAR 100

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

log_queries Table id BIGINT 19 null
editor_atto_autosave Table pagehash VARCHAR 64

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

facetoface_sessions Table capacity BIGINT 19 0

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

dp_plan_competency_assign Table priority BIGINT 19 null

Identifies the priority of this competency within the current plan.

org_type Table timemodified BIGINT 19 null
quiz Table timecreated BIGINT 19 0

The time when the quiz was added to the course.

comp_criteria_record Table timemodified BIGINT 19 null
chat Table studentlogs SMALLINT 5 0
feedback_sitecourse_map Table courseid BIGINT 19 0
tag_coll Table isdefault TINYINT 3 0
feedback360_quest_field Table feedback360id BIGINT 19 null
question_ddwtos Table id BIGINT 19 null
workshop_old Table ntassessments SMALLINT 5 0
facetoface Table maxmanagerreserves INT 10 1

How many reservations can each manager make

files Table mimetype VARCHAR 100 null

type of file - jpeg image, open document spreadsheet

message_popup Table messageid BIGINT 19 null
lti_tool_proxies Table name VARCHAR 255 Tool Provider

Tool Provider name

goal_user_type_cohort Table timemodified BIGINT 19 null
appraisal_stage_role_setting Table locked BIT 0 0
competency_templatecohort Table id BIGINT 19 null
facetoface Table id BIGINT 19 null
facetoface Table approvalrole BIGINT 19 null
competency_template Table visible TINYINT 3 1

Used to show/hide this learning plan template.

assignfeedback_editpdf_quick Table id BIGINT 19 null
enrol_lti_lti2_share_key Table autoapprove BIT 0 null
facetoface_room Table allowconflicts BIT 0 0
goal_framework Table description LONGTEXT 2147483647 null
workshop_submissions Table gradeoverby BIGINT 19 null

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

event_subscriptions Table userid BIGINT 19 0
survey_answers Table id BIGINT 19 null
question_categories Table name VARCHAR 255
grade_categories_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

book_chapters Table id BIGINT 19 null
facetoface_notification Table managerprefix LONGTEXT 2147483647 null
course_modules_completion Table reaggregate BIGINT 19 0

Time for when reaggregation should next occur.

scale Table userid BIGINT 19 0
org_competencies Table organisationid BIGINT 19 null
enrol_lti_tools Table lang VARCHAR 30 en
tool_customlang_components Table version VARCHAR 255 null

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

certificate Table bordercolor VARCHAR 30 0
qtype_multichoice_options Table questionid BIGINT 19 0

Foreign key references question.id

prog_assignment Table assignmenttype SMALLINT 5 0
workshop_elements_old Table scale SMALLINT 5 0
local_ld_module Table totaldedication BIGINT 19 0

Total time spent on this module, in seconds

scorm_seq_rulecond Table id BIGINT 19 null
assignsubmission_file Table assignment BIGINT 19 0
message_metadata Table processorid SMALLINT 5 null

The message processor id

appraisal_quest_field Table appraisalstagepageid BIGINT 19 null
competency_framework Table taxonomies VARCHAR 255

Sequence of terms to use for each competency level.

tool_monitor_subscriptions Table lastnotificationsent BIGINT 19 0

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

filter_config Table value LONGTEXT 2147483647 null

The correspoding config variable value.

upgrade_log Table details LONGTEXT 2147483647 null
forum Table blockperiod BIGINT 19 0
prog Table id BIGINT 19 null
event Table uuid VARCHAR 255
dp_plan_evidence_info_field Table required BIT 0 null
course_sections Table sequence LONGTEXT 2147483647 null
groups_members Table id BIGINT 19 null
user Table yahoo VARCHAR 50
lesson_attempts Table correct BIGINT 19 0
reportbuilder_grp_user_user Table reportbuilderuserid BIGINT 19 null
comp_type_info_field Table id BIGINT 19 null
facetoface_sessioncancel_info_field Table param4 LONGTEXT 2147483647 null
quiz_slots Table maxmark DECIMAL 12 0.0000000

How many marks this question contributes to quiz.sumgrades.

wiki_pages Table readonly BIT 0 0

Read only flag

tool_monitor_rules Table plugin VARCHAR 254

Frankenstlye name of the plguin

events_queue_handlers Table id BIGINT 19 null
appraisal_stage Table timedue BIGINT 19 null
question_gapselect Table correctfeedbackformat TINYINT 3 0
tag_instance Table timecreated BIGINT 19 0
facetoface_room_info_data Table facetofaceroomid BIGINT 19 null
feedback360_quest_field Table descriptionformat BIT 0 null
tool_recyclebin_category Table id BIGINT 19 null
question_response_analysis Table id BIGINT 19 null
pos_competencies Table linktype TINYINT 3 0
workshop_elements_old Table maxscore SMALLINT 5 1
pos_framework Table shortname VARCHAR 100 null
forum_discussions Table userid BIGINT 19 0
user_info_field Table signup TINYINT 3 0

display field on signup page

totara_compl_import_cert Table duedate VARCHAR 10 null
lesson_attempts Table timeseen BIGINT 19 0
user_preferences Table id BIGINT 19 null
feedback_valuetmp Table course_id BIGINT 19 0
repository_instances Table password VARCHAR 255 null
totara_navigation_settings Table value VARCHAR 255 null
scorm Table intro LONGTEXT 2147483647 null
enrol Table customtext2 LONGTEXT 2147483647 null

Custom - general text

comp_type_info_field Table required TINYINT 3 null
lti_submission Table id BIGINT 19 null
assign_overrides Table id BIGINT 19 null
message_popup Table id BIGINT 19 null
facetoface_asset Table name VARCHAR 100 null
pos_type Table timecreated BIGINT 19 null
facetoface_sessions Table id BIGINT 19 null
grade_items Table decimals BIT 0 null

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

facetoface_sessioncancel_info_data Table fieldid BIGINT 19 null
tool_monitor_events Table contextinstanceid BIGINT 19 null

Context instance id

feedback360_quest_field Table description LONGTEXT 2147483647 null
comp_type Table fullname VARCHAR 1024 null
wiki_locks Table userid BIGINT 19 0

Locking user

assignfeedback_file Table numfiles BIGINT 19 0

The number of files uploaded by a grader.

competency_relatedcomp Table id BIGINT 19 null
data Table requiredentries INT 10 0
prog_messagelog Table id BIGINT 19 null
workshop_elements_old Table elementno SMALLINT 5 0
qtype_multichoice_options Table id BIGINT 19 null
block_community Table coursedescription LONGTEXT 2147483647 null
assign Table completionsubmit TINYINT 3 0

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

certif_completion_history Table timewindowopens BIGINT 19 null

Date the window opens

grade_grades_history Table loggeduser BIGINT 19 null

the userid of the person who last modified this outcome

enrol_lti_tools Table rolelearner BIGINT 19 null
facetoface_notification_sent Table userid BIGINT 19 0
forum_posts Table subject VARCHAR 255
wiki_pages Table subwikiid BIGINT 19 0

Subwiki instance of this page

course_completion_criteria Table enrolperiod BIGINT 19 null

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

lti Table toolurl LONGTEXT 2147483647 null

Remote tool url

cohort_msg_queue Table cohortid BIGINT 19 null
task_scheduled Table classname VARCHAR 255

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

facetoface_sessions_dates Table sessiontimezone VARCHAR 100 null

Timezone used for display of dates and times, 99 means use user timeozone

local_ld_lastactivity Table id BIGINT 19 null
feedback360_scale_value Table score BIGINT 19 null
totara_userdata_purge_type_item Table timechanged BIGINT 19 null

Last time when the purge field was changed

competency_templatecomp Table sortorder BIGINT 19 null

Relative sort order

mnet_host Table name VARCHAR 80
tool_customlang Table lang VARCHAR 20

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

logstore_standard_log Table component VARCHAR 100
question_statistics Table variant BIGINT 19 null
enrol_flatfile Table id BIGINT 19 null
auth_approved_request Table positionid BIGINT 19 null

Position id

scale Table courseid BIGINT 19 0
glossary Table timecreated BIGINT 19 0
certif_completion Table userid BIGINT 19 null

Users id

scorm_seq_rulecond Table ruleconditionsid BIGINT 19 0
auth_connect_users Table timecreated BIGINT 19 null
feedback360_user_assignment Table id BIGINT 19 null
course_request Table requester BIGINT 19 0
reminder_sent Table messageid BIGINT 19 null
totara_compl_import_course Table courseshortname VARCHAR 255 null

course shortname

forum Table blockafter BIGINT 19 0
dp_component_settings Table templateid BIGINT 19 null

Identifies which template this component setting is for.

badge_criteria Table badgeid BIGINT 19 0
certif_completion_history Table certifpath TINYINT 3 null
totara_userdata_purge_type_item Table id BIGINT 19 null
user Table url VARCHAR 255
report_builder_filters Table reportid BIGINT 19 null

ID of the report this column belongs to

workshop_assessments_old Table teachergraded SMALLINT 5 0
lesson_pages Table lessonid BIGINT 19 0
totara_userdata_purge_item Table name VARCHAR 100

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

block_instances Table showinsubcontexts SMALLINT 5 null

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

user_devices Table model VARCHAR 32

the device model, Nexus 4 or iPad 1,1

files_reference Table id BIGINT 19 null
report_builder_schedule_email_audience Table scheduleid BIGINT 19 null
comp Table depthlevel BIGINT 19 null
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.

mnetservice_enrol_courses Table id BIGINT 19 null

Unique remote-course ID

lti Table debuglaunch BIT 0 0

Enable the debug-style launch which pauses before auto-submit

report_builder_graph Table legend VARCHAR 255

name of one column, used when axis are reversed

dp_objective_scale_value Table usermodified BIGINT 19 null

Identifies the id of the user who last modified the scale value

facetoface_session_info_field Table hidden TINYINT 3 null
quiz Table sumgrades DECIMAL 10 0.00000

The total of all the question instance maxmarks.

facetoface_notification_hist Table id BIGINT 19 null
prog_assignment Table assignmenttypeid BIGINT 19 0
chat_users Table chatid BIGINT 19 0
assign_overrides Table sortorder BIGINT 19 null

Rank for sorting overrides.

scorm_seq_rulecond Table measurethreshold FLOAT 11 0.0000
facetoface_notification_hist Table ical_method VARCHAR 32 null

ICAL method e.g. update, cancel etc.

portfolio_tempdata Table id BIGINT 19 null
facetoface_session_info_data_param Table value VARCHAR 32
comp_record Table assessorname VARCHAR 100 null
course_categories Table depth BIGINT 19 0
profiling Table totalexecutiontime BIGINT 19 null

time (in microseconds) spent by the run

competency_userevidence Table timemodified BIGINT 19 null
mnet_log Table userid BIGINT 19 0
assignment Table maxbytes BIGINT 19 100000
course_modules Table completiongradeitemnumber BIGINT 19 null

Grade-item number used to track automatic completion, if applicable.

quiz Table browsersecurity VARCHAR 32

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

totara_connect_client_org_frameworks Table timecreated BIGINT 19 null
assign Table intro LONGTEXT 2147483647 null

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

forum_discussions Table assessed BIT 0 1
scale_history Table oldid BIGINT 19 null
appraisal_role_changes Table userassignmentid BIGINT 19 null
totara_dashboard Table id BIGINT 19 null
totara_userdata_purge_type Table id BIGINT 19 null
feedback360_user_assignment Table timedue BIGINT 19 0
comp_template Table fullname LONGTEXT 2147483647 null
comments Table component VARCHAR 255 null

The plugin this comment belongs to.

workshop_old Table hidegrades TINYINT 3 0
mnet_remote_rpc Table id BIGINT 19 null
role_assignments Table timemodified BIGINT 19 0
comp_type_info_data_param Table dataid BIGINT 19 null
course_sections Table visible BIT 0 1
cache_flags Table value LONGTEXT 2147483647 null
workshop_submissions_old Table userid BIGINT 19 0
scorm_seq_rulecond Table cond VARCHAR 30 always
choice Table completionsubmit BIT 0 0

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

facetoface_sessioncancel_info_data_param Table value VARCHAR 32
appraisal_quest_field Table param5 LONGTEXT 2147483647 null
report_builder_schedule_email_external Table email VARCHAR 255
grade_items Table gradetype SMALLINT 5 1

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

course_request Table reason LONGTEXT 2147483647 null
course_info_field Table forceunique BIT 0 null
assignfeedback_comments Table grade BIGINT 19 0
logstore_standard_log Table objectid BIGINT 19 null
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

comp_template Table shortname VARCHAR 100 null
survey_analysis Table id BIGINT 19 null
license Table enabled BIT 0 1
competency_plan Table timemodified BIGINT 19 0
job_assignment Table tempmanagerexpirydate BIGINT 19 null
label Table introformat SMALLINT 5 0
stats_weekly Table stat2 BIGINT 19 0

stat2. usually used for writes.

task_scheduled Table id BIGINT 19 null
dp_course_settings Table priorityscale BIGINT 19 null

Identifies the scale used by this component

reminder_sent Table timesent BIGINT 19 null
survey_answers Table question BIGINT 19 0
qtype_ddimageortext_drops Table label LONGTEXT 2147483647 null

Alt label for drop box

grade_grades_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

totara_connect_client_courses Table timecreated BIGINT 19 null
course_completion_criteria Table timeend BIGINT 19 null

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

assign_grades Table grader BIGINT 19 0
report_builder Table defaultsortorder BIGINT 19 4

Integer representing the direction that default sorting should be done

competency_template Table contextid BIGINT 19 null
competency_relatedcomp Table competencyid BIGINT 19 null
grade_items_history Table grademin DECIMAL 10 0.00000

What is the minimum allowable grade?

reportbuilder_grp_org_record Table orgid BIGINT 19 null
dp_plan_history Table status TINYINT 3 null

The plan's status

feedback360_quest_field Table sortorder BIGINT 19 null
forum Table intro LONGTEXT 2147483647 null
cohort Table descriptionformat TINYINT 3 null
feedback_valuetmp Table tmp_completed BIGINT 19 0
dp_objective_scale Table sortorder BIGINT 19 null
resource Table intro LONGTEXT 2147483647 null
scale_history Table id BIGINT 19 null
question_attempts Table behaviour VARCHAR 32

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

question_attempt_step_data Table attemptstepid BIGINT 19 null

Foreign key, references question_attempt_steps.id

groupings_groups Table id BIGINT 19 null
messageinbound_handlers Table id BIGINT 19 null
imscp Table intro LONGTEXT 2147483647 null
grade_items_history Table needsupdate BIGINT 19 0

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

totara_userdata_export_type Table timechanged BIGINT 19 null

Updated after very update

enrol_lti_lti2_share_key Table sharekey VARCHAR 32
competency_plan Table descriptionformat SMALLINT 5 0
enrol_lti_lti2_share_key Table id BIGINT 19 null
course_modules_completion Table userid BIGINT 19 null

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

facetoface_room_info_field Table param1 LONGTEXT 2147483647 null
certificate Table orientation VARCHAR 10
grade_items_history Table itemmodule VARCHAR 30 null

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

auth_connect_servers Table serveridnumber VARCHAR 64

World unique server ID

lesson Table name VARCHAR 255
competency Table shortname VARCHAR 100 null

Shortname of a competency

events_handlers Table schedule VARCHAR 255 null

'cron' or 'instant'.

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

facetoface Table thirdpartywaitlist BIT 0 0

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

message_read Table notification BIT 0 0
rating Table scaleid BIGINT 19 null
cohort_visibility Table instanceid BIGINT 19 0
assignfeedback_editpdf_annot Table colour VARCHAR 10 black

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

appraisal_stage_page Table appraisalstageid BIGINT 19 null
workshop_submissions Table grade DECIMAL 10 null

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

glossary_categories Table glossaryid BIGINT 19 0
data_records Table id BIGINT 19 null
badge_criteria_met Table userid BIGINT 19 null
comp_record Table positionid BIGINT 19 null
grade_items Table courseid BIGINT 19 null

The course this item is part of

comp_framework Table visible TINYINT 3 null
workshop_rubrics_old Table newid BIGINT 19 null
cohort_plan_config Table excludecompleted BIT 0 1

Exclude auto plan creation for users who have a completed plan based on the template id

auth_approved_request_snapshots Table organisationid BIGINT 19 null
local_ld_course_day Table id BIGINT 19 null
question_hints Table clearwrong BIT 0 null

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

facetoface Table intro LONGTEXT 2147483647 null

intro

cohort_members Table cohortid BIGINT 19 0
comp_scale_assignments Table id BIGINT 19 null
org Table fullname VARCHAR 1024 null
facetoface_asset_info_field Table param1 LONGTEXT 2147483647 null
course_modules_completion Table coursemoduleid BIGINT 19 null

Activity that has been completed (or not).

question_attempt_steps Table id BIGINT 19 null
reportbuilder_grp_org_user Table includechildren BIT 0 0
message Table useridfrom BIGINT 19 0
grade_items_history Table categoryid BIGINT 19 null

(optional) the category group this item belongs to

totara_navigation Table depth BIT 0 1
block_recent_activity Table userid BIGINT 19 null

User performing the action

glossary_formats Table name VARCHAR 50
glossary Table editalways TINYINT 3 0
data Table rssarticles SMALLINT 5 0
mnet_session Table session_id VARCHAR 40

The PHP Session ID

feedback Table multiple_submit BIT 0 1
grade_outcomes_courses Table courseid BIGINT 19 null

id of the course

lesson_pages Table contents LONGTEXT 2147483647 null
feedback Table course BIGINT 19 0
gap_aspirational Table userid BIGINT 19 null
role_capabilities Table modifierid BIGINT 19 0
comp_criteria_record Table timecreated BIGINT 19 null
assign Table id BIGINT 19 null
question_answers Table id BIGINT 19 null
course_completion_log Table changeuserid BIGINT 19 null

User id of the person who caused the change

glossary Table intro LONGTEXT 2147483647 null
tool_customlang Table id BIGINT 19 null
external_functions Table services VARCHAR 1333 null

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

mnet_host Table id BIGINT 19 null

Unique Host ID

grade_grades Table feedback LONGTEXT 2147483647 null

grading feedback

facetoface_asset_info_field Table datatype VARCHAR 255 null
workshop_elements_old Table newid BIGINT 19 null
workshop_assessments Table weight BIGINT 19 1

The weight of the assessment for the purposes of aggregation

facetoface_signup_info_field Table required TINYINT 3 null
totara_userdata_user Table usercontextid BIGINT 19 null

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

logstore_standard_log Table ip VARCHAR 45 null

IP address

filter_config Table contextid BIGINT 19 null

References context.id.

gradingform_rubric_levels Table definitionformat BIGINT 19 null

The format of the definition field

totara_connect_sso_sessions Table ssotoken VARCHAR 64

Token identifying SSO session on TC client

tool_customlang Table outdated SMALLINT 5 0

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

workshop_submissions Table contentformat SMALLINT 5 0

The format of submission text

comp Table typeid BIGINT 19 0
mnet_log Table module VARCHAR 20
totara_userdata_purge Table origin VARCHAR 50

suspended, deleted or manual keyword matching totara_userdata_purge_type allowxxxx columns, use other keyword for custom code

quiz Table decimalpoints SMALLINT 5 2

Number of decimal points to use when displaying grades.

org Table sortthread VARCHAR 255 null
task_scheduled Table component VARCHAR 255

The component this scheduled task belongs to.

prog Table usermodified BIGINT 19 0
data Table intro LONGTEXT 2147483647 null
tool_customlang_components Table id BIGINT 19 null
prog_courseset Table sortorder BIGINT 19 0
org_type Table usermodified BIGINT 19 null
competency_usercompcourse Table timemodified BIGINT 19 null
job_assignment Table totarasync BIT 0 0

Determines whether record can be updated via tool_totara_sync

certificate Table savecert BIT 0 0
certificate Table gradefmt BIGINT 19 0
dp_plan_program_assign Table planid BIGINT 19 null

Identifies the plan this program is attached to

workshop_assessments_old Table grade DOUBLE 22 0
url Table displayoptions LONGTEXT 2147483647 null
repository_opensesame_bdls Table id BIGINT 19 null
assignment_upgrade Table oldinstance BIGINT 19 0
course_format_options Table id BIGINT 19 null
gradingform_guide_comments Table descriptionformat TINYINT 3 null

The format of the description field

cohort_plan_history Table cohortid BIGINT 19 null
qtype_match_options Table id BIGINT 19 null
reminder_message Table subject LONGTEXT 2147483647 null
message_processors Table name VARCHAR 166

Name of the message processor

lti_types Table parameter LONGTEXT 2147483647 null

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

tool_monitor_rules Table eventname VARCHAR 254

Fully qualified name of the event

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.

mnet_service2rpc Table serviceid BIGINT 19 0

Unique service ID

cohort_role Table cohortid BIGINT 19 0
user Table skype VARCHAR 50
prog_message Table sortorder BIGINT 19 0
comp_criteria Table linktype TINYINT 3 0
feedback_completed_history Table timemodified BIGINT 19 0
post Table format BIGINT 19 0
dp_plan_program_assign Table duedate BIGINT 19 null

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

reportbuilder_grp_org_user Table id BIGINT 19 null
lesson Table introformat SMALLINT 5 0
enrol_paypal Table receiver_email VARCHAR 255
grade_grades Table excluded BIGINT 19 0

grade excluded from aggregation functions, date means when excluded

stats_daily Table roleid BIGINT 19 0

id of role for the aggregates

resource_old Table popup LONGTEXT 2147483647 null
mnet_remote_service2rpc Table serviceid BIGINT 19 0

Unique service ID

facetoface_sessioncancel_info_data Table data LONGTEXT 2147483647 null
org_type_info_data Table data LONGTEXT 2147483647 null
messageinbound_datakeys Table timecreated BIGINT 19 null

The time that the data key was created.

prog_extension Table status SMALLINT 5 0
comp_framework Table id BIGINT 19 null
event Table timemodified BIGINT 19 0
gradingform_rubric_criteria Table description LONGTEXT 2147483647 null

The criterion description

workshopform_rubric Table workshopid BIGINT 19 null

Workshop ID

quiz_attempts Table quiz BIGINT 19 0

Foreign key reference to the quiz that was attempted.

workshop Table instructauthors LONGTEXT 2147483647 null

Instructions for the submission phase

feedback Table site_after_submit VARCHAR 255
dp_objective_scale_value Table idnumber VARCHAR 100 null

Defines a id that can be assigned to a scale value

totara_connect_client_pos_frameworks Table timecreated BIGINT 19 null
workshop_grades_old Table newplugin VARCHAR 28 null
comp_type_info_field Table description LONGTEXT 2147483647 null
assignment Table name VARCHAR 255
course_completions Table timeenrolled BIGINT 19 0
facetoface_notification Table body LONGTEXT 2147483647 null
dp_plan_evidence_info_field Table hidden BIT 0 null
mnetservice_enrol_enrolments Table hostid BIGINT 19 null

ID of the remote MNet host

grade_grades_history Table source VARCHAR 255 null

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

enrol_lti_lti2_user_result Table resourcelinkid BIGINT 19 null
course_modules Table visibleold BIT 0 1
scorm_seq_rolluprulecond Table operator VARCHAR 5 noOp
wiki_links Table id BIGINT 19 null
prog Table visible BIT 0 1
course_info_field Table defaultdata LONGTEXT 2147483647 null
reminder_message Table message LONGTEXT 2147483647 null
dp_plan_history Table timemodified BIGINT 19 null

Modification time

mnetservice_enrol_courses Table summary LONGTEXT 2147483647 null
auth_approved_request Table status TINYINT 3 null

Request status - 0 means pending, 1 approved, 2 rejected, etc.

assignfeedback_editpdf_cmnt Table pageno BIGINT 19 0

The page in the PDF that this comment appears on

totara_connect_client_courses Table id BIGINT 19 null
goal_type_info_field Table defaultdata LONGTEXT 2147483647 null
tag Table tagcollid BIGINT 19 null
resource_old Table course BIGINT 19 0
org_framework Table hidecustomfields TINYINT 3 null
role_sortorder Table roleid BIGINT 19 null
comp Table frameworkid BIGINT 19 null
profiling Table id BIGINT 19 null
external_functions Table id BIGINT 19 null
quiz_statistics Table kurtosis DECIMAL 15 null
event_subscriptions Table pollinterval BIGINT 19 0

Frequency of checks for new/changed events

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)

gradingform_guide_comments Table description LONGTEXT 2147483647 null

The comment description

tool_sitepolicy_localised_policy Table id BIGINT 19 null
data Table scale BIGINT 19 0
question Table timemodified BIGINT 19 0

time that question was last modified

totara_dashboard Table published BIT 0 0
mnetservice_enrol_courses Table idnumber VARCHAR 100
assignment_upgrade Table id BIGINT 19 null
feedback_completedtmp Table anonymous_response BIT 0 0
certificate Table datefmt BIGINT 19 0
competency_usercompplan Table proficiency TINYINT 3 null

Indicate if the competency is proficient not.

goal_type_info_field Table datatype VARCHAR 255 null
goal_type_info_field Table param5 LONGTEXT 2147483647 null
logstore_standard_log Table contextid BIGINT 19 null
lesson_answers Table answerformat TINYINT 3 0
facetoface_asset_info_field Table shortname VARCHAR 100 null
course_info_field Table required BIT 0 null
pos_framework Table usermodified BIGINT 19 null
backup_courses Table courseid BIGINT 19 0
assign Table submissiondrafts TINYINT 3 0

If true, assignment submissions will be considered drafts until the student clicks on the submit assignmnet button.

facetoface_sessions Table cutoff BIGINT 19 86400

The number of seconds before the session start by which the minimum capacity should be reached

dp_plan_history Table reason TINYINT 3 null

The reason for the status change

lti_types Table tooldomain VARCHAR 255
qtype_match_options Table shuffleanswers SMALLINT 5 1
auth_approved_request_snapshots Table lastnamephonetic VARCHAR 255 null
grade_grades_history Table locktime BIGINT 19 0

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

wiki_pages Table userid BIGINT 19 0

Edition author

wiki Table name VARCHAR 255 Wiki

name field for moodle instances

totara_connect_client_org_frameworks Table id BIGINT 19 null
backup_controllers Table backupid VARCHAR 32

unique id of the backup

glossary_entries Table usedynalink TINYINT 3 1
enrol_lti_lti2_resource_link Table contextid BIGINT 19 null
role_allow_override Table allowoverride BIGINT 19 0
dp_priority_scale_value Table name VARCHAR 255 null

Name for scale value

repository_opensesame_pkgs Table visible BIT 0 1

Is this course package visible?

scorm Table lastattemptlock BIT 0 0
wiki_links Table frompageid BIGINT 19 0

Page id with a link

message Table notification BIT 0 0
glossary Table id BIGINT 19 null
resource_old Table reference VARCHAR 255
goal_grp_cohort Table cohortid BIGINT 19 null
feedback_item Table presentation LONGTEXT 2147483647 null
report_builder_schedule_email_audience Table id BIGINT 19 null
block_totara_featured_links_tiles Table presetsaggregation SMALLINT 5 0

The aggregation of the preset rules ie the logic to combine them

lesson_answers Table score BIGINT 19 0
grade_categories_history Table aggregatesubcats BIT 0 0

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

forum_digests Table forum BIGINT 19 null
workshop_old Table description LONGTEXT 2147483647 null
totara_compl_import_cert Table evidenceid BIGINT 19 null

The evidence table id

grade_categories Table aggregateonlygraded BIT 0 0

aggregate only graded activities

messageinbound_messagelist Table messageid LONGTEXT 2147483647 null
lesson_pages Table contentsformat TINYINT 3 0
user_password_resets Table userid BIGINT 19 null

id of the user account which requester claimed to be

repository_opensesame_pkgs Table zipfilename VARCHAR 255
enrol Table cost VARCHAR 20 null

Custom - enrolment cost

qtype_ddimageortext_drops Table questionid BIGINT 19 0
grade_items_history Table display BIGINT 19 0
lti Table instructorcustomparameters VARCHAR 255 null

Additional custom parameters provided by the instructor

comp_type_info_data Table data LONGTEXT 2147483647 null
workshop_grades_old Table assessmentid BIGINT 19 0
workshop_aggregations Table userid BIGINT 19 null

The id of the user which aggregated grades are calculated for

prog_completion Table id BIGINT 19 null
glossary_entries Table attachment VARCHAR 100
assign_submission Table userid BIGINT 19 0
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

totara_compl_import_cert Table certificationshortname VARCHAR 255 null

certification shortname

feedback_template Table ispublic BIT 0 0
lesson_attempts Table userid BIGINT 19 0
dp_plan_evidence_info_field Table description LONGTEXT 2147483647 null
prog Table fullname VARCHAR 254
logstore_standard_log Table edulevel BIT 0 null
reportbuilder_grp_org_record Table id BIGINT 19 null
appraisal_stage Table name VARCHAR 255
course Table requested BIT 0 0
book_chapters Table content LONGTEXT 2147483647 null
message Table component VARCHAR 100 null
role_sortorder Table sortoder BIGINT 19 null
certif_completion Table certifid BIGINT 19 null

Certification ID

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

course Table newsitems MEDIUMINT 7 1
org_competencies Table competencyid BIGINT 19 null
facetoface_signup_info_field Table defaultdata LONGTEXT 2147483647 null
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

backup_controllers Table timemodified BIGINT 19 null

last time the controller was modified

course_categories Table certifcount BIGINT 19 0

Totara certification count from totara_program

feedback_item Table feedback BIGINT 19 0
lesson Table activitylink BIGINT 19 0
mnet_sso_access_control Table username VARCHAR 100

Username

block_positions Table subpage VARCHAR 16

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

scorm_scoes Table id BIGINT 19 null
org_type_info_field Table param4 LONGTEXT 2147483647 null
external_functions Table name VARCHAR 200
goal_type Table id BIGINT 19 null
dp_permissions Table action VARCHAR 255 null

Shortname of the permission to be set

message Table useridto BIGINT 19 0
block_rss_client Table title LONGTEXT 2147483647 null
dp_priority_scale_value Table timemodified BIGINT 19 null

Identifies the last time a scale value was modified

profiling Table timecreated BIGINT 19 null

unix timestap of the creation of this run

enrol_lti_lti2_resource_link Table primaryresourcelinkid BIGINT 19 null
feedback360 Table id BIGINT 19 null
grade_outcomes_history Table id BIGINT 19 null
qtype_match_subquestions Table id BIGINT 19 null
prog Table availableuntil BIGINT 19 0
groupings Table descriptionformat TINYINT 3 0
reportbuilder_grp_user_record Table reportbuilderrecordid BIGINT 19 null
enrol_lti_lti2_consumer Table toolproxy LONGTEXT 2147483647 null
external_functions Table component VARCHAR 100
workshop_old Table newplugin VARCHAR 28 null
totara_userdata_purge_type Table idnumber VARCHAR 255

Unique plain text identifier

workshopform_numerrors Table descriptionformat SMALLINT 5 0

The format of the description field

reportbuilder_grp_org_user Table orgid BIGINT 19 null
qtype_essay_options Table responserequired TINYINT 3 1

Nonzero if an inline text response is optional

grade_outcomes Table shortname VARCHAR 255

The short name or code for this outcome statement

prog_completion Table programid BIGINT 19 0
resource Table timemodified BIGINT 19 0
role_assignments Table sortorder BIGINT 19 0
grade_outcomes_history Table scaleid BIGINT 19 null

The recommended scale for this outcome.

comp_scale_values Table timemodified BIGINT 19 null
stats_monthly Table roleid BIGINT 19 0

id of role for the aggregates

qtype_match_options Table partiallycorrectfeedbackformat TINYINT 3 0
workshop_assessments_old Table gradinggrade SMALLINT 5 0
profiling Table runreference TINYINT 3 0

Is this run a reference one

cohort_rules Table modifierid BIGINT 19 null
appraisal Table name VARCHAR 255
registration_hubs Table token VARCHAR 255

the token to communicate with the hub by web service

workshop Table strategy VARCHAR 30

The type of the current grading strategy used in this workshop

choice_answers Table id BIGINT 19 null
mnet_host Table theme VARCHAR 100 null
course_format_options Table value LONGTEXT 2147483647 null

Value of the format option

survey_questions Table id BIGINT 19 null
scale_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

org Table totarasync BIT 0 0

Totara sync flag from totara_sync

sessions Table timemodified BIGINT 19 null
dp_objective_scale_value Table id BIGINT 19 null
competency_evidence Table actionuserid BIGINT 19 null
data_records Table userid BIGINT 19 0
grade_outcomes_history Table source VARCHAR 255 null

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

enrol Table name VARCHAR 255 null

Optional instance name

external_services_users Table id BIGINT 19 null
workshop_rubrics_old Table id BIGINT 19 null
report_builder_schedule Table format VARCHAR 50
pos_framework Table visible TINYINT 3 null
facetoface_session_info_data_param Table dataid BIGINT 19 null
backup_courses Table laststatus VARCHAR 1 5
context Table depth TINYINT 3 0
lti_submission Table userid BIGINT 19 null
chat_users Table groupid BIGINT 19 0
report_builder_preproc_track Table disabled SMALLINT 5 0

If none zero, the item is disabled, so will no longer be processed. This is used to prevent repeatedly attempting to process items which have a problem.

feedback360_grp_cohort Table cohortid BIGINT 19 null
org_competencies Table linktype TINYINT 3 0
message_contacts Table userid BIGINT 19 0
scorm Table scormtype VARCHAR 50 local

local, external or repository

course_sections Table availability LONGTEXT 2147483647 null

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

job_assignment Table positionid BIGINT 19 null

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

editor_atto_autosave Table contextid BIGINT 19 null

The contextid that the form was loaded with.

scale Table scale LONGTEXT 2147483647 null
totara_compl_import_cert Table certificationid BIGINT 19 null

Certification ID if one exists

facetoface_room_info_field Table forceunique TINYINT 3 null
enrol Table enrol VARCHAR 20
data_fields Table type VARCHAR 255
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

auth_connect_ids Table timecreated BIGINT 19 null
quiz_statistics Table skewness DECIMAL 15 null
forum_posts Table messagetrust TINYINT 3 0
lesson_answers Table answer LONGTEXT 2147483647 null
grade_items Table weightoverride BIT 0 0
tool_sitepolicy_localised_consent Table localisedpolicyid BIGINT 19 null

Which localised policy these statements relate to

tool_recyclebin_category Table shortname VARCHAR 255
question_statistics Table discriminativeefficiency DECIMAL 15 null
workshop_assessments Table gradinggradeoverby BIGINT 19 null

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

competency_template Table duedate BIGINT 19 null

The default due date for instances of this plan.

comp_record Table assessorid BIGINT 19 null
messageinbound_handlers Table validateaddress BIT 0 1

Whether to validate the sender address against the user record.

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.

enrol_lti_lti2_user_result Table ltiuserkey VARCHAR 255
external_services Table timecreated BIGINT 19 null
user_password_history Table timecreated BIGINT 19 null
feedback360_email_assignment Table id BIGINT 19 null
pos_type_info_field Table required TINYINT 3 null
competency Table usermodified BIGINT 19 null

The user who last modified this competency

files Table filepath VARCHAR 255

Optional - relative path to file from module content root, useful in Scorm and Resource mod - most of the mods do not need this

dp_plan_competency_assign Table approved SMALLINT 5 0

Indicates if the competency has been accepted as part of a plan, or is awaiting approval.

groupings_groups Table timeadded BIGINT 19 0
user_info_data Table dataformat TINYINT 3 0
auth_approved_request_snapshots Table confirmed BIT 0 null
facetoface_notification_sent Table sessionid BIGINT 19 0
facetoface_room_info_data Table data LONGTEXT 2147483647 null
goal_grp_pos Table posid BIGINT 19 null
task_adhoc Table customdata LONGTEXT 2147483647 null

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

rating Table rating BIGINT 19 null
qtype_ddmarker_drags Table questionid BIGINT 19 0
resource Table displayoptions LONGTEXT 2147483647 null
workshopform_comments Table descriptionformat SMALLINT 5 0

The format of the description field

report_builder_preproc_track Table groupid BIGINT 19 null

ID of the group the item belongs to

user Table idnumber VARCHAR 255
resource Table tobemigrated SMALLINT 5 0
appraisal_user_event Table userid BIGINT 19 null
resource Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

workshop_submissions Table workshopid BIGINT 19 null

the id of the workshop instance

resource_old Table introformat SMALLINT 5 0
assignment_submissions Table format SMALLINT 5 0
enrol_lti_tool_consumer_map Table toolid BIGINT 19 null

The tool ID.

glossary_entries Table userid BIGINT 19 0
forum Table trackingtype TINYINT 3 1
report_builder_graph Table reportid BIGINT 19 null

ID of the report this graph belongs to

block_zoola_reports_user Table id BIGINT 19 null
course_categories Table id BIGINT 19 null
forum_posts Table message LONGTEXT 2147483647 null
pos_type_info_data_param Table id BIGINT 19 null
tool_monitor_subscriptions Table userid BIGINT 19 null

User id of the subscriber

facetoface Table approvaltype BIGINT 19 0
scorm_seq_objective Table scoid BIGINT 19 0
pos Table sortthread VARCHAR 255 null
choice_answers Table choiceid BIGINT 19 0
scorm_scoes_track Table element VARCHAR 255
totara_userdata_purge Table timestarted BIGINT 19 null

Start of purge process, this happens in scheduled task or ad-hoc task

folder Table showexpanded BIT 0 1

1 = expanded, 0 = collapsed for sub-folders

question_statistics Table subquestions LONGTEXT 2147483647 null
course_info_field Table param5 LONGTEXT 2147483647 null
certif_completion_history Table timemodified BIGINT 19 null
dp_plan_evidence_info_data_param Table id BIGINT 19 null
totara_connect_clients Table addnewcourses BIT 0 0

Automatically add all new courses

data Table timemodified BIGINT 19 0

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

comp Table parentid BIGINT 19 null
lti Table servicesalt VARCHAR 40 null
course_categories Table path VARCHAR 255
context_temp Table id BIGINT 19 null

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

competency_relatedcomp Table timecreated BIGINT 19 null
tool_usertours_tours Table id BIGINT 19 null
prog_extension Table extensiondate BIGINT 19 0
facetoface_asset_info_data_param Table dataid BIGINT 19 null
tag Table description LONGTEXT 2147483647 null
workshop_grades Table peercomment LONGTEXT 2147483647 null

Reviewer's comment to the grade value.

report_builder_cache Table id BIGINT 19 null
report_builder_global_restriction Table id BIGINT 19 null
tool_sitepolicy_user_consent Table hasconsented BIT 0 null

Has the user consented to this option

report_builder_cache Table changed BIT 0 null
message_processors Table id BIGINT 19 null
appraisal_review_data Table itemid BIGINT 19 null
chat_users Table id BIGINT 19 null
totara_compl_import_course Table evidenceid BIGINT 19 null

The evidence table id

course_completion_crit_compl Table gradefinal DECIMAL 10 null

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

backup_controllers Table itemid BIGINT 19 null

id of the module/section/activity being backup

totara_connect_clients Table id BIGINT 19 null
goal_scale_values Table idnumber VARCHAR 100 null
goal_user_info_field Table hidden TINYINT 3 null
quiz Table showblocks SMALLINT 5 0

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

page Table legacyfileslast BIGINT 19 null
qtype_multichoice_options Table partiallycorrectfeedbackformat TINYINT 3 0
workshop Table assessmentstart BIGINT 19 0

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

scorm_scoes Table scormtype VARCHAR 5
competency_usercompplan Table timecreated BIGINT 19 null
auth_approved_request Table positionfreetext LONGTEXT 2147483647 null

Free text field for position - this is a hint for approver so that they can pick the appropriate position

comp_type_info_field Table hidden TINYINT 3 null
enrol_lti_lti2_consumer Table consumerguid VARCHAR 1024 null
workshop_submissions_old Table description LONGTEXT 2147483647 null
local_ld_import_logs_status Table timemodified BIGINT 19 null

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

course_completion_criteria Table courseinstance BIGINT 19 null

Course instance id (if using course criteria type)

wiki Table id BIGINT 19 null
quiz Table delay2 BIGINT 19 0

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

report_builder Table toolbarsearch SMALLINT 5 1

Indicates if toolbarsearch should be enabled

prog_extension Table extensionreason LONGTEXT 2147483647 null
report_builder_columns Table aggregate VARCHAR 30 null

Aggregation type, null means none

comp_record Table timecreated BIGINT 19 null
lti Table id BIGINT 19 null
totara_userdata_export_item Table result BIGINT 19 null

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

lesson_attempts Table id BIGINT 19 null
dp_priority_scale_value Table sortorder BIGINT 19 null

Identifies the order scale values appear in

cohort_role Table contextid BIGINT 19 0
goal_record Table deleted BIT 0 0
role Table name VARCHAR 255

Empty names are automatically localised

auth_connect_ids Table serverid BIGINT 19 null
question Table name VARCHAR 255
lesson Table usepassword SMALLINT 5 0
enrol_paypal Table id BIGINT 19 null
assign_user_flags Table assignment BIGINT 19 0

The assignment these flags apply to.

imscp Table name VARCHAR 255
prog Table audiencevisible SMALLINT 5 2
resource_old Table cmid BIGINT 19 null
appraisal_event_message Table content LONGTEXT 2147483647 null
dp_plan_evidence_info_data Table evidenceid BIGINT 19 null
grade_items_history Table calculation LONGTEXT 2147483647 null

Formula describing how to derive this grade from other items, referring to them using giXXX where XXX is grade item id ... eg something like: =sin(square(#gi20#)) + #gi30#

question_ddwtos Table shownumcorrect TINYINT 3 0
workshop_old Table gradingstrategy TINYINT 3 1
assign_submission Table latest TINYINT 3 0

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

grade_items Table timecreated BIGINT 19 null

The first time this grade_item was created

feedback360_quest_field Table defaultdataformat BIT 0 null
competency_modulecomp Table competencyid BIGINT 19 null

The course competency this activity is linked to.

totara_navigation_settings Table name VARCHAR 255
report_builder_cache Table queryhash VARCHAR 40 null
workshop_comments_old Table mailed TINYINT 3 0
wiki Table defaultformat VARCHAR 20 creole

Wiki's default editor

course_completions Table course BIGINT 19 0
resource_old Table oldid BIGINT 19 null
role_assignments Table userid BIGINT 19 0
comp_framework Table timemodified BIGINT 19 null
totara_connect_clients Table apiversion BIGINT 19 null

The API version used for communication with this client

scorm Table displaycoursestructure BIT 0 0
competency Table competencyframeworkid BIGINT 19 null

The framework this competency relates to.

feedback_completed Table feedback BIGINT 19 0
task_scheduled Table lastruntime BIGINT 19 null
mnet_log Table ip VARCHAR 45
enrol_lti_users Table userid BIGINT 19 null
sessions Table timecreated BIGINT 19 null
workshop_comments_old Table newplugin VARCHAR 28 null
totara_compl_import_cert Table importuserid BIGINT 19 null

ID of user running the import

context Table id BIGINT 19 null
rating Table ratingarea VARCHAR 50
mnet_remote_rpc Table functionname VARCHAR 40
mnet_rpc Table profile LONGTEXT 2147483647 null

Method signature

comp_scale_values Table id BIGINT 19 null
pos_type_info_field Table datatype VARCHAR 255
assignment_submissions Table timemarked BIGINT 19 0
dp_evidence_type Table description LONGTEXT 2147483647 null
mnet_log Table id BIGINT 19 null
question_categories Table info LONGTEXT 2147483647 null
tool_customlang Table modified SMALLINT 5 0

Has the string been modified via the translator?

goal_grp_org Table goalid BIGINT 19 null
enrol Table customdec1 DECIMAL 12 null

Custom - general decimal

grade_outcomes_history Table description LONGTEXT 2147483647 null

Outcome description

question_attempt_steps Table sequencenumber BIGINT 19 null

Numbers the steps in a question attempt sequentially.

grade_grades_history Table feedbackformat BIGINT 19 0

format of feedback text

scorm Table maxgrade DOUBLE 22 0
dp_plan_evidence_relation Table component VARCHAR 255

component name - competency, objective, course

facetoface_signups Table userid BIGINT 19 null
prog_recurrence Table currentcourseid BIGINT 19 0
dp_objective_scale_value Table sortorder BIGINT 19 null

Defines the order of the priority scale values

auth_connect_servers Table timecreated BIGINT 19 null
appraisal_user_event Table timescheduled BIGINT 19 null
pos_type Table shortname VARCHAR 100 null
auth_approved_request_snapshots Table email VARCHAR 100 null
grade_items_history Table itemtype VARCHAR 30

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

glossary_entries_categories Table id BIGINT 19 null
goal_type_info_field Table param1 LONGTEXT 2147483647 null
goal_user_info_data Table fieldid BIGINT 19 null
lesson_branch Table nextpageid BIGINT 19 0
facetoface Table introformat TINYINT 3 0

introformat

facetoface_notification_hist Table userid BIGINT 19 null

FK of user

workshop_comments_old Table userid BIGINT 19 0
dp_priority_scale Table timemodified BIGINT 19 null

Identifies the last time this scale was modified

wiki_pages Table timerendered BIGINT 19 0

Last render timestamp

totara_compl_import_cert Table importevidence BIT 0 0

Imported into evidence

dp_plan_objective Table id BIGINT 19 null
totara_navigation_settings Table id BIGINT 19 null
prog_info_field Table shortname VARCHAR 100 null
block_zoola_reports_schedule Table reporturi VARCHAR 1333

Zoola report URI

block Table name VARCHAR 40
totara_connect_client_cohorts Table id BIGINT 19 null
user Table lastaccess BIGINT 19 0
gap_aspirational Table timecreated BIGINT 19 null
scorm_seq_rolluprule Table minimumcount BIGINT 19 0
report_builder_settings Table name VARCHAR 100

Name of the setting

pos_type_info_field Table shortname VARCHAR 100
config_plugins Table plugin VARCHAR 100 core
course Table showreports SMALLINT 5 0
user Table calendartype VARCHAR 30 gregorian
comp_template Table competencycount BIGINT 19 null
facetoface_notification Table booked BIT 0 0
lti_submission Table gradepercent DECIMAL 10 null
certificate_issues_history Table timecreated BIGINT 19 0
certificate Table introformat SMALLINT 5 0
certificate_issues_history Table idarchived BIGINT 19 null
chat Table introformat SMALLINT 5 0

text format of intro field

qtype_ddmarker Table questionid BIGINT 19 0
pos_framework Table id BIGINT 19 null
goal Table description LONGTEXT 2147483647 null
forum_discussions Table archived BIT 0 0

If archived, then exclude this from the completion criteria

workshop_assessments Table gradinggrade DECIMAL 10 null

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

workshopallocation_scheduled Table resultstatus BIGINT 19 null

The resulting status of the most recent execution

grade_items_history Table gradepass DECIMAL 10 0.00000

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

qtype_multichoice_options Table incorrectfeedbackformat TINYINT 3 0
workshop_old Table id BIGINT 19 null
competency_templatecomp Table timecreated BIGINT 19 null

The time this link was created.

enrol_lti_lti2_consumer Table consumerkey256 VARCHAR 255
course Table audiencevisible SMALLINT 5 2

Audience visibility setting

cohort_rule_collections Table modifierid BIGINT 19 null
lesson Table mediaheight BIGINT 19 100
glossary Table scale BIGINT 19 0
certificate Table printdate BIGINT 19 0
local_ld_lastactivity Table coursemoduleid BIGINT 19 0

Coursemodule id

auth_connect_user_collections Table cohortid BIGINT 19 null
workshop Table grade DECIMAL 10 80.00000

The maximum grade for submission

question_numerical_units Table id BIGINT 19 null
lesson Table timelimit BIGINT 19 0
workshopeval_best_settings Table workshopid BIGINT 19 null
org_type_info_field Table sortorder BIGINT 19 null
report_builder_cache Table genstart BIGINT 19 null
comments Table timecreated BIGINT 19 null
job_assignment Table managerjaid BIGINT 19 null

The job assignment ID belonging to the user who will act as manager for this job assignment

role_assignments Table contextid BIGINT 19 0
cohort_role Table id BIGINT 19 null
workshop_elements_old Table stddev DOUBLE 22 0
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

grading_instances Table feedback LONGTEXT 2147483647 null

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

comp Table timemodified BIGINT 19 null
grade_items_history Table aggregationcoef2 DECIMAL 10 0.00000

Aggregation coefficient used for category weights or other aggregation types

survey Table intro LONGTEXT 2147483647 null
goal_user_type Table id BIGINT 19 null
task_scheduled Table customised TINYINT 3 0

Used on upgrades to prevent overwriting custom schedules.

stats_daily Table stattype VARCHAR 20 activity

type of stat

gradingform_rubric_levels Table score DECIMAL 10 null

The score for this level

quiz Table timeclose BIGINT 19 0

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

appraisal_review_data Table appraisalscalevalueid BIGINT 19 null
comp_scale_values Table proficient TINYINT 3 0
pos_type_info_data_param Table value VARCHAR 32
workshop Table gradedecimals SMALLINT 5 0

Number of digits that should be shown after the decimal point when displaying grades

goal_type_info_field Table id BIGINT 19 null
assign_overrides Table allowsubmissionsfromdate BIGINT 19 null

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

grade_items Table itemtype VARCHAR 30

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

auth_approved_request_snapshots Table usersnapshot BIGINT 19 null
scorm_seq_mapinfo Table writenormalizedmeasure BIT 0 0
course_modules Table showdescription BIT 0 0

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

user Table address VARCHAR 255
quiz_overview_regrades Table questionusageid BIGINT 19 null

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

grade_grades_history Table rawscaleid BIGINT 19 null

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

forum_read Table discussionid BIGINT 19 0
mnet_log Table remoteid BIGINT 19 0
competency_framework Table usermodified BIGINT 19 null

The user who last modified this framework

local_ld_import_logs_status Table timestarted BIGINT 19 null

When the import logs task started

wiki_subwikis Table wikiid BIGINT 19 0

Wiki activity

tool_sitepolicy_localised_policy Table isprimary BIT 0 null

If the localised policy is the Admin's primary version

report_builder_global_restriction Table allrecords BIT 0 0

True means no restrictions

question_statistics Table s BIGINT 19 0
user_info_field Table param5 LONGTEXT 2147483647 null

General parameter field

comp_type Table timemodified BIGINT 19 null
user_info_field Table required TINYINT 3 0

Field required

lti Table instructorchoiceallowsetting BIT 0 null

Allow a tool to store a setting

appraisal_grp_pos Table appraisalid BIGINT 19 null
workshop_old Table showleaguetable SMALLINT 5 0
goal_scale_values Table scaleid BIGINT 19 null
grade_grades_history Table oldid BIGINT 19 null
appraisal Table id BIGINT 19 null
cache_filters Table version BIGINT 19 0
quiz_reports Table id BIGINT 19 null
pos_type Table description LONGTEXT 2147483647 null
enrol Table customint1 BIGINT 19 null

Custom - general int

appraisal_quest_field Table param4 LONGTEXT 2147483647 null
scorm_scoes Table launch LONGTEXT 2147483647 null
user Table trackforums BIT 0 0
question_gapselect Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

pos_type_info_data Table positionid BIGINT 19 null
prog_completion_history Table positionid BIGINT 19 null
competency_framework Table shortname VARCHAR 100 null

Short name for the competency framework.

goal_type_info_data Table goalid BIGINT 19 null
workshop_comments_old Table workshopid BIGINT 19 0
scorm_seq_ruleconds Table scoid BIGINT 19 0
workshop_old Table maxbytes BIGINT 19 100000
facetoface_cancellation_info_field Table sortorder BIGINT 19 null
resource Table filterfiles SMALLINT 5 0
enrol Table customchar2 VARCHAR 255 null

Custom - general short name

scorm_scoes_track Table scormid BIGINT 19 0
workshop_rubrics_old Table elementno BIGINT 19 0
forum Table scale BIGINT 19 0
comp_record Table competencyid BIGINT 19 null
totara_userdata_export_type_item Table exportdata BIT 0 null

0 means item skipped during export, 1 means data to be exported

config Table value LONGTEXT 2147483647 null
mnetservice_enrol_enrolments Table id BIGINT 19 null

Unique enrollment ID

competency_coursecomp Table competencyid BIGINT 19 null

The competency that is linked to this course.

feedback Table name VARCHAR 255
block_quicklinks Table id BIGINT 19 null
choice Table intro LONGTEXT 2147483647 null
question_truefalse Table question BIGINT 19 0

Foreign key references question.id.

role_sortorder Table id BIGINT 19 null
badge_criteria_met Table critid BIGINT 19 null
appraisal_scale Table id BIGINT 19 null
page Table timemodified BIGINT 19 0
lesson_timer Table starttime BIGINT 19 0
portfolio_instance_config Table id BIGINT 19 null
cohort_rule_collections Table timecreated BIGINT 19 null
scorm_seq_objective Table minnormalizedmeasure FLOAT 11 0.0000
prog_completion Table coursesetid BIGINT 19 0
course_categories Table timemodified BIGINT 19 0
tag_instance Table component VARCHAR 100

Defines the Moodle component which the tag was added to

task_scheduled Table day VARCHAR 25
assignfeedback_file Table grade BIGINT 19 0
qtype_multichoice_options Table layout SMALLINT 5 0

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

assignment_submissions Table id BIGINT 19 null
facetoface_sessions_dates Table timefinish BIGINT 19 0
appraisal_grp_org Table appraisalid BIGINT 19 null
course_completion_criteria Table role BIGINT 19 null
competency_plan Table duedate BIGINT 19 0
enrol_lti_lti2_consumer Table enabled BIT 0 null
appraisal_grp_cohort Table id BIGINT 19 null
message_processors Table enabled BIT 0 1

Defines if processor is enabled

auth_approved_request_snapshots Table managerfreetext LONGTEXT 2147483647 null
question Table generalfeedbackformat TINYINT 3 0
data_records Table timecreated BIGINT 19 0
files Table sortorder BIGINT 19 0

order of files

report_builder_cache Table schedule BIGINT 19 null
prog_info_field Table sortorder BIGINT 19 null
lesson Table conditions LONGTEXT 2147483647 null
lesson_overrides Table userid BIGINT 19 null

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

job_assignment Table idnumber VARCHAR 100

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

course_info_field Table sortorder BIGINT 19 null
grade_outcomes Table id BIGINT 19 null

id of the table

goal_user_info_field Table param2 LONGTEXT 2147483647 null
portfolio_log Table tempdataid BIGINT 19 0

old id from portfolio_tempdata. This is so that we can gracefully catch a race condition between an external system requesting a file and causing the tempdata to be deleted, before the user gets the "your transfer is requested" page

user Table timecreated BIGINT 19 0
lesson_answers Table response LONGTEXT 2147483647 null
assign Table requireallteammemberssubmit TINYINT 3 0

If enabled, a submission will not be accepted until all team members have submitted it.

pos_type_info_data Table data LONGTEXT 2147483647 null
comp_type_info_data Table competencyid BIGINT 19 null
totara_navigation_settings Table itemid BIGINT 19 null
block_quicklinks Table title LONGTEXT 2147483647 null
workshopform_accumulative Table grade BIGINT 19 null

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

local_ld_module Table coursemoduleid BIGINT 19 null

Foreign key to the course_modules table

workshop_stockcomments_old Table elementno BIGINT 19 0
events_queue_handlers Table queuedeventid BIGINT 19 null

foreign key id corresponding to the id of the event_queues table

prog_courseset Table completiontype SMALLINT 5 0
imscp Table introformat SMALLINT 5 0
dp_plan_evidence Table name VARCHAR 255

Name for this item of evidence

totara_sync_log Table info VARCHAR 255 null

log entry info message

sessions Table state BIGINT 19 0

0 means normal session

message_read Table useridto BIGINT 19 0
appraisal_stage_data Table id BIGINT 19 null
scorm Table maxattempt BIGINT 19 1
user_private_key Table id BIGINT 19 null
totara_userdata_purge_type Table userstatus BIT 0 null

Type is suitable for this user status only. Cannot be changed after creation, 0 means active, 1 deleted and 2 suspended

workshopform_comments Table sort BIGINT 19 0

Defines the dimension order within the assessment form

blog_external Table id BIGINT 19 null
certif_completion Table timemodified BIGINT 19 null
auth_approved_request Table timeresolved BIGINT 19 null
grade_items_history Table scaleid BIGINT 19 null

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

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

user_info_category Table sortorder BIGINT 19 0

Display order

forum_discussion_subs Table userid BIGINT 19 null
auth_approved_request_snapshots Table firstnamephonetic VARCHAR 255 null
certificate_issues Table code VARCHAR 40 null
quiz_statistics Table standarderror DECIMAL 15 null
data Table editany SMALLINT 5 0
lti Table instructorchoiceallowroster BIT 0 null

Allow the roster to be retrieved

tool_sitepolicy_policy_version Table id BIGINT 19 null
prog_completion_log Table changeuserid BIGINT 19 null

User id of the person who caused the change

gap_aspirational Table usermodified BIGINT 19 null
glossary Table rsstype TINYINT 3 0
report_builder_group Table preproc VARCHAR 255

Name of the pre-processor used by this activity group

certif_completion_history Table timeexpires BIGINT 19 null

Date the certificate expires

tool_monitor_rules Table descriptionformat BIT 0 null

Description format

facetoface_sessions Table sendcapacityemail BIT 0 0

Notification flag for minimum bookings capactiy email.

scorm_scoes Table sortorder BIGINT 19 0

order of scoes

mnet_service Table name VARCHAR 40
grade_categories Table fullname VARCHAR 255

The name of this grade category

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.

facetoface_sessioncancel_info_field Table param2 LONGTEXT 2147483647 null
role_names Table contextid 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.

facetoface_asset Table timemodified BIGINT 19 0
question Table qtype VARCHAR 20
block_zoola_reports_schedule Table userid BIGINT 19 null

User ID

badge_issued Table userid BIGINT 19 0
feedback360_scale_value Table name VARCHAR 255 null
facetoface_signups Table archived BIT 0 0

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

files Table author VARCHAR 255 null

The original author of the file

forum_discussions Table id BIGINT 19 null
lti_types Table course BIGINT 19 null
course_modules Table score SMALLINT 5 0
question_categories Table id BIGINT 19 null
message Table subject LONGTEXT 2147483647 null

The message subject

goal_type Table idnumber VARCHAR 100 null
logstore_standard_log Table contextlevel BIGINT 19 null
prog Table certifid BIGINT 19 null

FK to certification table

comp Table idnumber VARCHAR 100 null
files Table userid BIGINT 19 null

Optional - general userid field - meaning depending on plugin

org_relations Table id2 BIGINT 19 null
user_password_history Table id BIGINT 19 null
workshop_aggregations Table id BIGINT 19 null
enrol_paypal Table tax VARCHAR 255
upgrade_log Table plugin VARCHAR 100 null
cohort_visibility Table timemodified BIGINT 19 null
workshop_submissions_old Table late SMALLINT 5 0
post Table lastmodified BIGINT 19 0
cohort Table alertmembers BIT 0 0

Totara alert members from totara_cohort

wiki_synonyms Table id BIGINT 19 null
lesson_overrides Table timelimit BIGINT 19 null

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

dp_component_settings Table sortorder BIGINT 19 null

Controls the ordering of components, used when displaying component tabs.

forum_posts Table userid BIGINT 19 0
choice Table limitanswers TINYINT 3 0
folder Table id BIGINT 19 null
enrol Table expirythreshold BIGINT 19 0

Custom - when should be the participants notified

choice Table display SMALLINT 5 0
facetoface_sessioncancel_info_data Table facetofacesessioncancelid BIGINT 19 null

WARNING - this points to session id

enrol Table expirynotify BIT 0 0

Custom - notify users before expiration

certif_completion Table timewindowopens BIGINT 19 null

Date the window opens

reportbuilder_grp_pos_record Table includechildren BIT 0 0
competency_templatecomp Table id BIGINT 19 null
assign_overrides Table assignid BIGINT 19 0

Foreign key references assign.id

forum_queue Table postid BIGINT 19 0
user Table timezone VARCHAR 100 99
question_numerical Table id BIGINT 19 null
course_info_field Table param2 LONGTEXT 2147483647 null
feedback_completed Table courseid BIGINT 19 0
dp_plan_evidence_info_data Table id BIGINT 19 null
course_modules Table deletioninprogress BIT 0 0
assignfeedback_file Table assignment BIGINT 19 0
local_ld_import_logs_status Table timefinished BIGINT 19 null

When the import logs tash finished

report_builder_settings Table type VARCHAR 100

Component of report builder that the setting is for

glossary Table name VARCHAR 255
message_providers Table component VARCHAR 200

The name of the component that produces these messages

question Table penalty DECIMAL 12 0.3333333
facetoface Table showoncalendar BIT 0 1
user_preferences Table name VARCHAR 255
book_chapters Table timecreated BIGINT 19 0
mnet_session Table mnethostid BIGINT 19 0

Unique remote host ID

competency_template Table description LONGTEXT 2147483647 null

Description of this learning plan template

facetoface_asset_info_field Table required TINYINT 3 null
totara_sync_log Table logtype VARCHAR 60 null

log type

repository_opensesame_pkgs Table timecreated BIGINT 19 null

Date when package added

report_builder_columns Table sortorder BIGINT 19 null

Determines the order that the columns appear in the report

wiki_locks Table id BIGINT 19 null
qtype_ddimageortext Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

question_statistics Table negcovar TINYINT 3 0
workshopform_rubric_config Table id BIGINT 19 null
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.

cohort_rulesets Table timemodified BIGINT 19 null
data_fields Table dataid BIGINT 19 0
scale Table description LONGTEXT 2147483647 null
mnet_log Table course BIGINT 19 0
appraisal_scale_value Table id BIGINT 19 null
lti_types_config Table typeid BIGINT 19 null

Basic LTI type id

comp_type_info_field Table param3 LONGTEXT 2147483647 null
qtype_ddmarker_drops Table questionid BIGINT 19 0
mnetservice_enrol_courses Table startdate BIGINT 19 null
glossary_entries_categories Table entryid BIGINT 19 0
workshop_assessments Table id BIGINT 19 null
user_private_key Table value VARCHAR 128

private access key value

facetoface_session_roles Table id BIGINT 19 null

id of the table

grade_grades_history Table exported BIGINT 19 0

date of last grade export, 0 if none

role Table sortorder BIGINT 19 0
appraisal_event_message Table id BIGINT 19 null
facetoface_notification_hist Table notificationid BIGINT 19 null

FK of notification

enrol_lti_users Table serviceurl LONGTEXT 2147483647 null
org_type_info_field Table id BIGINT 19 null
enrol_flatfile Table action VARCHAR 30
totara_connect_sso_sessions Table active BIT 0 0

Set to 1 after client fetches user data via get_sso_user

competency_userevidencecomp Table timecreated BIGINT 19 null
grade_categories_history Table id BIGINT 19 null
workshopform_rubric Table sort BIGINT 19 0

Defines the dimension order within the assessment form

goal_scale_values Table name LONGTEXT 2147483647 null
enrol_lti_lti2_tool_proxy Table created BIGINT 19 null
auth_connect_servers Table serversecret VARCHAR 64

Secret this client uses in server requests

org Table description LONGTEXT 2147483647 null
appraisal_event Table event VARCHAR 32

Event name: activation, stage_complete or stage_due

qtype_essay_options Table graderinfoformat SMALLINT 5 0

The text format for graderinfo.

context Table instanceid BIGINT 19 0
stats_user_monthly Table roleid BIGINT 19 0
prog_message Table messagesubject VARCHAR 255
enrol Table customchar3 VARCHAR 1333 null

Custom - general short name

totara_compl_import_cert Table rownumber BIGINT 19 null

Row number in the csv file

glossary_alias Table entryid BIGINT 19 0
question_calculated Table correctanswerlength BIGINT 19 2
tag_instance Table itemid BIGINT 19 null
assignsubmission_onlinetext Table onlineformat SMALLINT 5 0

The format for this online text submission.

stats_user_weekly Table statswrites BIGINT 19 0
lesson_grades Table userid BIGINT 19 0
comp_scale_assignments Table scaleid BIGINT 19 null
competency_usercompcourse Table grade BIGINT 19 null

The course grade assigned for the competency.

user_private_key Table script VARCHAR 128

plugin, module - unique identifier

comp_record_history Table timemodified BIGINT 19 null
scorm Table whatgrade BIGINT 19 0
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.

grading_definitions Table descriptionformat TINYINT 3 null

Format of the description field

auth_connect_sso_sessions Table id BIGINT 19 null
feedback360_scale_value Table id BIGINT 19 null
auth_connect_users Table serveruserid BIGINT 19 null
enrol_lti_lti2_nonce Table consumerid BIGINT 19 null
course_completion_criteria Table criteriatype BIGINT 19 0

Type of criteria

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.

course Table completionnotify BIT 0 0

Notify users when they complete this course

report_builder_group Table assignvalue BIGINT 19 null

Value used by some assign types to store information about assignments

prog_assignment Table completiontime BIGINT 19 0
prog_info_field Table param2 LONGTEXT 2147483647 null
user_info_field Table sortorder BIGINT 19 0

order within the category

forum_discussions Table course BIGINT 19 0
tool_sitepolicy_consent_options Table id BIGINT 19 null
feedback360_scale Table scaletype TINYINT 3 null
feedback_item Table label VARCHAR 255
totara_connect_clients Table clientname VARCHAR 255

Name of the client system

pos_relations Table id BIGINT 19 null
question_gapselect Table questionid BIGINT 19 0
reportbuilder_grp_user_user Table userid BIGINT 19 null
certificate Table printteacher BIGINT 19 0
user_info_field Table name LONGTEXT 2147483647 null

field name

totara_userdata_purge Table usercreated BIGINT 19 null
course Table visibleold BIT 0 1

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

org_type_info_data Table organisationid BIGINT 19 null
feedback360_quest_field Table datatype VARCHAR 255 null
auth_approved_request_snapshots Table firstname VARCHAR 100 null
block_totara_featured_links_tiles Table tilerulesshowing BIT 0 0

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

certificate Table timecreated BIGINT 19 0
grade_settings Table name VARCHAR 255
totara_navigation Table visibility BIT 0 0
reportbuilder_grp_user_record Table timecreated BIGINT 19 0
facetoface_asset Table usermodified BIGINT 19 null

user id who modified the asset

enrol_lti_lti2_user_result Table ltiresultsourcedid VARCHAR 1024
quiz_statistics Table timemodified BIGINT 19 null
enrol Table enrolenddate BIGINT 19 0

Custom - end of enrolment

grade_outcomes_history Table descriptionformat TINYINT 3 0
cohort_plan_history Table usercreated BIGINT 19 null
workshop_grades_old Table elementno BIGINT 19 0
report_builder_settings Table id BIGINT 19 null
mnet_host Table transport TINYINT 3 0
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.

grade_import_values Table itemid BIGINT 19 null

if set, this points to existing grade_items id

lti_types Table enabledcapability LONGTEXT 2147483647 null

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

prog_recurrence Table nextcourseid BIGINT 19 0
scorm_aicc_session Table sessiontime VARCHAR 255 null
user_preferences Table userid BIGINT 19 0
dp_competency_settings Table duedatemode SMALLINT 5 0

Defines how due dates are handled by this component

course_completion_crit_compl Table rpl VARCHAR 255 null

Totara recognition of prior learning from totara_core

dp_objective_settings Table priorityscale BIGINT 19 null
messageinbound_messagelist Table userid BIGINT 19 null
local_ld_import_logs_status Table progress DECIMAL 10 0.00

Percentage of work done (0 - 100)

cohort_rulesets Table rulecollectionid BIGINT 19 null
workshop Table useselfassessment TINYINT 3 0

optional feature: students perform self assessment of their own work

badge Table id BIGINT 19 null
comp_type Table id BIGINT 19 null
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.

repository_instances Table timemodified BIGINT 19 null
report_builder_filters Table id BIGINT 19 null
local_ld_module_day Table daytime BIGINT 19 null

Timestamp of the beginning of the day

org_framework Table sortorder BIGINT 19 null
course_completion_criteria Table id BIGINT 19 null
facetoface_sessions_dates Table timestart BIGINT 19 0
dp_plan_evidence Table readonly BIT 0 0
glossary Table timemodified BIGINT 19 0
grading_definitions Table description LONGTEXT 2147483647 null

More detailed description of the form

choice Table publish TINYINT 3 0
mnet_rpc Table functionname VARCHAR 40
question_response_analysis Table whichtries VARCHAR 255
cohort_visibility Table cohortid BIGINT 19 0
logstore_standard_log Table action VARCHAR 100
course_info_data Table id BIGINT 19 null
survey_questions Table intro VARCHAR 50
reportbuilder_grp_pos_user Table id BIGINT 19 null
enrol_lti_lti2_consumer Table enableuntil BIGINT 19 null
tool_sitepolicy_localised_consent Table consentoption VARCHAR 1333

The option the user selects to consent

user Table country VARCHAR 2
question_calculated_options Table shuffleanswers SMALLINT 5 0

Whether the choices can be randomly shuffled.

goal_user_type Table timemodified BIGINT 19 null
tool_recyclebin_category Table timecreated BIGINT 19 null
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.

enrol_lti_lti2_resource_link Table created BIGINT 19 null
badge_backpack Table backpackuid BIGINT 19 null
glossary Table allowprintview TINYINT 3 1
block_instances Table pagetypepattern VARCHAR 64

The types of page this block appears on. Either an exact page type like mod-quiz-view, or a pattern like mod-quiz-* or course-view-*. Note that course-view-* will match course-view.

totara_connect_clients Table clienttype VARCHAR 30

LMS or Social

totara_dashboard Table locked BIT 0 0
auth_connect_user_collections Table collectiontype VARCHAR 30

cohort, course

stats_daily Table stat1 BIGINT 19 0

stat1. usually used for reads

mnet_service Table offer BIT 0 0

Do we even offer this service?

assign_submission Table status VARCHAR 10 null

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

pos_type_info_field Table hidden TINYINT 3 null
report_builder_schedule Table nextreport BIGINT 19 null
appraisal_user_event Table eventid BIGINT 19 null
totara_connect_client_pos_frameworks Table clientid BIGINT 19 null
feedback360_scale_data Table feedback360questfieldid BIGINT 19 null
scorm_seq_rulecond Table scoid BIGINT 19 0
pos_type_info_field Table defaultdata LONGTEXT 2147483647 null
facetoface_signups_status Table signupid BIGINT 19 null
repository_instances Table contextid BIGINT 19 null
course_format_options Table name VARCHAR 100

Name of the format option

question_calculated Table answer BIGINT 19 0
grade_items Table needsupdate BIGINT 19 0

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

enrol_lti_tools Table membersyncmode BIT 0 0
stats_user_daily Table id BIGINT 19 null
mnet_application Table name VARCHAR 50
totara_userdata_export Table origin VARCHAR 50

self keyword matching totara_userdata_purge_type allowxxxx columns, use other keyword for custom code

events_queue Table stackdump LONGTEXT 2147483647 null

serialized debug_backtrace showing where the event was fired from

assignment_submissions Table data1 LONGTEXT 2147483647 null
qtype_randomsamatch_options Table correctfeedback LONGTEXT 2147483647 null

Feedback shown for any correct response.

backup_controllers Table status SMALLINT 5 null

current status of the backup (configured, ui, running...)

workshop_old Table overallocation SMALLINT 5 0
totara_connect_sso_sessions Table id BIGINT 19 null
assign_overrides Table groupid BIGINT 19 null

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

forum_queue Table id BIGINT 19 null
workshop_old Table gradinggrade SMALLINT 5 0
question_response_analysis Table timemodified BIGINT 19 null
report_builder_preproc_track Table lastchecked BIGINT 19 null

Timestamp of when the item was last checked

workshop_submissions Table published TINYINT 3 0

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

glossary Table entbypage SMALLINT 5 10
assignment Table var4 BIGINT 19 0
appraisal_stage Table description LONGTEXT 2147483647 null
glossary_formats Table sortorder VARCHAR 50
grade_items_history Table outcomeid BIGINT 19 null

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

reminder_message Table reminderid BIGINT 19 null
competency_evidence Table id BIGINT 19 null
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.

report_builder_schedule Table userid BIGINT 19 null
prog_completion_log Table id BIGINT 19 null
lesson Table mediaclose SMALLINT 5 0
glossary_alias Table alias VARCHAR 255
appraisal_event_rcpt Table appraisalrole SMALLINT 5 null
course_completion_log Table timemodified BIGINT 19 null
comp_criteria Table timemodified BIGINT 19 null
goal_type_info_field Table required TINYINT 3 null
org_type Table id BIGINT 19 null
role_capabilities Table timemodified BIGINT 19 0
lti_types Table secureicon LONGTEXT 2147483647 null

Secure URL to icon file

grade_grades Table exported BIGINT 19 0

date of last grade export, 0 if none

grade_items Table aggregationcoef DECIMAL 10 0.00000

Aggregation coefficient used for category weights or other aggregation types

question_answers Table answerformat TINYINT 3 0
stats_monthly Table id BIGINT 19 null
facetoface_room_info_data Table id BIGINT 19 null
gradingform_rubric_levels Table id BIGINT 19 null
post Table subject VARCHAR 128
goal_scale_assignments Table frameworkid BIGINT 19 null
assignfeedback_editpdf_quick Table rawtext LONGTEXT 2147483647 null
auth_connect_sso_sessions Table serveruserid BIGINT 19 null
appraisal_event_message Table appraisaleventid BIGINT 19 null
lti Table grade BIGINT 19 100

Grade scale

block_rss_client Table url VARCHAR 255
grade_items_history Table id BIGINT 19 null
workshop_old Table grade SMALLINT 5 0
post Table attachment VARCHAR 100 null

attachment

reportbuilder_grp_pos_user Table reportbuilderuserid BIGINT 19 null
assignsubmission_onlinetext Table assignment BIGINT 19 0
workshop_assessments_old Table newid BIGINT 19 null
appraisal_user_assignment Table id BIGINT 19 null
totara_userdata_export_type_item Table name VARCHAR 100

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

goal_item_history Table timemodified BIGINT 19 null
org_type_info_field Table description LONGTEXT 2147483647 null
course_categories Table programcount BIGINT 19 0

Totara program count from totara_program

user Table descriptionformat TINYINT 3 1
goal_user_type Table usermodified BIGINT 19 null
totara_sync_log Table id BIGINT 19 null
log_queries Table info LONGTEXT 2147483647 null

detailed info such as error text

pos_competencies Table timecreated BIGINT 19 null
badge_criteria Table criteriatype BIGINT 19 null

The criteria type we are aggregating

assignment_submissions Table numfiles BIGINT 19 0
survey_answers Table answer2 LONGTEXT 2147483647 null
gradingform_rubric_fillings Table criterionid BIGINT 19 null

The ID of the criterion (row) in the rubric

tag_coll Table id BIGINT 19 null
pos_type_info_data Table fieldid BIGINT 19 null
appraisal_role_assignment Table timecreated BIGINT 19 0
totara_userdata_purge_type_item Table component VARCHAR 100

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

grade_items_history Table multfactor DECIMAL 10 1.00000

Multiply all grades by this

enrol_paypal Table memo VARCHAR 255
grade_items_history Table itemname VARCHAR 255 null

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

competency_plan Table userid BIGINT 19 null
grade_categories_history Table aggregation BIGINT 19 0

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

certificate Table customtext LONGTEXT 2147483647 null
report_builder Table embedded SMALLINT 5 0

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

repository Table sortorder BIGINT 19 0
totara_compl_import_course Table completiondateparsed BIGINT 19 null

completiondate parsed using csvdateformat

prog_courseset Table label VARCHAR 255
feedback360_scale_data Table feedback360scalevalueid BIGINT 19 null
block_zoola_reports_cohort Table cohortid BIGINT 19 null

Cohort ID

feedback Table timemodified BIGINT 19 0
facetoface_notification Table id BIGINT 19 null
grade_grades Table informationformat BIGINT 19 0

format of information text

qtype_ddmarker_drops Table shape VARCHAR 255 null

circle, rectangle, polygon

assign_user_flags Table workflowstate VARCHAR 20 null

The current workflow state of the grade

pos_competencies Table positionid BIGINT 19 null
enrol_lti_lti2_resource_link Table consumerid BIGINT 19 null
prog Table exceptionssent BIT 0 0
enrol_lti_tools Table gradesync BIT 0 0
qtype_ddimageortext_drops Table id BIGINT 19 null
user Table username VARCHAR 100
user_info_field Table categoryid BIGINT 19 0

id from category table

certificate Table reportcert BIT 0 0
tool_recyclebin_course Table section BIGINT 19 null
totara_compl_import_course Table timeupdated BIGINT 19 0

Time the record was added to the system

forum Table lockdiscussionafter BIGINT 19 0
prog Table idnumber VARCHAR 100
grade_items Table timemodified BIGINT 19 null

The last time this grade_item was modified

facetoface_room_info_field Table description LONGTEXT 2147483647 null
question_calculated Table tolerancetype BIGINT 19 1
competency_usercomp Table timecreated BIGINT 19 null
book Table navstyle SMALLINT 5 1
lesson_attempts Table retry SMALLINT 5 0
report_builder_global_restriction Table description LONGTEXT 2147483647 null

Description of the global report restriction

local_ld_course Table courseid BIGINT 19 null

Foreign key to the course

workshop_submissions Table gradeover DECIMAL 10 null

Grade for the submission manually overridden by a teacher. Grade is always from interval 0..100. If NULL then the grade is not overriden.

registration_hubs Table id BIGINT 19 null
assignment Table introformat SMALLINT 5 0
reportbuilder_grp_cohort_user Table timecreated BIGINT 19 0
facetoface_sessions Table waitlisteveryone BIT 0 0

Will everyone be added to the waiting list

forum_track_prefs Table userid BIGINT 19 0
user Table maildigest BIT 0 0
enrol_paypal Table item_name VARCHAR 255
assign_overrides Table userid BIGINT 19 null

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

quiz_attempts Table timefinish BIGINT 19 0

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

scorm Table revision BIGINT 19 0

revison number

goal_user_type_cohort Table usermodified BIGINT 19 null
lesson_branch Table id BIGINT 19 null
competency_usercomp Table reviewerid BIGINT 19 null

User that reviewed the competency.

grade_outcomes_history Table timemodified BIGINT 19 null

The last time this grade_item was modified

mnet_log Table coursename VARCHAR 40
workshop Table evaluation VARCHAR 30

The recently used grading evaluation method

feedback360_grp_org Table feedback360id BIGINT 19 null
facetoface_room_info_field Table param2 LONGTEXT 2147483647 null
badge Table expireperiod BIGINT 19 null
feedback_completedtmp Table courseid BIGINT 19 0
auth_approved_request_snapshots Table organisationfreetext LONGTEXT 2147483647 null
feedback360_grp_pos Table id BIGINT 19 null
appraisal Table timefinished BIGINT 19 null

timestamp

mnet_host Table last_connect_time BIGINT 19 0
message_contacts Table contactid BIGINT 19 0
workshop Table conclusionformat SMALLINT 5 1

The format of the conclusion field content.

user_info_data Table fieldid BIGINT 19 0

id from the field table

course Table theme VARCHAR 50
assignfeedback_editpdf_cmnt Table gradeid BIGINT 19 0
auth_approved_request Table username VARCHAR 100

Requested username - also used for duplicate lookups when signing up

competency_framework Table scaleconfiguration LONGTEXT 2147483647 null

Scale information.

certificate Table certificatetype VARCHAR 50
scorm Table completionscorerequired TINYINT 3 null
pos_framework Table idnumber VARCHAR 100 null
user_password_resets Table token VARCHAR 32

secret set and emailed to user

filter_active Table id BIGINT 19 null
data Table name VARCHAR 255
cohort_members Table timeadded BIGINT 19 0
certif_completion_history Table unassigned BIT 0 0

Unassigned from certification

my_pages Table sortorder MEDIUMINT 7 0

The order of the pages for a user

goal_type_info_data Table data LONGTEXT 2147483647 null
external_functions Table classname VARCHAR 100
appraisal_quest_field Table descriptionformat BIT 0 null
totara_navigation Table url VARCHAR 255 null
profiling Table runid VARCHAR 32

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

tool_customlang Table master LONGTEXT 2147483647 null

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

dp_plan_evidence Table id BIGINT 19 null
enrol_lti_users Table id BIGINT 19 null
backup_logs Table message LONGTEXT 2147483647 null

text logged

question_multianswer Table id BIGINT 19 null
enrol_lti_lti2_tool_proxy Table updated BIGINT 19 null
lesson_branch Table userid BIGINT 19 0
glossary Table displayformat VARCHAR 50 dictionary
page Table intro LONGTEXT 2147483647 null
certif Table activeperiod VARCHAR 20 null

How long is the certificate active for - stored as seconds

dp_plan_competency_assign Table manual BIT 0 0

Was this assignment made manually

enrol_flatfile Table timeend BIGINT 19 0
dp_priority_scale Table name VARCHAR 255 null

Defines the name of the priority scale

book_chapters Table subchapter BIGINT 19 0
message_read Table fullmessage LONGTEXT 2147483647 null
lti_submission Table ltiid BIGINT 19 null

ID of the LTI tool instance

facetoface_signups_status Table timecreated BIGINT 19 null
question Table stamp VARCHAR 255
auth_approved_request_snapshots Table status TINYINT 3 null
org Table shortname VARCHAR 100 null
assign_plugin_config Table assignment BIGINT 19 0
lesson_answers Table timemodified BIGINT 19 0
facetoface_cancellation_info_data Table facetofacecancellationid BIGINT 19 null

WARNING - this points to signup id

badge_manual_award Table recipientid BIGINT 19 null
scorm Table navpositiontop BIGINT 19 -100
question_statistics Table slot BIGINT 19 null

The position in the quiz where this question appears

totara_userdata_export_type_item Table id BIGINT 19 null
comp_scale_values Table idnumber VARCHAR 100 null
grade_items_history Table hidden BIGINT 19 0

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

grade_items Table aggregationcoef2 DECIMAL 10 0.00000

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

pos Table timevalidto BIGINT 19 null
course_sections Table summary LONGTEXT 2147483647 null
block_totara_featured_links_tiles Table audienceaggregation SMALLINT 5 0

The aggregation of the audience rules ie AND or OR

enrol_lti_lti2_consumer Table consumerversion VARCHAR 255 null
pos_type Table timemodified BIGINT 19 null
tag_area Table callback VARCHAR 100 null
competency_userevidence Table descriptionformat BIT 0 null
tag_instance Table itemtype VARCHAR 100
grade_categories_history Table aggregateonlygraded BIT 0 0

aggregate only graded items

block_rss_client Table description LONGTEXT 2147483647 null
grade_import_newitem Table importcode BIGINT 19 null

import batch code for identification

certificate_issues_history Table certificateid BIGINT 19 0
enrol Table password VARCHAR 50 null

Custom - enrolment or access password

block_recent_activity Table action BIT 0 null

0 created, 1 updated, 2 deleted

forum_track_prefs Table forumid BIGINT 19 0
dp_plan_program_assign Table reasonfordecision LONGTEXT 2147483647 null

The reason for approving/declining the request

badge_criteria_met Table id BIGINT 19 null
comp_framework Table shortname VARCHAR 100 null
forum_discussions Table groupid BIGINT 19 -1
choice Table allowmultiple TINYINT 3 0
lesson Table completiontimespent BIGINT 19 0
assignfeedback_editpdf_queue Table submissionattempt BIGINT 19 null
gradingform_rubric_criteria Table sortorder BIGINT 19 null

Defines the order of the criterion in the rubric

enrol_paypal Table instanceid BIGINT 19 0
certificate Table printwmark VARCHAR 255 0
facetoface_room Table timemodified BIGINT 19 0
tag_area Table callbackfile VARCHAR 100 null
totara_userdata_user Table timesuspendedpurged BIGINT 19 null

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

quiz Table questiondecimalpoints SMALLINT 5 -1

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

workshopform_numerrors Table id BIGINT 19 null
task_adhoc Table blocking TINYINT 3 0
totara_connect_client_cohorts Table cohortid BIGINT 19 null
lti Table instructorchoicesendname BIT 0 null

Send user's name

feedback_item Table id BIGINT 19 null
post Table module VARCHAR 20
capabilities Table captype VARCHAR 50
tool_sitepolicy_user_consent Table userid BIGINT 19 null

The user whose answered this is

tag Table timemodified BIGINT 19 null
tool_monitor_events Table link VARCHAR 254

Link to the event location

auth_approved_request Table organisationid BIGINT 19 null

Organisation id

tool_sitepolicy_policy_version Table timepublished BIGINT 19 null

Timestamp of when the policy was published

resource Table display SMALLINT 5 0
tool_monitor_events Table id BIGINT 19 null
facetoface_notification Table conditiontype BIGINT 19 null
cohort Table draftcollectionid BIGINT 19 null

Totara draft collection id from totara_cohort

data Table rsstitletemplate LONGTEXT 2147483647 null
blog_association Table contextid BIGINT 19 null
scorm Table course BIGINT 19 0
quiz_statistics Table id BIGINT 19 null
reminder_message Table id BIGINT 19 null
user Table policyagreed BIT 0 0
glossary_entries Table sourceglossaryid BIGINT 19 0
tool_monitor_rules Table template LONGTEXT 2147483647 null

Message template

totara_userdata_user Table timedeleted BIGINT 19 null

Best guess when user was actually suspended

quiz_overview_regrades Table newfraction DECIMAL 12 null

The new fraction for this question_attempt after regrading.

quiz Table completionpass BIT 0 0
goal_personal Table scalevalueid BIGINT 19 null
totara_userdata_purge_item Table id BIGINT 19 null
auth_connect_user_collections Table timecreated BIGINT 19 null
lesson_answers Table flags SMALLINT 5 0
totara_navigation Table timemodified BIGINT 19 0
assignment_submissions Table data2 LONGTEXT 2147483647 null
message_metadata Table icon VARCHAR 255 null
license Table shortname VARCHAR 255 null
certif Table timemodified BIGINT 19 0
gap_aspirational Table positionid BIGINT 19 null
pos_competencies Table usermodified BIGINT 19 null
grade_categories_history Table path VARCHAR 255 null

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

stats_weekly Table stat1 BIGINT 19 0

stat1. usually used for reads

facetoface_signups Table jobassignmentid BIGINT 19 null

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

filter_active Table contextid BIGINT 19 null

References context.id.

dp_plan Table userid BIGINT 19 null

ID of the user this plan is for

goal_scale Table usermodified BIGINT 19 null
reminder_message Table period BIGINT 19 null
mnet_host Table force_theme BIT 0 0
qtype_essay_options Table id BIGINT 19 null
wiki_subwikis Table groupid BIGINT 19 0

Group that owns this wiki

assignfeedback_editpdf_cmnt Table colour VARCHAR 10 black

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

question_calculated_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

competency Table id BIGINT 19 null
block_totara_featured_links_tiles Table audienceshowing BIT 0 0

This field holds whether the audience rules are to be applied

appraisal_review_data Table content LONGTEXT 2147483647 null
grading_definitions Table method VARCHAR 100

The name of the plugin providing this grading form

assignment Table var2 BIGINT 19 0
lesson_branch Table timeseen BIGINT 19 0
events_queue_handlers Table timemodified BIGINT 19 null

time stamp of the last attempt to run this from the queue

imscp Table revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

enrol_lti_lti2_nonce Table id BIGINT 19 null
pos_framework Table fullname VARCHAR 1024 null
external_services_functions Table externalserviceid BIGINT 19 null
totara_compl_import_cert Table completiondate VARCHAR 10 null

completiondate

prog_user_assignment Table timeassigned BIGINT 19 0
question_datasets Table datasetdefinition BIGINT 19 0
auth_connect_users Table id BIGINT 19 null
enrol_lti_users Table consumerkey LONGTEXT 2147483647 null
portfolio_log Table returnurl VARCHAR 255

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

org Table visible TINYINT 3 null
message_metadata Table urgency SMALLINT 5 null

The message urgency

appraisal_history Table appraisalid BIGINT 19 null
facetoface_sessioncancel_info_field Table datatype VARCHAR 255 null
badge_external Table collectionid BIGINT 19 null

Badge collection id in the backpack

dp_plan_objective Table approved SMALLINT 5 0
totara_compl_import_course Table rownumber BIGINT 19 null

Row number in the csv file

backup_trusted_files Table filesize BIGINT 19 null
goal_user_info_field Table param5 LONGTEXT 2147483647 null
choice Table name VARCHAR 255
tool_sitepolicy_localised_policy Table policytextformat TINYINT 3 1

The format of the policytext field

facetoface_sessions Table selfapproval BIT 0 0

Allow self approval

block_totara_stats Table userid BIGINT 19 null
cohort Table broken BIT 0 0

Totara broken flag from totara_cohort

backup_trusted_files Table id BIGINT 19 null
license Table version BIGINT 19 0
goal_personal Table timecreated BIGINT 19 null
data Table notification BIGINT 19 0

Notify people when things change

badge_backpack Table autosync BIT 0 0
assign_grades Table timemodified BIGINT 19 0

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

quiz Table reviewoverallfeedback MEDIUMINT 7 0

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

imscp Table keepold BIGINT 19 -1

incremented when after each file changes, solves browser caching issues

block_recent_activity Table modname VARCHAR 20 null

module type name (for delete action)

goal Table frameworkid BIGINT 19 null
report_builder Table accessmode SMALLINT 5 0

Controls how access to the report is determined

grade_grades_history Table informationformat BIGINT 19 0

format of information text

feedback360_grp_cohort Table id BIGINT 19 null
data_fields Table param5 LONGTEXT 2147483647 null
feedback360_quest_field Table param4 LONGTEXT 2147483647 null
external_tokens Table lastaccess BIGINT 19 null

last access timestamp

appraisal_user_assignment Table jobassignmentlastmodified BIGINT 19 null
groupings Table configdata LONGTEXT 2147483647 null

extra configuration data - may be used by group IU tools

org Table timecreated BIGINT 19 null
totara_connect_client_cohorts Table timecreated BIGINT 19 null
lti Table timecreated BIGINT 19 0
quiz Table canredoquestions SMALLINT 5 0

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

files Table timecreated BIGINT 19 null
totara_navigation Table visibilityold BIT 0 null

Stores the last visibility state

pos_type Table usermodified BIGINT 19 null
qtype_match_subquestions Table questiontextformat TINYINT 3 0
goal Table proficiencyexpected BIGINT 19 null
appraisal_user_assignment Table appraisalid BIGINT 19 null
block_community Table coursename VARCHAR 255
facetoface_cancellation_info_field Table shortname VARCHAR 100 null
workshop_old Table submissionend BIGINT 19 0
workshop Table overallfeedbackfiletypes VARCHAR 255 null

comma separated liat of file extensions

goal_scale_values Table description LONGTEXT 2147483647 null
grade_items Table gradepass DECIMAL 10 0.00000

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

appraisal_stage_role_setting Table id BIGINT 19 null
comp_scale Table defaultid BIGINT 19 null
totara_compl_import_course Table importevidence BIT 0 0

imported into evidence

tool_recyclebin_course Table name VARCHAR 255 null
stats_user_weekly Table id BIGINT 19 null
forum_posts Table id BIGINT 19 null
enrol Table currency VARCHAR 3 null

Custom - cost currency

user_private_key Table validuntil BIGINT 19 null

timestampt - valid until data

gradingform_guide_comments Table definitionid BIGINT 19 null

The ID of the form definition this faq is part of

files Table timemodified BIGINT 19 null
competency Table ruletype VARCHAR 100 null
lti Table name VARCHAR 255

name field for moodle instances

workshop_old Table nsassessments SMALLINT 5 0
competency_evidence Table usercompetencyid BIGINT 19 null
messageinbound_handlers Table defaultexpiration BIGINT 19 86400

The default expiration period to use when creating a new key

report_builder_graph Table series LONGTEXT 2147483647 null

Series info encoded in json format

mnet_host Table public_key_expires BIGINT 19 0
course_published Table huburl VARCHAR 255 null

the url of the "registered on" hub

facetoface_room Table hidden BIT 0 0

Do not show this room in add/search room dialogs

pos Table shortname VARCHAR 100 null
course Table defaultgroupingid BIGINT 19 0

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

question_attempts Table maxmark DECIMAL 12 null

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

data Table defaultsort BIGINT 19 0
scorm_scoes_data Table id BIGINT 19 null
dp_plan_objective Table reasonfordecision LONGTEXT 2147483647 null

The reason for approving/declining the request

block_instances Table configdata LONGTEXT 2147483647 null

A serialized blob of configuration data for this block instance.

forum_discussions Table forum BIGINT 19 0
data_records Table groupid BIGINT 19 0
comp_template_assignment Table timecreated BIGINT 19 null
page Table contentformat SMALLINT 5 0
wiki Table timemodified BIGINT 19 0
cohort_rules Table sortorder BIGINT 19 null
dp_plan_component_relation Table mandatory VARCHAR 255 null

Is this a manadatory relation

grade_import_newitem Table id BIGINT 19 null
user_enrolments Table id BIGINT 19 null
url Table externalurl LONGTEXT 2147483647 null
grade_items Table calculation LONGTEXT 2147483647 null

Formula describing how to derive this grade from other items, referring to them using giXXX where XXX is grade item id ... eg something like: =sin(square(#gi20#)) + #gi30#

question_response_analysis Table credit DECIMAL 15 null
prog_user_assignment Table userid BIGINT 19 0
facetoface_cancellation_info_field Table description LONGTEXT 2147483647 null
enrol_lti_users Table toolid BIGINT 19 null
local_ld_module_day Table id BIGINT 19 null
grading_definitions Table timecopied BIGINT 19 0

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

tool_monitor_history Table id BIGINT 19 null
choice_options Table maxanswers BIGINT 19 0
enrol Table customint2 BIGINT 19 null

Custom - general int

appraisal_quest_field Table id BIGINT 19 null
reportbuilder_grp_cohort_record Table timecreated BIGINT 19 0
tool_sitepolicy_user_consent Table timeconsented BIGINT 19 null

Timestamp of when the user answered

user_info_field Table id BIGINT 19 null
user Table lastname VARCHAR 100
appraisal_scale_data Table appraisalroleassignmentid BIGINT 19 null
scorm_scoes_track Table timemodified BIGINT 19 0
course_completions Table positionid BIGINT 19 null

Totara position id from totara_hierarchy

mnet_rpc Table plugintype VARCHAR 20
portfolio_instance_user Table instance BIGINT 19 null

fk to instance table

tag_instance Table contextid BIGINT 19 null

The context id of the item that was tagged

quiz_attempts Table id BIGINT 19 null

Standard Moodle primary key.

facetoface_signups_status Table id BIGINT 19 null
role_assignments Table component VARCHAR 100

plugin responsible responsible for role assignment, empty when manually assigned

workshopform_numerrors_map Table workshopid BIGINT 19 null

The id of the workshop

feedback360_resp_assignment Table timeassigned BIGINT 19 null
stats_user_monthly Table courseid BIGINT 19 0
lti_types_config Table name VARCHAR 100

Basic LTI param

course_sections Table course BIGINT 19 0
event Table instance BIGINT 19 0
facetoface_signup_info_field Table hidden TINYINT 3 null
quiz Table preferredbehaviour VARCHAR 32

The behaviour to ask questions to use.

cohort_rules Table timecreated BIGINT 19 null
facetoface_room Table description LONGTEXT 2147483647 null
competency_usercompcourse Table competencyid BIGINT 19 null

Competency associated to the user.

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.

qtype_ddimageortext Table correctfeedbackformat TINYINT 3 0
survey_questions Table multi VARCHAR 100
question_numerical_units Table multiplier DECIMAL 40 1.00000000000000000000

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

tool_usertours_steps Table targettype TINYINT 3 null

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

external_services_users Table externalserviceid BIGINT 19 null
workshop Table usepeerassessment TINYINT 3 0

optional feature: students perform peer assessment of others' work

certificate_issues Table userid BIGINT 19 0
feedback_completed Table id BIGINT 19 null
grade_items Table iteminstance BIGINT 19 null

id of the item module

workshop_submissions_old Table newid BIGINT 19 null
mnet_service2rpc Table rpcid BIGINT 19 0

Unique Function ID

message_read Table timeusertodeleted BIGINT 19 0
resource_old Table migrated BIGINT 19 0
forum_discussion_subs Table forum BIGINT 19 null
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.

feedback_value Table value LONGTEXT 2147483647 null
course_modules Table added BIGINT 19 0
user_enrolments Table modifierid BIGINT 19 0
facetoface_sessions Table usermodified BIGINT 19 null
course_completion_crit_compl Table timecompleted BIGINT 19 null
enrol_totara_f2f_pending Table timecreated BIGINT 19 0
feedback_value Table id BIGINT 19 null
groupings Table description LONGTEXT 2147483647 null
workshop_elements_old Table id BIGINT 19 null
certificate Table printsignature VARCHAR 255 0
appraisal_user_assignment Table status BIGINT 19 0
totara_compl_import_course Table importerror BIT 0 0

true/false if there were any errors

cohort_msg_queue Table timecreated BIGINT 19 null
capabilities Table name VARCHAR 255
prog_info_data Table id BIGINT 19 null
survey_questions Table options LONGTEXT 2147483647 null
goal_scale Table defaultid BIGINT 19 null
filter_active Table active SMALLINT 5 null

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

report_builder Table globalrestriction BIT 0 0

Enable global restrictions for this report

local_ld_course_day Table ldcourseid BIGINT 19 null

Foreign key to the local_ld_course table

org_relations Table description LONGTEXT 2147483647 null
facetoface_asset Table allowconflicts BIT 0 0
repository_opensesame_pkgs Table expirationdate VARCHAR 20

Date the license is valid until as text

wiki_links Table topageid BIGINT 19 0

Page id that recives a link

block_totara_featured_links_tiles Table blockid BIGINT 19 null

This is the block id that the tile belongs to

block_rss_client Table userid BIGINT 19 0
message_read Table timeuserfromdeleted BIGINT 19 0
book_chapters Table title VARCHAR 255
assignsubmission_onlinetext Table submission BIGINT 19 0
workshop_grades Table dimensionid BIGINT 19 null

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

gradingform_rubric_criteria Table descriptionformat TINYINT 3 null

The format of the description field

forum_posts Table mailnow BIGINT 19 0
enrol_lti_tools Table roleinstructor BIGINT 19 null
certif_completion_history Table id BIGINT 19 null
assignfeedback_editpdf_queue Table submissionid BIGINT 19 null
prog Table assignmentsdeferred BIT 0 0

Indicates that user assignments need to be updated

event Table visible SMALLINT 5 1
quiz_slots Table questionid BIGINT 19 0

Foreign key references question.id.

certif_completion Table certifpath TINYINT 3 null

CERT/RECET

quiz_attempts Table timemodifiedoffline BIGINT 19 0

Last modified time via web services.

competency_templatecohort Table timemodified BIGINT 19 null
goal_record Table id BIGINT 19 null
tool_monitor_rules Table description LONGTEXT 2147483647 null

Description of the rule

goal Table timecreated BIGINT 19 null
message_providers Table name VARCHAR 100

The full name of the message provider in standard form

competency_usercompcourse Table proficiency TINYINT 3 null

Indicate if the competency is proficient not.

quiz Table intro LONGTEXT 2147483647 null

Quiz introduction text.

reportbuilder_grp_pos_record Table posid BIGINT 19 null
qtype_ddimageortext_drops Table ytop BIGINT 19 0
totara_navigation_settings Table type VARCHAR 255
resource_old Table newid BIGINT 19 null
competency_plancomp Table timemodified BIGINT 19 null
enrol_lti_lti2_tool_proxy Table id BIGINT 19 null
events_handlers Table status BIGINT 19 0

number of failed attempts to process this handler

editor_atto_autosave Table id BIGINT 19 null
question_dataset_definitions Table options VARCHAR 255
enrol_lti_lti2_context Table id BIGINT 19 null
grade_grades Table aggregationstatus VARCHAR 10 unknown

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

tag_area Table tagcollid BIGINT 19 null
enrol_paypal Table timeupdated BIGINT 19 0
lesson Table deadline BIGINT 19 0
totara_connect_client_cohorts Table clientid BIGINT 19 null
feedback360_scale_data Table feedback360respassignmentid BIGINT 19 null
enrol Table roleid BIGINT 19 0

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

job_assignment Table usermodified BIGINT 19 null

The ID of the user who last modified this job assignment

workshop Table conclusion LONGTEXT 2147483647 null

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

question_calculated_options Table partiallycorrectfeedbackformat TINYINT 3 0
competency_plan Table status BIT 0 null
competency_plan Table name VARCHAR 100
tool_recyclebin_course Table timecreated BIGINT 19 0
certificate_issues_history Table timecompleted BIGINT 19 null

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

facetoface_signup_info_field Table param5 LONGTEXT 2147483647 null
wiki_versions Table userid BIGINT 19 0

Edition autor

qtype_ddimageortext_drags Table infinite SMALLINT 5 0
lti_types_config Table id BIGINT 19 null
pos_framework Table hidecustomfields TINYINT 3 null
totara_userdata_export_type Table timecreated BIGINT 19 null

When was this type added

reportbuilder_grp_pos_record Table reportbuilderrecordid BIGINT 19 null
facetoface_session_info_field Table defaultdata LONGTEXT 2147483647 null
role_allow_switch Table roleid BIGINT 19 null

The role the user has.

certificate_issues Table certificateid BIGINT 19 0
totara_sync_log Table action VARCHAR 60 null

action performed

workshop_old Table usepassword SMALLINT 5 0
scorm_scoes Table identifier VARCHAR 255
question_ddwtos Table incorrectfeedbackformat TINYINT 3 0
tool_usertours_steps Table targetvalue LONGTEXT 2147483647 null

The value for the specified target type.

comp_record Table reaggregate BIGINT 19 0
facetoface_signup_info_data_param Table value VARCHAR 32
cohort_msg_queue Table timemodified BIGINT 19 null
comp_relations Table id1 BIGINT 19 null
dp_plan_evidence Table timecreated BIGINT 19 null

Timestamp indicating when this evidence item was created

prog_info_field Table param1 LONGTEXT 2147483647 null
quiz_statistics Table cic DECIMAL 15 null
goal_record Table goalid BIGINT 19 null
scorm_aicc_session Table id BIGINT 19 null
files Table source LONGTEXT 2147483647 null

contains the reference if the file is imported from external sites

user_private_key Table timecreated BIGINT 19 null

created timestamp

facetoface_signup_info_field Table id BIGINT 19 null
block_recent_activity Table courseid BIGINT 19 null

Course id

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

The secret key for this data item.

log_queries Table error MEDIUMINT 7 0

is error

assign_grades Table attemptnumber BIGINT 19 0

The attempt number that this grade relates to

grade_items_history Table action BIGINT 19 0

created/modified/deleted constants

feedback_completed Table userid BIGINT 19 0
data Table timeviewto BIGINT 19 0
registration_hubs Table hubname VARCHAR 255
role_allow_override Table id BIGINT 19 null
grade_import_values Table finalgrade DECIMAL 10 null

raw grade value

external_services_functions Table functionname VARCHAR 200
resource Table introformat SMALLINT 5 0
tag_coll Table component VARCHAR 100 null
gradingform_guide_fillings Table id BIGINT 19 null
course_completion_history Table courseid BIGINT 19 null
mnetservice_enrol_enrolments Table enroltime BIGINT 19 0
feedback_template Table course BIGINT 19 0
question Table questiontext LONGTEXT 2147483647 null
question_attempts Table id BIGINT 19 null
assign Table cutoffdate BIGINT 19 0

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

upgrade_log Table info VARCHAR 255
sessions Table firstip VARCHAR 45 null
grade_grades_history Table excluded BIGINT 19 0

grade excluded from aggregation functions, date means when excluded

gradingform_guide_criteria Table definitionid BIGINT 19 null

The ID of the form definition this criterion is part of

workshop_elements_old Table workshopid 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.

user Table lastlogin BIGINT 19 0
facetoface_asset_dates Table id BIGINT 19 null
groupings Table id BIGINT 19 null
report_builder_columns Table id BIGINT 19 null
wiki_synonyms Table pagesynonym VARCHAR 255 Pagesynonym

Page name synonym

resource_old Table id BIGINT 19 null
wiki_pages Table cachedcontent LONGTEXT 2147483647 null

Cache wiki content

quiz_sections Table quizid BIGINT 19 null

Foreign key references quiz.id.

feedback_completed_history Table userid BIGINT 19 0
assignfeedback_editpdf_cmnt Table id BIGINT 19 null
event Table id BIGINT 19 null
event_subscriptions Table courseid BIGINT 19 0
wiki_locks Table lockedat BIGINT 19 0

timestamp

my_pages Table private BIT 0 1

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

qtype_ddimageortext_drags Table questionid BIGINT 19 0
certificate Table printhours VARCHAR 255 null
certif_completion Table renewalstatus TINYINT 3 0
blog_external Table failedlastsync BIT 0 0

Whether or not the last sync failed for some reason

grade_grades_history Table itemid BIGINT 19 null

The item this grade belongs to

assign_user_flags Table allocatedmarker BIGINT 19 0

The allocated marker to this submission

scorm_seq_objective Table satisfiedbymeasure BIT 0 1
badge_backpack Table password VARCHAR 50 null
feedback360_scale Table userid BIGINT 19 null
prog_completion_history Table timestarted BIGINT 19 0
appraisal_stage_data Table appraisalstageid BIGINT 19 null
repository_opensesame_pkgs Table externalid VARCHAR 255

OpenSesame course identifier - unique id

comp_type_info_field Table param2 LONGTEXT 2147483647 null
backup_controllers Table purpose SMALLINT 5 null

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

question_dataset_definitions Table itemcount BIGINT 19 0
groupings Table name VARCHAR 255

Short human readable unique name for group.

user_enrolments Table timeend BIGINT 19 2147483647
scorm_seq_ruleconds Table id BIGINT 19 null
workshop_submissions_old Table nassessments BIGINT 19 0
profiling Table totalmemory BIGINT 19 null

Total memory used byt the run

appraisal_grp_cohort Table cohortid BIGINT 19 null
grading_definitions Table usermodified BIGINT 19 null

The ID of the user who did the most recent modification

facetoface_room Table timecreated BIGINT 19 0
auth_approved_request_snapshots Table requestid BIGINT 19 null
block_totara_stats Table eventtype BIGINT 19 null
glossary_entries Table teacherentry TINYINT 3 0
goal_framework Table sortorder BIGINT 19 null
report_builder_schedule Table lastmodified BIGINT 19 0

Timestamp when the scheduled report settings was last modified

backup_courses Table id BIGINT 19 null
org_type_info_data_param Table id BIGINT 19 null
enrol_lti_tool_consumer_map Table consumerid BIGINT 19 null

The consumer ID.

dp_objective_settings Table objectivescale BIGINT 19 null
goal_user_info_field Table typeid BIGINT 19 null
scale_history Table userid BIGINT 19 0
log Table info VARCHAR 255
dp_competency_settings Table templateid BIGINT 19 null

Identifies the template these settings should be applied to

workshop_assessments_old Table teachercomment LONGTEXT 2147483647 null
workshopform_accumulative Table workshopid BIGINT 19 null

Workshop ID

qtype_randomsamatch_options Table choose BIGINT 19 4

Number of subquestions to randomly generate.

workshop_submissions Table attachment TINYINT 3 0

Used by File API file_postupdate_standard_filemanager

pos_relations Table id1 BIGINT 19 null
forum_posts Table created BIGINT 19 0
comp_scale_values Table sortorder BIGINT 19 null
config Table id BIGINT 19 null
totara_compl_import_course Table customfields LONGTEXT 2147483647 null

Any custom field data

pos Table timevalidfrom BIGINT 19 null
lti Table showdescriptionlaunch BIT 0 0
course_info_field Table id BIGINT 19 null
facetoface Table approvaladmins VARCHAR 255 null
lesson_attempts Table pageid BIGINT 19 0
auth_connect_sso_sessions Table serverid BIGINT 19 null
glossary Table assesstimestart BIGINT 19 0
scorm_seq_objective Table objectiveid VARCHAR 255
workshopallocation_scheduled Table resultmessage VARCHAR 1333 null

Optional short message describing the resulting status

workshop Table latesubmissions TINYINT 3 0

Allow submitting the work after the deadline

comp_template_assignment Table id BIGINT 19 null
message Table timeusertodeleted BIGINT 19 0
lti_tool_settings Table id BIGINT 19 null
dp_priority_scale_value Table numericscore DECIMAL 10 null
facetoface_session_info_field Table datatype VARCHAR 255 null
grade_categories_history Table fullname VARCHAR 255

The name of this grade category

appraisal_quest_field_role Table appraisalrole SMALLINT 5 null
block_quicklinks Table block_instance_id BIGINT 19 null
competency Table ruleconfig LONGTEXT 2147483647 null
dp_objective_scale_value Table name VARCHAR 255 null

Name of the scale value

quiz_statistics Table allattemptsavg DECIMAL 15 null
totara_connect_client_courses Table courseid BIGINT 19 null
course_request Table category BIGINT 19 0
event Table userid BIGINT 19 0
portfolio_log Table id BIGINT 19 null
repository_instances Table id BIGINT 19 null
competency_evidence Table url VARCHAR 255 null
glossary Table usedynalink TINYINT 3 1
question_answers Table feedback LONGTEXT 2147483647 null
goal_type_info_data_param Table dataid BIGINT 19 null
pos_type_info_field Table locked TINYINT 3 null
goal_type_info_field Table locked TINYINT 3 null
lti_submission Table datesubmitted BIGINT 19 null
comp_type_info_field Table fullname VARCHAR 1024 null
comp_template Table id BIGINT 19 null
workshopallocation_scheduled Table settings LONGTEXT 2147483647 null

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

cohort_plan_history Table manual BIT 0 0
tag_correlation Table id BIGINT 19 null
modules Table name VARCHAR 20
grade_items_history Table iteminstance BIGINT 19 null

id of the item module

label Table id BIGINT 19 null
qtype_essay_options Table responseformat VARCHAR 16 editor

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

competency_coursecompsetting Table usermodified BIGINT 19 null

The user who last modified this setting

data_content Table content3 LONGTEXT 2147483647 null
dp_component_settings Table component VARCHAR 255 null

Shortname of the component

auth_connect_servers Table servername VARCHAR 255

Name received from server, for UI identification only

grade_grades Table itemid BIGINT 19 null

The item this grade belongs to

scorm Table grademethod TINYINT 3 0
prog_courseset Table nextsetoperator SMALLINT 5 0
grade_grades_history Table feedback LONGTEXT 2147483647 null

grading feedback

mnetservice_enrol_enrolments Table userid BIGINT 19 null

ID of our local user on this server

tool_sitepolicy_policy_version Table versionnumber BIGINT 19 null

Version number of the policy

facetoface_sessioncancel_info_field Table hidden TINYINT 3 null
files Table status BIGINT 19 0

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

org_competencies Table id BIGINT 19 null
glossary Table course BIGINT 19 0
lesson_answers Table responseformat TINYINT 3 0
goal_personal Table userid BIGINT 19 null
dp_plan_evidence_info_field Table fullname VARCHAR 1333 null
forum_digests Table maildigest BIT 0 -1
glossary Table mainglossary TINYINT 3 0
facetoface Table selectjobassignmentonsignup BIT 0 0

Users with multiple job assignments will select one on signup

lesson_pages Table prevpageid BIGINT 19 0
event Table subscriptionid BIGINT 19 null

The event_subscription id this event is associated with.

facetoface_cancellation_info_field Table fullname VARCHAR 1024 null
tool_customlang Table original LONGTEXT 2147483647 null

English original of the string

user Table mnethostid BIGINT 19 0
appraisal_quest_field_role Table appraisalquestfieldid BIGINT 19 null
assignfeedback_editpdf_cmnt Table width BIGINT 19 120

width, in pixels, of the comment box

dp_plan_evidence_info_data Table fieldid BIGINT 19 null
feedback_item Table hasvalue BIT 0 0
grading_instances Table definitionid BIGINT 19 null

The ID of the form definition this is instance of

mnet_application Table xmlrpc_server_url VARCHAR 255
quiz_statistics Table lastattemptsavg DECIMAL 15 null
question Table modifiedby BIGINT 19 null

userid of person who last edited this question

workshop_old Table timemodified BIGINT 19 0
appraisal_quest_field Table param3 LONGTEXT 2147483647 null
cohort Table startdate BIGINT 19 null

Totara start date from totara_cohort

cache_filters Table filter VARCHAR 32
grade_items_history Table weightoverride BIT 0 0
mnet_log Table time BIGINT 19 0
qtype_ddimageortext_drags Table draggroup BIGINT 19 0
report_builder_saved Table reportid BIGINT 19 null

ID of the report this saved search belongs to

gradingform_rubric_criteria Table definitionid BIGINT 19 null

The ID of the form definition this criterion is part of

course_modules Table groupmode SMALLINT 5 0
survey_answers Table userid BIGINT 19 0
workshop_submissions_old Table title VARCHAR 100
glossary Table allowcomments TINYINT 3 0
totara_userdata_purge_type Table allowdeleted BIT 0 0

Allow selection for purging after deletion

org_type_info_field Table param3 LONGTEXT 2147483647 null
chat_users Table version VARCHAR 16
glossary_entries Table definitiontrust TINYINT 3 0
scorm_aicc_session Table timemodified BIGINT 19 0

time this session was last used

tag_area Table showstandard BIT 0 0
comp_type_info_field Table sortorder BIGINT 19 null
comp_relations Table id2 BIGINT 19 null
question_attempts Table responsesummary LONGTEXT 2147483647 null

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

qtype_shortanswer_options Table usecase TINYINT 3 0

Whether answers are matched case-sensitively.

user_info_field Table shortname VARCHAR 255 shortname

short name for each field

workshop_grades_old Table grade SMALLINT 5 0
auth_approved_request Table profilefields LONGTEXT 2147483647 null

The JSON encoded string containing all custom profile fields data

appraisal_history Table userid BIGINT 19 null
cache_flags Table id BIGINT 19 null
scorm_aicc_session Table scormid BIGINT 19 0

id from scorm table

grade_outcomes_history Table courseid BIGINT 19 null

Mostly these are defined site wide ie NULL

assignment Table var5 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

enrol_lti_lti2_user_result Table id BIGINT 19 null
reportbuilder_grp_pos_record Table id BIGINT 19 null
assignment Table preventlate TINYINT 3 0
question_response_analysis Table aid VARCHAR 100 null
choice_options Table timemodified BIGINT 19 0
goal Table usermodified BIGINT 19 null
appraisal_grp_pos Table id BIGINT 19 null
external_tokens Table validuntil BIGINT 19 null

timestampt - valid until data

course_categories Table coursecount BIGINT 19 0
tool_monitor_subscriptions Table id BIGINT 19 null
auth_connect_user_collections Table id BIGINT 19 null
goal_type_info_field Table fullname VARCHAR 1024 null
workshop_assessments_old Table timecreated BIGINT 19 0
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

user_password_resets Table timerequested BIGINT 19 null

The time that the user first requested this password reset

enrol_totara_f2f_pending Table id BIGINT 19 null
enrol_lti_tools Table enrolid BIGINT 19 null
prog_message Table triggertime BIGINT 19 0
feedback_completed_history Table idarchived BIGINT 19 null
competency Table parentid BIGINT 19 0

The parent competency.

comp_type_info_field Table param4 LONGTEXT 2147483647 null
upgrade_log Table id BIGINT 19 null
course_completion_aggr_methd Table method BIT 0 0

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

grading_instances Table itemid BIGINT 19 null

This identifies the graded item within the grabable area

qtype_ddmarker_drops Table choice BIGINT 19 0
glossary_categories Table usedynalink TINYINT 3 1
question_statistics Table randomguessscore DECIMAL 12 null

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

tag_instance Table timemodified BIGINT 19 0

timemodified

dp_plan_evidence_info_data_param Table value VARCHAR 32
comp_type_info_field Table shortname VARCHAR 100 null
totara_userdata_purge_type_item Table name VARCHAR 100

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

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

enrol_lti_lti2_consumer Table lastaccess BIGINT 19 null
label Table course BIGINT 19 0
task_adhoc Table faildelay BIGINT 19 null
appraisal_history Table timecreated BIGINT 19 null
qtype_multichoice_options Table incorrectfeedback LONGTEXT 2147483647 null

Feedback shown for any incorrect response.

reminder_sent Table id BIGINT 19 null
goal_user_info_field Table locked TINYINT 3 null
wiki_pages Table id BIGINT 19 null
facetoface Table allowcancellationsdefault BIT 0 1
resource Table name VARCHAR 255
course_modules Table course BIGINT 19 0
cohort_plan_history Table completed BIT 0 null
log Table module VARCHAR 20
enrol_lti_tools Table timezone VARCHAR 100 99
badge_manual_award Table issuerrole BIGINT 19 null
sessions Table userid BIGINT 19 null
block_zoola_reports_cohort Table blockinstanceid BIGINT 19 null

Block instance ID

totara_userdata_export_item Table exportid BIGINT 19 null
stats_daily Table id BIGINT 19 null
grade_outcomes_history Table action BIGINT 19 0

created/modified/deleted constants

cohort_visibility Table id BIGINT 19 null
choice Table timeopen BIGINT 19 0
totara_connect_clients Table clienturl VARCHAR 255

Web address of the client system

editor_atto_autosave Table userid BIGINT 19 null

The id of the user that loaded the form.

assignment Table timemodified BIGINT 19 0
workshop_old Table phase TINYINT 3 0
badge_issued Table uniquehash LONGTEXT 2147483647 null
facetoface_room Table usermodified BIGINT 19 null

user id who modified the room

job_assignment Table id BIGINT 19 null
page Table legacyfiles SMALLINT 5 0
goal_user_info_field Table id BIGINT 19 null
auth_approved_request Table lang VARCHAR 30

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

assignfeedback_editpdf_annot Table gradeid BIGINT 19 0
dp_priority_scale Table id BIGINT 19 null
enrol_totara_f2f_pending Table enrolid BIGINT 19 0
goal_grp_pos Table timemodified BIGINT 19 null
chat_users Table lastmessageping BIGINT 19 0
scale_history Table source VARCHAR 255 null

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

prog Table shortname VARCHAR 100
workshopform_comments Table description LONGTEXT 2147483647 null

The description of the dimension

grading_definitions Table id BIGINT 19 null
facetoface_room Table capacity BIGINT 19 0
assignment Table var3 BIGINT 19 0
repository Table visible BIT 0 1
stats_weekly Table timeend BIGINT 19 0
enrol Table id BIGINT 19 null
question_dataset_items Table itemnumber BIGINT 19 0
totara_connect_clients Table addnewcohorts BIT 0 0

Automatically add all new cohorts

dp_plan_course_assign Table courseid BIGINT 19 null

Identifies the course being assigned

backup_courses Table lastendtime BIGINT 19 0
url Table name VARCHAR 255
grade_categories Table hidden BIT 0 0
totara_compl_import_cert Table certificationidnumber VARCHAR 100 null

certification id number

course_info_field Table shortname VARCHAR 100 null
badge Table notification BIT 0 1

Message when badge is awarded

feedback360_email_assignment Table email VARCHAR 255
feedback_value_history Table idarchived BIGINT 19 null
cohort_rule_collections Table timemodified BIGINT 19 null
resource_old Table name VARCHAR 255
org_relations Table id BIGINT 19 null
mnet_session Table confirm_timeout BIGINT 19 0

UNIX timestamp for expiry of session

cohort_rule_params Table name VARCHAR 255
block_rss_client Table shared TINYINT 3 0
quiz_overrides Table groupid BIGINT 19 null

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

feedback360_scale_data Table id BIGINT 19 null
dp_plan Table createdby BIT 0 0

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

lesson Table displayleft SMALLINT 5 0
lesson_branch Table retry BIGINT 19 0
context Table contextlevel BIGINT 19 0
forum_discussion_subs Table discussion BIGINT 19 null
block_zoola_reports_schedule Table courseid BIGINT 19 null

Course ID

user_devices Table timecreated BIGINT 19 null
competency_coursecomp Table timemodified BIGINT 19 null

The time this link was modified.

feedback360 Table description LONGTEXT 2147483647 null
goal_scale_assignments Table usermodified BIGINT 19 null
report_builder_saved Table id BIGINT 19 null
persistent_login Table userid BIGINT 19 null
goal_personal Table id BIGINT 19 null
event Table timeduration BIGINT 19 0
org Table frameworkid BIGINT 19 null
grade_settings Table courseid BIGINT 19 null
portfolio_instance_user Table value LONGTEXT 2147483647 null

value of config item

course_info_data Table data LONGTEXT 2147483647 null
question_gapselect Table partiallycorrectfeedbackformat TINYINT 3 0
grade_outcomes_history Table oldid BIGINT 19 null
facetoface Table course BIGINT 19 0
workshop_rubrics_old Table newplugin VARCHAR 28 null
goal_personal Table targetdate BIGINT 19 null
totara_sync_log Table runid BIGINT 19 0

Run Batch ID

workshop_assessments_old Table newplugin VARCHAR 28 null
goal_user_type Table fullname VARCHAR 1024 null
role_capabilities Table contextid BIGINT 19 0
course_info_field Table param1 LONGTEXT 2147483647 null
quiz_slots Table requireprevious SMALLINT 5 0

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

appraisal_quest_field_role Table id BIGINT 19 null
feedback_valuetmp Table item BIGINT 19 0
reminder Table timecreated BIGINT 19 null
modules Table search VARCHAR 255
gradingform_guide_criteria Table id BIGINT 19 null
grading_instances Table raterid BIGINT 19 null

The ID of the user who did the assessment

feedback Table autonumbering BIT 0 1
quiz Table name VARCHAR 255

Quiz name.

prog_completion Table organisationid BIGINT 19 null
org_framework Table timemodified BIGINT 19 null
lesson Table retake SMALLINT 5 1
dp_plan_objective Table description LONGTEXT 2147483647 null
pos_relations Table id2 BIGINT 19 null
facetoface_notification_hist Table ical_uid VARCHAR 255 null

globally unique id of ical event

totara_userdata_export_item Table timestarted BIGINT 19 null

Start time of purging method

role_capabilities Table capability VARCHAR 255
feedback_completedtmp Table random_response BIGINT 19 0
question Table hidden BIT 0 0
pos_type_info_field Table param3 LONGTEXT 2147483647 null
quiz_statistics Table firstattemptsavg DECIMAL 15 null
tool_usertours_tours Table sortorder BIGINT 19 0
cohort Table component VARCHAR 100

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

appraisal_scale Table name VARCHAR 255 null
feedback_value Table completed BIGINT 19 0
lti_types Table timecreated BIGINT 19 null
cohort_plan_history Table affectedusers BIGINT 19 null
forum_posts Table parent BIGINT 19 0
message_read Table timecreated BIGINT 19 0
enrol_paypal Table txn_id VARCHAR 255
workshop_submissions Table timemodified BIGINT 19 null

Timestamp when the submission has been updated

feedback360_scale Table id BIGINT 19 null
repository_instances Table readonly BIT 0 0
competency_userevidencecomp Table timemodified BIGINT 19 null
local_ld_course Table id BIGINT 19 null
groups_members Table timeadded BIGINT 19 0
goal Table typeid BIGINT 19 0
course_categories Table name VARCHAR 255
repository_instances Table timecreated BIGINT 19 null
org Table depthlevel BIGINT 19 null
course_sections Table section BIGINT 19 0
competency_relatedcomp Table timemodified BIGINT 19 null
cohort Table name VARCHAR 254

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

report_builder Table contentmode SMALLINT 5 0

Controls how the content of the report is determined

comp_type_info_field Table param1 LONGTEXT 2147483647 null
course Table startdate BIGINT 19 0
auth_connect_sso_sessions Table timecreated BIGINT 19 null
comp_template Table visible TINYINT 3 null
role_sortorder Table userid BIGINT 19 null
appraisal_grp_org Table id BIGINT 19 null
auth_approved_request Table middlename VARCHAR 255 null

Middle name

stats_daily Table courseid BIGINT 19 0
glossary Table rssarticles TINYINT 3 0
block_rss_client Table id BIGINT 19 null
course_info_data Table fieldid BIGINT 19 null
gradingform_rubric_fillings Table id BIGINT 19 null
certificate Table intro LONGTEXT 2147483647 null
course_info_data Table courseid BIGINT 19 null
badge Table issuerurl VARCHAR 255
repository_opensesame_pkgs Table id BIGINT 19 null
course_modules Table indent MEDIUMINT 7 0
mnet_host2service Table id BIGINT 19 null
user_enrolments Table timecreated BIGINT 19 0
lesson_answers Table jumpto BIGINT 19 0
facetoface_asset_info_field Table description LONGTEXT 2147483647 null
goal Table id BIGINT 19 null
log Table cmid BIGINT 19 0
cohort Table description LONGTEXT 2147483647 null

Standard description text box

auth_approved_request Table lastnamephonetic VARCHAR 255 null

Last name phonetic

course Table showgrades TINYINT 3 1
assign_submission Table groupid BIGINT 19 0

The group id for team submissions

scorm_scoes_track Table attempt BIGINT 19 1
reportbuilder_grp_pos_record Table timecreated BIGINT 19 0
competency_userevidence Table userid BIGINT 19 null
dp_plan_course_assign Table grade DECIMAL 10 null

Stores the course grade at the moment the plan is marked as complete. Set to null for active plans.

qtype_ddmarker_drops Table id BIGINT 19 null
data Table addtemplate LONGTEXT 2147483647 null
comp_criteria Table iteminstance BIGINT 19 null
grade_outcomes Table timemodified BIGINT 19 null

the time this outcome was last updated

cohort_rule_params Table modifierid BIGINT 19 null
enrol_lti_lti2_resource_link Table settings LONGTEXT 2147483647 null
goal_user_type Table shortname VARCHAR 100 null
enrol_lti_lti2_context Table type VARCHAR 100 null
report_builder_columns Table reportid BIGINT 19 null

ID of the report this column belongs to

tool_sitepolicy_user_consent Table id BIGINT 19 null
mnet_session Table useragent VARCHAR 40

SHA1 hash of User Agent

comp_type_info_field Table param5 LONGTEXT 2147483647 null
grading_definitions Table options LONGTEXT 2147483647 null

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

course_completions Table reaggregate BIGINT 19 0
chat Table intro LONGTEXT 2147483647 null
reportbuilder_grp_cohort_user Table reportbuilderuserid BIGINT 19 null
prog_completion_history Table programid BIGINT 19 0
appraisal_event_message Table name VARCHAR 255

Message title

log_display Table action VARCHAR 40
page Table id BIGINT 19 null
mnet_remote_rpc Table xmlrpcpath VARCHAR 80
workshopform_rubric Table descriptionformat SMALLINT 5 0

The format of the description field

external_tokens Table contextid BIGINT 19 null

context id where in token valid

workshop_old Table nattachments SMALLINT 5 0
folder Table intro LONGTEXT 2147483647 null
pos Table timecreated BIGINT 19 null
competency_plan Table timecreated BIGINT 19 null
prog_recurrence Table id BIGINT 19 null
org_type_info_field Table param5 LONGTEXT 2147483647 null
dp_template Table workflow VARCHAR 255 null

Current workflow for this template

appraisal_event_rcpt Table id BIGINT 19 null
block Table visible BIT 0 1
grade_items Table sortorder BIGINT 19 0

Sorting order of the columns

filter_config Table name VARCHAR 255

The config variable name.

feedback_item Table position SMALLINT 5 0
feedback Table id BIGINT 19 null
tool_monitor_rules Table timewindow MEDIUMINT 7 null

Time window in seconds

workshop Table timemodified BIGINT 19 null

The timestamp when the module was modified

badge Table attachment BIT 0 1

Attach baked badge for download

totara_userdata_export_item Table id BIGINT 19 null
config_log Table plugin VARCHAR 100 null
report_builder_graph Table timemodified BIGINT 19 0

udpated when graph changes

log_queries Table qtype MEDIUMINT 7 null

query type constant

reminder Table title LONGTEXT 2147483647 null
block_quicklinks Table displaypos SMALLINT 5 0
comp_scale_values Table numericscore DECIMAL 10 null
portfolio_tempdata Table instance BIGINT 19 0

which portfolio plugin instance is being used

cohort_rule_params Table timemodified BIGINT 19 null
competency_evidence Table action TINYINT 3 null
auth_approved_request_snapshots Table resolvedby BIGINT 19 null
qtype_ddmarker Table correctfeedbackformat TINYINT 3 0
comp Table proficiencyexpected BIGINT 19 null
prog Table timecreated BIGINT 19 0
workshop_aggregations Table workshopid BIGINT 19 null

the id of the workshop instance

lesson Table available BIGINT 19 0
grade_grades_history Table overridden BIGINT 19 0

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

assign_user_flags Table mailed SMALLINT 5 0

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

lesson Table progressbar SMALLINT 5 0
facetoface_notification Table usermodified BIGINT 19 null
workshop_assessments_old Table submissionid BIGINT 19 0
reportbuilder_grp_org_record Table reportbuilderrecordid BIGINT 19 null
prog_info_field Table id BIGINT 19 null
goal_user_info_field Table param1 LONGTEXT 2147483647 null
grade_outcomes Table description LONGTEXT 2147483647 null

outcome description

enrol_lti_lti2_resource_link Table ltiresourcelinkkey VARCHAR 255
files Table pathnamehash VARCHAR 40

complete file path sha1 hash - unique for each file

tool_recyclebin_category Table fullname VARCHAR 255
dp_objective_scale_value Table achieved SMALLINT 5 0

Identifies if this scale value is an achieved value

feedback360_grp_pos Table includechildren BIT 0 null
feedback Table anonymous BIT 0 1
quiz Table completionattemptsexhausted BIT 0 0
enrol_lti_lti2_resource_link Table id BIGINT 19 null
badge_manual_award Table id BIGINT 19 null
goal_item_history Table scalevalueid BIGINT 19 null
comp_criteria_record Table userid BIGINT 19 null
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)

facetoface_cancellation_info_field Table datatype VARCHAR 255 null
reportbuilder_grp_cohort_record Table id BIGINT 19 null
facetoface_asset_info_field Table id BIGINT 19 null
totara_compl_import_cert Table importerror BIT 0 0

true/false if there were any errors

goal_item_history Table itemid BIGINT 19 null
quiz_feedback Table mingrade DECIMAL 10 0.00000

The lower limit of this grade band. Inclusive.

workshop_rubrics_old Table description LONGTEXT 2147483647 null
goal_type_info_field Table param3 LONGTEXT 2147483647 null
dp_plan_component_relation Table component1 VARCHAR 255 null

The first component in the relation - first alphabetically

dp_plan_evidence Table usermodified BIGINT 19 null

Identifies the user who last modified this item of evidence

local_ld_module_day Table day VARCHAR 10

Day formatted as 'YYYY-MM-DD'

workshopallocation_scheduled Table resultlog LONGTEXT 2147483647 null

The log of the most recent execution

competency_evidence Table descidentifier VARCHAR 255
workshop Table phaseswitchassessment TINYINT 3 0

Automatically switch to the assessment phase after the submissions deadline

facetoface_signup_info_field Table param1 LONGTEXT 2147483647 null
report_builder_graph Table settings LONGTEXT 2147483647 null

Custom graph configuration in INI format

question_gapselect Table shownumcorrect TINYINT 3 0
forum_posts Table totalscore SMALLINT 5 0
competency_coursecomp Table sortorder BIGINT 19 null

The display order for this link.

glossary_formats Table defaulthook VARCHAR 50
goal_user_info_data_param Table id BIGINT 19 null
org_framework Table idnumber VARCHAR 100 null
chat_users Table firstping BIGINT 19 0
course_completions Table organisationid BIGINT 19 null

Totara organisation id from totara_hierarchy

question_dataset_items Table definition BIGINT 19 0
facetoface_notification Table timemodified BIGINT 19 null
competency_framework Table description LONGTEXT 2147483647 null

Description of this competency framework

prog_completion_log Table description LONGTEXT 2147483647 null

Description of what changed, English only

scale Table name VARCHAR 255
report_builder_schedule_email_external Table id BIGINT 19 null
workshop Table overallfeedbackfiles SMALLINT 5 0

Number of allowed attachments to the overall feedback.

grade_items_history Table locktime BIGINT 19 0

lock all final grades after this date

course_completions Table invalidatecache BIT 0 0

Deprecated since Totara 10, please do not use

quiz Table attempts MEDIUMINT 7 0

The maximum number of attempts a student is allowed.

quiz_overview_regrades Table oldfraction DECIMAL 12 null

The previous fraction for this question_attempt.

forum_discussions Table timemodified BIGINT 19 0
task_scheduled Table dayofweek VARCHAR 25
repository_instance_config Table instanceid BIGINT 19 null
assign Table sendnotifications TINYINT 3 0

Allows the disabling of email notifications in the assign module.

goal_user_type_cohort Table id BIGINT 19 null
role Table id BIGINT 19 null
facetoface_cancellation_info_field Table param3 LONGTEXT 2147483647 null
facetoface_sessioncancel_info_field Table sortorder BIGINT 19 null
cohort_rulesets Table id BIGINT 19 null
pos Table idnumber VARCHAR 100 null
auth_connect_ids Table tablename VARCHAR 64

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

facetoface_asset_info_data Table facetofaceassetid BIGINT 19 null
qtype_ddimageortext_drops Table xleft BIGINT 19 0
backup_logs Table id BIGINT 19 null
comp_template_assignment Table usermodified BIGINT 19 null
enrol_paypal Table receiver_id VARCHAR 255
report_builder_graph Table maxrecords BIGINT 19 500

Maximum of records used in a graph?

course Table lang VARCHAR 30
mnet_host Table applicationid BIGINT 19 1
course_published Table timechecked BIGINT 19 null

the last time the status has been checked

workshopform_numerrors Table description LONGTEXT 2147483647 null

The description of the dimension

repository_opensesame_bdls Table timecreated BIGINT 19 null

Date when bundle added

facetoface_notification Table cancelled BIT 0 0
totara_userdata_export_type Table includefiledir BIT 0 0

Include file contents in export archive

prog_user_assignment Table assignmentid BIGINT 19 0
facetoface Table reservecanceldays INT 10 1

Number days before the session when all unconfirmed reservations are deleted

question Table defaultmark DECIMAL 12 1.0000000
quiz Table introformat SMALLINT 5 0

Quiz intro text format.

workshop_old Table assessmentend BIGINT 19 0
report_builder_filters Table type VARCHAR 255

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

appraisal_history Table id BIGINT 19 null
competency Table description LONGTEXT 2147483647 null

Description of a single competency

goal_scale_values Table proficient TINYINT 3 0
chat_users Table ip VARCHAR 45
mnet_host Table last_log_id BIGINT 19 0
local_ld_module Table id BIGINT 19 null
feedback Table introformat SMALLINT 5 0
cache_filters Table timemodified BIGINT 19 0
lesson_branch Table flag SMALLINT 5 0
dp_plan_component_relation Table id BIGINT 19 null
files Table component VARCHAR 100

Full name of the component owning the area

quiz_statistics Table lastattemptscount BIGINT 19 null
prog_completion_history Table id BIGINT 19 null
role_context_levels Table contextlevel BIGINT 19 null
prog_info_field Table defaultdata LONGTEXT 2147483647 null
badge Table message LONGTEXT 2147483647 null
gradingform_guide_criteria Table descriptionformat TINYINT 3 null

The format of the description field

totara_userdata_user Table timesuspended BIGINT 19 null

Best guess when user was actually deleted

quiz Table navmethod VARCHAR 16 free

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

user_info_field Table param3 LONGTEXT 2147483647 null

General parameter field

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

report_builder_columns Table transform VARCHAR 30 null

Column transform function, null means none

mnet_host2service Table publish BIT 0 0
quiz_overrides Table attempts MEDIUMINT 7 null
capabilities Table riskbitmask BIGINT 19 0
totara_userdata_export_type Table id BIGINT 19 null
report_builder Table showtotalcount BIT 0 0

Should a total count of records before filters are applied be shown

course_info_data_param Table dataid BIGINT 19 null
data Table manageapproved SMALLINT 5 1
certif Table id BIGINT 19 null
tool_sitepolicy_localised_policy Table title VARCHAR 1333

Title of the policy

scorm_seq_ruleconds Table action VARCHAR 25
question_statistics Table hashcode VARCHAR 40

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

reportbuilder_grp_org_user Table reportbuilderuserid BIGINT 19 null
comp_criteria Table usermodified BIGINT 19 null
user Table description LONGTEXT 2147483647 null
lti_tool_proxies Table capabilityoffered LONGTEXT 2147483647 null

List of capabilities offered, one per line

data Table timeavailablefrom BIGINT 19 0
user Table msn VARCHAR 50
dp_plan_objective Table timemodified BIGINT 19 null
logstore_standard_log Table relateduserid BIGINT 19 null
facetoface_asset_info_field Table forceunique TINYINT 3 null
grading_instances Table status BIGINT 19 0

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

cohort Table calculationstatus TINYINT 3 1

Totara calculatio nstatus flag from totara_cohort

forum_digests Table userid BIGINT 19 null
goal_type Table timemodified BIGINT 19 null
goal_scale_assignments Table scaleid BIGINT 19 null
quiz_grades Table timemodified BIGINT 19 0

The last time this grade changed.

feedback_template Table id BIGINT 19 null
scale_history Table scale LONGTEXT 2147483647 null
facetoface_session_info_data_param Table id BIGINT 19 null
data_fields Table param8 LONGTEXT 2147483647 null
question_categories Table infoformat TINYINT 3 0
report_builder_filters Table sortorder BIGINT 19 null

Determines the order that the filters appear in the report

modules Table id BIGINT 19 null
lti_types Table timemodified BIGINT 19 null
blog_external Table url LONGTEXT 2147483647 null
workshop Table introformat SMALLINT 5 0

The format of the intro field

survey_answers Table time BIGINT 19 0
qtype_ddimageortext_drags Table id BIGINT 19 null
question_dataset_definitions Table name VARCHAR 255
feedback_value_history Table item BIGINT 19 0
course_format_options Table sectionid BIGINT 19 0

Null if this is a course option, otherwise id of the section this option is for

goal_scale Table name VARCHAR 255 null
course_completion_crit_compl Table criteriaid BIGINT 19 0

Completion criteria this references

question_hints Table shownumcorrect BIT 0 null

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

prog_exception Table timeraised BIGINT 19 0
user Table timemodified BIGINT 19 0
facetoface_sessioncancel_info_field Table param5 LONGTEXT 2147483647 null
scorm_scoes Table title VARCHAR 255
goal_type_info_field Table shortname VARCHAR 100 null
goal_framework Table idnumber VARCHAR 100