ERD 연습문제 2

테이블 (4)

Untitled (LEPORTS ACTIVITY)

  • Key (lCode) — char(30) — 기본 키 — NOT NULL
  • Field (lDescription) — text
  • Field (lName) — char(30)
  • Key (cNo) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (CLASS)

  • Key (cNo) — char(30) — 기본 키 — NOT NULL
  • Field (cCode) — char(30)
  • Field (cTime) — char(30)
  • Field (cPermitPeople) — integer
  • Field (cRegisteredPeople) — integer
  • Field (cLevel) — integer(2)

Untitled (MEMBER)

  • Key (mName) — char(30) — 기본 키 — NOT NULL
  • Field (mAddress) — char(50)
  • Field (mAge) — integer(3)

Untitled (CLASS_MEMBER)

  • Key (mName) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (cNo) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (PersonalLevel) — integer(2)