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":"true"}},{"id":28,"value":{"id":"summoner1_id","name":"summoner1_id","type":"int4","nullable":"true"}},{"id":29,"value":{"id":"summoner2_id","name":"summoner2_id","type":"int4","nullable":"true"}},{"id":30,"value":{"id":"item0","name":"item0","type":"int4","nullable":"true"}},{"id":31,"value":{"id":"item1","name":"item1","type":"int4","nullable":"true"}},{"id":32,"value":{"id":"item2","name":"item2","type":"int4","nullable":"true"}},{"id":33,"value":{"id":"item3","name":"item3","type":"int4","nullable":"true"}},{"id":34,"value":{"id":"item4","name":"item4","type":"int4","nullable":"true"}},{"id":35,"value":{"id":"item5","name":"item5","type":"int4","nullable":"true"}},{"id":36,"value":{"id":"item6","name":"item6","type":"int4","nullable":"true"}},{"id":37,"value":{"id":"damage_dealt_objectives","name":"damage_dealt_objectives","type":"int4","nullable":"true"}},{"id":38,"value":{"id":"damage_dealt_champions","name":"damage_dealt_champions","type":"int4","nullable":"true"}},{"id":39,"value":{"id":"damage_taken","name":"damage_taken","type":"int4","nullable":"true"}},{"id":40,"value":{"id":"heal","name":"heal","type":"int4","nullable":"true"}},{"id":41,"value":{"id":"minions","name":"minions","type":"int4","nullable":"true"}},{"id":42,"value":{"id":"critical_strike","name":"critical_strike","type":"int4","nullable":"true"}},{"id":43,"value":{"id":"killing_spree","name":"killing_spree","type":"int4","nullable":"true"}},{"id":44,"value":{"id":"time_spent_living","name":"time_spent_living","type":"int4","nullable":"true"}},{"id":45,"value":{"id":"perks_primary_style","name":"perks_primary_style","type":"int4","nullable":"true"}},{"id":46,"value":{"id":"perks_secondary_style","name":"perks_secondary_style","type":"int4","nullable":"true"}},{"id":47,"value":{"id":"perks_selected","name":"perks_selected","type":"_int4","nullable":"true"}}],"name":"match_players","id":"match_players","schema":"public"},"position":{"top":64,"left":448},"id":2,"rowsExpanded":true,"selected":false},{"value":{"rows":[{"id":0,"value":{"id":"id","name":"id","type":"varchar","nullable":"true"}},{"id":1,"value":{"id":"game_id","name":"game_id","type":"int8","nullable":"true"}},{"id":2,"value":{"id":"map","name":"map","type":"int4","nullable":"true"}},{"id":3,"value":{"id":"gamemode","name":"gamemode","type":"int4","nullable":"true"}},{"id":4,"value":{"id":"date","name":"date","type":"int8","nullable":"true"}},{"id":5,"value":{"id":"region","name":"region","type":"varchar","nullable":"true"}},{"id":6,"value":{"id":"result","name":"result","type":"int4","nullable":"true"}},{"id":7,"value":{"id":"season","name":"season","type":"float4","nullable":"true"}},{"id":8,"value":{"id":"game_duration","name":"game_duration","type":"int4","nullable":"true"}}],"name":"matches","id":"matches","schema":"public"},"position":{"top":528,"left":1216},"id":4,"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":"color","name":"color","type":"int4","nullable":"true"}},{"id":3,"value":{"id":"result","name":"result","type":"varchar","nullable":"true"}},{"id":4,"value":{"id":"barons","name":"barons","type":"int4","nullable":"true"}},{"id":5,"value":{"id":"dragons","name":"dragons","type":"int4","nullable":"true"}},{"id":6,"value":{"id":"inhibitors","name":"inhibitors","type":"int4","nullable":"true"}},{"id":7,"value":{"id":"rift_heralds","name":"rift_heralds","type":"int4","nullable":"true"}},{"id":8,"value":{"id":"towers","name":"towers","type":"int4","nullable":"true"}},{"id":9,"value":{"id":"bans","name":"bans","type":"_int4","nullable":"true"}},{"id":10,"value":{"id":"ban_orders","name":"ban_orders","type":"_int4","nullable":"true"}}],"name":"match_teams","id":"match_teams","schema":"public"},"position":{"top":624,"left":832},"id":3,"rowsExpanded":false,"selected":false},{"value":{"rows":[{"id":0,"value":{"id":"puuid","name":"puuid","type":"varchar","nullable":"true"}},{"id":1,"value":{"id":"created_at","name":"created_at","type":"timestamptz","nullable":"true"}},{"id":2,"value":{"id":"updated_at","name":"updated_at","type":"timestamptz","nullable":"true"}}],"name":"summoners","id":"summoners","schema":"public"},"position":{"top":1504,"left":832},"id":7,"rowsExpanded":false,"selected":false},{"value":{"rows":[{"id":0,"value":{"id":"id","name":"id","type":"int4","nullable":"true"}},{"id":1,"value":{"id":"summoner_puuid","name":"summoner_puuid","type":"varchar","nullable":"true"}},{"id":2,"value":{"id":"match_id","name":"match_id","type":"varchar","nullable":"true"}}],"name":"summoner_matchlist","id":"summoner_matchlist","schema":"public"},"position":{"top":1408,"left":448},"id":5,"rowsExpanded":false,"selected":false},{"value":{"rows":[{"id":0,"value":{"id":"id","name":"id","type":"int4","nullable":"true"}},{"id":1,"value":{"id":"summoner_puuid","name":"summoner_puuid","type":"varchar","nullable":"true"}},{"id":2,"value":{"id":"name","name":"name","type":"varchar","nullable":"true"}},{"id":3,"value":{"id":"created_at","name":"created_at","type":"timestamptz","nullable":"true"}}],"name":"summoner_names","id":"summoner_names","schema":"public"},"position":{"top":1680,"left":448},"id":6,"rowsExpanded":false,"selected":false}],"refs":[{"from":{"table":5,"rows":[1]},"to":{"table":7,"rows":[0]},"id":1,"selected":false},{"from":{"table":1,"rows":[1]},"to":{"table":2,"rows":[0]},"id":2,"selected":false},{"from":{"table":3,"rows":[1]},"to":{"table":4,"rows":[0]},"id":3,"selected":false},{"from":{"table":2,"rows":[1]},"to":{"table":4,"rows":[0]},"id":4,"selected":false},{"from":{"table":2,"rows":[9]},"to":{"table":3,"rows":[2]},"id":5,"selected":false},{"from":{"table":2,"rows":[4]},"to":{"table":7,"rows":[0]},"id":6,"selected":false},{"from":{"table":6,"rows":[1]},"to":{"table":7,"rows":[0]},"id":7,"selected":false}],"size":{"width":2752,"height":1904},"schema":"public"}