...
| column | type | description | used | indexed | can be removed |
|---|---|---|---|---|---|
| id | text | hash of userid, batchid and courseid and contentid | PK | ||
| batchid | text | ||||
| completedcount | int | how many time the content was completed | |||
| contentid | text | Y | |||
| contentversion | text | ||||
| courseid | text | Y | |||
| datetime | timestamp | ||||
| grade | text | N | Y | ||
lastaccesstime | text | ||||
| lastcompletedtime | text | ||||
| lastupdatedtime | text | ||||
| progress | int | progress pushed | |||
| result | text | N | Y | ||
| score | text | N | Y | ||
| status | int | 1 for progress 2 for completed | Y | ||
| userid | text | Y | |||
| viewcount | int | how many times user viewed the content |
user_courses (ES → usercourses)
| column | type | description | used | indexed | can be removed |
|---|---|---|---|---|---|
| id | text | hash of userid, batchid and courseid | PK | ||
| active | boolean | turns false when user unenroll | |||
| addedby | text | ||||
| batchid | text | Y | |||
| completedon | timestamp | ||||
| contentid | text | ||||
courseid | text | Y | |||
| courselogourl | text | Y | |||
| coursename | text | Y | Y | ||
| datetime | timestamp | ||||
| delta | text | N | Y | ||
| description | text | Y | |||
| enrolleddate | text | ||||
| grade | text | N | Y | ||
| lastreadcontentid | text | ||||
| lastreadcontentstatus | int | ||||
| leafnodescount | int | Y | |||
| progress | int | count of content completed | |||
| status | int | 1 for progress 2 for completed | Y | ||
| tocurl | text | Y | |||
| userid | text |