app_totara_userdata_user

2 rows


Description

Extension of user table for tracking of selected purging types for each user - 1 to 1 mapping to user table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_userdata_user_id_seq'::regclass)
userid int8 19 null
app_user.id Defined in XMLR
usercontextid int8 19 √ null
suspendedpurgetypeid int8 19 √ null
app_totara_userdata_purge_type.id Defined in XMLR
timesuspended int8 19 √ null
timesuspendedpurged int8 19 √ null
deletedpurgetypeid int8 19 √ null
app_totara_userdata_purge_type.id Defined in XMLR
timedeleted int8 19 √ null
timedeletedpurged int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_totauseruser_id_pk Primary key Asc id
app_totauseruser_del_ix Performance Asc deletedpurgetypeid
app_totauseruser_sus_ix Performance Asc suspendedpurgetypeid
app_totauseruser_use2_ix Performance Asc userid
app_totauseruser_use_uix Must be unique Asc userid

Relationships

Close relationships within degrees of separation