ScoreBoard

Tables (7)

InternationalLeague (인터내셔널리그)

  • interLeague_id (국제리그코드) — varchar2 — Primary key — NOT NULL
  • na_id (나라코드) — varchar2 — Foreign key → Nation.na_id — NOT NULL
  • interLeague_name (국제리그명칭) — varchar2 — NOT NULL

InternationalTeam (국제팀)

  • interLeague_id (국제리그코드) — varchar2 — Primary key — NOT NULL
  • na_id (나라코드) — varchar2 — Foreign key → InternationalLeague.na_id — NOT NULL
  • team_name (국제팀명칭) — varchar2 — NOT NULL

League (리그)

  • league_id (리그코드) — varchar2 — Primary key — NOT NULL
  • na_id (나라코드) — varchar2 — Foreign key → Nation.na_id — NOT NULL
  • league_name (리그명칭) — varchar2 — NOT NULL
  • league_division (리그디비전) — int — NOT NULL

LeagueTeam (리그팀)

  • leagueTeam_id (리그팀코드) — varchar2 — Primary key — NOT NULL
  • league_id (리그코드) — varchar2 — Foreign key → League.league_id — NOT NULL
  • na_id (나라코드) — varchar2 — Foreign key → League.na_id — NOT NULL
  • team_name (리그팀명칭) — varchar2 — NOT NULL

Nation (나라)

  • na_id (나라코드) — varchar2 — Primary key — NOT NULL
  • na_code (나라이름) — varchar2 — NOT NULL

Player (선수)

  • interTeam_id (국제팀코드) — varchar2 — Foreign key → InternationalTeam.interLeague_id — NOT NULL
  • leagueTeam_id (리그팀코드) — varchar2 — Foreign key → LeagueTeam.leagueTeam_id — NOT NULL
  • age (나이) — int
  • birth (생일) — varchar2
  • uniform_number (등번호) — int
  • position (포지션) — int — 0 = 골키퍼, 1=수비수, 2=미드필더, 3=공격수
  • league_id (리그코드) — varchar2 — Foreign key → LeagueTeam.league_id — NOT NULL
  • na_id (나라코드) — varchar2 — Foreign key → LeagueTeam.na_id — NOT NULL

Staff (스텝)

  • head_coatch (감독) — varchar2 — NOT NULL