Logstore Standard Log Table Schema (logstore_standard_log)


Standard log table

logstore_standard_log table columns

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_fk R
contextlevel BIGINT 19 null
contextinstanceid BIGINT 19 null
context.id Implied Constraint R
userid BIGINT 19 null
user.id Implied Constraint R
courseid BIGINT 19 null
course.id Implied Constraint R
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

Table contained -1 rows

logstore_standard_log table indexes

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

logstore_standard_log table relationships