Purpose: Used to add additional data to student accounts. This could be group information, preferences, sites, etc. It is based around academic years and module IDs.
Joins: users and schools tables.
| Field | Type | Purpose |
|---|---|---|
| userID | int(10) unsigned | The ID of the user that the metadata pertains to. |
| idMod | int(11) unsigned | The ID of the module that the metadata applies to. |
| type | varchar(255) | The name of the metadata field. |
| value | varchar(255) | The value of the metadata. |
| calendar_year | enum('2010/11', '2011/12', '2012/13', '2013/14', '2014/15', '2015/16', '2016/17', '2017/18', '2018/19', '2019/20') | Academic year the metadata applies to. |
The Information below is for an in development branch of Rogo
Purpose: Used to add additional data to student accounts. This could be group information, preferences, sites, etc. It is based around academic years and module IDs.
Version: 6.1
Joins: academic_year, users and schools tables.
| Field | Type | Purpose | Key |
|---|---|---|---|
| userID | int(10) unsigned | The ID of the user that the metadata pertains to. | |
| idMod | int(11) unsigned | The ID of the module that the metadata applies to. | |
| type | varchar(255) | The name of the metadata field. | |
| value | varchar(255) | The value of the metadata. | |
| calendar_year | int(4) | Academic year the metadata applies to. | FOREIGN KEY academic_year.calendar_year |