도서

테이블 (6)

BOOKNAME (Untitled3)

  • Harry Potter (Key) — volume(30) — 기본 키 — NOT NULL
  • History of Quidditch (Key2) — volume(20) — 기본 키 — NOT NULL
  • The Hogwarts Classics Box Set (Key3) — volume(10) — 기본 키 — NOT NULL
  • FANTASTIC BEASTS AND WHERE TO FIND THEM the original screenplay (Key4) — volume(10) — 기본 키 — NOT NULL
  • Career of Evil (Field4) — volume(10)
  • The Christmas Pig (Field6) — volume(10)
  • Icarborg (Field7) — volume(10)
  • writer (Key22) — JK.Rowling(100) — 외래 키 → book.writer — NOT NULL
  • Year (Key32) — 1997-2021 — 외래 키 → book.Year — NOT NULL

WORK (Untitled6)

  • workID (Key) — int(30) — 기본 키 — NOT NULL
  • workTile (Field) — char(50)
  • movieID (Key5) — int(10) — 외래 키 → movie.movieID — NOT NULL
  • writer (Key2) — JK.Rowling(100) — 외래 키 → book.writer — NOT NULL
  • Year (Key3) — 1997-2021 — 외래 키 → book.Year — NOT NULL

a public library (Untitled)

  • book (Key) — int — 기본 키 — NOT NULL

book (Untitled2)

  • writer (Key2) — JK.Rowling(100) — 기본 키 — NOT NULL
  • Year (Key3) — 1997-2021 — 기본 키 — NOT NULL
  • bookname (Field2) — Harry Potter,History of Quidditch,,The Tales of Beedle the Bard
  • Language (Field3) — KOREA
  • ISBN (Field) — 88894518
  • book (Key) — int — 외래 키 → a public library.book — NOT NULL

movie (Untitled5)

  • movieID (Key5) — int(10) — 기본 키 — NOT NULL
  • Harry Potter (Key) — volume(30) — 외래 키 → BOOKNAME.Harry Potter — NOT NULL
  • History of Quidditch (Key2) — volume(20) — 외래 키 → BOOKNAME.History of Quidditch — NOT NULL
  • The Hogwarts Classics Box Set (Key3) — volume(10) — 외래 키 → BOOKNAME.The Hogwarts Classics Box Set — NOT NULL
  • FANTASTIC BEASTS AND WHERE TO FIND THEM the original screenplay (Key4) — volume(10) — 외래 키 → BOOKNAME.FANTASTIC BEASTS AND WHERE TO FIND THEM the original screenplay — NOT NULL

series (Untitled4)

  • writer (Key2) — JK.Rowling(100) — 외래 키 → book.writer — NOT NULL
  • Language (Field) — KOREA
  • Language (Field2) — English
  • Harry Potter (Key) — volume(30) — 외래 키 → BOOKNAME.Harry Potter — NOT NULL
  • History of Quidditch (Key22) — volume(20) — 외래 키 → BOOKNAME.History of Quidditch — NOT NULL
  • The Hogwarts Classics Box Set (Key3) — volume(10) — 외래 키 → BOOKNAME.The Hogwarts Classics Box Set — NOT NULL
  • FANTASTIC BEASTS AND WHERE TO FIND THEM the original screenplay (Key4) — 외래 키 → BOOKNAME.FANTASTIC BEASTS AND WHERE TO FIND THEM the original screenplay — NOT NULL