Totara Userdata Purge Item Table Schema (totara_userdata_purge_item)


Description

Items of each user data purge and their result

totara_userdata_purge_item table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
purgeid BIGINT 19 null
totara_userdata_purge.id totauserpurgitem_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

timestarted BIGINT 19 null

Start time of purging method

timefinished BIGINT 19 null

End time of purging method or time when marked as timed out

result BIGINT 19 null

null means not finished, -1 completed ok, -2 means error, -3 means skipped, -4 cancelled, -5 timed out

Table contained -1 rows

totara_userdata_purge_item table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totauserpurgitem_pur_ix Performance Asc purgeid

totara_userdata_purge_item table relationships