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