기말고사

테이블 (5)

Untitled (Member)

  • Key (ssn) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (phone) — char(11)
  • Field (address) — char(30)

Untitled (Book)

  • Key (BookID) — char(13) — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Field (author) — char(30)
  • Field (publisher) — char(30)
  • Field (pubyear) — int(4)

Untitled (Program)

  • Key (ProgramID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text
  • Field (date) — char(20)
  • Field (capacity) — integer(3)

Untitled (Enroll)

  • Key (ProgramID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ssn) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Bookloan)

  • Key (BookloanID) — char(13) — 기본 키 — NOT NULL
  • Field (loandate) — char(20)
  • Field (returndate) — char(20)
  • Key (BookID) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ssn) — char(13) — 외래 키 → Untitled.Key — NOT NULL