Totara Userdata Export Type Table Schema (totara_userdata_export_type)


Description

List of available user data export types

totara_userdata_export_type table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
totara_userdata_export.exporttypeid totauserexpo_exp2_fk R
totara_userdata_export_type_item.exporttypeid totauserexpotypeitem_exp2_fk R
fullname VARCHAR 1333

Human readable name, mutlilang supported

idnumber VARCHAR 255

Unique plain text identifier

description LONGTEXT 2147483647 null

HTML text with description of purging type

allowself BIT 1 0

Allow selection for self export

includefiledir BIT 1 0

Include file contents in export archive

usercreated BIGINT 19 null

Who added this type

timecreated BIGINT 19 null

When was this type added

timechanged BIGINT 19 null

Updated after very update

Table contained -1 rows

totara_userdata_export_type table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totauserexpotype_idn_uix Must be unique Asc idnumber

totara_userdata_export_type table relationships