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
courseid BIGINT 19 null
course.id Implied ConstraintR
relateduserid BIGINT 19 null
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

real user id when logged-in-as


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
logsstanlog_con4_ix Performance Asc contextid
logsstanlog_couanotim2_ix Performance Asc/Asc/Asc courseid + anonymous + timecreated
logsstanlog_tim2_ix Performance Asc timecreated
logsstanlog_useconconcrued2_ix Performance Asc/Asc/Asc/Asc/Asc/Asc userid + contextlevel + contextinstanceid + crud + edulevel + timecreated