Hi sselip,
Thank you for the post. Great question. MSTW is continually evolving. I have attempted to make each plugin work stand-alone. So if you are using just one, you are good to go. Then I have begun to integrate the plugins to some extent, so that if you are using multiple plugins, you don’t have to enter all the Teams, say, and their logos, and venues, etc, in every plugin. For example, Venues is now part of Schedules & Scoreboards, and as you mention, Team Rosters and Schedules & Scoreboards can share team data. (BTW, the CSV Import function and the MSTW CSV Exporter, make moving the data between plugins much easier than hand-jamming everything.)
At this point, “relatively unnormalized” is not a bad description. (I write the plugins to use them, not as a Comp Sci project, so they are no where near perfect under the covers.) So, no I do not have a entity-relationship diagram to share. In fact, I use the built-in WP data base tables, and the admin screens, as much as possible. So I really don’t know a lot about what’s going inside the WP DB, nor do I want to know. I just know the API, and that the DB is pretty damn fast and pretty damn solid. I will think about some flavor of a data diagram for the soon to be released MSTW League Manager, since it’s pretty complicated. (I like documentation about as much as any programmer, so don’t hold your breath.)
Probably not exactly what you hoped to hear, but the truth shall set us free! ??
Regards,
-Mark
