User Table Schema (user)


Description

One record for each person

user table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_history.userid apprhist_use2_fk R
appraisal_role_assignment.userid apprroleassi_use2_fk R
appraisal_role_changes.userassignmentid Implied Constraint R
appraisal_scale.userid apprscal_use2_fk R
appraisal_user_assignment.userid appruserassi_use2_fk R
appraisal_user_event.userid apprusereven_use2_fk R
assign_grades.userid Implied Constraint R
assign_overrides.userid assiover_use2_fk R
assign_submission.userid Implied Constraint R
assign_user_flags.userid assiuserflag_use2_fk R
assign_user_mapping.userid assiusermapp_use2_fk R
assignfeedback_editpdf_quick.userid assieditquic_use2_fk R
assignment_submissions.userid Implied Constraint R
auth_approved_request.resolvedby authapprrequ_res2_fk R
auth_approved_request.userid authapprrequ_use2_fk R
auth_approved_request_snapshots.userid Implied Constraint R
auth_approved_request_snapshots.usersnapshot authapprrequsnap_use2_fk R
auth_connect_sso_sessions.userid authconnssosess_use2_fk R
auth_connect_users.userid authconnuser_use3_fk R
auth_oauth2_linked_login.userid authoautlinklogi_use4_fk R
auth_oauth2_linked_login.usermodified authoautlinklogi_use3_fk R
backup_controllers.userid backcont_use2_fk R
backup_trusted_files.userid backtrusfile_use2_fk R
badge.usercreated badg_use4_fk R
badge.usermodified badg_use3_fk R
badge_backpack.userid badgback_use2_fk R
badge_criteria_met.userid badgcritmet_use2_fk R
badge_issued.userid badgissu_use2_fk R
badge_manual_award.issuerid badgmanuawar_iss3_fk R
badge_manual_award.recipientid badgmanuawar_rec2_fk R
block_community.userid bloccomm_use_fk R
block_quicklinks.userid Implied Constraint R
block_recent_activity.userid blocreceacti_use_fk R
block_rss_client.userid blocrssclie_use_fk R
block_totara_featured_links_tiles.userid bloctotafeatlinktile_use2_fk R
block_totara_stats.userid Implied Constraint R
block_zoola_notifications.userid Implied Constraint R
block_zoola_reports_schedule.userid Implied Constraint R
block_zoola_reports_schreps.userid bloczoolreposchr_use2_fk R
block_zoola_reports_user.userid bloczoolrepouser_use2_fk R
block_zoola_schedule_rcp.userid bloczoolschercp_use2_fk R
blog_external.userid blogexte_use2_fk R
certif_completion.userid certcomp_use2_fk R
certif_completion_history.userid certcomphist_use2_fk R
certificate_issues.userid Implied Constraint R
certificate_issues_history.userid certissuhist_use2_fk R
chat_messages.userid Implied Constraint R
chat_messages_current.userid Implied Constraint R
chat_users.userid Implied Constraint R
choice_answers.userid Implied Constraint R
cohort_members.userid cohomemb_use2_fk R
cohort_msg_queue.modifierid cohomsgqueu_mod2_fk R
cohort_msg_queue.userid cohomsgqueu_use2_fk R
cohort_plan_history.usercreated cohoplanhist_use2_fk R
cohort_role.usermodified cohorole_use2_fk R
cohort_rule_collections.modifierid cohorulecoll_mod2_fk R
cohort_rule_params.modifierid cohorulepara_mod2_fk R
cohort_rules.modifierid cohorule_mod4_fk R
cohort_rulesets.modifierid cohorule_mod3_fk R
cohort_visibility.usermodified cohovisi_use2_fk R
comments.userid Implied Constraint R
comp_criteria_record.userid compcritreco_use2_fk R
comp_record.assessorid compreco_ass2_fk R
comp_record.userid compreco_use2_fk R
comp_record_history.userid comprecohist_use2_fk R
comp_template_assignment.usermodified comptempassi_use2_fk R
competency_plan.userid Implied Constraint R
competency_usercomp.userid Implied Constraint R
competency_usercompcourse.userid Implied Constraint R
competency_usercompplan.userid Implied Constraint R
competency_userevidence.userid Implied Constraint R
competency_userevidencecomp.userevidenceid Implied Constraint R
config_log.userid conflog_use2_fk R
course_completion_crit_compl.userid courcompcritcomp_use2_fk R
course_completion_history.userid courcomphist_use2_fk R
course_completion_log.changeuserid courcomplog_cha2_fk R
course_completion_log.userid courcomplog_use2_fk R
course_completions.userid courcomp_use2_fk R
course_modules_completion.userid courmoducomp_use_fk R
data_records.userid Implied Constraint R
dp_evidence_type.usermodified dpevidtype_use2_fk R
dp_objective_scale.usermodified dpobjescal_use2_fk R
dp_objective_scale_value.usermodified dpobjescalvalu_use2_fk R
dp_plan.userid dpplan_use2_fk R
dp_plan_evidence.userid dpplanevid_use4_fk R
dp_plan_evidence.usermodified dpplanevid_use3_fk R
dp_plan_history.usermodified dpplanhist_use2_fk R
dp_priority_scale.usermodified dpprioscal_use2_fk R
dp_priority_scale_value.usermodified dpprioscalvalu_use2_fk R
editor_atto_autosave.userid Implied Constraint R
enrol_flatfile.userid enroflat_use2_fk R
enrol_lti_users.userid enroltiuser_use2_fk R
enrol_paypal.userid Implied Constraint R
enrol_totara_f2f_pending.userid Implied Constraint R
event.userid Implied Constraint R
event_subscriptions.userid Implied Constraint R
events_queue.userid evenqueu_use2_fk R
external_services_users.userid exteservuser_use2_fk R
external_tokens.creatorid extetoke_cre2_fk R
external_tokens.userid extetoke_use2_fk R
facetoface_asset.usercreated faceasse_use3_fk R
facetoface_asset.usermodified faceasse_use4_fk R
facetoface_interest.userid Implied Constraint R
facetoface_notification.usermodified facenoti_use2_fk R
facetoface_notification_hist.userid facenotihist_use2_fk R
facetoface_notification_sent.userid facenotisent_use2_fk R
facetoface_room.usercreated faceroom_use3_fk R
facetoface_room.usermodified faceroom_use4_fk R
facetoface_session_roles.userid facesessrole_use2_fk R
facetoface_sessions.usermodified facesess_use2_fk R
facetoface_signups.managerid facesign_man2_fk R
facetoface_signups.userid facesign_use2_fk R
facetoface_signups_status.createdby facesignstat_cre2_fk R
feedback360.userid feed_use2_fk R
feedback360_resp_assignment.userid feedrespassi_use2_fk R
feedback360_scale.userid feedscal_use2_fk R
feedback360_user_assignment.userid feeduserassi_use2_fk R
feedback_completed.userid Implied Constraint R
feedback_completed_history.userid feedcomphist_use2_fk R
feedback_completedtmp.userid Implied Constraint R
files.userid file_use2_fk R
forum_digests.userid forudige_use2_fk R
forum_discussion_subs.userid forudiscsubs_use2_fk R
forum_discussions.userid Implied Constraint R
forum_posts.userid Implied Constraint R
forum_queue.userid Implied Constraint R
forum_read.userid Implied Constraint R
forum_subscriptions.userid Implied Constraint R
gap_aspirational.userid gapaspi_use2_fk R
glossary_entries.userid Implied Constraint R
goal_personal.userid goalpers_use2_fk R
goal_record.userid goalreco_use2_fk R
goal_user_assignment.userid goaluserassi_use2_fk R
grade_categories_history.loggeduser gradcatehist_log2_fk R
grade_grades.userid gradgrad_use3_fk R
grade_grades.usermodified gradgrad_use4_fk R
grade_grades_history.loggeduser gradgradhist_log2_fk R
grade_grades_history.userid gradgradhist_use3_fk R
grade_grades_history.usermodified gradgradhist_use4_fk R
grade_import_newitem.importer gradimponewi_imp2_fk R
grade_import_values.importer gradimpovalu_imp2_fk R
grade_import_values.userid Implied Constraint R
grade_items_history.loggeduser graditemhist_log2_fk R
grade_outcomes.usermodified gradoutc_use2_fk R
grade_outcomes_history.loggeduser gradoutchist_log2_fk R
grading_definitions.usercreated graddefi_use4_fk R
grading_definitions.usermodified graddefi_use3_fk R
grading_instances.raterid gradinst_rat2_fk R
groups_members.userid groumemb_use2_fk R
job_assignment.appraiserid jobassi_app2_fk R
job_assignment.userid jobassi_use3_fk R
job_assignment.usermodified jobassi_use4_fk R
lesson_attempts.userid Implied Constraint R
lesson_branch.userid Implied Constraint R
lesson_grades.userid Implied Constraint R
lesson_overrides.userid lessover_use2_fk R
lesson_timer.userid Implied Constraint R
local_activityvisibility.userid Implied Constraint R
local_activityvisibility_que.userid Implied Constraint R
local_ld_course.userid localdcour_use2_fk R
local_ld_lastactivity.userid Implied Constraint R
log.userid Implied Constraint R
logstore_standard_log.userid Implied Constraint R
lti_submission.userid Implied Constraint R
lti_submission_history.userid ltisubmhist_use2_fk R
message_airnotifier_devices.userdeviceid Implied Constraint R
message_contacts.userid messcont_use_fk R
message_read.useridfrom messread_use_fk R
message_read.useridto messread_use2_fk R
messageinbound_messagelist.userid messmess_use2_fk R
mnet_log.userid Implied Constraint R
mnet_session.userid Implied Constraint R
mnetservice_enrol_enrolments.userid mnetenroenro_use2_fk R
my_pages.userid Implied Constraint R
persistent_login.userid perslogi_use2_fk R
portfolio_instance_user.userid portinstuser_use2_fk R
portfolio_log.userid portlog_use2_fk R
portfolio_tempdata.userid porttemp_use2_fk R
post.userid Implied Constraint R
post.usermodified post_use2_fk R
prog_completion.userid progcomp_use3_fk R
prog_completion_history.userid progcomphist_use3_fk R
prog_completion_log.changeuserid progcomplog_cha2_fk R
prog_completion_log.userid progcomplog_use2_fk R
prog_exception.userid progexce_use3_fk R
prog_extension.userid progexte_use3_fk R
prog_future_user_assignment.userid Implied Constraint R
prog_messagelog.userid progmess_use3_fk R
prog_user_assignment.userid Implied Constraint R
question.createdby ques_cre2_fk R
question.modifiedby ques_mod2_fk R
question_attempt_steps.userid quesattestep_use2_fk R
questionnaire_attempts.userid Implied Constraint R
questionnaire_response.userid Implied Constraint R
quickaccess_preferences.userid Implied Constraint R
quiz_attempts.userid quizatte_use2_fk R
quiz_grades.userid Implied Constraint R
quiz_overrides.userid quizover_use2_fk R
rating.userid rati_use2_fk R
reminder_sent.userid Implied Constraint R
report_builder_saved.userid repobuilsave_use3_fk R
report_builder_schedule.userid repobuilsche_use3_fk R
report_builder_schedule.usermodified repobuilsche_use4_fk R
report_builder_schedule_email_systemuser.userid repobuilscheemaisyst_use2_fk R
reportbuilder_grp_user_record.userid repogrpuserreco_use2_fk R
reportbuilder_grp_user_user.userid repogrpuseruser_use2_fk R
repository_instances.userid Implied Constraint R
role_assignments.userid roleassi_use2_fk R
role_capabilities.modifierid rolecapa_mod2_fk R
role_sortorder.userid rolesort_use2_fk R
scale.userid Implied Constraint R
scale_history.loggeduser scalhist_log2_fk R
scale_history.userid Implied Constraint R
scorm_aicc_session.userid scoraiccsess_use2_fk R
scorm_scoes_track.userid Implied Constraint R
sessions.userid sess_use2_fk R
stats_user_daily.userid Implied Constraint R
stats_user_monthly.userid Implied Constraint R
stats_user_weekly.userid Implied Constraint R
survey_analysis.userid Implied Constraint R
survey_answers.userid Implied Constraint R
tag.userid tag_use2_fk R
tool_monitor_history.userid Implied Constraint R
tool_monitor_rules.userid Implied Constraint R
tool_monitor_subscriptions.userid Implied Constraint R
tool_sitepolicy_localised_policy.authorid toolsitelocapoli_aut2_fk R
tool_sitepolicy_policy_version.publisherid toolsitepolivers_pub2_fk R
tool_sitepolicy_user_consent.userid toolsiteusercons_use2_fk R
totara_connect_sso_sessions.userid totaconnssosess_use2_fk R
totara_dashboard_user.userid totadashuser_use2_fk R
totara_userdata_export.userid totauserexpo_use2_fk R
totara_userdata_purge.usercontextid Implied Constraint R
totara_userdata_purge.userid totauserpurg_use2_fk R
totara_userdata_user.usercontextid Implied Constraint R
totara_userdata_user.userid totauseruser_use3_fk R
upgrade_log.userid upgrlog_use2_fk R
user_devices.userid userdevi_use2_fk R
user_enrolments.modifierid userenro_mod2_fk R
user_enrolments.userid userenro_use2_fk R
user_info_data.userid userinfodata_use3_fk R
user_lastaccess.userid userlast_use2_fk R
user_password_history.userid userpasshist_use2_fk R
user_password_resets.userid userpassrese_use2_fk R
user_preferences.userid userpref_use_fk R
user_private_key.userid userprivkey_use2_fk R
wiki_locks.userid Implied Constraint R
wiki_pages.userid Implied Constraint R
wiki_subwikis.userid Implied Constraint R
wiki_versions.userid Implied Constraint R
workshop_aggregations.userid workaggr_use2_fk R
workshop_assessments.gradinggradeoverby workasse_gra2_fk R
workshop_assessments.reviewerid workasse_rev2_fk R
workshop_submissions.authorid worksubm_aut2_fk R
workshop_submissions.gradeoverby worksubm_gra2_fk R
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
icq VARCHAR 15
skype VARCHAR 50
yahoo VARCHAR 50
aim VARCHAR 50
msn VARCHAR 50
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
url VARCHAR 255
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.
totarasync BIT 1 0

Totara sync flag from totara_sync

Table contained -1 rows

user table 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
user_tot_ix Performance Asc totarasync

user table relationships

Close relationships within degrees of separation