Log Table Schema (log)

Description

Every action is logged as far as possible

log table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

time

BIGINT

19

0

userid

BIGINT

19

0

user.id

Implied Constraint R

ip

VARCHAR

45

course

BIGINT

19

0

module

VARCHAR

20

cmid

BIGINT

19

0

action

VARCHAR

40

url

VARCHAR

100

info

VARCHAR

255

Showing 1 to 10 of 10 entries

Table contained -1 rows

log table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
log_act_ix	Performance	Asc	action
log_cmi_ix	Performance	Asc	cmid
log_coumodact_ix	Performance	Asc/Asc/Asc	course + module + action
log_tim_ix	Performance	Asc	time
log_usecou_ix	Performance	Asc/Asc	userid + course

Showing 1 to 6 of 6 entries

log table relationships

Close relationships within degrees of separation