Can anyone point me to an existing ERD for the moodle database? Thanks,
Mario
Can anyone point me to an existing ERD for the moodle database? Thanks,
Mario
I would LOVE to get one too
Who wouldn't want one? ;>
Shirley you jest Howard, the ER diagram is second only to the flow chart as a diagram that illustrates things that need diagramming. I love them so much I have created a wide and varied assortment of both the entire Moodle (2.0) database and the various components and uploaded it as .png files to this here site. See the links pointing off
http://docs.moodle.org/en/Development:Database_schema_introduction
Particularly the big one at the bottom entitled
ER Diagram of the installed system
Note that the value may be impaired by the bits where the tables are not in a relational structure (e.g. multi valued fields), but it should be a whole bunch better than no diagram.
You will also see the fine work of Mr T. Hunt which are much nicer than mine.
p.s. IANACS
At least there is really only 1 type of ER diagram. UML has 14 different types.
http://en.wikipedia.org/wiki/Unified_Modeling_Language
I use my own Moodle ER diagrams to illustrate how complex "real" systems can get.
I'd like to try to work one up, too.