Totara Userdata Export Table Schema (totara_userdata_export)


Description

List of all user data exports and their result

totara_userdata_export table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
totara_userdata_export_item.exportid totauserexpoitem_exp2_fk R
exporttypeid BIGINT 19 null
totara_userdata_export_type.id totauserexpo_exp2_fk R
origin VARCHAR 50

self keyword matching totara_userdata_purge_type allowxxxx columns, use other keyword for custom code
userid BIGINT 19 null
user.id totauserexpo_use2_fk R

The target user
contextid BIGINT 19 null
context.id Implied Constraint R

Context restriction will be used for exporting user data from one course or activity, null means the whole system
usercreated BIGINT 19 √ null

Usually the user that request the export
timecreated BIGINT 19 null

Time when user requested the export
timestarted BIGINT 19 √ null

Start of export process, this happens in ad-hoc task
timefinished BIGINT 19 √ null

End of export or time when marked as timed out, this is also used to export old files
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 table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totauserexpo_exp_ix Performance Asc exporttypeid
totauserexpo_use_ix Performance Asc userid

totara_userdata_export table relationships

Close relationships within degrees of separation