logstore_standard_log

0 rows


Description

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_fkR
contextlevel BIGINT 19 null
contextinstanceid BIGINT 19 null
context.id Implied ConstraintR
userid BIGINT 19 null
user.id Implied ConstraintR
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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
logsstanlog_con2_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

Relationships

Close relationships within degrees of separation