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 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

Indexes

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

Relationships

Close relationships within degrees of separation