도서
테이블 (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