database 예제 2

테이블 (4)

Untitled (MEMBER)

  • Key (memberID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(60)
  • Field (age) — int(3)
  • Field (gender) — char(1)
  • Field (registeredClass) — char(10)
  • Field (phone) — int(15)

Untitled (ACTIVITY)

  • Key (activityID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (description) — text

Untitled (ENROLLMENT)

  • Key (classID) — int(2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (memberID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (level) — char(10)

Untitled (CLASS)

  • Key (classID) — int(2) — 기본 키 — NOT NULL
  • Field (className) — char(10)
  • Field (location) — char(10)
  • Field (time) — time
  • Field (limitedNumber) — int(2)
  • Field (currentNumber) — int(2)
  • Field (instructorName) — char(20)
  • Key (activityID) — char(10) — 외래 키 → Untitled.Key — NOT NULL