LeagueStats/LeagueStatsSQL.diagram

{"type":"edit","version":3,"columns":[{"id":0,"value":{"id":"0","name":"name","type":"string"}},{"id":1,"value":{"id":"1","name":"type","type":"string"}},{"id":2,"value":{"id":"2","name":"nullable","type":"boolean"}}],"tables":[{"value":{"rows":[{"id":0,"value":{"id":"id","name":"id","type":"int4","nullable":"true"}},{"id":1,"value":{"id":"name","name":"name","type":"varchar","nullable":"true"}},{"id":2,"value":{"id":"batch","name":"batch","type":"int4","nullable":"true"}},{"id":3,"value":{"id":"migration_time","name":"migration_time","type":"timestamptz","nullable":"true"}}],"name":"adonis_schema","id":"adonis_schema","schema":"public"},"position":{"top":64,"left":1984},"id":0,"rowsExpanded":false,"selected":false},{"value":{"rows":[{"id":0,"value":{"id":"id","name":"id","type":"int4","nullable":"true"}},{"id":1,"value":{"id":"player_id","name":"player_id","type":"int4","nullable":"true"}},{"id":2,"value":{"id":"gamemode","name":"gamemode","type":"int4","nullable":"true"}},{"id":3,"value":{"id":"tier","name":"tier","type":"varchar","nullable":"true"}},{"id":4,"value":{"id":"rank","name":"rank","type":"int4","nullable":"true"}},{"id":5,"value":{"id":"lp","name":"lp","type":"int4","nullable":"true"}},{"id":6,"value":{"id":"wins","name":"wins","type":"int4","nullable":"true"}},{"id":7,"value":{"id":"losses","name":"losses","type":"int4","nullable":"true"}},{"id":8,"value":{"id":"created_at","name":"created_at","type":"timestamptz","nullable":"true"}}],"name":"match_player_ranks","id":"match_player_ranks","schema":"public"},"position":{"top":528,"left":64},"id":1,"rowsExpanded":false,"selected":false},{"value":{"rows":[{"id":0,"value":{"id":"id","name":"id","type":"int4","nullable":"true"}},{"id":1,"value":{"id":"match_id","name":"match_id","type":"varchar","nullable":"true"}},{"id":2,"value":{"id":"participant_id","name":"participant_id","type":"int4","nullable":"true"}},{"id":3,"value":{"id":"summoner_id","name":"summoner_id","type":"varchar","nullable":"true"}},{"id":4,"value":{"id":"summoner_puuid","name":"summoner_puuid","type":"varchar","nullable":"true"}},{"id":5,"value":{"id":"summoner_name","name":"summoner_name","type":"varchar","nullable":"true"}},{"id":6,"value":{"id":"win","name":"win","type":"int2","nullable":"true"}},{"id":7,"value":{"id":"loss","name":"loss","type":"int2","nullable":"true"}},{"id":8,"value":{"id":"remake","name":"remake","type":"int2","nullable":"true"}},{"id":9,"value":{"id":"team","name":"team","type":"int4","nullable":"true"}},{"id":10,"value":{"id":"team_position","name":"team_position","type":"int4","nullable":"true"}},{"id":11,"value":{"id":"kills","name":"kills","type":"int4","nullable":"true"}},{"id":12,"value":{"id":"deaths","name":"deaths","type":"int4","nullable":"true"}},{"id":13,"value":{"id":"assists","name":"assists","type":"int4","nullable":"true"}},{"id":14,"value":{"id":"kda","name":"kda","type":"float4","nullable":"true"}},{"id":15,"value":{"id":"kp","name":"kp","type":"float4","nullable":"true"}},{"id":16,"value":{"id":"champ_level","name":"champ_level","type":"int4","nullable":"true"}},{"id":17,"value":{"id":"champion_id","name":"champion_id","type":"int4","nullable":"true"}},{"id":18,"value":{"id":"champion_role","name":"champion_role","type":"int4","nullable":"true"}},{"id":19,"value":{"id":"double_kills","name":"double_kills","type":"int4","nullable":"true"}},{"id":20,"value":{"id":"triple_kills","name":"triple_kills","type":"int4","nullable":"true"}},{"id":21,"value":{"id":"quadra_kills","name":"quadra_kills","type":"int4","nullable":"true"}},{"id":22,"value":{"id":"penta_kills","name":"penta_kills","type":"int4","nullable":"true"}},{"id":23,"value":{"id":"baron_kills","name":"baron_kills","type":"int4","nullable":"true"}},{"id":24,"value":{"id":"dragon_kills","name":"dragon_kills","type":"int4","nullable":"true"}},{"id":25,"value":{"id":"turret_kills","name":"turret_kills","type":"int4","nullable":"true"}},{"id":26,"value":{"id":"vision_score","name":"vision_score","type":"int4","nullable":"true"}},{"id":27,"value":{"id":"gold","name":"gold","type":"int4","nullable