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 Implied ConstraintR
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
shortname VARCHAR 100
description LONGTEXT 2147483647 null
sortorder BIGINT 19 0
archetype VARCHAR 30

Indexes

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

Relationships

Close relationships within degrees of separation