id |
BIGINT |
19 |
|
√ |
null |
|
|
|
coursemoduleid |
BIGINT |
19 |
|
|
null |
|
|
Activity that has been completed (or not). |
userid |
BIGINT |
19 |
|
|
null |
|
user.id
|
courmoducomp_use_fk R
|
|
ID of user who has (or hasn't) completed the activity. |
completionstate |
BIT |
1 |
|
|
null |
|
|
Whether or not the user has completed the activity. Available states: 0 = not completed if there's no row in this table, that also counts as 0 1 = completed 2 = completed, show passed 3 = completed, show failed |
viewed |
BIT |
1 |
√ |
|
null |
|
|
Tracks whether or not this activity has been viewed. NULL = we are not tracking viewed for this activity 0 = not viewed 1 = viewed |
overrideby |
BIGINT |
19 |
√ |
|
null |
|
|
Tracks whether this completion state has been set manually to override a previous state. |
timemodified |
BIGINT |
19 |
|
|
null |
|
|
Time at which the completion state last changed. |