Thinking about an enhancement I would like to see, I have started to look at the Moodle codebase, from a position of having never written PHP. One of the things I have noticed is that there are quite a few integer fields in tabes that can only be meaningfully interpreted by referring back to the code; for example, course_completion_criteria.
It may simply be that I'm looking in the wrong place, but I could not see any table that mapped the integer to a string; that only occurs, AFAICT, in completion_criteria.php.
If this is so, has the possibility of providing convenience tables been mooted? Such tables would be auto-generated from the code, and would only be referred to in ad hoc queries, so they would have no impact on the performance of the system, but would be a great boon to those, like me, who are trying to get a handle on what's happening in the database.
It occurs to me that this would be an easy and no-risk way of getting my feet wet with the codebase.
Am I on the right track?