...
| Status | ||||||
|---|---|---|---|---|---|---|
|
...
Purpose: Stores student/module enrolements.
...
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. |