user

0 rows


Description

One record for each person, custom profile fields can be added via /user/profile/index.php

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
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_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
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_userevidence.userid competency_userevidence_erd_competency_usercompR
config_log.userid conflog_use2_fkR
contentbank_content.usercreated contcont_use4_fkR
contentbank_content.usermodified contcont_use3_fkR
enrol_flatfile.userid enroflat_use2_fkR
enrol_lti_users.userid enroltiuser_use2_fkR
enrol_paypal.userid enropayp_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
files.userid file_use2_fkR
forum_digests.userid forudige_use2_fkR
forum_discussion_subs.userid forudiscsubs_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_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
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_refresh_token.userid oautrefrtoke_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
quiz_attempts.userid quizatte_use2_fkR
quiz_overrides.userid quizover_use2_fkR
rating.userid rati_use2_fkR
repository_onedrive_access.usermodified repoonedacce_use2_fkR
role_assignments.userid roleassi_use2_fkR
role_capabilities.modifierid rolecapa_mod2_fkR
scale_history.loggeduser scalhist_log2_fkR
scorm_aicc_session.userid scoraiccsess_use2_fkR
sessions.userid sess_use2_fkR
tag.userid tag_use2_fkR
task_adhoc.userid taskadho_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_alt2_ix Performance Asc alternatename
user_aut2_ix Performance Asc auth
user_cit2_ix Performance Asc city
user_con2_ix Performance Asc confirmed
user_cou2_ix Performance Asc country
user_del2_ix Performance Asc deleted
user_ema2_ix Performance Asc email
user_fir3_ix Performance Asc firstname
user_fir4_ix Performance Asc firstnamephonetic
user_idn2_ix Performance Asc idnumber
user_las4_ix Performance Asc lastname
user_las5_ix Performance Asc lastaccess
user_las6_ix Performance Asc lastnamephonetic
user_mid2_ix Performance Asc middlename
user_mneuse2_uix Must be unique Asc/Asc mnethostid + username

Relationships