users_metadata
- Neill Magill
Owned by Neill Magill
Oct 25, 2022
1 min read
Loading data...
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.
| 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 |