ㅍㅍ
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