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. |