연습문제2

테이블 (5)

ACTIVITY

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

Untitled (CLASS)

  • Key (classID) — char(10) — 기본 키 — NOT NULL
  • Field (className) — char(10)
  • Field (actID) — char(10)
  • Key (activityID) — char(10) — 외래 키 → ACTIVITY.Key — NOT NULL

Untitled (CLASS_LEVEL)

  • Key (classID) — char(10) — 기본 키 — NOT NULL
  • Key (classID2) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (memID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (vipID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (level) — int(2)

Untitled (MEMBER)

  • Key (memID) — char(10) — 기본 키 — NOT NULL
  • Field (memName) — char(10)
  • Field (className) — char(10)
  • Field (datetime) — time
  • Field (max members) — int(2)

Untitled (VIP_INFORMATION)

  • Key (vipID) — char(10) — 기본 키 — NOT NULL
  • Field (vipName) — char(10)
  • Field (address) — char(30)
  • Field (age) — char(2)
  • Field (join date) — date