Totara Compl Import Cert Table Schema (totara_compl_import_cert)


Description

Intermediary file for importing certification completion data

totara_compl_import_cert table columns

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

id
certificationid BIGINT 19 √ null
certif.id Implied Constraint R

Certification ID if one exists
username VARCHAR 100 √ null

username
certificationshortname VARCHAR 255 √ null

certification shortname
certificationidnumber VARCHAR 100 √ null

certification id number
completiondate VARCHAR 10 √ null

completiondate
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 1 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 1 0

Imported into evidence
evidenceid BIGINT 19 √ null

The evidence table id
completiondateparsed BIGINT 19 √ null

completiondate parsed using csvdateformat
duedate VARCHAR 10 √ null
processed BIT 1 √ 0

Table contained -1 rows

totara_compl_import_cert table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totacompimpocert_evi_ix Performance Asc evidenceid
totacompimpocert_imp_ix Performance Asc importuserid
totacompimpocert_use_ix Performance Asc username

totara_compl_import_cert table relationships

Close relationships within degrees of separation