중간고사 2023913018 손지원

테이블 (5)

Untitled (BOOK)

  • Key (ISBN) — char(20) — 기본 키 — NOT NULL
  • Key (ssn2) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (Name) — char(20)
  • Field (Date) — date
  • Field (publisher) — char(20)
  • Field (kdc) — char(20)
  • Field (description) — text
  • Key (ssn) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ssn3) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (ssn) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(20)
  • Field (supervisor) — char(20)
  • Field (callnumber) — char(20)

Untitled (PRINTING HOUSE)

  • Key (ssn) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(20)
  • Field (deadline) — date

Untitled (WRITER)

  • Key (ssn) — char(20) — 기본 키 — NOT NULL
  • Field (Name) — char(20)
  • Field (address) — char(20)
  • Field (bestbook) — char(20)

Untitled (BOOKSTORE)

  • Key (ssn) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(20)
  • Field (warehousingdate) — date
  • Key (ssn2) — char(20) — 외래 키 → Untitled.Key — NOT NULL