# user_enrolments

0 rows

### Description

Users participating in courses (aka enrolled users) - everybody who is participating/visible in course, that means both teachers and students

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
status | BIGINT | 19 |  |  | 0 |  |  | 0..9 are system constants, 0 means active participation, see ENROL_PARTICIPATION_* constants, plugins may define own status greater than 10
enrolid | BIGINT | 19 |  |  | null |  |
enrol.id | userenro_enr2_fkR
userid | BIGINT | 19 |  |  | null |  |
user.id | userenro_use2_fkR
timestart | BIGINT | 19 |  |  | 0 |  |  |
timeend | BIGINT | 19 |  |  | 2147483647 |  |  |
modifierid | BIGINT | 19 |  |  | 0 |  |
user.id | userenro_mod2_fkR
timecreated | BIGINT | 19 |  |  | 0 |  |  |
timemodified | BIGINT | 19 |  |  | 0 |  |  |

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
userenro_enr_ix | Performance | Asc | enrolid
userenro_enruse_uix | Must be unique | Asc/Asc | enrolid + userid
userenro_mod_ix | Performance | Asc | modifierid
userenro_use_ix | Performance | Asc | userid

### Relationships