modules_student

ROGO 6.1.0


Purpose: Stores student/module enrolements.

Joins: academic_yearusers and modules tables.

Field
Type
Purpose
Key
idint(11)auto increment.PRIMARY KEY
userIDint(10) unsignedUser ID of the student.
idModint(11) unsignedModule ID of the module enroled on.
calendar_yearint(4)Academic year the metadata applies to.FOREIGN KEY academic_year.calendar_year
attempttinyint(4)1=First Attempt, 2=Resit 1, 3=Resit 2.
auto_updatetinyint(4)1=update automatically from SMS system, 0=do not automatically update.