1
mdl_assignment – Defines assignments
======
Field NameTypeLenDec
------
id
course
name
description
format
resubmit
type
maxbytes
timedue
grade
timeodified
------
Total Bytes
Indexes:
mdl_assignment_submissions - Info about submitted assignments
======
Field NameTypeLenDec
------
id
assignment
userid
timecreated
timemodified
numfiles
grade
comment
teacher
timemarked
mailed
------
Total Bytes
Indexes:
mdl_backup_files - To store and recode ids to user and course files
======
Field NameTypeLenDec
------
backup_code
file_type
path
old_id
new_id
------
Total Bytes
Indexes:
mdl_backup_ids - To store and convert ids in backup/restore
======
Field NameTypeLenDec
------
backup_code
table_name
old_id
new_id
info
------
Total Bytes
Indexes:
mdl_chat - Each of these is a chat room
======
Field NameTypeLenDec
------
id
course
name
intro
keepdays
studentlogs
chattime
schedule
timemodified
------
Total Bytes
Indexes:
mdl_chat_messages - Stores all the actual chat messages
======
Field NameTypeLenDec
------
id
chatid
userid
system
message
timestamp
------
Total Bytes
Indexes:
mdl_chat_users - Keeps track of which users are in which chatrooms
======
Field NameTypeLenDec
------
id
chatid
userid
version
ip
firstping
lastping
lastmessageping
sid
------
Total Bytes
Indexes:
mdl_choice - Available choices are stored here
======
Field NameTypeLenDec
------
id
course
text
format
answer1
answer2
answer3
answer4
answer5
answer6
publish
timemodified
------
Total Bytes
Indexes:
mdl_choice_answers
======
Field NameTypeLenDec
------
id
choice
userid
answer
timemodified
------
Total Bytes
Indexes:
id Primary
mdl_config - Moodle configuration variables
======
Field NameTypeLenDec
------
id
name
value
------
Total Bytes
Indexes:
name Primary
mdl_course - Course information
======
Field NameTypeLenDec
------
id
category
sortorder
password
fullname
shortname
summary
format
showgrades
modinfo
newsitems
teacher
teachers
student
students
guest
startdate
numsections
showrecent
marker
visible
timecreated
timemodified
------
Total Bytes
Indexes:
category Primary
mdl_course_category - Course categories
======
Field NameTypeLenDec
------
id
name
description
parent
sortorder
coursecount
visible
timemodified
------
Total Bytes
Indexes:
id Primary
mdl_course_display - Stores info about how to display the course
======
Field NameTypeLenDec
------
id
course
userid
display
------
Total Bytes
Indexes:
id Primary
mdl_course_modules - Stores info about active course modules
======
Field NameTypeLenDec
------
id
course
module
instance
section
added
deleted
score
visible
------
Total Bytes
Indexes:
id Primary
mdl_course_sections - Stores info about individual course sections
======
Field NameTypeLenDec
------
id
course
section
summary
sequence
visible
------
Total Bytes
Indexes:
mdl_forum - Forums contain and structure discussion
======
Field NameTypeLenDec
------
id
course
type
name
intro
open
assessed
assesstimefinish
scale
forcesubscribe
timemodified
------
Total Bytes
Indexes:
id Primary
mdl_forum_discussions - Forums are composed of discussions
======
Field NameTypeLenDec
------
id
course
forum
name
firstpost
assessed
timemodified
------
Total Bytes
Indexes:
mdl_forum_posts - All posts are stored in this table
======
Field NameTypeLenDec
------
id
discussion
parent
userid
created
modified
mailed
subject
message
format
attachment
totalscore
------
Total Bytes
Indexes:
mdl_forum_ratings - Contains user ratings for individual posts
======
Field NameTypeLenDec
------
id
userid
post
time
rating
------
Total Bytes
Indexes:
mdl_forum_subscriptions - Keeps track of who is subscribed to what forum
======
Field NameTypeLenDec
------
id
userid
forum
------
Total Bytes
Indexes:
id Primary
mdl_journal - Stores info about user journals
======
Field NameTypeLenDec
------
id
course
name
intro
days
assessed
timemodified
------
Total Bytes
Indexes:
mdl_journal_entries - All the journal entries of all people
======
Field NameTypeLenDec
------
id
journal
userid
modified
text
format
rating
comment
teacher
timemarked
mailed
------
Total Bytes
Indexes:
mdl_log - Every action is logged as far as possible
======
Field NameTypeLenDec
------
id
time
userid
ip
course
module
action
url
info
------
Total Bytes
Indexes:
mdl_log_display - For a particular module/action, specifies a moodle table/file
======
Field NameTypeLenDec
------
module
action
mtable
field
------
Total Bytes
Indexes:
mdl_modules - Stores info about each module loaded into moodle
======
Field NameTypeLenDec
------
id
name
version
cron
lastcron
search
visible
------
Total Bytes
Indexes:
mdl_quiz - Main information about each quiz
======
Field NameTypeLenDec
------
idQuiz id - unique number quiz attempted
courseCourse the quiz is for
nameName of quiz
introMessage to user displayed under name
timeopenTime quiz is first available to user
timecloseTime quiz closes
attemptsNumber of attempts allowed
attemptonlastAttempt builds on last: yes/no
feedbackDisplay feedback upon completion: yes/no
correctanswersShow correct answers in feedback: yes/no
grademethodGrading method: i.e. highest, average
reviewAllow users to review their answers: yes/no
shuffleanswersShuffle answers so order is unique to each user: yes/no
questions
sumgrades
grade
timecreatedTime quiz was created
timemodifiedTime quiz was last modified
------
Total Bytes
Indexes:
mdl_quiz_answers - Answers with a fractional grade (0-1) and feedback
======
Field NameTypeLenDec
------
idQuiz id - unique number quiz attempted
questionQuestion id
answerCorrect answer
fractionHow right the answer is (0-1)
feedbackFeedback to display on grade report
------
Total Bytes
Indexes:
mdl_quiz_attempts - Stores various attempts on a quiz
======
Field NameTypeLenDec
------
idINT10Quiz id - unique number quiz attempted
quizQuiz number
useridINT10User id of student
sumgradesNumber of questions answered correctly
timestartINT10Time quiz started
timefinishINT10Time quiz finished
timemodifiedINT10Most recent time quiz grade modified
------
Total Bytes
Indexes:
mdl_quiz_categories - Categories are for grouping questions
======
Field NameTypeLenDec
------
id
course
name
info
publish
stamp
------
Total Bytes
Indexes:
mdl_quiz_grades - Final quiz grade (may be best of several attempts)
======
Field NameTypeLenDec
------
idUnique number quiz attempted
quizQuiz number
useridUser id of student
gradeFinal quiz grade displayed as a percentage
timemodifiedMost recent time quiz grade modified
------
Total Bytes
Indexes:
mdl_quiz_match - Defines fixed matching questions
======
Field NameTypeLenDec
------
id
question
subquestions
------
Total Bytes
Indexes:
question Primary
mdl_quiz_match_sub - Defines subquestions that make up a matching question
======
Field NameTypeLenDec
------
idQuiz id number
question
questiontextText of question as it appears to student
answertextCorresponding text of answer as it appears to student
------
Total Bytes
Indexes:
question Primary
mdl_quiz_multianswers - Options for multianswer questions
======
Field NameTypeLenDec
------
idQuiz id number
question
answers
positionkey
answertype
norm
------
Total Bytes
Indexes:
question Primary
mdl_quiz_multichoice - Options for multiple choice questions
======
Field NameTypeLenDec
------
id
question
layout
answers
single
------
Total Bytes
Indexes:
question Primary
mdl_quiz_numerical - Options for numerical questions
======
Field NameTypeLenDec
------
id
question
answer
min
max
------
Total Bytes
Indexes:
answer Primary
mdl_quiz_question_grades - The grade for a question in a quiz
======
Field NameTypeLenDec
------
id
quiz
question
grade
------
Total Bytes
Indexes:
mdl_quiz_questions - The quiz questions themselves
======
Field NameTypeLenDec
------
id
category
name
questiontext
image
defaultgrade
qtype
stamp
version
------
Total Bytes
Indexes:
mdl_quiz_randomsamatch - Info about random short-answer matching questions
======
Field NameTypeLenDec
------
id
question
choose
------
Total Bytes
Indexes:
question Primary
mdl_quiz_responses - Stores user responses to a quiz, and percentage grades
======
Field NameTypeLenDec
------
id
attempt
question
answer
grade
------
Total Bytes
Indexes:
mdl_quiz_shortanswer - Options for short answer questions
======
Field NameTypeLenDec
------
id
question
answers
usecase
------
Total Bytes
Indexes:
question Primary
mdl_quiz_truefalse - Options for true/false questions
======
Field NameTypeLenDec
------
id
question
trueanswer
falseanswer
------
Total Bytes
Indexes:
question Primary
mdl_resource
======
Field NameTypeLenDec
------
id
course
name
type
reference
summary
alltext
timemodified
------
Total Bytes
Indexes:
id Primary
mdl_scale - Defines grading scales
======
Field NameTypeLenDec
------
idGrade scale id
courseidCourse id number
useridUser id number
name
scale
descriptionDescription of the rgade scale
timemodifiedMost recent time grade scale modified
------
Total Bytes
Indexes:
mdl_survey - Contains data for all surveys
======
Field NameTypeLenDec
------
id
course
template
days
timecreated
timemodified
name
intro
questions
------
Total Bytes
Indexes:
mdl_survey_analysis
======
Field NameTypeLenDec
------
id
survey
userid
notes
------
Total Bytes
Indexes:
id Primary
mdl_survey_answers - Holds each user’s answers to the survey
======
Field NameTypeLenDec
------
id
userid
survey
question
time
answer1
answer2
------
Total Bytes
Indexes:
id Primary
mdl_survey_questions - Holds questions for each survey
======
Field NameTypeLenDec
------
id
text
shorttext
multi
intro
type
options
------
Total Bytes
Indexes:
mdl_user - Holds user information for for each person
======
Field NameTypeLenDec
------
idUser id number
confirmedConfirmed enrollment via e-mail: 1/0
deletedDeleted user: 1/0
usernameUsername
passwordEncrypted password
idnumber
firstnameUser’s first name
lastnameUser’s last name
emailUser’s e-mail address
icqUser’s icq chat name
phone1User’s primary phone number
phone2User’s secondary phone number
institution
department
addressUser’s street adress
cityUser’s city
countryUser’s country
langLanguage preferences chosen by user
timezoneTimezone user is located in: used for time updates and quiz records/logs
firstaccessDate and time user first accessed online account
lastaccessLast time the user was logged in
currentloginTime user currently logged in
lastIPLocation of most recent log in
secretAnswer to user’s secret question in case of lost pasword
pictureLocation/filename of user’s picture
url
descriptionDescripton of user, entered by user upon account activation
mailformatHTML or plaintext: 1/0
maildisplay
htmleditorHTML commands valid in user text fields: 1/0
autosubscribeAutomatically subscribe user to forums visited: 1/0
timemodifiedMost recent time user recor modified
------
Total Bytes
Indexes:
id Primary
mdl_user_admins - One record per administrative user
======
Field NameTypeLenDec
------
id
useridUser id number for administrator
------
Total Bytes
Indexes:
id Primary
mdl_user_coursecreators - One record per course creator
======
Field NameTypeLenDec
------
id
useridUser id number for course creator
------
Total Bytes
Indexes:
id Primary
mdl_user_students - Holds student information
======
Field NameTypeLenDec
------
id
useridStudent id number
courseCourse student enrolled in
timestart
timeend
time
------
Total Bytes
Indexes:
id Primary
mdl_user_teachers - One record per teacher per course
======
Field NameTypeLenDec
------
id
useridUser id number
courseCourse user ‘teaches’
authority
role
editall
timemodifiedMost recent time teacher record modified
------
Total Bytes
Indexes:
mdl_workshop - Defines workshop
======
Field NameTypeLenDec
------
id
course
name
description
nelements
phase
format
gradingstrategy
resubmit
agreeassessments
hidegrades
anonymous
includeself
maxbytes
deadline
grade
ntassessments
nsassessments
timemodified
------
Total Bytes
Indexes:
mdl_workshop_assessments - Info about assessments by teacher and students
======
Field NameTypeLenDec
------
id
workshopid
submissionid
userid
timecreated
timegraded
timeagreed
grade
gradinggrade
mailed
generalcomment
teachercomment
------
Total Bytes
Indexes:
mdl_workshop_comments - Defines comments
======
Field NameTypeLenDec
------
id
workshopid
assessmentid
userid
timecreated
mailed
comments
------
Total Bytes
Indexes:
mdl_workshop_elements - Info about marking scheme of assignments
======
Field NameTypeLenDec
------
id
workshopid
elementno
description
scale
maxscore
weight
------
Total Bytes
Indexes:
mdl_workshop_grades - Info about individual grades given to each element
======
Field NameTypeLenDec
------
id
workshopid
assessmentid
elementno
feedback
grade
------
Total Bytes
Indexes:
mdl_workshop_rubrics - Info about the rubrics marking scheme
======
Field NameTypeLenDec
------
id
workshopid
elementno
rubricno
description
------
Total Bytes
Indexes:
mdl_workshop_submissions - Info about submitted work from teacher and students
======
Field NameTypeLenDec
------
id
workshopid
userid
title
timecreated
mailed
teachergrade
peergrade
biasgrade
reliabilitygrade
gradinggrade
finalgrade
------
Total Bytes
Indexes:
title Primary