library

Tables (3)

Untitled (rental)

  • Key (rental_id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → users.Key — NOT NULL
  • Key (book_id) — Foreign key → books.Key — NOT NULL
  • Field (rental_date)
  • Field (return_date)

books

  • Key (book_id) — Primary key — NOT NULL
  • Field (rental)
  • Field (search)
  • Field (delete)
  • Field (return)

users

  • Key (user_id) — Primary key — NOT NULL
  • Field (name)
  • Field2 (phonenumber)
  • Field3 (password)