연습문제2번

테이블 (5)

Untitled (CLASS)

  • Key (serialnumber) — char(10) — 기본 키 — NOT NULL
  • Field (time) — char(10)
  • Field (max) — char(3)
  • Field (currentmember) — char(3)
  • Field (name) — char(10) — 외래 키 → Untitled.Field

Untitled (MEMBER)

  • Field (name) — char(10) — 기본 키
  • Field (adress) — text
  • Field (age) — char(2)

Untitled (LEVEL)

  • Field (name) — char(10) — 외래 키 → Untitled.Field
  • Key (serialnumber) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (ACTIVITY)

  • Key (code) — char(4) — 기본 키 — NOT NULL
  • Field (explain) — text
  • Field (yoga) — char(10)
  • Field (aerobic) — char(10)
  • Field (swim) — char(10)
  • Field
  • Key (serialnumber) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (ENROLL)

  • Field (name) — char(10) — 외래 키 → Untitled.Field
  • Key (serialnumber) — char(10) — 외래 키 → Untitled.Key — NOT NULL