user

0 rows


Description

One record for each person, custom profile fields can be added via /user/profile/index.php for sample reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#USER_and_ENROLMENT_Reports

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
ai_action_register.userid aiactiregi_use2_fkR
ai_policy_register.userid aipoliregi_use_fkR
analytics_models.usermodified analmode_use2_fkR
analytics_models_log.usermodified analmodelog_use2_fkR
analytics_prediction_actions.userid analpredacti_use2_fkR
assign_overrides.userid assiover_use2_fkR
assign_user_flags.userid assiuserflag_use2_fkR
assign_user_mapping.userid assiusermapp_use2_fkR
assignfeedback_editpdf_quick.userid assieditquic_use2_fkR
auth_lti_linked_login.userid authltilinklogi_use2_fkR
auth_oauth2_linked_login.userid authoautlinklogi_use4_fkR
auth_oauth2_linked_login.usermodified authoautlinklogi_use3_fkR
backup_controllers.userid backcont_use2_fkR
badge.usercreated badg_use4_fkR
badge.usermodified badg_use3_fkR
badge_backpack.userid badgback_use2_fkR
badge_backpack_oauth2.userid badgbackoaut_use4_fkR
badge_backpack_oauth2.usermodified badgbackoaut_use3_fkR
badge_criteria_met.userid badgcritmet_use2_fkR
badge_issued.userid badgissu_use2_fkR
badge_manual_award.issuerid badgmanuawar_iss3_fkR
badge_manual_award.recipientid badgmanuawar_rec2_fkR
bigbluebuttonbn_recordings.usermodified bigbreco_use2_fkR
block_recent_activity.userid block_recent_activity_erd_user_idR
block_recentlyaccesseditems.userid blocrece_use2_fkR
block_rss_client.userid block_rss_client_erd_useridR
blog_external.userid blogexte_use2_fkR
cohort_members.userid cohomemb_use2_fkR
comments.userid comm_use2_fkR
communication_user.userid commuser_use2_fkR
competency.usermodified comp_use2_fkR
competency_coursecomp.usermodified compcour_use5_fkR
competency_coursecompsetting.usermodified compcour_use3_fkR
competency_evidence.actionuserid compevid_act2_fkR
competency_evidence.usermodified compevid_use2_fkR
competency_framework.usermodified compfram_use2_fkR
competency_modulecomp.usermodified compmodu_use2_fkR
competency_plan.usermodified compplan_use3_fkR
competency_plancomp.usermodified compplan_use5_fkR
competency_relatedcomp.usermodified comprela_use2_fkR
competency_template.usermodified comptemp_use4_fkR
competency_templatecohort.usermodified comptemp_use8_fkR
competency_templatecomp.usermodified comptemp_use6_fkR
competency_usercomp.usermodified compuser_use6_fkR
competency_usercompcourse.usermodified compuser_use8_fkR
competency_usercompplan.usermodified compuser_use10_fkR
competency_userevidence.userid competency_userevidence_erd_competency_usercompR
competency_userevidence.usermodified compuser_use12_fkR
competency_userevidencecomp.usermodified compuser_use14_fkR
config_log.userid conflog_use2_fkR
contentbank_content.usercreated contcont_use4_fkR
contentbank_content.usermodified contcont_use3_fkR
data_records.userid datareco_use2_fkR
enrol_flatfile.userid enroflat_use2_fkR
enrol_lti_users.userid enroltiuser_use2_fkR
enrol_paypal.userid enropayp_use2_fkR
event_subscriptions.userid evensubs_use2_fkR
events_queue.userid evenqueu_use2_fkR
external_services_users.userid exteservuser_use2_fkR
external_tokens.creatorid extetoke_cre2_fkR
external_tokens.userid extetoke_use2_fkR
favourite.userid favo_use2_fkR
file_conversion.usermodified fileconv_use2_fkR
files.userid file_use2_fkR
forum_digests.userid forudige_use2_fkR
forum_discussion_subs.userid forudiscsubs_use2_fkR
forum_discussions.usermodified forudisc_use2_fkR
grade_categories_history.loggeduser gradcatehist_log2_fkR
grade_grades.userid gradgrad_use3_fkR
grade_grades.usermodified gradgrad_use4_fkR
grade_grades_history.loggeduser gradgradhist_log2_fkR
grade_grades_history.userid gradgradhist_use3_fkR
grade_grades_history.usermodified gradgradhist_use4_fkR
grade_import_newitem.importer gradimponewi_imp2_fkR
grade_import_values.importer gradimpovalu_imp2_fkR
grade_import_values.userid gradimpovalu_use2_fkR
grade_items_history.loggeduser graditemhist_log2_fkR
grade_outcomes.usermodified gradoutc_use2_fkR
grade_outcomes_history.loggeduser gradoutchist_log2_fkR
grading_definitions.usercreated graddefi_use4_fkR
grading_definitions.usermodified graddefi_use3_fkR
grading_instances.raterid gradinst_rat2_fkR
groups_members.userid groumemb_use2_fkR
infected_files.userid infefile_use2_fkR
lesson_overrides.userid lessover_use2_fkR
log.userid log_erd_useridR
logstore_standard_log.realuserid logsstanlog_rea2_fkR
logstore_standard_log.relateduserid logsstanlog_rel2_fkR
logstore_standard_log.userid logsstanlog_use2_fkR
message_contact_requests.requesteduserid messcontrequ_req2_fkR
message_contact_requests.userid messcontrequ_use2_fkR
message_contacts.contactid messcont_con2_fkR
message_contacts.userid messcont_use2_fkR
message_conversation_actions.userid messconvacti_use2_fkR
message_conversation_members.userid messconvmemb_use2_fkR
message_email_messages.useridto messemaimess_use2_fkR
message_read.useridfrom message_read_erd_from_user_idR
message_user_actions.userid messuseracti_use2_fkR
message_users_blocked.blockeduserid messuserbloc_blo2_fkR
message_users_blocked.userid messuserbloc_use2_fkR
messageinbound_messagelist.userid messmess_use2_fkR
messages.useridfrom mess_use2_fkR
mnet_session.userid mnetsess_use2_fkR
mnetservice_enrol_enrolments.userid mnetenroenro_use2_fkR
my_pages.userid my_pages_erd_useridR
notifications.useridto noti_use2_fkR
oauth2_access_token.usermodified oautaccetoke_use2_fkR
oauth2_endpoint.usermodified oautendp_use2_fkR
oauth2_refresh_token.userid oautrefrtoke_use2_fkR
oauth2_system_account.usermodified oautsystacco_use2_fkR
oauth2_user_field_mapping.usermodified oautuserfielmapp_use2_fkR
payments.userid paym_use2_fkR
portfolio_instance_user.userid portinstuser_use2_fkR
portfolio_log.userid portlog_use2_fkR
portfolio_tempdata.userid porttemp_use2_fkR
post.usermodified post_use2_fkR
question.createdby ques_cre2_fkR
question.modifiedby ques_mod2_fkR
question_attempt_steps.userid quesattestep_use2_fkR
question_bank_entries.ownerid quesbankentr_own2_fkR
quiz_attempts.userid quizatte_use2_fkR
quiz_overrides.userid quizover_use2_fkR
quizaccess_seb_quizsettings.usermodified quizsebquiz_use2_fkR
quizaccess_seb_template.usermodified quizsebtemp_use2_fkR
rating.userid rati_use2_fkR
reportbuilder_audience.usercreated repoaudi_use3_fkR
reportbuilder_audience.usermodified repoaudi_use4_fkR
reportbuilder_column.usercreated repocolu_use3_fkR
reportbuilder_column.usermodified repocolu_use4_fkR
reportbuilder_filter.usercreated repofilt_use3_fkR
reportbuilder_filter.usermodified repofilt_use4_fkR
reportbuilder_report.usercreated reporepo_use3_fkR
reportbuilder_report.usermodified reporepo_use4_fkR
reportbuilder_schedule.usercreated reposche_use5_fkR
reportbuilder_schedule.usermodified reposche_use6_fkR
reportbuilder_schedule.userviewas reposche_use4_fkR
repository_instances.userid repoinst_use2_fkR
repository_onedrive_access.usermodified repoonedacce_use2_fkR
role_assignments.userid roleassi_use2_fkR
role_capabilities.modifierid rolecapa_mod2_fkR
scale.userid scal_use2_fkR
scale_history.loggeduser scalhist_log2_fkR
scale_history.userid scalhist_use2_fkR
scorm_aicc_session.userid scoraiccsess_use2_fkR
scorm_attempt.userid scoratte_use2_fkR
sessions.userid sess_use2_fkR
tag.userid tag_use2_fkR
task_adhoc.userid taskadho_use2_fkR
task_log.userid tasklog_use2_fkR
tool_dataprivacy_purposerole.usermodified tooldatapurp_use2_fkR
tool_dataprivacy_request.dpo tooldatarequ_dpo2_fkR
tool_dataprivacy_request.requestedby tooldatarequ_req2_fkR
tool_dataprivacy_request.userid tooldatarequ_use3_fkR
tool_dataprivacy_request.usermodified tooldatarequ_use4_fkR
tool_mfa_auth.userid toolmfaauth_use2_fkR
tool_mfa_secrets.userid toolmfasecr_use2_fkR
tool_policy_acceptances.userid toolpoliacce_use3_fkR
tool_policy_acceptances.usermodified toolpoliacce_use4_fkR
tool_policy_versions.usermodified toolpolivers_use2_fkR
upgrade_log.userid upgrlog_use2_fkR
user_devices.userid userdevi_use2_fkR
user_enrolments.modifierid userenro_mod2_fkR
user_enrolments.userid userenro_use2_fkR
user_info_data.userid user_info_data_erd_useridR
user_lastaccess.userid user_lastaccess_erd_useridR
user_password_history.userid userpasshist_use2_fkR
user_password_resets.userid userpassrese_use2_fkR
user_preferences.userid user_preferences_erd_useridR
user_private_key.userid userprivkey_use2_fkR
workshop_aggregations.userid workaggr_use2_fkR
workshop_assessments.gradinggradeoverby workasse_gra2_fkR
workshop_assessments.reviewerid workasse_rev2_fkR
workshop_submissions.authorid worksubm_aut2_fkR
workshop_submissions.gradeoverby worksubm_gra2_fkR
auth VARCHAR 20 manual

