Totara Userdata Export Type Item Table Schema (totara_userdata_export_type_item)


Description

Export type items and their settings, each export type has records for all items available at the time of saving changes

totara_userdata_export_type_item table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
exporttypeid BIGINT 19 null
totara_userdata_export_type.id totauserexpotypeitem_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
exportdata BIT 1 null

0 means item skipped during export, 1 means data to be exported
timecreated BIGINT 19 null

The time when item was added to the export type, this might be interesting for newly introduced items in preexisting types.
timechanged BIGINT 19 null

Last time when the export field was changed

Table contained -1 rows

totara_userdata_export_type_item table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totauserexpotypeitem_exp_ix Performance Asc exporttypeid
totauserexpotypeitem_expco_uix Must be unique Asc/Asc/Asc exporttypeid + component + name

totara_userdata_export_type_item table relationships

Close relationships within degrees of separation