tiger

Tables (5)

a_match (국제대회)

  • a_match_id (국제대회 id) — int — Primary key — NOT NULL
  • a_match_name (국제대회 이름) — varchar(30)
  • Field

league (리그)

  • league_id (리그 id) — int — Primary key — NOT NULL
  • league_name (리그이름) — varchar(50)
  • nation_id (국가 id) — int

league_team (리그팀)

  • league_team_id (리그팀 id) — int — Primary key — NOT NULL
  • league_team_name (리그팀 이름) — varchar(30)
  • league_id (리그 id) — int
  • manager_id (감독 id) — int
  • elo_score (엘로점수) — int

nation (국가)

  • nation_id (국가 id) — int — Primary key — NOT NULL
  • nationality (국적) — varchar(30)
  • nation_name (국가 이름) — varchar(30)
  • fifa_score (피파점수) — int

nation_team (국가대표팀)

  • nation_team_id (국가대표팀 id) — int — Primary key — NOT NULL
  • nation_id (국가 id) — int
  • manager_id (감독 id) — int
  • a_match_id (국제대회 id) — int
  • fifa_score (피파점수) — int