기말과제1

테이블 (7)

Untitled (BOOK)

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

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 (bookAuthorID) — char(10) — 기본 키 — NOT NULL
  • 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 (geisel) — char(30)
  • Field (bologna) — char(30)
  • Field (greenaway) — char(30)
  • Key (authorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (illustratorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (BOOK_ILLUSTRATOR)

  • Key (bookIllustratorID) — char(10) — 기본 키 — NOT NULL
  • 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