Database Schema - Revision history

Devdocsbot: Protected "Database Schema": Developer Docs Migration ([Edit=Allow only administrators] (indefinite))

2022-12-16T13:48:48Z

Protected "Database Schema": Developer Docs Migration ([Edit=Allow only administrators] (indefinite))

← Older revision		Revision as of 13:48, 16 December 2022
(No difference)

Devdocsbot: Update migration status and path

2022-12-16T13:47:00Z

Update migration status and path

← Older revision		Revision as of 13:47, 16 December 2022
Line 1:		Line 1:
	~~The files available here are in [http~~:~~//fabforce.net/dbdesigner4/ DBDesigner4] format. DBDesigner4 is a schema drawing program released under GPL.~~		{{Template:Migrated\|newDocId=/docs/apis/core/dml/database-schema}}

	~~The database schemas have been put together by [http://moodle.org/user/view.php?id=11101&course~~=~~11 Alberto Giampani], [http:/~~/~~moodle.org~~/~~user~~/~~view.php?id=192442&course=11 Dario Toledo] and [http:~~//~~moodle.org/user/view.php?id=305352&course=5 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 [https://moodle.org/mod/forum/view.php?id=55 General developer forum].~~


	~~=Moodle 4.0 =~~

	~~[http://www.examulator.com/er/4.0 Web view of the Moodle 4.00 schema] which is also grouped into common used components.~~

	~~=Moodle 3.11=~~

	~~[http://www.examulator.com/er/3.11 Web view of the Moodle 3.11 schema] which is also grouped into common used components.~~

	~~=Moodle 3.10=~~

	~~[http://www.examulator.com/er/3.10 Web view of the Moodle 3.10 schema] which is also grouped into common used components.~~

	~~=Moodle 3.9=~~

	~~[http://www.examulator.com/er/3.9 Web view of the Moodle 3.9 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=~~

	~~[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=~~

	[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=~~

	[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=~~

	~~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~~


	~~[[Category:XMLDB]]~~
	~~[[Category:DB]]~~
	~~[[Category:Interfaces]]~~

Marcusgreen at 12:05, 6 October 2022

2022-10-06T12:05:13Z

@@ 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].
-[http://www.examulator.com/er/ Web view of the Moodle 3.8 schema] which is also grouped into common used components.
+=Moodle 4.0 =
 =Moodle 3.7=

Cathkdsc at 10:29, 2 December 2020

2020-12-02T10:29:09Z

← Older revision		Revision as of 10:29, 2 December 2020
Line 7:		Line 7:
	=Moodle 3.8=		=Moodle 3.8=

	[http://www.examulator.com/er/ Web view of the Moodle 3.4 schema] which is also grouped into common used components. .		[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=		=Moodle 3.4=

	[~~http~~://www.examulator.com/er/ Web view of the Moodle 3.4 schema] which is also grouped into common used components. .		[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=		=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 ~~[http://examulator.com/er/components/index.html~~ components~~]. The schema is downloadable [http://www.examulator.com/er/moodle_33_erd.mwb Moodle 3.3 schema]~~ .		[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=		=Moodle 3.2=

Cathkdsc at 10:26, 2 December 2020

2020-12-02T10:26:04Z

← Older revision		Revision as of 10:26, 2 December 2020
Line 4:		Line 4:

	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.4 schema] which is also grouped into common used components. .

	=Moodle 3.4=		=Moodle 3.4=

Cathkdsc: /* Moodle 3.4 */

2020-12-02T10:24:45Z

Moodle 3.4

← Older revision		Revision as of 10:24, 2 December 2020
Line 7:		Line 7:
	=Moodle 3.4=		=Moodle 3.4=

	[http://www.examulator.com/er/ Web view of the Moodle 3.4 schema] which is also grouped into common used ~~[http://examulator.com/er/components/index.html~~ components]. The schema is downloadable [http://www.examulator.com/er/moodle_34_erd.mwb Moodle 3.4 schema] and can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool. It was reversed engineered using [http://www.examulator.com/er/er_howto.~~html moodle_local-sqlgenerator]~~.		[http://www.examulator.com/er/ Web view of the Moodle 3.4 schema] which is also grouped into common used components. .

	=Moodle 3.3=		=Moodle 3.3=

Cathkdsc at 09:44, 26 July 2018

2018-07-26T09:44:54Z

← Older revision		Revision as of 09:44, 26 July 2018
Line 4:		Line 4:

	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.4=

			[http://www.examulator.com/er/ Web view of the Moodle 3.4 schema] which is also grouped into common used [http://examulator.com/er/components/index.html components]. The schema is downloadable [http://www.examulator.com/er/moodle_34_erd.mwb Moodle 3.4 schema] and can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool. It was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].

	=Moodle 3.3=		=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 [http://examulator.com/er/components/index.html components]. The schema is downloadable [http://www.examulator.com/er/moodle_33_erd.mwb Moodle 3.3 schema] ~~by [https://www~~.moodleworld.com/new-moodle-3-3-database-schema-now-available/ Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool and which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].		[http://www.examulator.com/er/3.3/index.html Web view of the Moodle 3.3 schema] which is also grouped into common used [http://examulator.com/er/components/index.html components]. The schema is downloadable [http://www.examulator.com/er/moodle_33_erd.mwb Moodle 3.3 schema] .

	=Moodle 3.2=		=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 ~~and which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator]~~.		[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=

Cathkdsc: /* Moodle 3.3 */

2018-05-18T11:47:54Z

Moodle 3.3

← Older revision		Revision as of 11:47, 18 May 2018
Line 7:		Line 7:
	=Moodle 3.3=		=Moodle 3.3=

	[http://www.examulator.com/er/ Web view of the Moodle 3.3 schema] which is also grouped into common used [http://examulator.com/er/components/index.html components]. The schema is downloadable [http://www.examulator.com/er/moodle_33_erd.mwb Moodle 3.3 schema] by [https://www.moodleworld.com/new-moodle-3-3-database-schema-now-available/ Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool and which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].		[http://www.examulator.com/er/3.3/index.html Web view of the Moodle 3.3 schema] which is also grouped into common used [http://examulator.com/er/components/index.html components]. The schema is downloadable [http://www.examulator.com/er/moodle_33_erd.mwb Moodle 3.3 schema] by [https://www.moodleworld.com/new-moodle-3-3-database-schema-now-available/ Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool and which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].

	=Moodle 3.2=		=Moodle 3.2=

Cathkdsc: /* Moodle 3.2 */

2018-05-18T11:47:11Z

Moodle 3.2

← Older revision		Revision as of 11:47, 18 May 2018
Line 11:		Line 11:
	=Moodle 3.2=		=Moodle 3.2=

	[http://www.examulator.com/er/ 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 and which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].		[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 and which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].

	=Moodle 3.1=		=Moodle 3.1=

Nadavkav: /* Moodle 3.3 */

2017-09-01T16:10:39Z

Moodle 3.3

← Older revision		Revision as of 16:10, 1 September 2017
Line 7:		Line 7:
	=Moodle 3.3=		=Moodle 3.3=

	[http://www.examulator.com/er/ Web view of the Moodle 3.3 schema] ~~and a~~ downloadable [http://www.examulator.com/er/moodle_33_erd.mwb Moodle 3.3 schema] by [https://www.moodleworld.com/new-moodle-3-3-database-schema-now-available/ Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool and which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].		[http://www.examulator.com/er/ Web view of the Moodle 3.3 schema] which is also grouped into common used [http://examulator.com/er/components/index.html components]. The schema is downloadable [http://www.examulator.com/er/moodle_33_erd.mwb Moodle 3.3 schema] by [https://www.moodleworld.com/new-moodle-3-3-database-schema-now-available/ Marcus green] can be opened by [http://www.mysql.com/products/workbench MYSQL Workbench] tool and which was reversed engineered using [http://www.examulator.com/er/er_howto.html moodle_local-sqlgenerator].

	=Moodle 3.2=		=Moodle 3.2=