Purpose: Stores student/module enrolements.
Joins: users and modules tables.
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key – auto increment. |
| userID | int(10) unsigned | User ID of the student. |
| idMod | int(11) unsigned | Module ID of the module enroled on. |
| calendar_year | enum('2008/09','2009/10','2010/11','2011/12','2012/13','2013/14', '2014/15','2015/16','2016/17','2017/18','2018/19','2019/20') | Academic session. |
| attempt | tinyint(4) | 1=First Attempt, 2=Resit 1, 3=Resit 2. |
| auto_update | tinyint(4) | 1=update automatically from SMS system, 0=do not automatically update. |
| Warning |
|---|
The Information below is for an in development branch of RogoROGO 6.1.0+ |
Purpose: Stores student/module enrolements.Version: 6.1
Joins: academic_year, users and modules tables.
Field | Type | Purpose | Key |
|---|---|---|---|
| id | int(11) | auto increment. | PRIMARY KEY |
| userID | int(10) unsigned | User ID of the student. | |
| idMod | int(11) unsigned | Module ID of the module enroled on. | |
| calendar_year | int(4) | Academic year the metadata applies to. | FOREIGN KEY academic_year.calendar_year |
| attempt | tinyint(4) | 1=First Attempt, 2=Resit 1, 3=Resit 2. | |
| auto_update | tinyint(4) | 1=update automatically from SMS system, 0=do not automatically update. |