Totara Userdata Export Item Table Schema (totara_userdata_export_item)


Description

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
totara_userdata_export.id 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

Close relationships within degrees of separation