access_log

Purpose: Records page accesses (student homepage, question-based feedback report, question-based feedback report, etc)

Joins: users table.

FieldTypePurpose
idint(11) unsignedPrimary Key – auto increment.
userIDint(11) unsignedID of the member of user accessing the page.
typevarchar(255)The type of page accessed.
accesseddatetimeThe time/date when the access occurred.
ipaddresschar(60)The IP address of the computer accessing the page.
pagevarchar(255)The URL of the page being accessed.