Totara Userdata Purge Type Table Schema (totara_userdata_purge_type)


Description

List of available user data purge types

totara_userdata_purge_type table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
totara_userdata_purge.purgetypeid totauserpurg_pur2_fk R
totara_userdata_purge_type_item.purgetypeid totauserpurgtypeitem_pur2_fk R
totara_userdata_user.deletedpurgetypeid totauseruser_del2_fk R
totara_userdata_user.suspendedpurgetypeid totauseruser_sus2_fk R
userstatus BIT 1 null

Type is suitable for this user status only. Cannot be changed after creation, 0 means active, 1 deleted and 2 suspended
fullname VARCHAR 1333

Human readable name, mutlilang supported
idnumber VARCHAR 255

Unique plain text identifier
description LONGTEXT 2147483647 null

HTML text with description of purging type
allowmanual BIT 1 0

Allow use for manual purging
allowdeleted BIT 1 0

Allow selection for purging after deletion
allowsuspended BIT 1 0

Allow selection for purging after suspension
usercreated BIGINT 19 null

Who added this type
timecreated BIGINT 19 null

When was this type added
timechanged BIGINT 19 null

Updated only when user indicates that purges should be reapplied.

Table contained -1 rows

totara_userdata_purge_type table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totauserpurgtype_idn_uix Must be unique Asc idnumber

totara_userdata_purge_type table relationships

Close relationships within degrees of separation