Totara Userdata Purge Type Table Schema (totara_userdata_purge_type)


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