/
users_metadata

This space is archived

For current information please use the current ExamSys documentation

users_metadata

Owned by Joseph Baxter
Last updated: Mar 21, 2018

ROGO 6.1.0


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.

FieldTypePurposeKey
userIDint(10) unsignedThe ID of the user that the metadata pertains to.
idModint(11) unsignedThe ID of the module that the metadata applies to.
typevarchar(255)The name of the metadata field.
valuevarchar(255)The value of the metadata.
calendar_yearint(4)Academic year the metadata applies to.FOREIGN KEY academic_year.calendar_year

Related content