기말고사 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)