중간고사

테이블 (4)

Untitled (BOOK)

  • Key (ISBN) — int(20) — 기본 키 — NOT NULL
  • Key (pubID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (priID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (pubDate) — date
  • Field (publisher) — char(100)
  • Field (title) — text
  • Field (KDC) — int(20)

Untitled (PUBLISHER)

  • Key (pubID) — char(30) — 기본 키 — NOT NULL
  • Key (priID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(100)

Untitled (AUTHOR)

  • Key (name) — char(30) — 기본 키 — NOT NULL
  • Field (address) — char(100)
  • Field (masterpiece) — text
  • Key (ISBN) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (pubID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (priID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRINTER)

  • Key (ID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(100)