0 rows


Standard log table


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
eventname VARCHAR 255
component VARCHAR 100
action VARCHAR 100
target VARCHAR 100
objecttable VARCHAR 50 null
objectid BIGINT 19 null
crud VARCHAR 1
edulevel BIT 1 null
contextid BIGINT 19 null
context.id logsstanlog_con2_fkR
contextlevel BIGINT 19 null
contextinstanceid BIGINT 19 null
context.id Implied ConstraintR
userid BIGINT 19 null
user.id logsstanlog_use2_fkR
courseid BIGINT 19 null
course.id logsstanlog_cou2_fkR
relateduserid BIGINT 19 null
user.id logsstanlog_rel2_fkR
anonymous BIT 1 0

Was this event anonymous at the time of triggering?

other LONGTEXT 2147483647 null
timecreated BIGINT 19 null
origin VARCHAR 10 null

cli, cron, ws, etc.

ip VARCHAR 45 null

IP address

realuserid BIGINT 19 null
user.id logsstanlog_rea2_fkR

real user id when logged-in-as


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
logsstanlog_con_ix Performance Asc contextid
logsstanlog_cou_ix Performance Asc courseid
logsstanlog_couanotim_ix Performance Asc/Asc/Asc courseid + anonymous + timecreated
logsstanlog_rea_ix Performance Asc realuserid
logsstanlog_rel_ix Performance Asc relateduserid
logsstanlog_tim_ix Performance Asc timecreated
logsstanlog_use_ix Performance Asc userid
logsstanlog_useconconcruedu_ix Performance Asc/Asc/Asc/Asc/Asc/Asc userid + contextlevel + contextinstanceid + crud + edulevel + timecreated