The authorisation system used by this account, e.g. Oauth2 or manual https://docs.moodle.org/dev/Authentication_plugins
confirmed BIT 1 0

The user has confirmed account https://docs.moodle.org/en/Cleanup#Delete_unconfirmed_users_after
policyagreed BIT 1 0

User has agreed to system policies. https://github.com/moodle/moodle/tree/master/admin/tool/policy
deleted BIT 1 0

always check for deleted=0 when looking for non deleted accounts
suspended BIT 1 0

suspended flag prevents users to log in
mnethostid BIGINT 19 0

mainly used for connecting to the Mahara e-portfolio system https://mahara.org/
username VARCHAR 100
mnet_sso_access_control.username Defined in XMLR
password VARCHAR 255

stored as a hash, for authentication the password is hashed and compared with this
idnumber VARCHAR 255
firstname VARCHAR 100
lastname VARCHAR 100
email VARCHAR 100
emailstop BIT 1 0
phone1 VARCHAR 20
phone2 VARCHAR 20
institution VARCHAR 255
department VARCHAR 255
address VARCHAR 255
city VARCHAR 120
country VARCHAR 2
calendartype VARCHAR 30 gregorian
firstlogin Unknown 0 null

Unix timetamp first time ever this user logged in
lang VARCHAR 30 en
theme VARCHAR 50
timezone VARCHAR 100 99

