중간고사대체과제(24-1)

테이블 (9)

BOOK

  • Key (book_ID) — int(20) — 기본 키 — NOT NULL
  • Key (publisher-ID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — char(40)
  • Field (isbn) — char(18)
  • Field (publisher) — char(20)
  • Field (summary) — text
  • Field (status) — char(3)
  • Field (type) — char(10)
  • Field (price) — int(10)
  • Field

Untitled (PUBLISHER)

  • Key (publisher-ID) — int(20) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(40)
  • Field (publication_Year) — int(4)

Untitled (MEMBER)

  • Key (member_ID) — int(20) — 기본 키 — NOT NULL
  • Key (loan_ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(40)
  • Field (phone) — char(13)
  • Field (e-mail) — char(30)

Untitled (LOAN)

  • Key (loan_ID) — char(30) — 기본 키 — NOT NULL
  • Field (book_ID) — int(20)
  • Field (member_ID) — int(20)
  • Field (loan_Date) — date
  • Field (due_Date) — date
  • Field (return_Date) — date
  • Field (overdue_Fee) — int(10)

Untitled (AUTHOR)

  • Key (authorID) — int(20) — 기본 키 — NOT NULL
  • Key (book_ID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (publisher-ID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(40)
  • Field (address) — char(40)

Untitled (CATEGORY)

  • Key (KDC) — int(3) — 기본 키 — NOT NULL
  • Field (keyword) — text

Untitled (BOOK_AUTHOR)

  • Key (book_ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
  • Key (publisher-ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
  • Field (bookID) — int(20)
  • Field (authorID) — int(20)

Untitled (BOOK_CATEGORY)

  • Key (bookID) — int(20) — 기본 키 — NOT NULL
  • Key (book_ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
  • Key (publisher-ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
  • Key (KDC) — int(3) — 외래 키 → Untitled.Key — NOT NULL

Untitled (BOOK_LOAN)

  • Key (book_ID) — int(20) — 기본 키 — NOT NULL
  • Key (book_ID2) — int(20) — 외래 키 → BOOK.Key — NOT NULL
  • Key (publisher-ID) — int(20) — 외래 키 → BOOK.Key — NOT NULL
  • Key (loan_ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (member_ID) — int(20)