user

0 rows


Description

One record for each person

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
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_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_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_community.userid block_community_erd_user_idR
block_recent_activity.userid block_recent_activity_erd_user_idR
block_recentlyaccesseditems.userid blocrece_use2_fkR
block_rss_client.userid Implied ConstraintR
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 Implied ConstraintR
competency_userevidencecomp.userevidenceid Implied ConstraintR
config_log.userid conflog_use2_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_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
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 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_log.userid Implied ConstraintR
mnet_session.userid Implied ConstraintR
mnetservice_enrol_enrolments.userid mnetenroenro_use2_fkR
my_pages.userid my_pages_erd_useridR
notifications.useridto noti_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
quiz_attempts.userid quizatte_use2_fkR
quiz_grades.userid Implied ConstraintR
quiz_overrides.userid quizover_use2_fkR
rating.userid rati_use2_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_user_idR
user_password_history.userid userpasshist_use2_fkR
user_password_resets.userid userpassrese_use2_fkR
user_preferences.userid user_preferences_erd_user_idR
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
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.

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