book

Tables (6)

book

  • book_id — INT — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • author — VARCHAR(50) — NOT NULL
  • publisher — VARCHAR(50)
  • is_available — BOOLEAN — NOT NULL

book_order

  • order_id — INT — Primary key — NOT NULL
  • customer_id — INT — Foreign key → customer.customer_id — NOT NULL
  • book_id — INT — Foreign key → book.book_id — NOT NULL
  • order_date — DATE — NOT NULL

customer

  • customer_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • address — VARCHAR(100)

extension

  • extension_id — INT — Primary key — NOT NULL
  • lending_id — INT — Foreign key → lending.lending_id — NOT NULL
  • order_id — INT — Foreign key → lending.order_id — NOT NULL
  • customer_id — INT — Foreign key → lending.customer_id — NOT NULL
  • book_id — INT — Foreign key → lending.book_id — NOT NULL
  • extended_date — DATE — NOT NULL
  • fee — INT — NOT NULL
  • count — INT

lending

  • lending_id — INT — Primary key — NOT NULL
  • order_id — INT — Foreign key → book_order.order_id — NOT NULL
  • customer_id — INT — Foreign key → book_order.customer_id — NOT NULL
  • book_id — INT — Foreign key → book_order.book_id — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL

return

  • return_id — INT — Primary key — NOT NULL
  • lending_id — INT — Foreign key → lending.lending_id — NOT NULL
  • order_id — INT — Foreign key → lending.order_id — NOT NULL
  • customer_id — INT — Foreign key → lending.customer_id — NOT NULL
  • book_id — INT — Foreign key → lending.book_id — NOT NULL
  • return_date — DATE — NOT NULL
  • status — VARCHAR(20)