Database table descriptions¶
The tables are shown below in alphabetical order:
Stores the basic user information, such as username, password, email, name etc. This is a core Django framework table.
Stores the detail of the activities (pages/quizzes etc) associated with each section in a course.
Stores the detail of the badges that have been awarded to users, for the courses they have completed.
Links the badges awarded to a user to a specific version of the course.
Stores the detail of the badges that available to users.
Stores the detail of the courses available.
Stores the points that have been given to users for their engagement in activities.
Stores the detail of the sections of activities within a specific course.
Stores the detail of the activities and actions of a user.
Defines the specific fields that are displayed on the registration form.
Additional registration form fields that are not included in the auth_user table, but will be common almost all implementations.
Stores the detail of the user registration form responses for the profile_customfield entries.
Stores the detail of the quizzes and feedback a user has completed.
Stores the detail of the individual quiz and feedback responses a user has given for each quiz and feedback question.
Stores the individual quiz questions.
Stores the quizzes and feedback that are in the courses.
Links the quiz/feedback to the specific questions.
Stores the responses available for each quiz question.