I want to know how all the information in the blog is stored in the database. i.e I want to know the fields in the database table for a blog entry. I tried downloading the database structure from http://docs.moodle.org/dev/Database_Schema. But it shows an error.
I am a newbie. So, please help me!
Thanks in advance.
The attached file I created from an installation of Moodle 2.2. which may help explain the structure and you can see more information for the whole Moodle database system at
I am doing a project using moodle. I specifically want to know certain things. In every user's profile, there is an area called "interests". I want to know in which field of which table this information is getting stored.
Even with the help of documentation, it seems impossible to navigate through the source code and find this out.
Any help will be appreciated!
I can't speak for newer Moodles, but it looks like in 1.9 that information is stored in mdl_tag, mdl_tag_correlation, and mdl_tag_instance.
In which table are these fields present??
Those are the names of the three tables in which the information is distributed.
Although, on second look, maybe everything you need is in mdl_tag. It gives a userid and the name of the tag.
Thanks a lot cramer How did you find this out? I dont want to trouble everyone incase I need to find out something similar.
In this case, I thought I had a pretty good chance of just looking at the database tables and guessing. I knew I had some users who'd set their tags, so I'd recognize the data if I saw it. I'm afraid that doesn't work for every case, and I may even be wrong in this case, but I'm pretty sure that's what you're looking for.
