my erd
Tables (3)
Book (book)
- Book Id (book_id) — INT — Primary key — NOT NULL
- Title (title) — VARCHAR(255)
- Author (author) — VARCHAR(255)
- Language (language) — VARCHAR(255)
- Publisher (publisher) — VARCHAR(255)
- RegisterDate (registerDate) — LocalDate
Loan (loan)
- Loan Id (loan_id) — INT — Primary key — NOT NULL
- IsReturned (isReturned) — Boolean
- LoanDate (loanDate) — LocalDate
- ReturnDate (returnDate) — LocalDate
- User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL
- Book Id (book_id) — INT — Foreign key → Book.Book Id — NOT NULL
User (user)
- User Id (user_id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Gender (gender) — VARCHAR(255)
- SecurityNumber (securityNumber) — VARCHAR(255)
- PhoneNumber (phoneNumber) — VARCHAR(255)
- Address (address) — VARCHAR(255)