app_user

2 rows


Description

One record for each person

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_user_id_seq'::regclass)
app_appraisal_history.userid Defined in XMLR
app_appraisal_role_assignment.userid Defined in XMLR
app_appraisal_scale.userid Defined in XMLR
app_appraisal_user_assignment.userid Defined in XMLR
app_appraisal_user_event.userid Defined in XMLR
app_assign_overrides.userid Defined in XMLR
app_assign_user_flags.userid Defined in XMLR
app_assign_user_mapping.userid Defined in XMLR
app_assignfeedback_editpdf_quick.userid Defined in XMLR
app_auth_approved_request.resolvedby Defined in XMLR
app_auth_approved_request.userid Defined in XMLR
app_auth_approved_request_snapshots.usersnapshot Defined in XMLR
app_auth_connect_sso_sessions.userid Defined in XMLR
app_auth_connect_users.userid Defined in XMLR
app_auth_oauth2_linked_login.userid Defined in XMLR
app_auth_oauth2_linked_login.usermodified Defined in XMLR
app_backup_controllers.userid Defined in XMLR
app_backup_trusted_files.userid Defined in XMLR
app_badge.usercreated Defined in XMLR
app_badge.usermodified Defined in XMLR
app_badge_backpack.userid Defined in XMLR
app_badge_backpack_oauth2.userid Defined in XMLR
app_badge_backpack_oauth2.usermodified Defined in XMLR
app_badge_criteria_met.userid Defined in XMLR
app_badge_issued.userid Defined in XMLR
app_badge_manual_award.issuerid Defined in XMLR
app_badge_manual_award.recipientid Defined in XMLR
app_block_totara_featured_links_tiles.userid Defined in XMLR
app_blog_external.userid Defined in XMLR
app_certif_completion.userid Defined in XMLR
app_certif_completion_history.userid Defined in XMLR
app_certificate_issues_history.userid Defined in XMLR
app_cohort_members.userid Defined in XMLR
app_cohort_msg_queue.modifierid Defined in XMLR
app_cohort_msg_queue.userid Defined in XMLR
app_cohort_plan_history.usercreated Defined in XMLR
app_cohort_role.usermodified Defined in XMLR
app_cohort_rule_collections.modifierid Defined in XMLR
app_cohort_rule_params.modifierid Defined in XMLR
app_cohort_rules.modifierid Defined in XMLR
app_cohort_rulesets.modifierid Defined in XMLR
app_cohort_visibility.usermodified Defined in XMLR
app_comments.userid Defined in XMLR
app_comp_criteria_record.userid Defined in XMLR
app_comp_record.assessorid Defined in XMLR
app_comp_record.userid Defined in XMLR
app_comp_record_history.userid Defined in XMLR
app_comp_template_assignment.usermodified Defined in XMLR
app_config_log.userid Defined in XMLR
app_course_completion_history.userid Defined in XMLR
app_course_completion_log.changeuserid Defined in XMLR
app_course_completion_log.userid Defined in XMLR
app_dp_objective_scale.usermodified Defined in XMLR
app_dp_objective_scale_value.usermodified Defined in XMLR
app_dp_plan.userid Defined in XMLR
app_dp_plan_competency_value.assessorid Defined in XMLR
app_dp_plan_competency_value.user_id Defined in XMLR
app_dp_plan_history.usermodified Defined in XMLR
app_dp_priority_scale.usermodified Defined in XMLR
app_dp_priority_scale_value.usermodified Defined in XMLR
app_dp_record_of_learning.userid Defined in XMLR
app_engage_answer_choice.userid Defined in XMLR
app_engage_bookmark.userid Defined in XMLR
app_engage_question.userid Defined in XMLR
app_engage_resource.userid Defined in XMLR
app_engage_resource_completion.userid Defined in XMLR
app_engage_share.ownerid Defined in XMLR
app_engage_share_recipient.sharerid Defined in XMLR
app_enrol_flatfile.userid Defined in XMLR
app_enrol_lti_users.userid Defined in XMLR
app_enrol_paypal.userid Defined in XMLR
app_events_queue.userid Defined in XMLR
app_external_services_users.userid Defined in XMLR
app_external_tokens.creatorid Defined in XMLR
app_external_tokens.userid Defined in XMLR
app_facetoface_asset.usercreated Defined in XMLR
app_facetoface_asset.usermodified Defined in XMLR
app_facetoface_facilitator.usercreated Defined in XMLR
app_facetoface_facilitator.userid Defined in XMLR
app_facetoface_facilitator.usermodified Defined in XMLR
app_facetoface_notification.usermodified Defined in XMLR
app_facetoface_notification_hist.userid Defined in XMLR
app_facetoface_notification_sent.userid Defined in XMLR
app_facetoface_room.usercreated Defined in XMLR
app_facetoface_room.usermodified Defined in XMLR
app_facetoface_room_virtualmeeting.userid Defined in XMLR
app_facetoface_session_roles.userid Defined in XMLR
app_facetoface_sessions.usermodified Defined in XMLR
app_facetoface_signups.managerid Defined in XMLR
app_facetoface_signups.userid Defined in XMLR
app_facetoface_signups_dates_status.createdby Defined in XMLR
app_facetoface_signups_status.createdby Defined in XMLR
app_feedback360.userid Defined in XMLR
app_feedback360_resp_assignment.userid Defined in XMLR
app_feedback360_scale.userid Defined in XMLR
app_feedback360_user_assignment.userid Defined in XMLR
app_feedback_completed_history.userid Defined in XMLR
app_files.userid Defined in XMLR
app_forum_digests.userid Defined in XMLR
app_forum_discussion_subs.userid Defined in XMLR
app_gap_aspirational.userid Defined in XMLR
app_goal_perform_status.status_changer_user_id Defined in XMLR
app_goal_perform_status.user_id Defined in XMLR
app_goal_personal.userid Defined in XMLR
app_goal_record.userid Defined in XMLR
app_goal_user_assignment.userid Defined in XMLR
app_grade_categories_history.loggeduser Defined in XMLR
app_grade_grades.userid Defined in XMLR
app_grade_grades.usermodified Defined in XMLR
app_grade_grades_history.loggeduser Defined in XMLR
app_grade_grades_history.userid Defined in XMLR
app_grade_grades_history.usermodified Defined in XMLR
app_grade_import_newitem.importer Defined in XMLR
app_grade_import_values.importer Defined in XMLR
app_grade_items_history.loggeduser Defined in XMLR
app_grade_outcomes.usermodified Defined in XMLR
app_grade_outcomes_history.loggeduser Defined in XMLR
app_grading_definitions.usercreated Defined in XMLR
app_grading_definitions.usermodified Defined in XMLR
app_grading_instances.raterid Defined in XMLR
app_groups_members.userid Defined in XMLR
app_job_assignment.appraiserid Defined in XMLR
app_job_assignment.userid Defined in XMLR
app_job_assignment.usermodified Defined in XMLR
app_lesson_overrides.userid Defined in XMLR
app_lti_submission_history.userid Defined in XMLR
app_marketplace_linkedin_user_progress.user_id Defined in XMLR
app_message_conversation_members.userid Defined in XMLR
app_message_user_actions.userid Defined in XMLR
app_messageinbound_messagelist.userid Defined in XMLR
app_messages.useridfrom Defined in XMLR
app_ml_recommender_users.user_id Defined in XMLR
app_notifiable_event_user_preference.user_id Defined in XMLR
app_notifications.useridto Defined in XMLR
app_pathway_manual_rating.assigned_by Defined in XMLR
app_pathway_manual_rating.user_id Defined in XMLR
app_pathway_perform_rating.rater_user_id Defined in XMLR
app_pathway_perform_rating.user_id Defined in XMLR
app_perform_element_linked_review_content.selector_id Defined in XMLR
app_perform_manual_relation_selector.user_id Defined in XMLR
app_perform_subject_instance.subject_user_id Defined in XMLR
app_perform_subject_instance_manual_participant.created_by Defined in XMLR
app_perform_subject_instance_manual_participant.user_id Defined in XMLR
app_perform_subject_static_instance.appraiser_id Defined in XMLR
app_perform_track_user_assignment.subject_user_id Defined in XMLR
app_persistent_login.userid Defined in XMLR
app_playlist.userid Defined in XMLR
app_playlist_resource.userid Defined in XMLR
app_portfolio_instance_user.userid Defined in XMLR
app_portfolio_log.userid Defined in XMLR
app_portfolio_tempdata.userid Defined in XMLR
app_post.usermodified Defined in XMLR
app_prog_completion.userid Defined in XMLR
app_prog_completion_history.userid Defined in XMLR
app_prog_completion_log.changeuserid Defined in XMLR
app_prog_completion_log.userid Defined in XMLR
app_prog_exception.userid Defined in XMLR
app_prog_extension.userid Defined in XMLR
app_prog_messagelog.userid Defined in XMLR
app_question.createdby Defined in XMLR
app_question.modifiedby Defined in XMLR
app_question_attempt_steps.userid Defined in XMLR
app_quiz_attempts.userid Defined in XMLR
app_quiz_overrides.userid Defined in XMLR
app_rating.userid Defined in XMLR
app_reaction.userid Defined in XMLR
app_report_builder_saved.userid Defined in XMLR
app_report_builder_schedule.userid Defined in XMLR
app_report_builder_schedule.usermodified Defined in XMLR
app_report_builder_schedule_email_systemuser.userid Defined in XMLR
app_reportbuilder_grp_user_record.userid Defined in XMLR
app_reportbuilder_grp_user_user.userid Defined in XMLR
app_role_assignments.userid Defined in XMLR
app_role_capabilities.modifierid Defined in XMLR
app_scale_history.loggeduser Defined in XMLR
app_scorm_aicc_session.userid Defined in XMLR
app_scorm_trusted_packages.uploadedby Defined in XMLR
app_sessions.userid Defined in XMLR
app_tag.userid Defined in XMLR
app_task_adhoc.userid Defined in XMLR
app_tenant.usercreated Defined in XMLR
app_tool_sitepolicy_localised_policy.authorid Defined in XMLR
app_tool_sitepolicy_policy_version.publisherid Defined in XMLR
app_tool_sitepolicy_user_consent.userid Defined in XMLR
app_totara_competency_achievement.user_id Defined in XMLR
app_totara_competency_aggregation_queue.user_id Defined in XMLR
app_totara_competency_assignment_user_logs.user_id Defined in XMLR
app_totara_competency_assignment_users.user_id Defined in XMLR
app_totara_competency_pathway_achievement.user_id Defined in XMLR
app_totara_connect_sso_sessions.userid Defined in XMLR
app_totara_core_mention.userid Defined in XMLR
app_totara_criteria_item_record.user_id Defined in XMLR
app_totara_dashboard_user.userid Defined in XMLR
app_totara_evidence_item.created_by Defined in XMLR
app_totara_evidence_item.modified_by Defined in XMLR
app_totara_evidence_item.user_id Defined in XMLR
app_totara_evidence_type.created_by Defined in XMLR
app_totara_evidence_type.modified_by Defined in XMLR
app_totara_mobile_devices.userid Defined in XMLR
app_totara_mobile_requests.userid Defined in XMLR
app_totara_msteams_user.userid Defined in XMLR
app_totara_msteams_user_settings.userid Defined in XMLR
app_totara_msteams_user_state.userid Defined in XMLR
app_totara_reportedcontent.complainer_id Defined in XMLR
app_totara_reportedcontent.reviewer_id Defined in XMLR
app_totara_reportedcontent.target_user_id Defined in XMLR
app_totara_userdata_export.userid Defined in XMLR
app_totara_userdata_purge.userid Defined in XMLR
app_totara_userdata_user.userid Defined in XMLR
app_upgrade_log.userid Defined in XMLR
app_user_devices.userid Defined in XMLR
app_user_enrolments.modifierid Defined in XMLR
app_user_enrolments.userid Defined in XMLR
app_user_info_data.userid Defined in XMLR
app_user_password_history.userid Defined in XMLR
app_user_password_resets.userid Defined in XMLR
app_user_private_key.userid Defined in XMLR
app_virtualmeeting.userid Defined in XMLR
app_virtualmeeting_auth.userid Defined in XMLR
app_workshop_aggregations.userid Defined in XMLR
app_workshop_assessments.gradinggradeoverby Defined in XMLR
app_workshop_assessments.reviewerid Defined in XMLR
app_workshop_submissions.authorid Defined in XMLR
app_workshop_submissions.gradeoverby Defined in XMLR
app_workspace.user_id Defined in XMLR
app_workspace_discussion.user_id Defined in XMLR
app_workspace_member_request.user_id Defined in XMLR
app_workspace_off_notification.user_id Defined in XMLR
auth varchar 20 'manual'::character varying
confirmed int2 5 0
policyagreed int2 5 0
deleted int2 5 0
suspended int2 5 0
mnethostid int8 19 1
username varchar 100 ''::character varying
password varchar 255 ''::character varying
idnumber varchar 255 ''::character varying
firstname varchar 100 ''::character varying
lastname varchar 100 ''::character varying
email varchar 100 ''::character varying
emailstop int2 5 0
skype varchar 50 ''::character varying
phone1 varchar 20 ''::character varying
phone2 varchar 20 ''::character varying
institution varchar 255 ''::character varying
department varchar 255 ''::character varying
address varchar 255 ''::character varying
city varchar 120 ''::character varying
country varchar 2 ''::character varying
lang varchar 30 'en'::character varying
calendartype varchar 30 'gregorian'::character varying
theme varchar 50 ''::character varying
timezone varchar 100 '99'::character varying
firstaccess int8 19 0
lastaccess int8 19 0
lastlogin int8 19 0
currentlogin int8 19 0
lastip varchar 45 ''::character varying
secret varchar 15 ''::character varying
picture int8 19 0
url varchar 255 ''::character varying
description text 2147483647 √ null
descriptionformat int2 5 1
mailformat int2 5 1
maildigest int2 5 0
maildisplay int2 5 2
autosubscribe int2 5 1
trackforums int2 5 0
timecreated int8 19 0
timemodified int8 19 0
trustbitmask int8 19 0
imagealt varchar 255 √ null
lastnamephonetic varchar 255 √ null
firstnamephonetic varchar 255 √ null
middlename varchar 255 √ null
alternatename varchar 255 √ null
totarasync int2 5 0
tenantid int8 19 √ null
app_tenant.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_user_id_pk Primary key Asc id
app_user_alt_ix Performance Asc alternatename
app_user_aut_ix Performance Asc auth
app_user_cit_ix Performance Asc city
app_user_con_ix Performance Asc confirmed
app_user_cou_ix Performance Asc country
app_user_del_ix Performance Asc deleted
app_user_ema_ix Performance Asc email
app_user_fir2_ix Performance Asc firstnamephonetic
app_user_fir_ix Performance Asc firstname
app_user_idn_ix Performance Asc idnumber
app_user_las2_ix Performance Asc lastaccess
app_user_las3_ix Performance Asc lastnamephonetic
app_user_las_ix Performance Asc lastname
app_user_mid_ix Performance Asc middlename
app_user_ten_ix Performance Asc tenantid
app_user_tot_ix Performance Asc totarasync
app_user_use_uix Must be unique Asc username

Check Constraints

Constraint Name Constraint
app_usermnethostid_enum ((mnethostid = 1))

Relationships

Close relationships within degrees of separation