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)