기말고사 erd

테이블 (7)

Untitled (LEAGUE)

  • Key (LeagueID) — char(20) — 기본 키 — NOT NULL
  • Field (Leaguename) — char(50)
  • Field (country) — char(30)
  • Field (description) — text
  • Field (quantity) — float(20)
  • Key (TeamID) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (CLUB(TEAM))

  • Key (teamID) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (finance) — float(20)
  • Field (currentManger) — char(20)
  • Field (weeklyWage) — float(20)
  • Field (location) — char(10)
  • Field (target) — char(30)
  • Field (lastYearResult) — char(30)
  • Key (leaderSsn) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (LeagueID) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PLAYER)

  • Key (ssn) — char(20) — 기본 키 — NOT NULL
  • Field (country) — char(30)
  • Field (name) — char(50)
  • Field (foot) — char(10)
  • Field (height) — int(3)
  • Field (weight) — int(3)
  • Field (position) — char(20)
  • Field (age) — int(2)
  • Field (ransom) — float(20)
  • Field (goal) — int(4)
  • Field (assist) — int(4)
  • Field (yellowcard) — int(3)
  • Field (redcard) — int(3)
  • Key (TeamID) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (COACH)

  • Key (coachID) — char(20) — 기본 키 — NOT NULL
  • Field (age) — int(2)
  • Field (position) — char(20)
  • Field (name) — char(50)
  • Field (country) — char(30)
  • Key (playerSsn) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MANAGER)

  • Key (managerID) — char(20) — 기본 키 — NOT NULL
  • Field (LastYearResults) — char(30)
  • Field (name) — char(50)
  • Field (age) — int(2)
  • Field (country) — char(30)
  • Key (TeamID) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (GAME)

  • Key (gameID) — char(20) — 기본 키 — NOT NULL
  • Field (date) — char(30)
  • Field (opponent) — char(30)
  • Field (description) — longtext

Untitled (PLAY)

  • Key (ssn) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (gameID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (minute) — char(3)