예제2_답

테이블 (8)

ACTIVITY (Activity)

  • actCode (actcode) — char(10) — 기본 키 — NOT NULL
  • Field (actdescription) — text
  • Key (actname) — char(20) — NOT NULL

Untitled (Class)

  • Key (classID) — char(10) — 기본 키 — NOT NULL
  • Field (classname) — char(20)
  • Field (level) — char(4)
  • Field (price) — integer(10)
  • Field (location) — integer(3)
  • actCode (actcode) — char(10) — 외래 키 → ACTIVITY.actCode — NOT NULL

Untitled (member)

  • Key (memberID) — char(10) — 기본 키 — NOT NULL
  • Field (memberName) — char(20)
  • Field (address) — char(50)
  • Field (phone) — char(11)
  • Field (birthdate) — date
  • Field (gender) — char(1)

Untitled (enroll)

  • Key (memberID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (classID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (ClassTime)

  • Key (monClassID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (timeID2) — int(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MonthClass)

  • Key (monClaID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (year) — char(4)
  • Field (month) — char(2)
  • Field (lectureID) — char(10)
  • Key (classID) — integer — 외래 키 → Untitled.Key — NOT NULL
  • Key (lectureID2) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Time)

  • Key (timeID) — int(6) — 기본 키 — NOT NULL
  • Field (time) — char(20)

Untitled (Lecturer)

  • Key (lectureID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)
  • Field (phone) — onteger(20)
  • Field (descrition) — text