기말고사(곽슬비)

테이블 (4)

LIBRARY (MEMBER)

  • Key (memberID) — int(8) — 기본 키 — NOT NULL
  • Field (name) — char(5)
  • Field (birthdate) — date
  • Field (gender) — char(1)

Untitled (PROGRAM)

  • Key (programCode) — int(3) — 기본 키 — NOT NULL
  • Field2 (title) — char(20)
  • Field3 (date) — date
  • Field (time) — char(3)
  • Field (target) — char(20)
  • Field (location) — char(20)
  • Field (description) — text
  • Key (lecturerID) — int(2) — 외래 키 → Untitled.Key — NOT NULL

Untitled (ENROLL)

  • Key (memberID) — int(8) — 외래 키 → LIBRARY.Key — NOT NULL
  • Key (programCode) — int(3) — 외래 키 → Untitled.Key — NOT NULL

Untitled (LECTURER)

  • Key (lecturerID) — int(2) — 기본 키 — NOT NULL
  • Field (name) — char(5)
  • Field (job) — char(20)