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