기말과제12-28

테이블 (9)

Untitled (BOOK)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (title) — char(70)
  • Field (originalTitle) — char(70)
  • Field (KDC_6th) — char(20)
  • Field (pubYear) — int(4)
  • Field (type) — char(10)
  • Field (bookID) — char(10)
  • Key (awardID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (publisherID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (prizedYear) — int(4)

Untitled (AUTHOR)

  • Key (authorID) — char(10) — 기본 키 — NOT NULL
  • Field (nationality) — char(30)
  • Field (name) — char(30)
  • Field (alternativeName) — char(30)
  • Field (description) — text
  • Field (email) — email

Untitled (ILLUSTRATOR)

  • Key (illustratorID) — char(10) — 기본 키 — NOT NULL
  • Field (nationality) — char(30)
  • Field (name) — char(30)
  • Field (alternativeName) — char(30)
  • Field (description) — tex
  • Field (email) — email

Untitled (BOOK_AUTHOR)

  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (bookID) — char(10)
  • Field (role) — char(20)

Untitled (AWARD)

  • Key (awardID) — char(10) — 기본 키 — NOT NULL
  • Field (caldecott) — char(30)
  • Field (newbery) — char(30)
  • Field (carnegie) — char(30)
  • Field (andersen) — char(30)
  • Field (bolognaragazzi) — char(30)
  • Field (kategreenaway) — char(30)
  • Key (authorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (illustratorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (BOOK_ILLUSTRATOR)

  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (illustratorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (bookID) — char(10)
  • Field (role) — char(20)

Untitled (PUBLISHER)

  • Key (publisherID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (phone) — charr(20)
  • Field (email) — email

Untitled (BOOK_TRANSLATOR)

  • Key (translatorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (bookID) — char(10)
  • Field (roie) — char(20)

Untitled (TRANSLATOR)

  • Key (translatorID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (description) — tex
  • Field (email) — email