Mnet Log Table Schema (mnet_log)


Description

Store session data from users migrating to other sites

mnet_log table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
hostid BIGINT 19 0

Unique host ID
remoteid BIGINT 19 0
time BIGINT 19 0
userid BIGINT 19 0
user.id Implied Constraint R
ip VARCHAR 45
course BIGINT 19 0
coursename VARCHAR 40
module VARCHAR 20
cmid BIGINT 19 0
action VARCHAR 40
url VARCHAR 100
info VARCHAR 255

Table contained -1 rows

mnet_log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mnetlog_hosusecou_ix Performance Asc/Asc/Asc hostid + userid + course

mnet_log table relationships

Close relationships within degrees of separation