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
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
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 message_contacts_erd_user_idR
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 mnet_session_erd_useridR
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
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_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