BOOK

Tables (5)

BOOK (BOOK 책)

  • BOOK ISBN (ISBN) — INT (13) — Primary key — NOT NULL
  • Key (저자 ID) — INT (30) — Foreign key → Untitled3.Key — NOT NULL
  • Publication DATE (출판일) — INT (8)
  • Signature (서명) — CHAR(30)
  • Key (출판사 ID) — INT (30) — Foreign key → Untitled2.Key — NOT NULL

Untitled2 (출판사)

  • Key (출판사 ID) — INT (30) — Primary key — NOT NULL
  • Field (출판사 NAME) — CHAR (30)
  • Field (출판사 ADDRESS) — CHAR (40)

Untitled3 (저자)

  • Key (저자 ID) — INT (30) — Primary key — NOT NULL
  • Field (저자 SSN) — INT (13)
  • Field (저자 NAME) — CHAR (30)
  • Field (저자 ADDRESS) — CHAR (40)

Untitled4 (계약서)

  • Key (BOOK ISBN) — INT (13) — Primary key — NOT NULL
  • Field (인쇄 량) — INT (40)
  • Field (인쇄 마감일) — INT (14)
  • BOOK ISBN (ISBN2) — INT (13) — Foreign key → BOOK.BOOK ISBN — NOT NULL
  • Key (저자 ID) — INT (30) — Foreign key → BOOK.Key — NOT NULL

Untitled5 (인쇄소)

  • Key (인쇄소 ID) — INT (30) — Primary key — NOT NULL
  • Field (인쇄소 NAME) — CHAR (40)
  • Field (인쇄소 ADDRESS) — CHAR (40)
  • Field (인쇄량) — INT (6)
  • Key (BOOK ISBN) — INT (13) — Foreign key → Untitled4.Key — NOT NULL