erd 예제6

테이블 (6)

BOOK

  • Key (bookID) — char(200) — 기본 키 — NOT NULL
  • Field (ISBN) — num.
  • Key (ISBN2) — num — 외래 키 → Untitled.Key — NOT NULL

Untitled (PUBLICHER)

  • Key (publsherID) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(20)
  • Field (phone) — char(20)
  • Key (bookID) — char(200) — 외래 키 → BOOK.Key — NOT NULL

Untitled (BOOK_INFO)

  • Key (ISBN) — num — 기본 키 — NOT NULL
  • Field (bookID) — char(200)
  • Field (publisher) — char(20)
  • Field (author) — char(120)
  • Field (pub_date) — time
  • Field (booktitle) — char(200)
  • Field

Untitled (AUTHOR)

  • Key (authorID) — char(120) — 기본 키 — NOT NULL
  • Field (name) — char(120)
  • Field (address) — char(100)
  • Field (phone) — char(80)
  • Key (publsherID) — 외래 키 → Untitled.Key — NOT NULL
  • Key (bookID) — char(200) — 외래 키 → BOOK.Key — NOT NULL

Untitled (PRINTER)

  • Key (printerID) — char(5) — 기본 키 — NOT NULL
  • Field (name) — char(5)
  • Field (address) — char(5)
  • Field (phone) — char(5)
  • Field (email) — char(5)

Untitled (CONTRACT)

  • Key (contractID) — char(20) — 기본 키 — NOT NULL
  • Field (number_of_book) — char
  • Field (deadline) — time