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