ff

Tables (8)

Book

  • book_id — INT
  • title — VARCHAR(255) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • publisher — VARCHAR(100)
  • available_count — INT
  • price — DECIMAL(10, 2) — NOT NULL

BookLoan

  • CREATE — TABLE

BookStock

  • book_id — INT
  • available_date — DATE — NOT NULL

Customer

  • customer_id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL

Extension

  • extension_id — INT
  • loan_id — INT
  • extended_return_date — DATE — NOT NULL
  • fee — DECIMAL(10, 2) — NOT NULL

LibraryBook

  • book_id — INT
  • available_quantity — INT — NOT NULL
  • expected_available_date — DATE

Loan

  • loan_id — INT
  • customer_id — INT
  • book_id — INT
  • loan_date — DATE — NOT NULL
  • return_due_date — DATE — NOT NULL
  • return_date — DATE
  • is_extended — BOOLEAN
  • extension_count — INT

Notification

  • notification_id — INT
  • customer_id — INT
  • message — TEXT — NOT NULL
  • notification_date — DATE — NOT NULL