access_log

access_log

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

Joins: users table.

Field

Type

Purpose

Field

Type

Purpose

id

int(11) unsigned

Primary Key – auto increment.

userID

int(11) unsigned

ID of the member of user accessing the page.

type

varchar(255)

The type of page accessed.

accessed

datetime

The time/date when the access occurred.

ipaddress

char(60)

The IP address of the computer accessing the page.

page

varchar(255)

The URL of the page being accessed.