2 rows


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


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


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