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