Data Structure

Structure and list of collected data

Players & Teams Structure

01. Players

Main Information

id

Unique identifier assigned to a player (Visible in URL)

handle

Username
Additional Information

first_name

First Name

last_name

Last Name

country_code

Country Code (FR = France, US = United States, etc.)

bio

Biography

socials

Social Media (Twitter/Instagram/Twitch/Youtube/TikTok)

vlr_id

Player's VLR ID
Confidential Information

discord_id

Discord ID (Private information, used to validate a player's identity when modifying their profile)

val_id

Riot ID (Private information, used to retrieve match statistics for a player)

rso_token

Encrypted Riot access token. Used to query the Riot API on behalf of the player.

rso_refresh

Encrypted Riot refresh token. Used to renew access without re-authentication.

rso_expires_at

Expiry date of the current access token.

rso_linked_at

Date the player connected their Riot account.

Link

Player_Team

player_id

Unique identifier for a player

team_id

Unique identifier for a team

role

Player/Coach/Manager/etc.

joined_at

Date joined the team

left_at

Date left the team

02. Teams

Main Information

id

Unique identifier assigned to a team (Visible in URL)

name

Team Name
Additional Information

country_code

Country Code (FR = France, US = United States, etc.)

website

Website

socials

Social Media (Twitter/Instagram/Twitch/Youtube/TikTok)

bio

Biography

vlr_id

Team's VLR ID

Each team/player must have a name and an identifier; other information is added by the team/player or by administrators via tournament data.
Players/teams have the right to modify/delete 'Additional Information'.

The val_id and discord_id are not displayed or shared. They are provided by the player via Discord.

Tournaments Structure

03. Tournaments

Main Information

id

Unique tournament identifier

name

Competition Name

region

World Region (EMEA, NA, etc.)

category

Tournament Category (e.g., Challengers, Game Changers)

status

Current Status (Upcoming, Live, Finished)
Additional Information

prize_pool

Total Prize Pool

location

Physical Location

start_date

Start Date

end_date

End Date

vlr_id

data.tournaments.vlr_id

04. Tournament_phases

Technical Structure

name

Phase Name (e.g., Playoffs, Group A)

format

Game Mode (e.g., Single Elimination, Round Robin)

order

Phase display order

parent_id

Link to a parent phase (for subgroups)

Participants

Tournament_Teams

List of teams registered for the event

Each tournament must have an identifier, a name, dates, a region, a category, and a status. They are collected by our team or upon request during a tournament addition request.

Matches Structure

05. Matches

tournament_id

phase_id

round_number

round_name

match_order

team_a_id

team_b_id

scheduled_at

status

team_a_score

team_b_score

best_of

vlr_id

patch

06. Match_Vetos

match_id

team_id

map_name

type

order

07. Game_Maps

api_match_id

match_id

map_name

team_a_score

team_b_score

order

is_completed

08. Game_Player_Stats

match_id

game_map_id

player_id

team_id

agent_name

kills

deaths

assists

acs

adr

kast_percentage

first_kills

first_deaths

headshot_percentage

09. Game_Map_Rounds

game_map_id

round_number

winning_team

win_type

10. Game_Map_Round_Player_Stats

game_map_round_id

player_id

kills

assists

score

economy_spent

economy_remaining

weapon_id

armor

We collect a lot of match information to provide detailed statistics. We retrieve:
- Basic match information (Mandatory)
- Match vetos
- Played maps, with results and stats
- Global match stats
- Each round's result (Who wins, and how)
- Each player's stats per round (KDA/Economy/Weapon/Armor/etc)

These stats are not always collected, but we strive to obtain them to display the most complete statistics possible.

News Structure

11. News

Main Information

id

Unique news identifier (Visible in URL)

author

Author name

title

News title

content

News content
Additional Information

status

News status (draft/published/archived)

is_featured

Whether news is displayed on the homepage

published_at

Publication date

Link

news_relations

Link between news and a tournament/team/player, allows display on profile.

Each news item must have an identifier, a title, content, and an author.

The status is hidden but allows for display (Draft = In progress, Published = Visible on site, Archived = Hidden on site but accessible via API).

Other Data Structure

12. Page_views

Main Information

uri

Page URL

viewed_at

Time of viewing

count

Number of views

We store the number of visits per page per hour; we do not store who visited, from which region, or the exact time.

This data is stored and private. It is never shared; we use it to visualize site usage and adapt our infrastructure as needed.