기말과제

테이블 (3)

Untitled (Book)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Field (pubYear) — Int(4)
  • Field (type) — char(10)
  • Field (author) — char(30)
  • Field (Publisher) — char(30)

Untitled (Author)

  • Key (authorID) — char(10) — 기본 키 — NOT NULL
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text
  • Field (majorWork) — text

Untitled (Publisher)

  • Key (publisherID) — char(10) — 기본 키 — NOT NULL
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(30)