데이터베이스 기말고사

테이블 (9)

Untitled (WORK)

  • Key (workID) — int(20) — 기본 키 — NOT NULL
  • Field (workTiltle) — char(50)

Untitled (AUTHOR)

  • Key (autjID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (alternativeName) — char(30)
  • Field (nationality) — char(20)

Untitled (WORK_AUTHOR)

  • Key (workID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (autjID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (ILLUSTRATOR)

  • Key (illuID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (alternativeName) — char(30)
  • Field (nationality) — char(20)

Untitled (WORK_ILLUSTRATOR)

  • Key (workID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (illuID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (BOOK)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (title) — char(50)
  • Field (pubDate) — date
  • Field (type) — char(10)
  • Field (KDC) — char(20)
  • Field (page) — char(10)
  • Field (price) — integer
  • Key (workID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (pubID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (pubID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (phone) — char(20)
  • Field (fax) — char(20)
  • Field (email) — char(30)
  • Field (homepage)

Untitled (SUBJECT)

  • Key (subID) — int(20) — 기본 키 — NOT NULL
  • Field (subjectHeading) — char(30)
  • Field (description) — text

Untitled (WORK_SUBJECT)

  • Key (workID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (subID) — int(20) — 외래 키 → Untitled.Key — NOT NULL