# 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
customfield_shared.usermodified | custshar_use2_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
gradepenalty_duedate_rule.usermodified | gradduedrule_use2_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
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
reportbuilder_user_filter.usercreated | repouserfilt_use3_fkR
reportbuilder_user_filter.usermodified | repouserfilt_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
shortlink.userid | shor_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