https://docs.moodle.org/dev/api.php?action=feedcontributions&feedformat=atom&user=Lastent 2026-06-12T11:10:31Z User contributions MediaWiki 1.43.5 https://docs.moodle.org/dev/index.php?title=Database_schema_introduction&diff=7394 2008-07-21T14:39:58Z

<p>Lastent: Undo revision 40152 by Lastent (Talk)</p> <hr /> <div>The Moodle database has around 200 tables, and can be quite daunting at first sight. The good news is that you don't have to understand it all at once. For example, there are eight tables called forum_''somthing''. If you are interested in the forum module, then obviously you need to understand these tables, and the places they link into core tables. But if you are not interested in the forum module, you can forget about them. The same is true of each activity module.<br /> <br /> Once you take out the tables for each activity module in this way, and similarly take out the tables belonging to the enrolment plugins, question types, etc. You are left with about 50 core tables. But the good news is that even here they break down into groups that mostly you can understand together, or ignore. This page lists the core database tables in these groups. Later, it would be good to add more detailed documentation explaining some of these groups.<br /> <br /> The database structure is defined, edited and upgraded using the [[XMLDB_Documentation|XMLDB]] system.<br /> <br /> ==Configuration==<br /> <br /> ;config<br /> ;config_plugins<br /> <br /> ==Users and their profiles==<br /> <br /> ;user<br /> ;user_info_category<br /> ;user_info_field<br /> ;user_info_data<br /> ;user_lastaccess : this is separated from the user table for performance reasons<br /> ;user_preferences<br /> ;user_private_key<br /> <br /> ==[[Roles|The roles and capabilites system]]==<br /> <br /> ;role <br /> ;capabilites<br /> ;context<br /> ;role_allow_assign<br /> ;role_allow_override<br /> ;role_assignments<br /> ;role_capabilities<br /> ;role_names<br /> ;role_sortorder<br /> <br /> ==Courses and their organisation into categories==<br /> <br /> ;course<br /> ;course_categories<br /> ;course_display<br /> ;course_meta<br /> ;course_request<br /> <br /> ==Activities and their arrangement within courses==<br /> <br /> ;modules<br /> ;course_allowed_modules<br /> ;course_modules<br /> ;course_sections<br /> <br /> See also the tables belonging to particular activity modules. For example forum_*, [[Quiz_database_structure|quiz_*]], etc.<br /> <br /> ==[[Groups|Groups and groupings]]==<br /> <br /> ;groups<br /> ;groups_members<br /> ;groupings<br /> ;groupings_groups<br /> <br /> ==The logging system==<br /> <br /> ;log<br /> ;log_display<br /> <br /> ==[[Blocks#Creating_Database_Tables_for_Blocks|Blocks system]]==<br /> <br /> ;block<br /> ;block_instance<br /> ;block_pinned<br /> <br /> Some particular blocks also have their own database tables. For example block_rss_client.<br /> <br /> ==[[Events|Events]]==<br /> <br /> ;event_*<br /> <br /> ==Backup and restore==<br /> <br /> ;backup_config<br /> ;backup_courses<br /> ;backup_files<br /> ;backup_ids<br /> ;backup_log<br /> <br /> ==Statistics==<br /> <br /> ;stats_daily<br /> ;stats_monthly<br /> ;stats_user_daily<br /> ;stats_user_monthly<br /> ;stats_user_weekly<br /> ;stats_weekly<br /> <br /> ==Tags==<br /> <br /> ;tag_*<br /> <br /> ==[[Grades|Gradebook]]==<br /> <br /> ;grade_*<br /> <br /> ==[[Quiz_database_structure|Question bank]]==<br /> <br /> ;question<br /> ;question_answers<br /> ;question_attempts<br /> ;question_categories<br /> ;question_sessions<br /> ;question_states<br /> <br /> See also the tables for individual question types, which all start question_.<br /> <br /> ==Messaging system==<br /> <br /> ;message_*<br /> <br /> ==[[Moodle_Network|Moodle Network]]==<br /> <br /> ;mnet_*<br /> <br /> ==Caching==<br /> <br /> ;cache_*<br /> <br /> ==Miscellaneous==<br /> <br /> ;scale<br /> ;scale_history<br /> ;sessions2<br /> ;timezone<br /> ;post<br /> <br /> ==See also==<br /> * [[Database_Schema]] - some automatically generated diagrams.<br /> * [[XMLDB_Documentation]] - the XMLDB system used to define, edit, and update the database structure.<br /> [[Category:XMLDB]]</div>

Lastent https://docs.moodle.org/dev/index.php?title=Database_schema_introduction&diff=7393 2008-07-21T14:38:53Z

