Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
confirmed tinyint(1) No 0
deleted tinyint(1) No 0
username varchar(100) No
password varchar(32) No
idnumber varchar(12) Yes NULL
firstname varchar(20) No
lastname varchar(20) No
email varchar(100) No
icq varchar(15) Yes NULL
phone1 varchar(20) Yes NULL
phone2 varchar(20) Yes NULL
institution varchar(40) Yes NULL
department varchar(30) Yes NULL
address varchar(70) Yes NULL
city varchar(20) Yes NULL
country char(2) Yes NULL
lang varchar(5) Yes en
timezone float No 99
firstaccess int(10) UNSIGNED No 0
lastaccess int(10) UNSIGNED No 0
lastlogin int(10) UNSIGNED No 0
currentlogin int(10) UNSIGNED No 0
lastIP varchar(15) Yes NULL
secret varchar(15) Yes NULL
picture tinyint(1) Yes NULL
url varchar(255) Yes NULL
description text Yes NULL
mailformat tinyint(1) UNSIGNED No 1
maildisplay tinyint(2) UNSIGNED No 2
htmleditor tinyint(1) UNSIGNED No 1
autosubscribe tinyint(1) UNSIGNED No 1
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
username UNIQUE username
id UNIQUE id
Comment
One record per user
Description
User ID
Self registration - confirmed via email 1 =
yes - 0 = no
0 No - 1 Yes
Encrypted password
Matricola
Timezone user is located in: used for time
updates and quiz records/logs. 99 =
servertimezone / +1 +1,5 +2 … -1 -1,5 -2
…
first time login. In self registration=time
registered. If account was created by
admin = 0
every change (modify account =
timemodified)
Is the last access a user did before the
current access ("history" of last access)
first time logged in this session
Last ip used (if login this become your
current IP)
Used for self Registration confirmation
"code"(e-mail…)
User description
0= Text only - 1= HTML
0 = hide my real email adress from
everyone - 1 = allow everyone to see my
email adress - 2 = Allow only other course
members to see my email adress
0 = Use standard web forms - 1 = use
HTML text editors
Autosubscribe to form when posting
messages 1=yes - 0=no
Last time modified
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
One record per administrator user
Description
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
One record per course creator
Description
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
name varchar(50) No
value varchar(255) No
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
userid
useridname INDEX name
Comment
Allows modules to store arbitrary user preferences
Description
Foreign Key mdl_user.id
?
?
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
course int(10) UNSIGNED No 0
timestart int(10) UNSIGNED No 0
timeend int(10) UNSIGNED No 0
time int(10) UNSIGNED No 0
timeaccess int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
course
courseuserid INDEX userid
Comment
Is the relation course-students
Description
Foreign Key mdl_user.id
Foreign Key mdl_course.id
Last access to course as student
Field Type Null
Attributes Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
course int(10) UNSIGNED No 0
authority int(10) No 3
role varchar(40) No
editall int(1) UNSIGNED No 1
timemodified int(10) UNSIGNED No 0
timeaccess int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
course
courseuserid INDEX userid
Comment
Is the relation course-students
Description
Foreign Key mdl_user.id
Foreign Key mdl_course.id
Most recent time teacher record modified
Last time accessed to course as teacher
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
intro text No
timeopen int(10) UNSIGNED No 0
timeclose int(10) UNSIGNED No 0
attempts smallint(6) No 0
attemptonlast tinyint(4) No 0
feedback tinyint(4) No 0
correctanswers tinyint(4) No 1
grademethod tinyint(4) No 1
review tinyint(4) No 0
shufflequestions tinyint(4) No 0
shuffleanswers tinyint(4) No 0
questions text No
sumgrades int(10) No 0
grade int(10) No 0
timecreated int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Main information about each quiz
Definition of Quiz:
This module allows you to design and set quiz tests, consisting of multiple choice, true-false, and short answe
These questions are kept in a categorised database, and can be re-used within courses and even between co
can allow multiple attempts. Each attempt is automatically marked, and the teacher can choose whether to gi
show correct answers. This module includes grading facilities.
Description
Quiz id
Foreign Key mdl_course.id
Quiz name
Message to user displayed under name
Time quiz is first available to user
Time quiz closes
Number of attempts allowed: 0=unlimited
Attempt builds on last: yes/no: 1/0
yes/no: 1:0
show correct answre in feedback yes/no: 1/0
Grading method: highest, average, first
attempt, last attempt (1,2,3,4)
Allow user to review thier answers yes/no:
1/0
shuffle questions (0,1)
shuffle answers(0,1)
Foreign Key mdl_quiz_questions.id
separator ',' i.e. 1,2,4
Sum of grade for each question =
Sum(mdl_quiz_question_grades.grade)
where mdl_quiz.id =
mdl_quiz_question_grades.quiz
Grade for this Quiz
time quiz was created
time quiz was modified
f multiple choice, true-false, and short answer questions.
re-used within courses and even between courses. Quizzes
d, and the teacher can choose whether to give feedback or to
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
answer varchar(255) No
fraction varchar(10) No 0.0
feedback text No
Index
Keyname Type Field
PRIMARY PRIMARY id
question INDEX question
Comment
Answers, with a fractional grade (0-1) and feedback
Description
Foreign Key mdl_quiz.id
Answer to the question
How right the anwser is (0-1)
Feedback on the answer
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
info text No
publish tinyint(4) No 0
stamp varchar(255) No
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Categories are for grouping questions
Description
Foreign Key mdl_course.id
Category Name
Description of the category
yes/no: 1/0
?
Field Type Attributes Null Default Extra
id int(10) No auto_increment
category int(10) No 0
name varchar(255) No
questiontext text No
image varchar(255) No
defaultgrade int(10) UNSIGNED No 1
qtype smallint(6) No 0
stamp varchar(255) No
version int(10) No 1
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
The quiz questions themselves
Description
Foreign Key mdl_quiz_category.id
Question name
Question text
Default grade for question type 7,9 = 0, the
others = 1
Question Type (3=Multiple Choice,
2=True/False, 1=Short Answer,
8=Numerical, 5=Matching, 7=Description,
4=Random Question, 6=Random Short-
Answer Matching, 9=Embedded Answers
(Cloze))
?
Version - Times Modified
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
quiz int(10) UNSIGNED No 0
question int(10) UNSIGNED No 0
grade smallint(6) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
quiz INDEX quiz
question INDEX question
Comment
The grade for a question in a quiz
Description
Foreign Key mdl_quiz.id
Foreign Key mdl_quiz_questions.id
grade of the question
Field Type Null
Attributes Default Extra
id int(10) UNSIGNED No auto_increment
quiz int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
attempt smallint(6) No 0
sumgrades varchar(10) No 0.0
timestart int(10) UNSIGNED No 0
timefinish int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
quiz INDEX quiz
userid INDEX userid
Comment
Stores various attempts on a quiz
Description
Foreign Key mdl_quiz.id
Foreign Key mdl_user.id
number of attempt --> old_attempt + 1
total score
Time Started
Time Finished
?
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
quiz int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
grade varchar(10) No 0.0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
quiz INDEX quiz
userid INDEX userid
Comment
Final quiz grade (may be best of several attempts)
Description
Foreign Key mdl_quiz.id
Foreign Key mdl_user.id
copy or average of
mdl_quiz_attempts.grade for this userid
copy or average of
mdl_quiz_attempts.timemodified or
timefinished for this userid
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
subquestions varchar(255) No
Index
Keyname Type Field
PRIMARY PRIMARY id
question INDEX question
Comment
Defines fixed matching questions
Description
Foreign Key mdl_quiz.id
Foreign Key mdl_quiz_match_sub.id
separator ',' i.e. 1,2,4
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
questiontext text No
answertext varchar(255) No
Index
Keyname Type Field
PRIMARY PRIMARY id
question INDEX question
Comment
Defines the subquestions that make up a matching question
Description
Foreign Key mdl_quiz_questions.id
Text of question
Correct answer of question
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
layout tinyint(4) No 0
answers varchar(255) No
single tinyint(4) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
question INDEX question
Comment
Options for multiple choice questions
Description
Foreign Key mdl_quiz_questions.id
?
Foreign Key mdl_quiz_answers.id
separator ',' i.e. 1,2,4
single/multy : 1/0
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
answer int(10) UNSIGNED No 0
min varchar(255) No
max varchar(255) No
Index
Keyname Type Field
PRIMARY PRIMARY id
answer INDEX answer
Comment
Options for numerical questions
Description
Foreign Key mdl_quiz_questions.id
Foreign Key mdl_quiz_answers.id
separator ',' i.e. 1,2,4
equal to mdl_quiz_answer.answer - delta delta is set during the creation of the question
equal to mdl_quiz_answer.answer + delta
eation of the question
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
answers varchar(255) No
usecase tinyint(2) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
question INDEX question
Comment
Options for short answer questions
Description
Foreign Key mdl_quiz_questions.id
Foreign Key mdl_quiz_answers.id
separator ',' i.e. 1,2,4
Case sensitive answer? Yes/no: 1/0
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
trueanswer int(10) UNSIGNED No 0
falseanswer int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
question INDEX question
Comment
Options for True-False questions
Description
Foreign Key mdl_quiz_questions.id
Foreign Key mdl_quiz_answers.id
Foreign Key mdl_quiz_answers.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
choose int(10) UNSIGNED No 4
Index
Keyname Type Field
PRIMARY PRIMARY id
question INDEX question
Comment
Info about a random short-answer matching question
Description
Foreign Key mdl_quiz_questions.id
How many question take from
mdl_quiz_shortanswer
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
attempt int(10) UNSIGNED No 0
question int(10) UNSIGNED No 0
answer varchar(255) No
grade varchar(10) No 0.0
Index
Keyname Type Field
PRIMARY PRIMARY id
attempt INDEX attempt
question INDEX question
Comment
Stores user responses to a quiz, and percentage grades
Description
Foreign Key mdl_quiz_attempts.id
Foreign Key mdl_quiz_questions.id
The answer given to the question
The grade for this question
(=mdl_quiz_answer.fraction *
mdl_quiz_question_grade.grade where
mdl_quiz_question.id =
mdl_quiz_question_grade.question)
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
question int(10) UNSIGNED No 0
answers varchar(255) No
positionkey varchar(255) No
answertype smallint(6) No 0
norm int(10) UNSIGNED No 1
Index
Keyname Type Field
PRIMARY PRIMARY id
question INDEX question
Comment
Options for multianswer questions
Description
Foreign Key mdl_quiz_questions.id
?
?
?
?
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
intro text No
keepdays int(11) No 0
studentlogs int(4) No 0
chattime int(10) UNSIGNED No 0
schedule int(4) No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Each of these is a chat room
Definition of Chat
The Chat module allows participants to have a real-time synchronous discussion via the web. This is a useful
different understanding of each other and the topic being discussed - the mode of using a chat room is quite d
asynchronous forums. The Chat module contains a number of features for managing and reviewing chat disc
Description
Foreign Key mdl_quiz_course.id
Chat Name
Intro Text
Keep log for X days: 0=unlimited
Everyone can view past sessions: yes/no:
1/0
Start Chat Time (date - time)
0=Don't publish any chat time, 1=No repeat
publish only that chat time, 2=every day,
3=every week
Time modified
nous discussion via the web. This is a useful way to get a
ed - the mode of using a chat room is quite different from the
atures for managing and reviewing chat discussions.
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
chatid int(10) No 0
userid int(10) No 0
system int(1) UNSIGNED No 0
message text No
timestamp int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
timestamp
timemodifiedchat INDEX chatid
Comment
Stores all the actual chat messages
Description
Foreign Key mdl_chat.id
Foreign Key mdl_user.id
?
Message text
Message sent time
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
chatid int(11) No 0
userid int(11) No 0
version varchar(16) No
ip varchar(15) No
firstping int(10) UNSIGNED No 0
lastping int(10) UNSIGNED No 0
lastmessageping int(10) UNSIGNED No 0
sid varchar(32) No
Index
Keyname Type Field
PRIMARY PRIMARY id
userid INDEX userid
lastping INDEX lastping
Comment
Dinamic table, Keeps track of which users are in which chat rooms
Description
Foreign Key mdl_chat.id
Foreign Key mdl_user.id
?
Number ip used
time logged in
time last message sent
?
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
enum('single',
'news',
'general',
'social',
'eachuser',
type 'teacher') No general
name varchar(255) No
intro text No
open tinyint(2) UNSIGNED No 2
assessed int(10) UNSIGNED No 0
assesspublic int(4) UNSIGNED No 0
assesstimestart int(10) UNSIGNED No 0
assesstimefinish int(10) UNSIGNED No 0
scale int(10) No 0
maxbytes int(10) UNSIGNED No 0
forcesubscribe tinyint(1) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Forums contain and structure discussion
Forum Type:
A single simple discussion - is just a single topic, all on one page. Useful for short, focussed discussions.
Standard forum for general use - is an open forum where any one can start a new topic at any time. This is th
Each person posts one discussion - Each person can post exactly one new discussion topic (everyone can re
Definition of Forum:
This module is by far the most important - it is here that discussion takes place. When you add a new forum, y
with a choice of different types - a simple single-topic discussion, a free-for-all general forum, or a one-discus
user.
Description
Foreign Key mdl_course.id
forum type
Forum title
Intro Text
2= Students are allowed to start discussions
and reply, 1=Sudent are allowed only to
reply, 0=Student aren't allowed to post
Allow posts to be rated? 1=only teachers can
rate posts; 2=students can rate posts
Students can rate? Yes/no: 1/0
start time
finish time
Grade: Separate and connected ways of
knowing = -1 the others--> +1,+2…+100
Max attach size
yes/no: 1/0
Time modified
Useful for short, focussed discussions.
can start a new topic at any time. This is the best general-purpose forum.
one new discussion topic (everyone can reply to them though). This is useful when you want each student to start a discussion
takes place. When you add a new forum, yu will presented
free-for-all general forum, or a one-discussion-thread-per-
want each student to start a discussion about, say, their reflections on the week's topic, and everyone else responds to these.
, and everyone else responds to these.
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
forum int(10) UNSIGNED No 0
name varchar(255) No
firstpost int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
groupid int(10) UNSIGNED No 0
assessed tinyint(1) No 1
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Forums are composed of discussions
Description
Foreign Key mdl_course.id
Foreign Key mdl_forum.id
Post Title
Foreign Key mdl_forum_posts.id
Foreign Key mdl_user.id
Foreign Key mdl_groups.id --> 0=no
group
rated?
Time modified
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
discussion int(10) UNSIGNED No 0
parent int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
created int(10) UNSIGNED No 0
modified int(10) UNSIGNED No 0
mailed tinyint(2) UNSIGNED No 0
subject varchar(255) No
message text No
format tinyint(2) No 0
attachment varchar(100) No
totalscore tinyint(4) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
All posts are stored in this table
Description
Foreign Key mdl_forum_discussion.id
id of the post parent
Foreign Key mdl_user.id
Created time
Modified time
yes/no: 1/0
Subject of the post
Message of the post
Format of the post: 0=Moodle autoformat; 1=
HTML format; 2=Plain text format; 3=Wiki
format
path
rate total score
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
post int(10) UNSIGNED No 0
time int(10) UNSIGNED No 0
rating tinyint(4) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Contains user ratings for individual posts
Description
Foreign Key mdl_user.id
Foreign Key mdl_forum_posts.id
Time sent
value
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
forum int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Keeps track of who is subscribed to what forum
Description
Foreign Key mdl_user.id
Foreign Key mdl_forum.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
text text No
format tinyint(2) UNSIGNED No 0
answer1 varchar(255) No Yes
answer2 varchar(255) No No
answer3 varchar(255) Yes NULL
answer4 varchar(255) Yes NULL
answer5 varchar(255) Yes NULL
answer6 varchar(255) Yes NULL
publish tinyint(2) UNSIGNED No 0
showunanswered tinyint(2) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Available choices are stored here.
Definition of Choice:
A choice activity is very simple - you ask a question and specify a choice of responses. Students can make th
you have a report screen where you can see the results. I use it to gather research consent from my students
use it for quick polls or class votes.
Description
Foreign Key mdl_course.id
Name
Text
Format--> moodle, html, plain text, wiki
text answer
text answer
text answer
text answer
text answer
text answer
publish answers to students? 0=no, 1=yes
but anonymous, 2=yes with names
show people who didnt answer? Yes/no 1/0
Time modified/created
a choice of responses. Students can make their choice, and
o gather research consent from my students, but you could
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
choice int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
answer tinyint(4) No 0
timemodified int(10) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Description
Foreign Key mdl_choice.id
Foreign Key mdl_user.id
selected answer = mdl_choice.answerX
Time modified/created
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
category int(10) UNSIGNED No 0
sortorder int(10) UNSIGNED No 0
password varchar(50) No
fullname varchar(254) No
shortname varchar(15) No
summary text No
format varchar(10) No topics
showgrades smallint(2) UNSIGNED No 1
modinfo longtext No
newsitems smallint(5) UNSIGNED No 1
teacher varchar(100) No Teacher
teachers varchar(100) No Teachers
student varchar(100) No Student
students varchar(100) No Students
guest tinyint(2) UNSIGNED No 0
startdate int(10) UNSIGNED No 0
numsections smallint(5) UNSIGNED No 1
showrecent smallint(5) UNSIGNED No 1
marker int(10) UNSIGNED No 0
maxbytes int(10) UNSIGNED No 0
showreports int(4) UNSIGNED No 0
visible int(10) UNSIGNED No 1
groupmode int(4) UNSIGNED No 0
groupmodeforce int(4) UNSIGNED No 0
timecreated int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
category INDEX category
Comment
Description
Foreign Key mdl_course_category.id
course full name
course short name
yes/no: 1/0
Name for teacher
Name for teachers
Name for Student
Name for Students
yes/no: 1/0
Time Created
Time modified
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
name varchar(255) No
description text No
parent int(10) UNSIGNED No 0
sortorder int(10) UNSIGNED No 0
coursecount int(10) UNSIGNED No 0
visible tinyint(1) No 1
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Course categories
Description
Category Name
Description
Parent Category
Number of courses in this category =
sum(mdl_course.id) where
mdl_course_category.id=mdl_course.catego
ry
yes/no: 1/0
Time created/modified
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
display int(10) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
course
courseuserid INDEX userid
Comment
Stores info about how to display the course
Description
Foreign Key mdl_course.id
Foreign Key mdl_user.id
Display method (I didn't study that)
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
module int(10) UNSIGNED No 0
instance int(10) UNSIGNED No 0
section int(10) UNSIGNED No 0
added int(10) UNSIGNED No 0
deleted tinyint(1) UNSIGNED No 0
score tinyint(4) No 0
indent int(5) UNSIGNED No 0
visible tinyint(1) No 1
groupmode tinyint(4) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Description
Foreign Key mdl_course.id
Foreign Key mdl_modules.id
??Foreign Key mdl_course_sections.id
yes/no: 1/0
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
section int(10) UNSIGNED No 0
summary text No
sequence text No
visible tinyint(1) No 1
Index
Keyname Type Field
PRIMARY PRIMARY id
course
coursesection INDEX section
Comment
Description
Foreign Key mdl_course.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
name varchar(20) No
version int(10) No 0
cron int(10) UNSIGNED No 0
lastcron int(10) UNSIGNED No 0
search varchar(255) No
visible tinyint(1) No 1
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Description
Module name
Module Version (date YYYYMMDDXX)
Time between each cron
Last cron time
yes/no: 1/0
Field Type Null
Attributes Default Extra
id int(10) UNSIGNED No auto_increment
time int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
ip varchar(15) No
course int(10) UNSIGNED No 0
module varchar(10) No
cmid int(10) UNSIGNED No 0
action varchar(15) No
url varchar(100) No
info varchar(255) No
Index
Keyname Type Field
PRIMARY PRIMARYid
time
course
timecoursemodul module
eaction INDEX action
course
coursemoduleacti module
on INDEX action
course
courseuserid INDEX userid
ip FULLTEXT ip
ip_2 FULLTEXT ip
Comment
Every action is logged as far as possible.
Description
Action time
Foreign Key mdl_user.id
ip of the user
Foreign Key mdl_course.id
The module name where something
happened on Foreign Key
mdl_log_display.module
?
Foreign Key mdl_log_display.action
url called during this action
?
Field Type Attributes Null Default Extra
module varchar(20) No
action varchar(20) No
mtable varchar(20) No
field varchar(40) No
Index
Keyname Type Field
NO INDEX
Comment
For a particular module/action, specifies a moodle table/field
Description
Module name
action name
moodle table used for this action
? Field name of the tag ? Or
name of the table field?
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
content text No
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Defines labels
Definition of Label:
This is a not a true activity - it is a "dummy" activity that allows you to insert text and graphics among the othe
course page.
Description
Foreign Key mdl_course.id
Label name
Label text
Time created/modified
u to insert text and graphics among the other activities on the
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
courseid int(10) UNSIGNED No 0
name varchar(254) No
description text No
lang varchar(10) No en
picture int(10) UNSIGNED No 0
timecreated int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
courseid INDEX courseid
Comment
Each record is a group in a course.
Description
Foreign Key mdl_course.id
Group name
Group description
Language of the group
Path to the picture
Time created
Time modified
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
groupid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
timeadded int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
groupid INDEX groupid
Comment
Lists memberships of users to groups
Description
Foreign Key mdl_groups.id
Foreign Key mdl_user.id
Time added
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
name varchar(255) No
value text No
Index
Keyname Type Field
PRIMARY PRIMARY id
name UNIQUE name
Comment
Moodle configuration variables
Description
Name of the config variable (i.e. version, language…)
Value of the config variable
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
template int(10) UNSIGNED No 0
days smallint(6) No 0
timecreated int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
name varchar(255) No
intro text Yes NULL
questions varchar(255) Yes NULL
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Surveys
Definition of survey:
The survey module provides a number of predefined survey instruments that are useful in evaluating and und
class. Currently they include the COLLES and the ATTLS instruments. They can be given to students early in
diagnostic tool and at the end of the course as an evaluation tool (I use one every week in my courses).
Description
Foreign Key mdl_course.id
1/2/3/4: COLLES
(actual)/COLLES(preferred)/COLLES(preferr
ed and actual)/ATLAS --> first 4 row of this
table are templates
?
Time created
Time modified
Survey Name
Survey intro text
Foreign Key mdl_survey_questions.id is a copy of the template row
separator ',' i.e. 1,2,4
uments that are useful in evaluating and understanding your
ments. They can be given to students early in the course as a
(I use one every week in my courses).
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
text varchar(255) No
shorttext varchar(30) No
multi varchar(100) No
intro varchar(50) Yes NULL
type tinyint(3) No 0
options text Yes NULL
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Description
list of questions (mdl_survey_question.id) if
its a multiple one, separator ','
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
survey int(10) UNSIGNED No 0
question int(10) UNSIGNED No 0
time int(10) UNSIGNED Yes NULL
answer1 char(255) Yes NULL
answer2 char(255) Yes NULL
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Description
Foreign Key mdl_user.id
Foreign Key mdl_survey.id
Foreign Key mdl_survey_questions.id
Time sent answer
Answer text: 1/2/3/4 for chioce, text for
comment answer
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
survey int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
notes text No
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Description
Foreign Key mdl_survey.id
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
type tinyint(4) No 0
reference varchar(255) Yes NULL
summary text No
alltext text No
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
Comment
Definition of Resource:
Resources are content: information the teacher wants to bring into the course. These can be prepared files up
course server; pages edited directly in Moodle; or external web pages made to appear part of this course.
Description
Foreign Key mdl_course.id
Resource name
Type of the resource (4=plain text,5=web
link, …)
Reference to this Resource (example web-
link, picture path …)
Summary text
Full text of the resource
Time created/modified
o the course. These can be prepared files uploaded to the
ages made to appear part of this course.
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
courseid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
name varchar(255) No
scale text No
description text No
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Defines grading scales
Description
Foreign Key mdl_course.id
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
description text No
format tinyint(2) UNSIGNED No 0
resubmit tinyint(2) UNSIGNED No 0
type int(10) UNSIGNED No 1
maxbytes int(10) UNSIGNED No 100000
timedue int(10) UNSIGNED No 0
grade int(10) No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Defines assignments
Definition of Assignment:
An assignment is where you set a task with a due date and a maximum grade. Students will be able to upload
the requirements. The date they upload their file is recorded. Afterwards, you will have a single page on which
file (and how late or early it is), and then record a grade and a comment. Half an hour after you grade any par
Moodle will automatically email that student a notification.
Description
Foreign Key mdl_course.id
Assignment name
Assignment description
Assignment text format (moodle format,
html, plain text, wiki)
allow resubmissions yes/no:1/0
upload file/offline assignment: 1/0
attachment max size
Due date limit
grade
time created/modified
ximum grade. Students will be able to upload one file to satisify
erwards, you will have a single page on which ou can view each
mment. Half an hour after you grade any particular student,
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
assignment int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
timecreated int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
numfiles int(10) UNSIGNED No 0
grade int(11) No 0
comment text No
teacher int(10) UNSIGNED No 0
timemarked int(10) UNSIGNED No 0
mailed tinyint(1) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Info about submitted assignments
Due date = data di scadenza
Description
Foreign Key mdl_assignment.id
Foreign Key mdl_user.id
time assignment was sent
time assignment was modified
number of files uploaded
Teacher grade on this assignment
Teacher Feedback on this assignment
Teacher user id: Foreign Key mdl_user.id
Time graded by teacher
Mailed grade to student --> yes/no: 1/0
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
name varchar(255) No
course int(10) No 0
day int(10) UNSIGNED No 0
hours tinyint(1) No 0
roll tinyint(1) No 0
notes varchar(64) No
timemodified int(10) UNSIGNED No 0
dynsection tinyint(1) No 0
edited tinyint(1) No 0
autoattend tinyint(1) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Rilevazione presenze
Definition of Attendance:
This module allows an attendance register to be manually maintained for a given week or topic.
Description
name = Date - note
Foreign Key mdl_course.id
Timestamp date of this attendace
How many hours
notes on this attendance
Time created/modified
yes/no: 1/0
ained for a given week or topic.
Field Type Attributes Null Default Extra
id int(11) No auto_increment
dayid int(10) UNSIGNED No 0
userid int(11) No 0
hour tinyint(1) UNSIGNED No 0
status int(11) No 0
notes varchar(64) No
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Description
Foreign Key mdl_attendance.id
Foreign Key mdl_user.id
how many
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) Yes NULL
intro text Yes NULL
introformat tinyint(2) No 0
days smallint(5) UNSIGNED No 7
assessed int(10) No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Definition of Journal:
Each journal activity is an entry in the whole course journal. For each one you can specify an open-ended que
what students write, as well as a window of time in which the journal is open (weekly course format only). A ge
thumb is to create one journal per week. Encourage students to write reflectively and critically in these journal
available to them and you. Afterwards, you will be able to grade and comment all the entries for that week or t
will receive an automatic email informing them of your feedback. Journals are not designed to be continually a
need to do that then add more journal activities.
Description
Foreign Key mdl_course.id
Time created/modified
each one you can specify an open-ended question that guides
nal is open (weekly course format only). A general rule of
write reflectively and critically in these journals, as they are only
and comment all the entries for that week or topic, and students
Journals are not designed to be continually added to - if you
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
journal int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
modified int(10) UNSIGNED No 0
text text No
format tinyint(2) No 0
rating int(10) Yes 0
comment text Yes NULL
teacher int(10) UNSIGNED No 0
timemarked int(10) UNSIGNED No 0
mailed int(1) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
All the journal entries of all people
Description
Foreign Key mdl_journal.id
Foreign Key mdl_user.id
Teacher user id: Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
name varchar(255) No
description text No
courseid int(10) UNSIGNED No 0
groupid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
modulename varchar(20) No
instance int(10) UNSIGNED No 0
eventtype varchar(20) No
timestart int(10) UNSIGNED No 0
timeduration int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
id UNIQUE id
courseid INDEX courseid
userid INDEX userid
Comment
For everything with a time associated to it
Description
Foreign Key mdl_course.id
Foreign Key mdl_groups.id
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
deleteafter smallint(5) UNSIGNED No 14
dialoguetype tinyint(3) No 0
tinyint(3)
multipleconversations No 0
maildefault tinyint(3) No 0
timemodified int(10) UNSIGNED No 0
name varchar(255) Yes NULL
intro text Yes NULL
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Definition of Dialogue:
This module allows students or teachers to start two-way dialogues with another person. The functionality of t
eventually be made part of a standard instant messaging function
Description
Foreign Key mdl_course.id
How many days after it was closed u have to
delete this dialogue
0=teacher-student;1=student-
student;2=everybody
Allow multiple conversation yes/no: 1/0
time created/modified
dialogue name
dialogue intro text
es with another person. The functionality of this module will
n
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
dialogueid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
recipientid int(10) UNSIGNED No 0
lastid int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
closed tinyint(3) No 0
seenon int(10) UNSIGNED No 0
ctype tinyint(3) No 0
format tinyint(2) No 0
subject varchar(100) No
Index
Keyname Type Field
PRIMARY PRIMARY id
dialogueid INDEX dialogueid
timemodified INDEX timemodifie
Comment
All the conversations between pairs of people
Description
Foreign Key mdl_dialogue.id
Person that start the dialogue: Foreign
Key mdl_user.id
The dialogue receive the dialogue:
Foreign Key mdl_user.id
Last person that wrote message to this
dialogue: Foreign Key mdl_user.id
Time last message was sent
Time closed
Dinamyc field, to see when someone read
the message
Subjet of this conversation
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
dialogueid int(10) UNSIGNED No 0
conversationid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
timecreated int(10) UNSIGNED No 0
mailed int(1) UNSIGNED No 0
text text No
Index
Keyname Type Field
PRIMARY PRIMARY id
conversationid INDEX conversationid
Comment
All the conversation entries
Description
Foreign Key mdl_dialogue.id
Foreign Key mdl_conversation.id
Foreign Key mdl_user.id
Time created
0=mailed ; 1=not mailed
Dialogue text
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
nelements tinyint(3) UNSIGNED No 1
phase tinyint(3) UNSIGNED No 0
gradingstrategy tinyint(3) UNSIGNED No 1
usemaximum tinyint(3) UNSIGNED No 0
anonymous tinyint(3) UNSIGNED No 0
maxbytes int(10) UNSIGNED No 100000
deadline int(10) UNSIGNED No 0
grade tinyint(3) No 0
timemodified int(10) UNSIGNED No 0
teacherweight tinyint(3) UNSIGNED No 5
gradingweight tinyint(3) UNSIGNED No 5
showleaguetable tinyint(3) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Defines exercise
Definition of exercise:
This module is a little like a workshop without the peer assessment - a more advanced form of Assignment. In
functionality of this may eventually be integrated into the Assignment module.
Description
Foreign Key mdl_course.id
Deadline TimeStamp
nt - a more advanced form of Assignment. In fact, the
ment module.
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
exerciseid int(10) UNSIGNED No 0
submissionid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
timecreated int(10) UNSIGNED No 0
timegraded int(10) UNSIGNED No 0
grade float No 0
gradinggrade int(3) No 0
mailed tinyint(2) UNSIGNED No 0
generalcomment text No
teachercomment text No
Index
Keyname Type Field
PRIMARY PRIMARY id
submissionid INDEX submissionid
userid INDEX userid
Comment
Info about assessments by teacher and students
Description
Foreign Key mdl_exercise.id
Foreign Key
mdl_exercise_submissions.id
Foreign Key mdl_user.id
Field Type Null
Attributes Default Extra
id int(10) UNSIGNED No auto_increment
exerciseid int(10) UNSIGNED No 0
elementno tinyint(3) UNSIGNED No 0
description text No
scale tinyint(3) UNSIGNED No 0
maxscore tinyint(3) UNSIGNED No 1
weight tinyint(3) UNSIGNED No 11
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Info about marking scheme of assignment
Description
Foreign Key mdl_exercise.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
exerciseid int(10) UNSIGNED No 0
assessmentid int(10) UNSIGNED No 0
elementno int(10) UNSIGNED No 0
feedback text No
grade tinyint(3) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
assessmentid INDEX assessmentid
Comment
Info about individual grades given to each element
Description
Foreign Key mdl_exercise.id
Foreign Key mdl_exercise_assesments.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
exerciseid int(10) UNSIGNED No 0
elementno int(10) UNSIGNED No 0
rubricno tinyint(3) UNSIGNED No 0
description text No
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Info about the rubrics marking scheme
Description
Foreign Key mdl_exercise.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
exerciseid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
title varchar(100) No
timecreated int(10) UNSIGNED No 0
resubmit tinyint(3) UNSIGNED No 0
mailed tinyint(3) UNSIGNED No 0
isexercise tinyint(3) UNSIGNED No 0
late tinyint(3) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
userid INDEX userid
Comment
Info about submitted work from teacher and students
Description
Foreign Key mdl_exercise.id
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
description text No
nelements tinyint(3) UNSIGNED No 1
phase tinyint(2) UNSIGNED No 0
format tinyint(2) UNSIGNED No 0
gradingstrategy tinyint(2) UNSIGNED No 1
resubmit tinyint(2) UNSIGNED No 0
agreeassessments tinyint(2) UNSIGNED No 0
hidegrades tinyint(2) UNSIGNED No 0
anonymous tinyint(2) UNSIGNED No 0
includeself tinyint(2) UNSIGNED No 0
maxbytes int(10) UNSIGNED No 100000
deadline int(10) UNSIGNED No 0
grade int(10) No 0
ntassessments tinyint(3) UNSIGNED No 0
nsassessments tinyint(3) UNSIGNED No 0
overallocation tinyint(3) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
mergegrades tinyint(3) UNSIGNED No 0
teacherweight tinyint(3) UNSIGNED No 5
peerweight tinyint(3) UNSIGNED No 5
tinyint(3)
includeteachersgrade UNSIGNED No 0
biasweight tinyint(3) UNSIGNED No 5
reliabilityweight tinyint(3) UNSIGNED No 5
gradingweight tinyint(3) UNSIGNED No 5
teacherloading tinyint(3) UNSIGNED No 5
assessmentstodrop tinyint(3) UNSIGNED No 0
showleaguetable tinyint(3) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Defines workshop
Definition of Workshop:
A Workshop is a peer assessment activity with a huge array of options. It allows participants to assess each o
well as exemplar projects, in a number of ways. It also coordinates the collection and distribution of these ass
variety of ways.
Description
Foreign Key mdl_course.id
ptions. It allows participants to assess each other's projects, as
es the collection and distribution of these assessments in a
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
workshopid int(10) UNSIGNED No 0
submissionid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
timecreated int(10) UNSIGNED No 0
timegraded int(10) UNSIGNED No 0
timeagreed int(10) UNSIGNED No 0
grade float No 0
gradinggrade int(3) No 0
mailed tinyint(3) UNSIGNED No 0
resubmission tinyint(3) UNSIGNED No 0
donotuse tinyint(3) UNSIGNED No 0
generalcomment text No
teachercomment text No
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Info about assessments by teacher and students
Description
Foreign Key mdl_workshop.id
Foreign Key
mdl_workshop_submissions.id
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
workshopid int(10) UNSIGNED No 0
assessmentid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
timecreated int(10) UNSIGNED No 0
mailed tinyint(2) UNSIGNED No 0
comments text No
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Defines comments
Description
Foreign Key mdl_workshop.id
Foreign Key
mdl_workshop_assessments.id
Foreign Key mdl_user.id
Field Type Null
Attributes Default Extra
id int(10) UNSIGNED No auto_increment
workshopid int(10) UNSIGNED No 0
elementno tinyint(3) UNSIGNED No 0
description text No
scale tinyint(3) UNSIGNED No 0
maxscore tinyint(3) UNSIGNED No 1
weight float No 1
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Info about marking scheme of assignment
Description
Foreign Key mdl_workshop.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
workshopid int(10) UNSIGNED No 0
assessmentid int(10) UNSIGNED No 0
elementno int(10) UNSIGNED No 0
feedback text No
grade tinyint(3) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Info about individual grades given to each element
Description
Foreign Key mdl_workshop.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
workshopid int(10) UNSIGNED No 0
elementno int(10) UNSIGNED No 0
rubricno tinyint(3) UNSIGNED No 0
description text No
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Info about the rubrics marking scheme
Description
Foreign Key mdl_workshop.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
workshopid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
title varchar(100) No
timecreated int(10) UNSIGNED No 0
mailed tinyint(2) UNSIGNED No 0
teachergrade int(3) UNSIGNED No 0
peergrade int(3) UNSIGNED No 0
biasgrade int(3) UNSIGNED No 0
reliabilitygrade int(3) UNSIGNED No 0
gradinggrade int(3) UNSIGNED No 0
finalgrade int(3) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
title INDEX title
Comment
Info about submitted work from teacher and students
Description
Foreign Key mdl_workshop.id
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
course int(10) UNSIGNED No 0
name varchar(255) No
intro text No
studentcanpost tinyint(2) UNSIGNED No 0
tinyint(2)
allowduplicatedentries UNSIGNED No 0
displayformat tinyint(2) UNSIGNED No 0
mainglossary tinyint(2) UNSIGNED No 0
showspecial tinyint(2) UNSIGNED No 1
showalphabet tinyint(2) UNSIGNED No 1
showall tinyint(2) UNSIGNED No 1
allowcomments tinyint(2) UNSIGNED No 0
usedynalink tinyint(2) UNSIGNED No 1
defaultapproval tinyint(2) UNSIGNED No 1
globalglossary tinyint(2) UNSIGNED No 0
entbypage tinyint(3) UNSIGNED No 10
assessed int(10) UNSIGNED No 0
assesstimestart int(10) UNSIGNED No 0
assesstimefinish int(10) UNSIGNED No 0
scale int(10) No 0
timecreated int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Definition of glossary:
This activity allows participants to create and maintain a list of definitions, like a dictionary.
The entries can be searched or browsed in many different formats.
The glossary also allows teachers to export entries from one glossary to another (the main one) within the sam
Finally, it is possible to automatically create links to these entries from throughout the course.
Description
Foreign Key mdl_course.id
finitions, like a dictionary.
ssary to another (the main one) within the same course.
from throughout the course.
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
entryid int(10) UNSIGNED No 0
alias text No
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
entries alias
Description
Foreign Key mdl_glossary_entries.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
glossaryid int(10) UNSIGNED No 0
name varchar(255) No
usedynalink tinyint(2) UNSIGNED No 1
Index Type Field
Keyname PRIMARY id
PRIMARY
Comment
all categories for glossary entries
Description
Foreign Key mdl_glossary.id
Field Type Null
Attributes Default Extra
id int(10) UNSIGNED No auto_increment
entryid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
comment text No
format tinyint(2) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
comments on glossary entries
Description
Foreign Key mdl_glossary_entries.id
Foreign Key mdl_user.id
Field Type Null
Attributes Default Extra
id int(10) UNSIGNED No auto_increment
fid int(10) UNSIGNED No 0
visible tinyint(2) UNSIGNED No 1
relatedview tinyint(3) No -1
showgroup tinyint(2) UNSIGNED No 1
defaultmode varchar(50) No
defaulthook varchar(50) No
sortkey varchar(50) No
sortorder varchar(50) No
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Setting of the display formats
Description
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
glossaryid int(10) UNSIGNED No 0
userid int(10) UNSIGNED No 0
concept varchar(255) No
definition text No
format tinyint(2) UNSIGNED No 0
attachment varchar(100) No
timecreated int(10) UNSIGNED No 0
timemodified int(10) UNSIGNED No 0
teacherentry tinyint(2) UNSIGNED No 0
sourceglossaryid int(10) UNSIGNED No 0
usedynalink tinyint(2) UNSIGNED No 1
casesensitive tinyint(2) UNSIGNED No 0
fullmatch tinyint(2) UNSIGNED No 1
approved tinyint(2) UNSIGNED No 1
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
all glossary entries
Description
Foreign Key mdl_glossary.id
Foreign Key mdl_user.id
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
categoryid int(10) UNSIGNED No 0
entryid int(10) UNSIGNED No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
categories of each glossary entry
Description
Field Type Attributes Null Default Extra
id int(10) UNSIGNED No auto_increment
userid int(10) UNSIGNED No 0
entryid int(10) UNSIGNED No 0
time int(10) UNSIGNED No 0
rating tinyint(4) No 0
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Contains user ratings for entries
Description
Foreign Key mdl_user.id
Foreign Key mdl_glossary_entries.id
Field Type Attributes Null Default Extra
Index
Keyname Type Field
PRIMARY PRIMARY id
Comment
Description