2024_10_22 중간고사

테이블 (8)

Untitled (BOOK)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (bookName) — char(40)
  • Field (pubDate) — char(10)
  • Field (description) — text
  • Key (pubID) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (pubID) — char(20) — 기본 키 — NOT NULL
  • Field (pubName) — char(40)
  • Field (address) — char(30)
  • Field (description) — text

Untitled (AUTHOR)

  • Field (autName) — char(30) — 기본 키
  • Field (address) — char(30)
  • Field (majorBook) — char(40)
  • Field (desription) — text

Untitled (PRINT)

  • Key (priID) — char(20) — 기본 키 — NOT NULL
  • Field (priName) — char(40)
  • Field (address) — char(30)

Untitled (KDC)

  • Key (kdcNum) — char(9) — 기본 키 — NOT NULL
  • Field (authorizedKeyword) — text — 기본 키

Untitled (DESCRIPTION)

  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (autName) — char(30) — 외래 키 → Untitled.Field
  • Key (kdcNum) — char(9) — 외래 키 → Untitled.Key — NOT NULL
  • Field (authorizedKeyword) — text — 외래 키 → Untitled.Field
  • Field (relatedStory) — text
  • Field (relatedPerson) — text

Untitled (WORK)

  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (autName) — char(30) — 외래 키 → Untitled.Field

Untitled (CONTRACT)

  • Key (priID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (priAmount) — char(10)
  • Field (contDate) — char(10)