연습문제2

테이블 (5)

Untitled (AEROBICS ACTIVITY)

  • Key (Code) — int — 기본 키 — NOT NULL
  • Field (Description) — text

Untitled (YOGA ACTIVITY)

  • Key (Code) — int — 기본 키 — NOT NULL
  • Field (Description) — char(20)

Untitled (SWIMMING ACTIVITY)

  • Key (Code) — int — 기본 키 — NOT NULL
  • Field (Description) — text

Untitled (ACTIVITY CLASS)

  • Key (ClassID) — int — 기본 키 — NOT NULL
  • Field (OperatingTime) — char(10)
  • Field (MaxCapacity) — char(30)
  • Field (CurrentEnrollment) — char(30)
  • Key (Code) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (Code2) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (ClassID2) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (Code3) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (ACTUVITY CODE)

  • Key (Member) — ichar(30) — 기본 키 — NOT NULL
  • Field (Name) — char(30)
  • Field (Address) — char(30)
  • Field (Age) — char(20)
  • Field (enrolledClass) — char(30)
  • Field (DefficultyLevel) — int
  • Field (LevelCode) — int
  • Field (LevelName) — text
  • Key (ClassID) — int — 외래 키 → Untitled.Key — NOT NULL