Logstore Standard Log Table Schema (logstore_standard_log)


Description

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

Close relationships within degrees of separation