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

Close relationships within degrees of separation