role

0 rows


Description

moodle roles

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
badge_manual_award.issuerrole badgmanuawar_iss4_fkR
enrol.roleid enro_rol2_fkR
enrol_flatfile.roleid enroflat_rol2_fkR
mnetservice_enrol_courses.roleid Implied ConstraintR
role_allow_assign.allowassign rolealloassi_all2_fkR
role_allow_assign.roleid rolealloassi_rol2_fkR
role_allow_override.allowoverride rolealloover_all2_fkR
role_allow_override.roleid rolealloover_rol2_fkR
role_allow_switch.allowswitch rolealloswit_all2_fkR
role_allow_switch.roleid rolealloswit_rol2_fkR
role_allow_view.allowview rolealloview_all2_fkR
role_allow_view.roleid rolealloview_rol2_fkR
role_assignments.roleid roleassi_rol2_fkR
role_capabilities.roleid rolecapa_rol2_fkR
role_context_levels.roleid rolecontleve_rol2_fkR
role_names.roleid rolename_rol2_fkR
stats_daily.roleid Implied ConstraintR
stats_monthly.roleid Implied ConstraintR
stats_user_daily.roleid Implied ConstraintR
stats_user_monthly.roleid Implied ConstraintR
stats_user_weekly.roleid Implied ConstraintR
stats_weekly.roleid Implied ConstraintR
tool_cohortroles.roleid Implied ConstraintR
tool_dataprivacy_purposerole.roleid tooldatapurp_rol2_fkR
name VARCHAR 255

Empty names are automatically localised

shortname VARCHAR 100
description LONGTEXT 2147483647 null

Empty descriptions may be automatically localised

sortorder BIGINT 19 0
archetype VARCHAR 30

Role archetype is used during install and role reset, marks admin role and helps in site settings

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
role_sho_uix Must be unique Asc shortname
role_sor_uix Must be unique Asc sortorder

Relationships