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