test
Tables (3)
Books
- book_id — INT
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(100) — NOT NULL
- publisher — VARCHAR(100)
- year — INT
Loans
- loan_id — INT
- user_id — INT
- book_id — INT
- loan_date — DATE — NOT NULL
- return_date — DATE
Users
- user_id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(15)