# role

View table data

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