기말

테이블 (5)

Untitled (Member)

  • Key (memberID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(8)
  • Field (address) — text
  • Field (phoneNumber) — char(11)

Untitled (Subject)

  • Field (subjectNumber) — int(1) — 기본 키
  • Key (subjectName) — char(2) — NOT NULL

Untitled (Lecture)

  • Key (lectureNumber) — int(2) — 기본 키 — NOT NULL
  • Field (lectureName) — char(10)
  • Field (lecturer) — char(5)
  • Field (place) — char(10)
  • Field (day) — char(3)
  • Field (price) — int(6)

Untitled (Record)

  • Key (memberID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (lectureNumber) — int(2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (subjectNumber) — int(1) — 외래 키 → Untitled.Field

Untitled (Classification)

  • Key (lectureNumber) — int(2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (subjectNumber) — int(1) — 외래 키 → Untitled.Field