https://github.com/moodle/moodle/blob/master/lang/en/timezones.php
firstaccess BIGINT 19 0
lastaccess BIGINT 19 0
lastlogin BIGINT 19 0

Unix timetamp of last loginlogin
currentlogin BIGINT 19 0

Unix timetamp for start of current login
lastip VARCHAR 45
secret VARCHAR 15
picture BIGINT 19 0

0 means no image uploaded, positive values are revisions thta prevent caching problems, negative values are reserved for future use
description LONGTEXT 2147483647 √ null
descriptionformat TINYINT 3 1

HTML,MOODLE,PLAIN,MARKDOWN https://github.com/moodle/moodle/blob/master/lib/weblib.php
mailformat BIT 1 1
maildigest BIT 1 0
maildisplay TINYINT 3 2
autosubscribe BIT 1 1
trackforums BIT 1 0
timecreated BIGINT 19 0
timemodified BIGINT 19 0
trustbitmask BIGINT 19 0
imagealt VARCHAR 255 √ null

alt tag for user uploaded image
lastnamephonetic VARCHAR 255 √ null

Last name phonetic
firstnamephonetic VARCHAR 255 √ null

First name phonetic
middlename VARCHAR 255 √ null

Middle name
alternatename VARCHAR 255 √ null

Alternate name - Useful for three-name countries.
moodlenetprofile VARCHAR 255 √ null

Moodle.net profile information

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
user_alt_ix Performance Asc alternatename
user_aut_ix Performance Asc auth
user_cit_ix Performance Asc city
user_con_ix Performance Asc confirmed
user_cou_ix Performance Asc country
user_del_ix Performance Asc deleted
user_ema_ix Performance Asc email
user_fir2_ix Performance Asc firstnamephonetic
user_fir_ix Performance Asc firstname
user_idn_ix Performance Asc idnumber
user_las2_ix Performance Asc lastaccess
user_las3_ix Performance Asc lastnamephonetic
user_las_ix Performance Asc lastname
user_mid_ix Performance Asc middlename
user_mneuse_uix Must be unique Asc/Asc mnethostid + username

Relationships

Close relationships within degrees of separation