Totara Userdata Purge Type Item Table Schema (totara_userdata_purge_type_item)


Description

Purge type items and their settings, each purge type has records for all items available at the time of saving changes

totara_userdata_purge_type_item table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
purgetypeid BIGINT 19 null
totara_userdata_purge_type.id totauserpurgtypeitem_pur2_fk R
component VARCHAR 100

Plugin name or subsystem, e.g. mod_glossary, core_user
name VARCHAR 100

Class name without namespace, e.g. comment, post, completion
purgedata BIT 1 null

0 means item skipped during purging, 1 means data to be purged
timecreated BIGINT 19 null

The time when item was added to the purge type, this might be interesting for newly introduced items in preexisting types.
timechanged BIGINT 19 null

Last time when the purge field was changed

Table contained -1 rows

totara_userdata_purge_type_item table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totauserpurgtypeitem_pur_ix Performance Asc purgetypeid
totauserpurgtypeitem_purco_uix Must be unique Asc/Asc/Asc purgetypeid + component + name

totara_userdata_purge_type_item table relationships

Close relationships within degrees of separation