app_user

Columns

Related columns Constraint Comments

Search:

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_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_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_evidence_type.usermodified	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_evidence.userid	Defined in XMLR
app_dp_plan_evidence.usermodified	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_enrol_flatfile.userid	Defined in XMLR
app_enrol_lti_users.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_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_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_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_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_messageinbound_messagelist.userid	Defined in XMLR
app_mnetservice_enrol_enrolments.userid	Defined in XMLR
app_persistent_login.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_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_role_sortorder.userid	Defined in XMLR
app_scale_history.loggeduser	Defined in XMLR
app_scorm_aicc_session.userid	Defined in XMLR
app_sessions.userid	Defined in XMLR
app_tag.userid	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_connect_sso_sessions.userid	Defined in XMLR
app_totara_dashboard_user.userid	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_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

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

0

username

varchar

100

''::character varying

password

varchar

255

''::character varying

idnumber

varchar

255

''::character varying

Showing 1 to 10 of 54 entries

Indexes

Search:

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

Showing 1 to 10 of 17 entries

Relationships

Close relationships within degrees of separation

One
Two degrees

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation