2024.10.22준서서B반이혜청

테이블 (5)

Untitled (BOOK)

  • Key (bookID) — char(10) — 기본 키 — NOT NULL
  • Field (ISBN) — char(13)
  • Field (title) — char(30)
  • Field (writer) — char(2)
  • Field (publisher) — char(10)
  • Field (publication Date) — Date

Untitled (PUBLISHR)

  • Key (publisherID) — char(10) — 기본 키 — NOT NULL
  • Field (publisherNane) — char(20)
  • Field (address) — char(50)
  • Field (phone) — char(20)
  • Field (email) — email
  • Key (bookID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WRITER)

  • Key (writerID) — char(10) — 기본 키 — NOT NULL
  • Key (quintityID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (bookID2) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (writerName) — char(20)
  • Field (representativeTitle) — char(30)
  • Field
  • Key (bookID) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRINTING)

  • Key (printingID) — char(10) — 기본 키 — NOT NULL
  • Key (bookID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (printingName) — char(20)
  • Field (address) — char(50)
  • Field (phone) — char(20)
  • Field (email) — email

Untitled (CONTRACT)

  • Key (quintityID) — char(10) — 기본 키 — NOT NULL
  • Key (bookID) — char(10) — 외래 키 → Untitled.Key — NOT NULL