users_metadata

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