|
|
### Database Tables
|
|
|
|
|
|
Tables required to fetch enrolled users depending on their course role.
|
|
|
|
|
|
#### mdl_user_enrolments
|
|
|
|
|
|
You can find API documentation for Enrolement API here:
|
|
|
https://moodledev.io/docs/4.4/apis/subsystems/enrol
|
|
|
|
|
|
```bash
|
|
|
Table "public.mdl_user_enrolments"
|
|
|
Column | Type | Collation | Nullable | Default
|
|
|
--------------+--------+-----------+----------+-------------------------------------------------
|
|
|
id | bigint | | not null | nextval('mdl_user_enrolments_id_seq'::regclass)
|
|
|
status | bigint | | not null | 0
|
|
|
enrolid | bigint | | not null |
|
|
|
userid | bigint | | not null |
|
|
|
timestart | bigint | | not null | 0
|
|
|
timeend | bigint | | not null | 2147483647
|
|
|
modifierid | bigint | | not null | 0
|
|
|
timecreated | bigint | | not null | 0
|
|
|
timemodified | bigint | | not null | 0
|
|
|
Indexes:
|
|
|
"mdl_userenro_id_pk" PRIMARY KEY, btree (id)
|
|
|
"mdl_userenro_enr_ix" btree (enrolid)
|
|
|
"mdl_userenro_enruse_uix" UNIQUE, btree (enrolid, userid)
|
|
|
"mdl_userenro_mod_ix" btree (modifierid)
|
|
|
"mdl_userenro_use_ix" btree (userid)
|
|
|
```
|
|
|
|
|
|
### mdl_role
|
|
|
|
|
|
```bash
|
|
|
Table "public.mdl_role"
|
|
|
Column | Type | Collation | Nullable | Default
|
|
|
-------------+------------------------+-----------+----------+--------------------------------------
|
|
|
id | bigint | | not null | nextval('mdl_role_id_seq'::regclass)
|
|
|
name | character varying(255) | | not null | ''::character varying
|
|
|
shortname | character varying(100) | | not null | ''::character varying
|
|
|
description | text | | not null |
|
|
|
sortorder | bigint | | not null | 0
|
|
|
archetype | character varying(30) | | not null | ''::character varying
|
|
|
Indexes:
|
|
|
"mdl_role_id_pk" PRIMARY KEY, btree (id)
|
|
|
"mdl_role_sho_uix" UNIQUE, btree (shortname)
|
|
|
"mdl_role_sor_uix" UNIQUE, btree (sortorder)
|
|
|
```
|
|
|
|
|
|
### mdl_role_assignment
|
|
|
|
|
|
```bash
|
|
|
Table "public.mdl_role_assignments"
|
|
|
Column | Type | Collation | Nullable | Default
|
|
|
--------------+------------------------+-----------+----------+--------------------------------------------------
|
|
|
id | bigint | | not null | nextval('mdl_role_assignments_id_seq'::regclass)
|
|
|
roleid | bigint | | not null | 0
|
|
|
contextid | bigint | | not null | 0
|
|
|
userid | bigint | | not null | 0
|
|
|
timemodified | bigint | | not null | 0
|
|
|
modifierid | bigint | | not null | 0
|
|
|
component | character varying(100) | | not null | ''::character varying
|
|
|
itemid | bigint | | not null | 0
|
|
|
sortorder | bigint | | not null | 0
|
|
|
Indexes:
|
|
|
"mdl_roleassi_id_pk" PRIMARY KEY, btree (id)
|
|
|
"mdl_roleassi_comiteuse_ix" btree (component, itemid, userid)
|
|
|
"mdl_roleassi_con_ix" btree (contextid)
|
|
|
"mdl_roleassi_rol_ix" btree (roleid)
|
|
|
"mdl_roleassi_rolcon_ix" btree (roleid, contextid)
|
|
|
"mdl_roleassi_sor_ix" btree (sortorder)
|
|
|
"mdl_roleassi_use_ix" btree (userid)
|
|
|
"mdl_roleassi_useconrol_ix" btree (userid, contextid, roleid)
|
|
|
```
|
|
|
|
|
|
|
|
|
|