block block_community block_instances block_positions

The Moodle 2.2 Database Schema "reverse engineered" from the installed database using
MySQL Workbench
Marcus Green 2012. For more about Moodle see http://www.moodle.org
For more about the Moodle database structure
http://docs.moodle.org/dev/Database_schema_introduction
Groups
Cohort
groupings_groups
cohort_members
groupings
groups
Users
groups_members
user
Blocks
us
block
block_community
block_positions
block_rss_client
block_instances
Forum
forum
Courses
course
course_completion_crit_compl
course_allowed_modules
course_completion_criteria
course_categories
forum_subscrip
course_completion_notify
course_completion_aggr_methd
course_completions
course_request
course_display
course_modules_availability
Enrollments
url
course_modules
course_published
course_sections
enrol_flatfile
course_modules_completion
External Services
ex
Feedback
feedback_com
feedback
cohort
feedback_item
feedb
user_info_field
feedback_
user_enrolments
user_info_data
feedback_completed
user_info_category
feedback_template
user_private_key
user_lastaccess
feedback_va
feedback_sitecourse_map
user_preferences
Questions
forum_track_pr…
m
forum_discussions
forum_posts
question_attempt_
bscriptions
forum_queue
forum_read
question_categ
enrol
enrol_authorize
enrol_paypal
file
enrol_authorize_refunds
external_services_functions
external_functions
external_tokens
Quiz System
quiz_statistics
ck_completedtmp
quiz
feedback_valuetmp
quiz_question_statistics
quiz_feedback
back_tracking
quiz_grades
quiz_question_instances
quiz_overrides
te
ck_value
quiz_question_response_stats
quiz_attempts
quiz_reports
quiz_overview_regrades
question_answers
question_attempt_step_data
tempt_steps
question_attempts
question
_categories
question_dataset_definitions
question_datasets
question_hints
question_usages
question_sessions
question_states
Chat system
chat
chat_messages_current
chat_users
chat_messages
Grades
Roles
role_capabilities
role_context_levels
grade_grades
role_allow_switch
role_names
grade_grades_hist
role
grade_categories_hi
role_allow_assign
role_sortorder
role_assignments
grade_import_value
Messages
grade_outcomes
mnet_host2service
message
message_providers
Gradings
message_contacts
message_read
message_processors
grading_areas
grading_definitio
message_working
Blogs
blog_associatio
Mnet Inter Moodle Networking
mnet_application
mnetservice_enrol_enrolments
Assignments
mnet_log
mnet_service
mnet_remote_rpc
mnet_service2rpc
assignment
assignment_submissions
mnet_remote_service2rpc
mnet_host
mnet_session
mnet_rpc
Portfolio
mnet_sso_access_control
Cache
mnetservice_enrol_courses
p
portfo
external_services
external_services_users
Question Types
question_dat
qu
grade_settings
grade_outcomes_history
questio
rades
ques
grade_categories
grade_letters
s_history
qu
ies_history
grade_items
values
Glossary
grade_items_history
grade_import_newitem
grade_outcomes_courses
grading_instances
glossary_alia
gradingform_rubric_fillings
eas
finitions
gradingform_rubric_criteria
gradingform_rubric_levels
post
ciation
blog_external
Choices
choice
glossar
sions
portfolio_instance_config
choice_answers
choice_options
portfolio_instance
Wiki
wiki
portfolio_tempdata
portfolio_mahara_queue
portfolio_instance_user
portfolio_log
question_numerical
n_dataset_items
question_truefalse
question_randomsamatch
question_match_sub
question_multichoice
question_calculated
uestion_multianswer
question_shortanswer
question_calculated_options
question_match
question_numerical_units
qtype_essay_options
question_numerical_options
glossary
glossary_categories
y_alias
glossary_formats
glossary_entries_categories
lossary_entries
wiki_links
wiki_locks
wiki_synonyms
cache_filters
cache_text
cache_flags
Configuration
config_plugins
Repository
config
repository
repository_instances
repository_instance_config
Statistics
Backups
stats_daily
stats_monthly
stats_user_monthly
stats_user_daily
stats_user_weekly
backup_logs
stats_weekly
backup_courses
Survey
Tags
survey
survey_questions
backup_files
tag
Workshop
survey_analysis
tag_correlation
survey_answers
tag_instance
workshop
workshop_aggr
workshop_a
workshop
works
workshop_elements_
workshop_submissions
workshop_submissions_
workshopeval_best_set
Database
ns
config_log
timezone
filter_config
data_fields
data
filter_active
data_content
modules
backup_controllers
backup_files_template
ses
data_records
Scorm Integration
scale_hi
backup_ids
s
backup_ids_template
scorm_aicc_
scorm_seq_
_aggregations
hop_assessments
rkshop_assessments_old
workshop_comments_old
ments_old
workshop_grades
workshop_grades_…
sions
sions_old
st_settings
workshop_old
workshop_rubrics_old
workshopform_accumulative
workshopform_comments
workshopform_numerrors
workshopform_numerrors_map
workshopform_rubric
workshop_stockcomments_old
workshopform_rubric_config
workshopform_rubric_levels
scorm_seq_ro
wiki_pages
wiki_versions
wiki_subwikis
ale_history
scorm_seq_mapinfo
scorm
scorm_seq_objective
_aicc_session
scorm_scoes_track
_seq_rolluprule
scorm_scoes
scorm_scoes_data
seq_rolluprulecond
scorm_seq_ruleconds
scorm_seq_rulecond