app_totara_compl_import_course

0 rows


Description

Intermediary file for importing course completion data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_totara_compl_import_course_id_seq'::regclass)
courseid int8 19 null
username varchar 100 null
courseshortname varchar 255 null
courseidnumber varchar 100 null
completiondate varchar 10 null
grade varchar 10 null
customfields text 2147483647 null
timecreated int8 19 null
timeupdated int8 19 0
importuserid int8 19 null
importerror int2 5 0
importerrormsg text 2147483647 null
rownumber int8 19 null
importevidence int2 5 0
evidenceid int8 19 null
completiondateparsed int8 19 null
processed int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_totacompimpocour_id_pk Primary key Asc id
app_totacompimpocour_evi_ix Performance Asc evidenceid
app_totacompimpocour_imp_ix Performance Asc importuserid
app_totacompimpocour_tim_ix Performance Asc timecreated
app_totacompimpocour_use_ix Performance Asc username

Relationships