도서2

테이블 (5)

book_loans

  • loan_id — INT
  • user_id — INT — NOT NULL
  • book_id — INT — NOT NULL
  • loan_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • return_date — DATE

book_reservations

  • reservation_id — INT
  • user_id — INT — NOT NULL
  • book_id — INT — NOT NULL
  • reservation_date — DATE — NOT NULL
  • expiration_date — DATE — NOT NULL
  • loan_id — INT

books

  • book_id — INT
  • title — VARCHAR(255) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • isbn — VARCHAR(20) — NOT NULL
  • published_date — DATE
  • shelf_id — INT

bookshelves

  • shelf_id — INT
  • shelf_name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • description — TEXT

library_users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • full_name — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(15)