General help

what happened to the value "enrol_database" in the field/column called 'component' in role_assignment table?

I can't remember what the columns called context id, contextlevel, and itemid does and how they are tied to the type of enrolment for that student.

Here is my query

SELECT mra.id as MRAID, mra.roleid as mraroleid, mra.contextid as mracontextid, mra.userid, mra.component as componentlng, mra.itemid as mraitemid, mc.id as MCID, mc.contextlevel as mccontextlevel, mc.instanceid, mue.id, mue.status, mue.enrolid, mue.userid as theuserid

FROM
mdl_role_assignments mra, mdl_context mc, mdl_user_enrolments mue

WHERE
mra.roleid = '5' and
mra.contextid = mc.id and
mra.component = 'enrol_database' and
mra.itemid = mue.enrolid and
mra.itemid = 'xxxxxxx' and
mra.userid = mue.userid and
mc.contextlevel = '50';

thanks!