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: 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 |
enum('2010/11', '2011/12', '2012/13', '2013/14', '2014/15', '2015/16', '2016/17', '2017/18', '2018/19', '2019/20'| int(4) | Academic year the metadata applies to. | FOREIGN KEY academic_year.calendar_year |