ㅍㅍ

Tables (6)

Book

  • book_id — INT
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100)
  • publisher — VARCHAR(100)
  • isbn — VARCHAR(20)

BookLoan

  • loan_id — INT
  • customer_id — INT
  • book_id — INT
  • loan_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • return_date — DATE
  • status — ENUM('대출중', '반납완료', '연체') — NOT NULL

Customer

  • customer_id — INT
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • address — TEXT

FeePayment

  • payment_id — INT
  • extension_id — INT
  • payment_date — DATE — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • payment_method — ENUM('현금', '카드', '온라인') — NOT NULL

LibraryBook

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

LoanExtension

  • extension_id — INT
  • loan_id — INT
  • extension_date — DATE — NOT NULL
  • new_due_date — DATE — NOT NULL
  • fee_amount — DECIMAL(10, 2) — NOT NULL