Totara Userdata Export Item Table Schema (totara_userdata_export_item)


Items of each user data export and their result

totara_userdata_export_item table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
exportid BIGINT 19 null totauserexpoitem_exp2_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_export_item table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totauserexpoitem_exp_ix Performance Asc exportid

totara_userdata_export_item table relationships