[다시]ERD 연습문제 2
테이블 (4)
Untitled (reports)
- Key (rCode) — char(20) — 기본 키 — NOT NULL
- Field (rName) — char(20)
- Field (rDescription) — text
Untitled (user)
- Key (uCode) — char(30) — 기본 키 — NOT NULL
- Field (uName) — char(30)
- Field (uAddress) — char(30)
- Field (uAge) — int(3)
- Field (uGender) — char(5)
Untitled (class_user)
- Key (cCode) — char(20) — 외래 키 → class.Key — NOT NULL
- Key (uCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (uLevel) — int(3)
- Field (uRegDate) — date
class
- Key (cCode) — char(20) — 기본 키 — NOT NULL
- Field (cName) — char(30)
- Field (cDay) — char(30)
- Field (cTime) — char(30)
- Field (cLevel) — int(4)
- Field (cRegistered) — int(3)
- Field (cLimit) — int(3)
- Key (rCode) — char(20) — 외래 키 → Untitled.Key — NOT NULL