Well, the easy part is over. There are a couple of unresolved issues that I am looking forward to settling. The main one of these being figuring what and how to use the ‘team_id’ and ‘game_id’ fields in the League History Tables. Figuring that out will allow me to separate some of the adjusted stats to the sub_league level. Without resolving this, I would have to join the players’ team_id to a league_id-sub_league_id pair on the team_relations table and then group by that pair. And since sub_league_id’s are not unique it would be a little trickier. I can’t see it working in my head at the moment, though I am sure an hour or two at the whiteboard could see me through. Still, not for now.
There will be other tables added as my little project grows wings, but these are all I need right now to start figuring out how to calculate stats.