기말과제

테이블 (4)

Untitled (book)

  • Key (ISBN) — int(13) — 기본 키 — NOT NULL
  • Key (pubID) — int(5) — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — char(30)
  • Field (pubYear) — int(4)
  • Field (pubMonth) — int(2)
  • Field (description) — LONGTEXT
  • Field (award) — LONGTEXT
  • Field (price) — int(10)
  • Field (bookType) — ENUM

Untitled (publisher)

  • Key (pubID) — int(5) — 기본 키 — NOT NULL
  • Field (pubName) — char(20)
  • Field (address) — TEXT
  • Field (CEO) — char(50)
  • Field (website) — char(50)

Untitled (author)

  • Key (authID) — int(10) — 기본 키 — NOT NULL
  • Field (authName) — char(20)
  • Field (description) — LONGTEXT
  • Field (award) — LONGTEXT

Untitled (book_author)

  • Key (ISBN) — int(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (pubID) — int(5) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authID) — int(10) — 외래 키 → Untitled.Key — NOT NULL