Anyone understand the table relationships message subsystem?

Anyone understand the table relationships message subsystem?

by Marcus Green -
Number of replies: 2
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

I have been drawing up an ER diagram of the messaging subsystem and have deduced what I think are some additional relationships. However I cannot see any obvious links to the message_provider table. The component field implies a link to information such as modules/plugins but I cannot find anywhere where that might link to a primary key (perhaps there is no such obvious relationship). You can see it in its loneliness here.

http://www.examulator.com/er/3.1/components/message.png

(Click on the diagram to make it less fuzzy)

Average of ratings: -
In reply to Marcus Green

Re: Anyone understand the table relationships message subsystem?

by Mike Churchward -
Picture of Core developers Picture of Plugin developers Picture of Testers

Hi Marcus -

I don't believe there is any direct link from the "message_provider" table to any other table. Similar to the "config_plugin" table, this table contains root level information used by various API's and functions. The closest data to a link there would be the "component" field, which contains information like "mod_forum" and "enrol_manual".

Hope that helps.

mike

Average of ratings: Useful (1)
In reply to Mike Churchward

Re: Anyone understand the table relationships message subsystem?

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

Thanks for the feedback Mike. I think you may be correct about message_provider, though it seems odd to have other tables that are related by implication of the name but not of any obvious field.

I shall move on to other subsystems. I now have 47 inferred pk/fk relationships

https://github.com/marcusgreen/moodle_local-sqlgenerator/blob/master/morekeys.xml

And an improved diagram of the relationships between the forum tables.

http://www.examulator.com/er/3.1/components/forum.png


Average of ratings: -