app_logstore_standard_log

0 rows


Description

Standard log table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_logstore_standard_log_id_seq'::regclass)
eventname varchar 255 ''::character varying
component varchar 100 ''::character varying
action varchar 100 ''::character varying
target varchar 100 ''::character varying
objecttable varchar 50 null
objectid int8 19 null
crud varchar 1 ''::character varying
edulevel int2 5 null
contextid int8 19 null
app_context.id Defined in XMLR
contextlevel int8 19 null
contextinstanceid int8 19 null
userid int8 19 null
courseid int8 19 null
relateduserid int8 19 null
anonymous int2 5 0
other text 2147483647 null
timecreated int8 19 null
origin varchar 10 null
ip varchar 45 null
realuserid int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_logsstanlog_id_pk Primary key Asc id
app_logsstanlog_con_ix Performance Asc contextid
app_logsstanlog_couanotim_ix Performance Asc/Asc/Asc courseid + anonymous + timecreated
app_logsstanlog_tim_ix Performance Asc timecreated
app_logsstanlog_useconconcr_ix Performance Asc/Asc/Asc/Asc/Asc/Asc userid + contextlevel + contextinstanceid + crud + edulevel + timecreated

Relationships