<p>Lastent: /* Configuration */</p> <hr /> <div>The Moodle database has around 200 tables, and can be quite daunting at first sight. The good news is that you don't have to understand it all at once. For example, there are eight tables called forum_''somthing''. If you are interested in the forum module, then obviously you need to understand these tables, and the places they link into core tables. But if you are not interested in the forum module, you can forget about them. The same is true of each activity module.<br /> <br /> Once you take out the tables for each activity module in this way, and similarly take out the tables belonging to the enrolment plugins, question types, etc. You are left with about 50 core tables. But the good news is that even here they break down into groups that mostly you can understand together, or ignore. This page lists the core database tables in these groups. Later, it would be good to add more detailed documentation explaining some of these groups.<br /> <br /> The database structure is defined, edited and upgraded using the [[XMLDB_Documentation|XMLDB]] system.<br /> <br /> ==Configuration==<br /> <br /> ===config===<br /> On this table there is stored data about the main configuration of the moodle installation, their fields are:<br /> - id<br /> - name<br /> - value<br /> ===config_plugins===<br /> On this table there is stored data about the plugins that have been installed on our moodle installation, their fields are:<br /> - id<br /> - plugin<br /> - name<br /> - value<br /> <br /> ==Users and their profiles==<br /> <br /> ;user<br /> ;user_info_category<br /> ;user_info_field<br /> ;user_info_data<br /> ;user_lastaccess : this is separated from the user table for performance reasons<br /> ;user_preferences<br /> ;user_private_key<br /> <br /> ==[[Roles|The roles and capabilites system]]==<br /> <br /> ;role <br /> ;capabilites<br /> ;context<br /> ;role_allow_assign<br /> ;role_allow_override<br /> ;role_assignments<br /> ;role_capabilities<br /> ;role_names<br /> ;role_sortorder<br /> <br /> ==Courses and their organisation into categories==<br /> <br /> ;course<br /> ;course_categories<br /> ;course_display<br /> ;course_meta<br /> ;course_request<br /> <br /> ==Activities and their arrangement within courses==<br /> <br /> ;modules<br /> ;course_allowed_modules<br /> ;course_modules<br /> ;course_sections<br /> <br /> See also the tables belonging to particular activity modules. For example forum_*, [[Quiz_database_structure|quiz_*]], etc.<br /> <br /> ==[[Groups|Groups and groupings]]==<br /> <br /> ;groups<br /> ;groups_members<br /> ;groupings<br /> ;groupings_groups<br /> <br /> ==The logging system==<br /> <br /> ;log<br /> ;log_display<br /> <br /> ==[[Blocks#Creating_Database_Tables_for_Blocks|Blocks system]]==<br /> <br /> ;block<br /> ;block_instance<br /> ;block_pinned<br /> <br /> Some particular blocks also have their own database tables. For example block_rss_client.<br /> <br /> ==[[Events|Events]]==<br /> <br /> ;event_*<br /> <br /> ==Backup and restore==<br /> <br /> ;backup_config<br /> ;backup_courses<br /> ;backup_files<br /> ;backup_ids<br /> ;backup_log<br /> <br /> ==Statistics==<br /> <br /> ;stats_daily<br /> ;stats_monthly<br /> ;stats_user_daily<br /> ;stats_user_monthly<br /> ;stats_user_weekly<br /> ;stats_weekly<br /> <br /> ==Tags==<br /> <br /> ;tag_*<br /> <br /> ==[[Grades|Gradebook]]==<br /> <br /> ;grade_*<br /> <br /> ==[[Quiz_database_structure|Question bank]]==<br /> <br /> ;question<br /> ;question_answers<br /> ;question_attempts<br /> ;question_categories<br /> ;question_sessions<br /> ;question_states<br /> <br /> See also the tables for individual question types, which all start question_.<br /> <br /> ==Messaging system==<br /> <br /> ;message_*<br /> <br /> ==[[Moodle_Network|Moodle Network]]==<br /> <br /> ;mnet_*<br /> <br /> ==Caching==<br /> <br /> ;cache_*<br /> <br /> ==Miscellaneous==<br /> <br /> ;scale<br /> ;scale_history<br /> ;sessions2<br /> ;timezone<br /> ;post<br /> <br /> ==See also==<br /> * [[Database_Schema]] - some automatically generated diagrams.<br /> * [[XMLDB_Documentation]] - the XMLDB system used to define, edit, and update the database structure.<br /> [[Category:XMLDB]]</div>

Lastent https://docs.moodle.org/dev/index.php?title=Database_structure&diff=10229 2008-07-21T03:31:13Z

<p>Lastent: </p> <hr /> <div>[[Database Structure]]<br /> <br /> On this page we will describe the structure of the database of a Moodle installation<br /> ===Introduction===<br /> All the data we set on our Moodle installation is stored on a database, the one we set on the installation, Moodle supports many database engines such MySql, Postgresql, etc.<br /> <br /> As developers some times we need to know the structure of the tables, what are do they store and what each field mean.<br /> <br /> [[Category:Database Structure]]</div>

Lastent https://docs.moodle.org/dev/index.php?title=Database_structure&diff=10228 2008-07-21T03:28:23Z

<p>Lastent: New page: Database Structure On this page we will describe the structure of the database of a Moodle installation ===Introduction=== All the data we set on our Moodle installation is...</p> <hr /> <div>[[Database Structure]]<br /> On this page we will describe the structure of the database of a Moodle installation<br /> ===Introduction===<br /> All the data we set on our Moodle installation is stored on a database, the one we set on the installation, Moodle supports many database engines such MySql, Postgresql, etc.<br /> <br /> As developers some times we need to know the structure of the tables, what are do they store and what each field mean.<br /> <br /> [[Category:Database Structure]]</div>

Lastent