soccer DB

Tables (4)

Matches (tb_matches)

  • 경기_id (match_id) — VARCHAR — Primary key — NOT NULL
  • 경기날짜 (matchdate) — DATETIME
  • 경기시간 (matchtime) — DATETIME
  • 홈팀 (hometeam_name) — VARCHAR
  • 어웨이팀 (awayteam_name) — VARCAHR
  • 홈팀 득점 (homescores) — int
  • 원정팀 득점 (awayscores) — int
  • 홈팀 슛 (homeshots) — int
  • 원정팀 슛 (awayshots) — int
  • 홈팀 공중경합성공 (homeaerialswon) — int
  • 원정팀 공중경합성공 (awayaerialswonn) — int
  • 홈팀 점유율 (homepossesion) — FLOAT
  • 원정팀 점유율 (awaypossesion) — FLOAT
  • 홈팀 패스 성공율 (homepasssuccess) — FLOAT
  • 어웨이팀 패스 성공율 (awaypassssuccess) — FLOAT
  • Field

Player stat (tb_players_stats)

  • 해당 시즌 (season_id) — VARCHAR — Primary key — NOT NULL
  • 플레이어 id (player_id) — INT — Primary key — NOT NULL
  • 팀 id (team_id) — INT — Primary key — NOT NULL
  • 나이 (age) — INT
  • 선발출전횟수 (apperiances) — INT
  • 교체출전횟수 (apps_sub) — INT
  • 출전시간 (minutes) — INT
  • 골 수 (Goals) — INT
  • Field

Players (tb_players)

  • 플레이어 id (player_id) — INT — Primary key — NOT NULL
  • 포지션 (position) — VARCHAR
  • 생년월일 (birthdate) — DATETIME
  • 플레이어 이름 (player_name) — VARCHAR — NOT NULL

Teams (tb_teams)

  • 팀 id (team_id) — INT — Primary key — NOT NULL
  • 팀 이름 (team_name) — VARCHAR — Primary key — NOT NULL
  • 리그 (League) — VARCHAR