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