2024_db_기말과제

테이블 (3)

book

  • Key (book_ID) — int(10) — 기본 키 — NOT NULL
  • Field (title) — char(250)
  • Field (author) — char(100)
  • Field (category) — char(50)

loan

  • Key (loan_ID) — int(10) — 기본 키 — NOT NULL
  • Field (loan_Date) — date
  • Field (return_Date) — date
  • Key (user_ID) — int(10) — 외래 키 → user.Key — NOT NULL
  • Key (book_ID) — int(10) — 외래 키 → book.Key — NOT NULL

user

  • Key (user_ID) — int(10) — 기본 키 — NOT NULL
  • Field (name) — char(50)
  • Field (phone) — int(11)