Databases: Entity Relationship Diagram

Databases: Entity Relationship Diagram

by Mario G Magno -
Number of replies: 9

Can anyone point me to an existing ERD for the moodle database? Thanks,

Mario

Average of ratings: -
In reply to Mario G Magno

Re: Databases: Entity Relationship Diagram

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
I don't believe such a thing exists. I'd be interested to know why you want one?
In reply to Howard Miller

Re: Databases: Entity Relationship Diagram

by Fohsap Muimi -

Who wouldn't want one? ;>

In reply to Fohsap Muimi

Re: Databases: Entity Relationship Diagram

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Me!

Only computer science students think they are a good idea big grin
In reply to Howard Miller

Re: Databases: Entity Relationship Diagram

by Marcus Green -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

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

Average of ratings: Useful (2)
In reply to Marcus Green

Re: Databases: Entity Relationship Diagram

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Well partly... I suspect we are (again) in the grips of somebody's programming assignment in this case.

I don't have any problem with proper documentation for stuff but I'm generally too lazy to learn what all the little symbols mean. UML diagrams are even worse. I'm generally just wary of mindless adherence to some methodology. Sorry - just an old rebel big grin
Average of ratings: Useful (1)