3주차 연습문제2_김자언

테이블 (4)

Untitled (ACTIVITIES)

  • Key (aCode) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char10)
  • Field (description) — text

Untitled (CLASS)

  • Key (cID) — char(15) — 기본 키 — NOT NULL
  • Field (runninghour) — int(3)
  • Field (limitedpersonnel) — int(2)
  • Field (currentpersonnel) — int(2)
  • Field (level) — int(1)

Untitled (MEMBER)

  • Key (mID) — char(15) — 기본 키 — NOT NULL
  • Field (address) — text
  • Field (age) — int(3)
  • Field (name) — char(10)
  • Key (level) — int(1) — 외래 키 → Untitled.Key — NOT NULL
  • Key (aCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (cID) — char(15) — 외래 키 → Untitled.Key — NOT NULL

Untitled (CLASS_REGISTERED)

  • Key (level) — int(1) — 기본 키 — NOT NULL
  • Key (aCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (cID) — char(15) — 외래 키 → Untitled.Key — NOT NULL