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_backup_controllers.userid Defined in XMLR
app_blog_external.userid Defined in XMLR
app_cohort_members.userid Defined in XMLR
app_config_log.userid Defined in XMLR
app_enrol_flatfile.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_files.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_mnetservice_enrol_enrolments.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_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_overrides.userid Defined in XMLR
app_rating.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_upgrade_log.userid Defined in XMLR
app_user_enrolments.modifierid Defined in XMLR
app_user_enrolments.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 32 ''::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
icq varchar 15 ''::character varying
skype varchar 50 ''::character varying
yahoo varchar 50 ''::character varying
aim varchar 50 ''::character varying
msn varchar 50 ''::character varying
phone1 varchar 20 ''::character varying
phone2 varchar 20 ''::character varying
institution varchar 40 ''::character varying
department varchar 30 ''::character varying
address varchar 70 ''::character varying
city varchar 120 ''::character varying
country varchar 2 ''::character varying
lang varchar 30 'en'::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 int2 5 0
url varchar 255 ''::character varying
description text 2147483647 null
descriptionformat int2 5 0
mailformat int2 5 1
maildigest int2 5 0
maildisplay int2 5 2
htmleditor int2 5 1
ajax int2 5 1
autosubscribe int2 5 1
trackforums int2 5 0
timecreated int8 19 0
timemodified int8 19 0
trustbitmask int8 19 0
imagealt varchar 255 null
screenreader int2 5 0
totarasync int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_user_id_pk Primary key Asc id
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_fir_ix Performance Asc firstname
app_user_idn_ix Performance Asc idnumber
app_user_las2_ix Performance Asc lastaccess
app_user_las_ix Performance Asc lastname
app_user_mneuse_uix Must be unique Asc/Asc mnethostid + username
app_user_tot_ix Performance Asc totarasync

Relationships