lck
Tables (6)
LEAGUES
- LEAGUE_ID — VARCHAR2(5 BYTE) — Primary key
- LEAGUE_NAME — VARCHAR2(40 BYTE)
- COUNTRY — VARCHAR2(40 BYTE)
SUMMONERS
- SUMMONER_ID — VARCHAR2(15 BYTE) — Primary key
- TEAM_ID — VARCHAR2(5 BYTE) — Foreign key → TEAMS.TEAM_ID
- SUMMONER_NAME — VARCHAR2(10 BYTE)
- POSITION — VARCHAR2(10 BYTE)
TEAMS
- TEAM_ID — VARCHAR2(5 BYTE) — Primary key
- TEAM_NAME — VARCHAR2(40 BYTE)
- RANK — NUMBER
matches
- match_id — number — Primary key
- rounds — number
- match_date — date
- win_team — VARCHAR2(5 BYTE) — Foreign key → TEAMS.TEAM_ID
- lose_team — VARCHAR2(5 BYTE) — Foreign key → TEAMS.TEAM_ID
- scores — varchar2(5)
seosons
- seoson_id — varchar2(15) — Primary key
- LEAGUE_ID — VARCHAR2(5 BYTE) — Foreign key → LEAGUES.LEAGUE_ID
- start_date — date
- end_date — date
- winner — VARCHAR2(5 BYTE) — Foreign key → TEAMS.TEAM_ID
stats
- stat_id — number — Primary key
- match_id — number — Foreign key → matches.match_id
- SUMMONER_ID — VARCHAR2(15 BYTE) — Foreign key → SUMMONERS.SUMMONER_ID
- TEAM_ID — VARCHAR2(5 BYTE) — Foreign key → SUMMONERS.TEAM_ID
- kills — number
- deaths — number
- assists — number