log

0 rows


Description

Every action is logged as far as possible

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
time BIGINT 19 0
userid BIGINT 19 0
user.id log_erd_useridR
ip VARCHAR 45
course BIGINT 19 0
module VARCHAR 20
cmid BIGINT 19 0
action VARCHAR 40
url VARCHAR 100
info VARCHAR 255

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
log_act_ix Performance Asc action
log_cmi_ix Performance Asc cmid
log_coumodact_ix Performance Asc/Asc/Asc course + module + action
log_tim_ix Performance Asc time
log_usecou_ix Performance Asc/Asc userid + course

Relationships