app_log

0 rows


Description

Every action is logged as far as possible

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_log_id_seq'::regclass)
time int8 19 0
userid int8 19 0
ip varchar 45 ''::character varying
course int8 19 0
module varchar 20 ''::character varying
cmid int8 19 0
action varchar 40 ''::character varying
url varchar 100 ''::character varying
info varchar 255 ''::character varying

Indexes

Constraint Name Type Sort Column(s)
app_log_id_pk Primary key Asc id
app_log_act_ix Performance Asc action
app_log_cmi_ix Performance Asc cmid
app_log_coumodact_ix Performance Asc/Asc/Asc course + module + action
app_log_tim_ix Performance Asc time
app_log_usecou_ix Performance Asc/Asc userid + course

Relationships