도서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)