Refactoring and database structure changes to store new data #1
Description
To further increase the amount of information, and perhaps solve the inconsistency of LoLEsports data, we should save the endpoint information:
With these endpoints we can achieve, among many other things:
- Gold per team
- Gold per player
- Champion player and position per player
- Number of turrets pulled
- Number and type of dragons killed
This data is requested per game (remember that a match can have several games).
Therefore, we have to set up our database structure to store the match IDs and their data.
I will write a more detailed analysis later, but right now I leave a .zip with 3 files attached:
- An example of /details
- An example of /window
- A script with a proposal, containing new tables and relations.
new_structure_and_examples.zip