[다시]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