연습2

테이블 (5)

ACTIVITY (Untitled)

  • activityCode (Key) — char(15) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • description (Field2) — text

CLASS (Untitled2)

  • classID (Key) — char(20) — 기본 키 — NOT NULL
  • className (Field) — char(30)
  • level (Field2) — char(3)
  • description (Field3) — text
  • price (Field4) — integer(10)
  • capacity (Field5) — intager(3)
  • activityCode (Key2) — char(15) — 외래 키 → ACTIVITY.activityCode — NOT NULL

CLASS_TIME (Untitled5)

  • classID (Key) — char(20) — 외래 키 → CLASS.classID — NOT NULL

ENROLL (Untitled4)

  • classID (Key) — char(20) — 외래 키 → CLASS.classID — NOT NULL
  • memberID (Key2) — char(20) — 외래 키 → MEMBER.memberID — NOT NULL

MEMBER (Untitled3)

  • memberID (Key) — char(20) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • phone (Field2) — char(15)