Note:

If you want to create a new page for developers, you should create it on the Moodle Developer Resource site.

Database Schema: Difference between revisions

From MoodleDocs
No edit summary
(12 intermediate revisions by 2 users not shown)
Line 5: Line 5:
Discussion of the database schemas happens either in the forum of the relevant module, or in the [https://moodle.org/mod/forum/view.php?id=55 General developer forum].
Discussion of the database schemas happens either in the forum of the relevant module, or in the [https://moodle.org/mod/forum/view.php?id=55 General developer forum].


=Moodle 3.8=
[http://www.examulator.com/er/ Web view of the Moodle 3.8 schema] which is also grouped into common used components.
=Moodle 3.7=
[https://www.examulator.com/er/3.7/index.html Web view of the Moodle 3.7 schema] which is also grouped into common used components.
=Moodle 3.6=
[https://www.examulator.com/er/3.6/index.html Web view of the Moodle 3.6 schema] which is also grouped into common used components.
=Moodle 3.5=
[https://www.examulator.com/er/3.5/index.html Web view of the Moodle 3.5 schema] which is also grouped into common used components. .
=Moodle 3.4=
[https://www.examulator.com/er/3.4/index.html Web view of the Moodle 3.4 schema] which is also grouped into common used components.
=Moodle 3.3=
[http://www.examulator.com/er/3.3/index.html Web view of the Moodle 3.3 schema] which is also grouped into common used components.
=Moodle 3.2=
[http://www.examulator.com/er/3.2/index.html Web view of the Moodle 3.2 schema] and a downloadable [http://www.examulator.com/er/moodle_32_erd.mwb Moodle 3.2 schema] by [http://www.moodleworld.com/moodle-entity-relationship-diagram-moodle-3-2-available-moodle3-2/ Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool.


=Moodle 3.1=  
=Moodle 3.1=  


[http://www.examulator.com/er/ Web view of the Moodle 3.1 schema] and a downloadable [http://www.examulator.com/er/moodle31_erd.mwb Moodle 3.1 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool. Which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].
[http://www.examulator.com/er/3.1/index.html Web view of the Moodle 3.1 schema] and a downloadable [http://examulator.com/er/3.1/moodle_31_erd.mwb Moodle 3.1 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool.  


=Moodle 3.0=  
=Moodle 3.0=  


[http://www.examulator.com/er/ Web view of the Moodle 3.0 schema] and a downloadable [http://www.examulator.com/er/moodle30_erd.mwb Moodle 3.0 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool. Which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].
[http://www.examulator.com/er/3.0/index.html Web view of the Moodle 3.0 schema] and a downloadable [http://www.examulator.com/er/moodle30_erd.mwb Moodle 3.0 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool.  


=Moodle 2.9=
=Moodle 2.9=


[http://www.examulator.com/er/ Web view of the Moodle 2.9 schema] and a downloadable [http://www.examulator.com/er/moodle29_erd.mwb Moodle 2.9 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool. Which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].
[http://www.examulator.com/er/2.9/index.html Web view of the Moodle 2.9 schema] and a downloadable [http://www.examulator.com/er/moodle29_erd.mwb Moodle 2.9 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool.  
 
=Moodle 2.8=
 
[http://www.examulator.com/er/2.8/index.html Web view of the Moodle 2.8 schema] and a downloadable [http://www.examulator.com/er/moodle28_erd.mwb Moodle 2.8 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool.
 
=Moodle 2.7=
 
[http://www.examulator.com/er/2.7/index.html Web view of the Moodle 2.7 schema] and a downloadable [http://www.examulator.com/er/moodle27_erd.mwb Moodle 2.7 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool.
 
=Moodle 2.2=
 
[http://www.examulator.com/er/2.2/index.html Web view of the Moodle 2.2 schema] and a downloadable [http://www.examulator.com/er/moodle22_erd.mwb Moodle 2.2 schema] by [https://moodle.org/mod/forum/discuss.php?d=278052 Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool.  


=Moodle 1.8=
=Moodle 1.8=

Revision as of 10:29, 2 December 2020

The files available here are in DBDesigner4 format. DBDesigner4 is a schema drawing program released under GPL.

The database schemas have been put together by Alberto Giampani, Dario Toledo and Isaac Cueto. We are also discussing a means of creating them automatically from the new XMLDB definitions with an XML transform.

Discussion of the database schemas happens either in the forum of the relevant module, or in the General developer forum.

Moodle 3.8

Web view of the Moodle 3.8 schema which is also grouped into common used components.

Moodle 3.7

Web view of the Moodle 3.7 schema which is also grouped into common used components.

Moodle 3.6

Web view of the Moodle 3.6 schema which is also grouped into common used components.

Moodle 3.5

Web view of the Moodle 3.5 schema which is also grouped into common used components. .

Moodle 3.4

Web view of the Moodle 3.4 schema which is also grouped into common used components.

Moodle 3.3

Web view of the Moodle 3.3 schema which is also grouped into common used components.

Moodle 3.2

Web view of the Moodle 3.2 schema and a downloadable Moodle 3.2 schema by Marcus green can be opened by MYSQL Workbench tool.

Moodle 3.1

Web view of the Moodle 3.1 schema and a downloadable Moodle 3.1 schema by Marcus green can be opened by MYSQL Workbench tool.

Moodle 3.0

Web view of the Moodle 3.0 schema and a downloadable Moodle 3.0 schema by Marcus green can be opened by MYSQL Workbench tool.

Moodle 2.9

Web view of the Moodle 2.9 schema and a downloadable Moodle 2.9 schema by Marcus green can be opened by MYSQL Workbench tool.

Moodle 2.8

Web view of the Moodle 2.8 schema and a downloadable Moodle 2.8 schema by Marcus green can be opened by MYSQL Workbench tool.

Moodle 2.7

Web view of the Moodle 2.7 schema and a downloadable Moodle 2.7 schema by Marcus green can be opened by MYSQL Workbench tool.

Moodle 2.2

Web view of the Moodle 2.2 schema and a downloadable Moodle 2.2 schema by Marcus green can be opened by MYSQL Workbench tool.

Moodle 1.8

http://moodle.org/file.php/5/moddata/forum/28/376698/moodle_1.8_data_structure.rar

Moodle 1.7

http://moodle.org/file.php/11/moddata/forum/110/268325/db-edudist-Moodle-1.7_.rar

Moodle 1.5.3

http://moodle.org/file.php/11/moddata/forum/110/267644/Db-Edudist-Moodle1.5.3-xml.rar