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