Gradebook Database Schema - Table Names

Gradebook Database Schema - Table Names

by Dennis Ng -
Number of replies: 1

Hi all,

I'm new to Moodle. I was just wondering what the tables in the Gradebook database schema store and represent? For me some of the tbl names aren't meaningful to explain what's being stored. Also the some of the field names are throwing me off too :-S.

If anyone could help or direct me to a webpage that would be great.

Thanks smile.

 

DB Schema: http://docs.moodle.org/dev/images_dev/e/e0/Gradebook_erd.png

Average of ratings: -
In reply to Dennis Ng

Re: Gradebook Database Schema - Table Names

by Bob Puffer -

I can give you the basics of the table usage:

  • grade_items contains a record for each current grade item for each course including categories and course grade items
  • grade_grades contains the grade for each user for each item from grade_items (join on g.itemid=i.id)
  • grade_categories contains the specifying information for each grade category for each course
  • grade_settings contains any settings that are different than defaults for each course (course-specific unlike preferences which are user-specific)
  • grade_letters maintains any custom setting a course uses for the letter grade boundaries
  • all of the history tables mimic their respective regular tables except they keep all iterations of changes made to the respective items, grades, categories, etc.
  • we don't use outcomes and we don't import grades so I'm at a loss there
Average of ratings: Useful (2)