JinyongFootBall

Tables (4)

League (리그)

  • league_id (리그ID) — int — Primary key — NOT NULL
  • name (리그이름) — VARCHAR2(255) — NOT NULL

Player (선수)

  • player_id (선수ID) — int — Primary key — NOT NULL
  • team_id (팀ID) — int — Foreign key → Team.team_id — NOT NULL
  • Field (선수이름) — VARCHAR2(255)
  • overall (능력치) — NUMBER(10)
  • position (포지션) — ENUM

Staff (스태프)

  • staff_id (스태프ID) — Primary key — NOT NULL
  • league_id (리그ID) — int — Foreign key → League.league_id — NOT NULL
  • name (코치이름) — VARCHAR2(255)
  • role (역할) — ENUM

Team (팀)

  • team_id (팀ID) — int — Primary key — NOT NULL
  • league_id (리그ID) — int — Foreign key → League.league_id — NOT NULL
  • name (팀이름) — VARCHAR2(255) — NOT NULL