Totara Compl Import Course Table Schema (totara_compl_import_course)


Description

Intermediary file for importing course completion data

totara_compl_import_course table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null

id

courseid BIGINT 19 null
course.id Implied Constraint R

Course id if one exists

username VARCHAR 100 null

username

courseshortname VARCHAR 255 null

course shortname

courseidnumber VARCHAR 100 null

course idnumber

completiondate VARCHAR 10 null

completiondate

grade VARCHAR 10 null

grade

customfields LONGTEXT 2147483647 null

Any custom field data

timecreated BIGINT 19 null

Time the record was imported into this table

timeupdated BIGINT 19 0

Time the record was added to the system

importuserid BIGINT 19 null

ID of user running the import

importerror BIT 0 0

true/false if there were any errors

importerrormsg LONGTEXT 2147483647 null

Any error messages for this record

rownumber BIGINT 19 null

Row number in the csv file

importevidence BIT 0 0

imported into evidence

evidenceid BIGINT 19 null

The evidence table id

completiondateparsed BIGINT 19 null

completiondate parsed using csvdateformat

Table contained -1 rows

totara_compl_import_course table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totacompimpocour_evi_ix Performance Asc evidenceid
totacompimpocour_imp_ix Performance Asc importuserid
totacompimpocour_use_ix Performance Asc username

totara_compl_import_course table relationships