user

0 rows


Description

One record for each person

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
adminpresets.userid Implied ConstraintR
adminpresets_app.userid Implied ConstraintR
analytics_prediction_actions.userid analpredacti_use2_fkR
assign_grades.userid Implied ConstraintR
assign_overrides.userid assiover_use2_fkR
assign_submission.userid Implied ConstraintR
assign_user_flags.userid assiuserflag_use2_fkR
assign_user_mapping.userid assiusermapp_use2_fkR
assignfeedback_editpdf_quick.userid assieditquic_use2_fkR
assignment_submissions.userid Implied ConstraintR
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_logs.userid Implied ConstraintR
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
chat_messages.userid Implied ConstraintR
chat_messages_current.userid Implied ConstraintR
chat_users.userid Implied ConstraintR
choice_answers.userid Implied ConstraintR
cohort_members.userid cohomemb_use2_fkR
comments.userid comm_use2_fkR
competency_plan.userid Implied ConstraintR
competency_usercomp.userid Implied ConstraintR
competency_usercompcourse.userid Implied ConstraintR
competency_usercompplan.userid Implied ConstraintR
competency_userevidence.userid competency_userevidence_erd_competency_usercompR
competency_userevidencecomp.userevidenceid Implied ConstraintR
config_log.userid conflog_use2_fkR
contentbank_content.usercreated contcont_use4_fkR
contentbank_content.usermodified contcont_use3_fkR
course_completion_crit_compl.userid Implied ConstraintR
course_completions.userid Implied ConstraintR
course_modules_completion.userid Implied ConstraintR
data_records.userid Implied ConstraintR
editor_atto_autosave.userid Implied ConstraintR
enrol_flatfile.userid enroflat_use2_fkR
enrol_lti_users.userid enroltiuser_use2_fkR
enrol_paypal.userid enropayp_use2_fkR
event.userid Implied ConstraintR
event_subscriptions.userid Implied ConstraintR
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
feedback_completed.userid Implied ConstraintR
feedback_completedtmp.userid Implied ConstraintR
files.userid file_use2_fkR
forum_digests.userid forudige_use2_fkR
forum_discussion_subs.userid forudiscsubs_use2_fkR
forum_discussions.userid Implied ConstraintR
forum_grades.userid Implied ConstraintR
forum_posts.userid Implied ConstraintR
forum_queue.userid Implied ConstraintR
forum_read.userid Implied ConstraintR
forum_subscriptions.userid Implied ConstraintR
glossary_entries.userid Implied ConstraintR
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 Implied ConstraintR
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
h5pactivity_attempts.userid Implied ConstraintR
infected_files.userid infefile_use2_fkR
lesson_attempts.userid Implied ConstraintR
lesson_branch.userid Implied ConstraintR
lesson_grades.userid Implied ConstraintR
lesson_overrides.userid lessover_use2_fkR
lesson_timer.userid Implied ConstraintR
log.userid log_erd_useridR
logstore_standard_log.userid Implied ConstraintR
lti_submission.userid Implied ConstraintR
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_log.userid Implied ConstraintR
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.userid Implied ConstraintR
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_grades.userid Implied ConstraintR
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 Implied ConstraintR
repository_onedrive_access.usermodified repoonedacce_use2_fkR
role_assignments.userid roleassi_use2_fkR
role_capabilities.modifierid rolecapa_mod2_fkR
scale.userid Implied ConstraintR
scale_history.loggeduser scalhist_log2_fkR
scale_history.userid Implied ConstraintR
scorm_aicc_session.userid scoraiccsess_use2_fkR
scorm_scoes_track.userid Implied ConstraintR
search_simpledb_index.userid Implied ConstraintR
sessions.userid sess_use2_fkR
stats_user_daily.userid Implied ConstraintR
stats_user_monthly.userid Implied ConstraintR
stats_user_weekly.userid Implied ConstraintR
survey_analysis.userid Implied ConstraintR
survey_answers.userid Implied ConstraintR
tag.userid tag_use2_fkR
task_adhoc.userid taskadho_use2_fkR
task_log.userid Implied ConstraintR
tool_cohortroles.userid Implied ConstraintR
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_monitor_history.userid Implied ConstraintR
tool_monitor_rules.userid Implied ConstraintR
tool_monitor_subscriptions.userid Implied ConstraintR
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
wiki_locks.userid Implied ConstraintR
wiki_pages.userid Implied ConstraintR
wiki_subwikis.userid Implied ConstraintR
wiki_versions.userid Implied ConstraintR
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
confirmed BIT 1 0
policyagreed BIT 1 0
deleted BIT 1 0
suspended BIT 1 0

suspended flag prevents users to log in
mnethostid BIGINT 19 0
username VARCHAR 100
password VARCHAR 255
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
lang VARCHAR 30 en
calendartype VARCHAR 30 gregorian
theme VARCHAR 50
timezone VARCHAR 100 99
firstaccess BIGINT 19 0
lastaccess BIGINT 19 0
lastlogin BIGINT 19 0
currentlogin BIGINT 19 0
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
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

Close relationships within degrees of separation