Totara Sync Log Table Schema (totara_sync_log)


Description

log table for totara element syncing

totara_sync_log table columns

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

unix time

element VARCHAR 60

element name

logtype VARCHAR 60 √ null

log type

action VARCHAR 60 √ null

action performed

info VARCHAR 255 √ null

log entry info message

runid BIGINT 19 0

Run Batch ID

Table contained -1 rows

totara_sync_log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totasynclog_act_ix Performance Asc action
totasynclog_ele_ix Performance Asc element
totasynclog_log_ix Performance Asc logtype
totasynclog_run_ix Performance Asc runid
totasynclog_tim_ix Performance Asc time