연습문제2

테이블 (6)

AEROBICS

  • Key (code) — char(4) — 기본 키 — NOT NULL
  • Field (explain) — text

CLASS (SWIM)

  • Key (code) — char(5) — 기본 키 — NOT NULL
  • Field (explain) — text

MEMBER

  • Key (memberID) — char(30) — 기본 키 — NOT NULL
  • name — char(3)
  • adress

SWIM (CLASS)

  • Key (classNo) — char(10) — 기본 키 — NOT NULL
  • Field

Untitled (ACTIVITY)

  • Key (activityCode) — char(5) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text

YOGA

  • Key (code) — char(5) — 기본 키 — NOT NULL
  • Field (explain) — text