연습문제 6

테이블 (6)

BOOKINFOR

  • Key (isbn) — char(20) — 기본 키 — NOT NULL
  • Field (signature) — char(30)
  • Field (pubDate) — date
  • Field (review) — text
  • Key (pubID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (pubInfor) — text

Untitled (AUTHOR)

  • Key (ssn) — char(13) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (profile) — text

Untitled (BOOKAUTHOR)

  • Key (isbn) — char(20) — 외래 키 → BOOKINFOR.Key — NOT NULL
  • Key (ssn) — char(13) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRINTSHOP)

  • Key (printID) — int(10) — 기본 키 — NOT NULL
  • Field (appellation) — char(10)
  • Field (address) — char(20)

Untitled (PUBLISHER)

  • Key (pubID) — int — 기본 키 — NOT NULL
  • Field (appellation) — char(10)
  • Field (address) — char(20)

Untitled (CONTRACT INFOR)

  • Key (isbn) — char(20) — 외래 키 → BOOKINFOR.Key — NOT NULL
  • Key (printID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (volume) — int
  • Field (closingDate) — date